In this class IÂ discuss the 15 most useful Excel formulas.Â
Everyone lesson covers a (group of) formula(s). The videos are built up in three ways:
1. What does the formula do?
2. What is it used for?
3. Demonstration
This class helps you to gain a head start in using Excel. These formulas are the basis of building more complex and useful formulas.Â
Attached, is the file used for the formulas. In case you want to look back into how the formulas are built up, feel free to download the spreadsheet and dive into it!
Enjoy the class!
Overview
Syllabus
- Introduction
- Class Outline
- NOW & TODAY
- SUM(IFS)
- COUNT(IFS)
- AVERAGE(IFS)
- MIN & MAX
- CONCAT / &
- TRIM
- UPPER, lower & Proper
- IF
- AND / OR
- NOT
- RIGHT, LEFT & LEN
- PMT
- VLOOKUP
- IFERROR
Taught by
Ruben Wollerich