About the Course
Formulas in Excel are a beautiful thing. It allows us to analyze and manipulate data very easily and in a way that simply can’t be done on pen and paper. In addition, it allows us to do it with relative ease. For example, for a given table with values, to add all values in one column to the next involves writing the formula once (which takes a few seconds), then duplicating it to the rest (another few seconds). It couldn’t easier.
In this course I’m going to cover everything you need to know to get started with formulas. I should remind you that this extends beyond basic arithmetic (i.e. addition and subtraction). Therefore, this is just the stepping stone to even more wonderful Excel formulas in your immediate future!
This is for beginners and possibly some intermediates as I have included some more advanced functions as well that you may not be aware of.
This course contains just over 15 videos with a total time just over 36 minutes.
This course is designed for beginners.
- Manual calculations
- Addition, subtraction
- Multiplication and division
- Cell linking
- Nested formulas
- Formula Tracing
- AutoSum Function
- Opening Act
- Promotional Video00:00:00
Don't forget to download the work file so you can follow along!
- Core Functions
- Manual Calcuations00:00:00
- Your first formula Subtraction00:00:00
- Multiplication and Division00:00:00
- Decimal Places00:00:00
- Does This Cell Equal That Cell00:00:00
- Nested Formula’s00:00:00
- Linking Cells00:00:00
- Tracing and Auditing
- Tracing Formula’s00:00:00
- Show Formula’s00:00:00
- Bonus Functions
- Autosum Function00:00:00
- Autosum functions in Detail00:00:00
- Combining Text With Formula’s00:00:00