Create formulas ,functions and macros with Excel
Microsoft Excel is the go-to tool for working with data. There are probably a handful of people who haven’t used Excel, given its immense popularity. Excel is a widely used software application in industries today, built to generate reports and business insights. Excel supports several in-built applications that make it easier to use.
What you’ll learn
- Activating Macros and VBA Tools.
- Create formulas for arithmetic tasks.
- Re-using formulas.
- Calculating YTD Profits.
- Calculating Percentage Change.
- Calculate Relative and absolute reference.
- Using Rank Function.
- Create and edit macros.
- Saving a worksheet with a macro.
Course Content
- Excel Formulas and Functions –> 11 lectures • 51min.
- Excel VBA and Macros –> 10 lectures • 46min.
Requirements
Microsoft Excel is the go-to tool for working with data. There are probably a handful of people who haven’t used Excel, given its immense popularity. Excel is a widely used software application in industries today, built to generate reports and business insights. Excel supports several in-built applications that make it easier to use.
One such feature that allows Excel to stand out is – Excel formulas. in this course you will learn the various Microsoft Excel functions and formulas. These formulas and functions enable you to perform calculations and data analysis faster. Here, we will look into the top 25 Excel formulas that one must know while working on Excel.
What is Excel Formula?
In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division. In addition to these, you can find out averages and calculate percentages in excel for a range of cells, manipulate date and time values, and do a lot more.
There is another term that is very familiar to Excel formulas, and that is “function”. The two words, “formulas” and “functions” are sometimes interchangeable. They are closely related, but yet different. A formula begins with an equal sign. Meanwhile, functions are used to perform complex calculations that cannot be done manually. Functions in excel have names that reflect their intended use.