Explore formulas in Excel – the premier way to handle calculations.
While computers are good at many different tasks, they still thrive most in the areas of math and automation. Excel formulas, which combine both aspects, have thus become an important facet in regular business activity and made compiling important data much easier.
You’ll explore the foundations of using formulas to manipulate your data in more dynamic and calculative ways. From adding numbers in two different cells together, to doing more advanced logic with dates, you’ll learn valuable techniques that simplify how you obtain certain data without ever pulling out a separate calculator.
Regardless of your skills in math or goals, Excel formulas will allow you to unlock the full power of spreadsheet management and automate many tedious tasks that can hamper productivity.
This course assumes basic Excel skills.
You will learn how to:
- Set up mathematical operations
- Use absolute references for easy auto-filling
- Access basic functions, such as averaging
- Reference data on other sheets
- Manipulate dates using formula logic
- Deal with named ranges in formulas