Course Information
Course Overview
Microsoft Excel Course for Data and Business Analytics (Basic to Advanced)
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
Course Content
- 18 section(s)
- 135 lecture(s)
- Section 1 Module A - Excel Basics (for Beginners)
- Section 2 Module B - Excel Essentials
- Section 3 Module C - Excel Formulas and Functions
- Section 4 Module D - Data Analysis
- Section 5 Module E - Excel Charts and Visualizations
- Section 6 Module F - Pivot Table
- Section 7 Module G - Modern Excel - DAX and Power Query
- Section 8 Module H - Advanced Dashboard Reporting in Excel (DAX & Visualizations)
- Section 9 Module I - More Learnings - Advanced Excel - More Scenario Examples
- Section 10 Module J - Exclusive Templates
- Section 11 Module K - 15 Excel Functions Refresher
- Section 12 Excel Assessment / MCQS Quiz - Part 1
- Section 13 Quick Excel Tips & Tricks - Features & Functions
- Section 14 Excel Practice Assignments - Functions & Formulas
- Section 15 Learn Analytics using PYTHON in Microsoft Excel
- Section 16 Earn Income - Side Hustle - Freelancing Services of Microsoft Excel
- Section 17 LinkedIn Profile Optimization Tips | Exploring Jobs (On-Site + Remote)
- Section 18 Microsoft Office Specialist MOS Exams Certification with Files
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
Skills covered in this course
Reviews
-
YYogeswary Arumugam
YES VERY CLEAR AND UNDERSTANDABLE
-
ssahib zar
very informative videos & easy to understand & well explained
-
LLaurent Outang
The author could at least have taken the trouble to recreate a cohesive presentation on Udemy, rather than pasting together a disparate collection of webinars and online course snippets (sometimes even in their local language?!): It's not very professional! Moreover a lot of exercice files are missing, so You can not practice along !
-
UUdemy User
I am thoroughly enjoying the course so far. The step by step expalnation is easy to understand.