Microsoft Excel Course: Beginner to Advanced - AI and ChatGPT
Learn A-Z in Microsoft Excel in 12 hours and become an advanced excel user with Vlookup, Xlookup, Pivot Tables, Power Pivot, Charts, Dashboard and more.
Updated on Jun, 2025
Language - English
Office Productivity,Microsoft,Excel
Lectures -170
Resources -2
Duration -8 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Welcome to the Excel Mastery course, where you'll learn everything from beginner to intermediate Microsoft Excel. We are delighted to present new tools to help you improve your Excel skills, with a focus on learning Excel formulas and commercial use cases.
Excel Formulas Module: Includes 40 new formulas for diverse circumstances. From financial computations to statistical analysis, these formulae will give you the confidence to manage a variety of scenarios.
Improve your data analysis skills with an extended session on Excel Pivot Tables, covering 15 scenarios. Learn how to quickly summarize and analyze huge datasets.
Discover how AI may be used to enhance Excel dashboards. Learn how to utilize AI to recognize.
Goals
- Become an Excel Formulas master.
- Become a Pivot table advanced user.
- Become confident at using complex Excel formulas.
- Become confident at creating and customising charts.
Prerequisites
- Basic Knowledge of using a computer and Microsoft Excel installed.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
3 Lectures
-
Introduction to the Course Story
01:04
01:04
-
Introduction to Excel Environment
03:11
03:11
-
Spreadsheets Features vs Function
05:04
05:04
Absolute fundamentals of Excel
11 Lectures
Data Cleaning with Flash Fill
11 Lectures
Managing the collection of information using Data Validation
14 Lectures
Interpreting information with Filtering and Sorting
13 Lectures
Analysing information with Pivot Tables and Advanced Pivot Tables
27 Lectures
Simple visualisations of info with Conditional Formatting
14 Lectures
Absolute fundamentals of Formulas
4 Lectures
Most frequently used Excel functions
11 Lectures
Advanced concepts of Excel Formulas
3 Lectures
Advanced Excel Formulas : Wild Cards and IF Family of Formulas
8 Lectures
Date Formulas
8 Lectures
VLookup and XLookup
17 Lectures
Nested Formulas and Using ChatGPT to build formulas
6 Lectures
Advanced Text Functions
7 Lectures
Rounding Functions
5 Lectures
Advanced AI use cases in Excel with ChatGPT
8 Lectures
Instructor Details
Kadhiravan Jayachandiran
A Microsoft certified Excel Expert (MO 201) with over 10 years of experience in the Recruitment and Analytics Industry.
Having worked for several Multinational companies and startups I understand the importance of Excel in all types of organizations and how it's used differently from one to another.
I use Excel every day, every hour of my life both personal and professional, and have been tutoring this tool for over 13 years.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now