What you’ll learn:
- Excel
- Advanced Excel
- Advanced Excel Formulas
- Pivot Table and Slicers
- Advanced Conditional formatting
- VBA
- Vlookup & XLookup
Requirements
- Exposure to Excel environment
Description
Updated for 2021
You would get to learn the basic concepts that run excel and become efficient at it. This is the most updated course on Excel with the Most recent formulas and Features that matter the most.
You can be the excel guru at your workplace and master most of the unknown or poorly used shortcuts. Yet very powerful in their own terms.
This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I teach through animated designs and videos for you to understand the concepts better.
We’ll deep dive into a broad range of Excel formulas & functions, including:
Lookup/Reference functions
Statistical functions
Formula-based formatting
Date & Time functions
Logical operators
What gives you the right to teach this class? Can’t I just Google this stuff?
I have a genuine passion for Excel that most people reserve for things like kittens, ice cream, and significant others. The only thing I love more than learning Excel is teaching it, and as the founder of YourExcelGuy and have helped 10000+ students across 10+ countries.
Thanks!
-Kadhir (Founder, YourExcelGuy)
Who this course is for:
- All Levels of Excel Users