Microsoft Excel: Beginner to Advanced - With 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 Jul, 2024
Language - English
Excel,Data & Analytics,Data Analysis,Excel Dashboard,Excel Formulas and Functions,
Lectures -162
Duration -7.5 hours
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 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
3 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
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