Complete Excel Formulas Course
About the Course
DESCRIPTION
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!
TARGET AUDIENCE
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.
STRUCTURE
This course contains just over 15 videos with a total time just over 36 minutes.
DIFFICULTY
This course is designed for beginners.
COURSE OUTCOMES
 Manual calculations
 Addition, subtraction
 Multiplication and division
 Cell linking
 Nested formulas
 Formula Tracing
 AutoSum Function
 Concatenation
Course Structure
 Opening Act

Don't forget to download the work file so you can follow along!

 Core Functions
 Tracing and Auditing
 Bonus Functions