Description
What you’ll learn
-
Our Excel course is designed to take you from zero to hero so you can confidently list ‘Advanced Excel Skills’ on your resume/CV
-
Dashboard Reporting in Excel with Tips
-
Advanced Excel – More Scenario Examples, Data Analysis, Pivot Table
-
Modern Excel – DAX and Power Query
-
Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
-
Create dynamic reports by mastering one of the most popular tools, PivotTables
Introduction:
Are you ready to take your Excel skills to the next level?
Do you want to pursue a career in Excel related work?
Are you finding that employers these days want ‘Advanced Excel Skills’?
Or maybe you’ve started a new job that requires more advanced Excel skills.
Do you struggle with Excel?
Not sure which formula to use for your situation?
Are you tired spending hours online trying to get “RIGHT” help?
When asked to make a dashboard or report, not sure where to start?
Module K – 15 Excel Functions Refresher, Module J – Exclusive Templates, Module I – Additional Learning 2 – Advanced Excel – More Scenario Examples, Module H – Additional Learning 1 – Dashboard Reporting in Excel with Tips, Module G – Modern Excel – DAX and Power Query, Module F – Pivot Table, Module E – Excel Charts and Visualizations, Module D – Data Analysis, Module C – Excel Formulas and Functions, Module B – Excel Essentials, Module A – Excel Basics (for Beginners)
Our Excel course is designed to take you from zero to hero so you can confidently list ‘Advanced Excel Skills’ on your resume/CV, or quickly get to grips with the requirements of a new job.
I have used the Excel 2021 / Office 365 to record these videos. Almost everything covered in this course will work for all the Excel versions (2010, 2013, 2016, 2019 & Office 365).
IS THIS ONLINE EXCEL COURSE FOR BEGINNERS ONLY?
This Complete Excel Course is for two types of people:
-
Excel beginners, i.e. anyone looking to learn Excel from scratch
-
Excel intermediate and Excel advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of.
The Excel Essentials for the Real World Course covers ALL the fundamentals an Excel beginner needs to know. BUT it also fills in the gaps for Excel Intermediate and Advanced users. It’s for corporate professionals who feel comfortable with Excel but not 100% confident.
This is more than an Excel Basics Course. It starts off easy and adds in tips and tricks many Excel advanced users don’t know of.
COURSE UPDATED to Include the BRAND NEW Excel Functions available in Microsoft 365 such as:
-
Excel’s new XLOOKUP function
-
New FILTER function in Excel
-
SORT, SORTBY & UNIQUE functions
PYTHON Module is added
Who this course is for:
- Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
- Students who want to make sure they have the Excel knowledge to succeed at their next job.
- Data analysts looking to discover new tools to help them do more in less time.
Course content
- Module A – Excel Basics (for Beginners)2 lectures • 27min
- Module A – Excel Basics (for Beginners)
- Module B – Excel Essentials8 lectures • 1hr 2min
- Module B – Excel Essentials
- Module C – Excel Formulas and Functions21 lectures • 6hr 24min
- Module C – Excel Formulas and Functions
- Module D – Data Analysis11 lectures • 2hr 53min
- Module D – Data Analysis
- Module E – Excel Charts and Visualizations1 lecture • 1hr 37min
- Module E – Excel Charts and Visualizations
- Module F – Pivot Table2 lectures • 1hr 14min
- Module F – Pivot Table
- Module G – Modern Excel – DAX and Power Query20 lectures • 4hr 40min
- Module G – Modern Excel – DAX and Power Query
- Module H – Advanced Dashboard Reporting in Excel (DAX & Visualizations)2 lectures • 2hr 6min
- Module H – Advanced Dashboard Reporting in Excel (DAX & Visualizations)
- Module I – More Learnings – Advanced Excel – More Scenario Examples24 lectures • 4hr 8min
- Module I – More Learnings – Advanced Excel – More Scenario Examples
- Module J – Exclusive Templates1 lecture • 1min
- Module J – Exclusive Templates
Reviews
There are no reviews yet.