Advanced Excel Formulas, Shortcuts and Excel Efficiency Tips
- Description
- Curriculum
- FAQ
- Reviews
Take your Excel formula skills to the next level. Become more productive and efficient!
This course will teach you how to solve complex Excel problems quickly. You will learn advanced techniques to slice and dice data efficiently. All of the examples are business focused, so you can see how to be more productive in the real world.
- Lookups – VLOOKUP, HLOOKUP formulas
- Index + Match formula examples and tricks
- SUMIF + SUMIFs formulas
- COUNTIF + AVERAGEIF formulas
- Wildcard character in formulas (most Excel users don’t know this exists)
- Split first and last name using Left and Right formulas
- Use the EOMonth and DATEDIF formulas with dates
- Indirect formula to pull information from other worksheets
- SUMPRODUCT formula, the most dynamic Excel formula
- Array formulas
- Excel shortcuts and efficiency tips that I use daily
- Re-group rows using numbering and filtering
- Select and delete blank value rows
These are tips and tricks that I use daily as a CPA accountant and with hundreds of clients. Every file used in the videos is included as a reference. Practice makes perfect, so you are encouraged to download all of the reference files and practice alongside the videos.
With efficiency in mind, there is no fluff. Every video jumps directly into the Excel formula or shortcut example. The course also includes a Q&A section where you can ask questions, reply to other students and myself. Let’s begin!
-
2Absolute and Relative ReferencesVideo lesson
-
3VLOOKUP FormulaVideo lesson
-
4HLOOKUP FormulaVideo lesson
-
5Index + Match FormulasVideo lesson
-
6DATEDIF FormulaText lesson
-
7Index + Match Another ExampleVideo lesson
-
8Index + Match TrickVideo lesson
-
9SUMIF + SUMIFs FormulasVideo lesson
-
10AVERAGEIF + COUNTIF FormulasVideo lesson
-
11Wildcard Character in FormulasVideo lesson
-
12Split Names Using Left and Right FormulasVideo lesson
-
13EOMonth Formula for DatesVideo lesson
-
14Indirect Formula to Pull From Other SheetsVideo lesson
-
15SUMPRODUCT FormulaVideo lesson
-
16How the SUMPRODUCT Formula WorksVideo lesson
-
17Array FormulasVideo lesson
External Links May Contain Affiliate Links read more