Excel Formulas Made Easy – Learn more than 100 Formulas
$0.99
“Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work.”
“straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example.”
What you’ll learn
- Write advanced formulas for summing and counting values in a list.
- Use lookup functions to fetch values on a spreadsheet.
- Perform calculations with dates and times
- Use formulas to clean and prepare data for analysis.
- Identify and solve formula errors
Course content
1919 sections • 97 lectures • Total duration 8 hours 47 minutes
Introduction
Formulas in a Nutshell
Referencing Cells, Sheets and Workbooks in a Formula
Using Logical Functions
Formulas for Summing Values
Counting Formulas
Calculating Averages
Specialized Functions for Summing and Counting
Working with Text
Date Formulas
Time Formulas
Dynamic Array Functions - Formulas Have Changed Forever
Lookup Formulas
Advanced Lookup Formulas
Solving Formula Errors
New Functions in Excel 2016
Formula Challenges - Test your Skills with Real World Scenarios
Answers for the Formula Challenges
More Learning