Microsoft Excel: Beginner to Advanced in animation 2026 + AI
-
Introduction
-
Fundamentals of Excel
-
Flash Fill – A data Cleaning and Processing FeaturePractice File for Flash FillIntroduction to Flash Fill – Magical Feature of Excel0sFlashFill for Joining Data in Excel0sFlashFill to Split Data0sFlashFill for Dates Extraction and Manipulation0sExtracting Month info as text and converting again0sFlashFill for Formatting Data0sFlash Fill for Complex Data Situations0sWhere Flash Fill would Fail0sFlashFill Assignment – Question0sFlash Fill Assignment Solution0sFlash Fill Answer File0sWhat have we Learnt so Far0s
-
Additional Data Management Tools
-
Data Validation – A Data Collection and Data Quality Management Tool – BasicsPractice File for Data ValidationIntroduction to Data Validation0sHow Data Validation works0sValidating an input with certain number of characters0sReplicating Data Validation to Other Rows0sValidating an Input of Date values using Data Validation0sEnabling Input Message and Error Alert for Data Validation Cells0sData Validation for Time Information0sCustom List of Items in Data Validation0sData Validation Assignment Question0sData Validation Assignment Solution0sData Validation – Answer FileLearning so Far0sAI Lesson : Allowing a Complex Student ID Entry with Data Validation and ChatGPT0sAI Lesson: Allowing only current date using Data Validation and ChatGPT0sAI Lessons 3 – Validating an Email address using ChatGPT0s
-
Absolute Fundamentals of ExcelPractice file for FundamentalsSheets Management in Excel0sManaging Column Width and Row Height0sBasic Formatting options0sCopy and Paste0sPaste Special – Paste values only0sCopying as an Image and Pasting0sPaste Special – Linked Image0sPaste Formulas and Number Formatting0sAdvanced Paste Special – Skipping Blanks0sAdvanced Paste Special – Pasting with Operations0sFreeze and Unfreeze0sWrapping and Merging0s
-
Filtering and Sorting – A Data Interpretation ToolPractice File for this SectionIntroduction to Filtering0sApplying Filter for the First Time0sFiltering Data On Misaligned Dataset0sFiltering Data on a Text based Information0sFiltering Date information with 1 criteria0sFiltering Date information with 2 criteria0sFiltering Time information with Multiple Criteria0sFiltering Data on Multiple Fields0sIntroduction to Sorting0sSorting Date Information0sFiltering and Sorting Dates0sAdvanced Sorting Along with Filtering0sPractice File with AnswersSo Far in this Course0s
-
Additional Filtering tools – Advanced Filter
-
Excel Pivot Tables – A Data Analysis ToolPractice file for Pivot TablesThe Business Story Continuation0sPivot Tables Introduction0sPivot Table Interface and our First Pivot Table0sHow Pivot Table Works0sFirst Pivot Table with a Calculation0sDifferent Calculations from the Same Field0sUsing Rows and Columns in Pivot Tables for the Same Field0sUsing Rows and Columns for 2 different fields0sManaging Labels of a Complex Pivot Table0sSorting Values in Pivot Table0sLabel Filtering in Pivot Tables0sValues Filtering in Pivot Tables0sReport Level Filters in Pivot Tabels0sFormatting Values in Pivot Table0sManaging Date Information in Pivot Tables0sMulti Field Calculations in Pivot Tables0sTop 3 and Bottom 3 in Pivot Tables0sChanges in the Data Source0sColumn Referencing and the Challenges of Blanks0sRange Vs Table Source for Pivot Tables0sGrouping Data in Pivots0sUsing Slicers to Filter Single and Multiple Reports0sUsing Timelines to filter single and Multiple Reports0sPivot Table Assignment Question Walkthrough0sPivot Table Assignment Solution Walkthrough0sOur Learning So Far0sPractice File with Answers
-
Visualizing Data with Conditional Formatting – BasicsPractice File for Conditional FormattingChallenges of Understanding Summarized Data0sHow Effective is Conditional Formatting0sUnderstanding Data Bars and How it works0sUsing Data Bars on Same Filed and Adjacent Field0sCustomizing Data Bars0sIntroduction to Color Scales0sApplying Color Scales on Pivot Table Report0sCustomizing Color ScalesIntroduction to Icon Sets0sApplying Icon Sets on a Report and Customizing Criteria0sCustomizing the Icon Sets0sDuplicates Highlight and Where Conditional Formatting Fails0sConditional Formatting – Icon Sets and Top Bottom Rules0sConditional Formatting Assignment Walkthrough0sAnswer file for Conditional FormattingLearning so Far0s
-
Printing and Layouts
-
Excel Formulas and Functions 101
-
Excel Formulas: Basic Functions but Frequently usedBasic Functions Practice File with QuestionsHow SUM Function works0sHow AVERAGE works – Excel Formulas0sPracticing AVERAGE Excel Formulas0sHow COUNT and COUNTA function works – Excel Formulas0sCount Function and Counting Capabilities0sCOUNTA and its Counting Capabilities and Limitations with Excel Formulas0sHow MAX and MIN function works0sPracticing MAX and MIN – Excel Formulas0sAssignment Question0sAssignment Solution0sAnswer file for Basic Formulas
-
Some More Concepts of Excel Formulas and Functions
-
Excel Formulas: Solving Business Questions with Logical Formulas
-
Advanced Excel Formulas: Wild Cards and IF Family of FormulasDownloadable Practice FileUsing SumIF and Calculating a Metric – Excel Formulas0sSumIF with Wild Cards in Excel Formulas0sAverageIF and CountIF Formulas along with the Wildcard situations0sIFS Formula and SumIFS Formulas0sSumIFS with Wild Card Situations and SumIFS with Operator Situations0sAverageIFS with Wildcard and Operator Situations in Excel Formulas0sMaxIFS with Operators and Wild Cards – Excel Formulas0sMinIFS with Operators and Wild Cards – Excel Formulas0sAnswer File for all of these Functions
-
Excel Formulas: TEXT Formulas
-
Basic Excel Formulas: Data and Time FormulasPractice file for download with QuestionsCreating dynamic current date with TODAY – Excel Formulas0sExtracting only the DAY information from a date – Excel formulas0sExtracting only the MONTH information from a date – Excel formulas0sExtracting only the YEAR information from a date – Excel formulas0sExtracting all forms of TIME information from a timestamp – Excel Formulas0sFinding the difference of DAYS0sFinding the difference of Working Days using NETWORKDAYS0sFinding the difference of custom working days using NETWORKDAYS.INTL0sAnswer file for download
-
Excel Formulas: Vookup, XLookup and other lookup formulasVLOOKUP Practice FilesIntroduction to VLOOKUP – Excel Formulas0sHow VLookup Works0sVlookup in Simple Business Situation 2 – Text Clue0sVlookup in Simple Business Situation 3 – Number as the Clue0sVlookup in Simple Business Situation 4 – Number as the Clue0sVlookup in Simple Business Situation 5 – Approximate Lookup0sVlookup in Simple Business Situation 6 – Two Way Lookup0sIntroduction to XLookup – Excel Formulas0sALERT for XLookupPractice File for XLookup – Excel FormulasXLOOKUP on Simple Data – Excel Formulas0sXLOOKUP on Date and Horizontal Data – Excel Formulas0sXLOOKUP with Match mode of Higher Value0sXLOOKUP with Match mode of Lower Value0sXLOOKUP with Match mode of Wildcard Characters0sIntroduction to INDEX Formula – Excel Formulas0sIntroduction to MATCH formula – Excel Formulas0sUsing INDEX and MATCH Together0s
-
Advanced Excel Formulas: Nested Formulas and ChatGPTPractice file for download – QuestionsIntroduction to Nested formulas – Excel Formulas0sCreating our First Nested formula – Excel Formulas0sReversing the Logic within a Nested formula – Excel Formulas0sBuilding Complex Nested Formulas in a Step by Step Approach0sBuilding a Complex Nested IF Formulas with ChatGPT0sBuilding a Super Complex Nested IF function with ChatGPT0sAnswer File for this Section
-
Advanced Text FormulasPractice File DownloadExtracting Numbers using TEXT formula0sExtracting Month info using TEXT Formula0sExtracting AM or PM from timestamp using TEXT formula0sSome more situations of using TEXT Formula0sReplacing values using SUBSTITUTE Formula0sReplacing values using REPLACE Formula0sChanging dynamic values using SWITCH formula0s
-
Rounding Excel Formulas
-
Advanced Statistics Formulas
-
Charts and VisualizationWhy Charts are needed ?0sComparison Charts – Clustered 2D column0sComparison Charts – Stacked 2D column0sComparison Charts – 100% Stacked 2D Column0sComparison Charts – Clustered 2D Bar0sComparison Charts – Stacked 2D Bar0sComparison Charts – 100% Stacked Bar0sTrend Charts – 2D Clustered Line Chart0sTrend Charts – 2D Stacked Line Chart0sTrend Charts – 2D Fully Stacked line Chart0sLine Charts with Markers0sTrend Charts – Clustered Area Chart0sTrend Charts – Stacked Area Chart0sPart to Whole Relationships – 2D Pie Chart0sPart to Whole Relationships – 2D Pie of a Pie chart0s
-
Dashboarding with Pivot TablesDashboarding Project File for DownloadImportance of Dashboard0sCreating and Managing Business Questions for Dashboarding0sSetting up the Environment for Dashboarding0sGenerating Business Answers and Questions for Dashboarding0sChoosing Charts for Dashboarding0sAligning and Resizing Charts – Draft View of Dashboard0sRemoving Distractions from the Dashboard0sBringing the Insights Out from our Dashboard0s
-
Interactive Dashboarding
-
Advanced Customizations and Data Summarization of Dashboards
-
Creative Dashboard
-
Advanced Use Cases of AI Using ChatGPTPractice files for AICounting Words of Sentences0sCreating a Project Deadline Alert0sProfit Margin Calculation0sCreating a flag for Employee Attendance and Tracking with ChatGPT0sDynamic Pricing Model with ChatGPT0sCustomer Segmentation with ChatGPT0sInventory Management with ChatGPT0sExpense Report Validation with ChatGPT0s
-
Conclusion
Welcome to our Updated Excel Mastery Course with ChatGPT, where we’ve enhanced our offerings to cater to beginners and advanced users alike. In addition to the comprehensive Excel content previously mentioned, we are excited to introduce new features to elevate your Excel skills even further, with a special emphasis on AI-driven learning for Excel Formulas.
This covers the below features and formulas for you to learn:
300+ business situations
Excel Fundamentals
FlashFill
Data Validation
Text-To-Columns
Duplicates Remover
Advanced and custom Fill
Advanced Filtering and Sorting
Grouping and ungrouping
Printing and layouts Management
Pivot Tables
Advanced Pivot Tables
Conditional Formatting
Excel Basic Functions
Text Function
Logical Functions
Wild Cards in Excel formulas and functions
Logical Aggregation Functions
Advanced IF and IFS functions
Vlookup and Hlookup
Xlookup
Match and Index
Rounding functions
Advanced Statistics Functions
Advanced Calculations
Basic and Advanced Date and Time Functions
Nested Formulas
Charts and Visualisations
Dashboard Creation and Analysis
AI use cases for all the topics covered
Data Source management
New Features:
AI-Driven Learning for Excel Formulas:
Dive into the future of Excel learning with our cutting-edge AI-driven modules. Leverage artificial intelligence to enhance your understanding of complex formulas, receive personalised insights, and optimise your Excel workflow. Uncover the power of AI as a companion in your data analysis journey.
How to Use ChatGPT for Excel Complex Situations:
Unlock the full potential of ChatGPT to navigate intricate Excel scenarios. Learn how to seamlessly integrate AI assistance for problem-solving, formula optimisation, and gaining insights into unique challenges you may encounter in your data analysis journey.
Expanded Excel Formulas Module:
Delve deeper into Excel formulas with an additional 20 formulas covering a wide range of situations. From financial calculations to statistical analysis, these formulas will empower you to handle diverse data scenarios with confidence.
Extended Excel Pivot Tables Section:
Elevate your data analysis game with an extended section on Excel Pivot Tables, covering 15 different situations. Master the art of summarizing and analyzing large datasets with ease.
Enhanced Excel Dashboard:
Explore the integration of AI in dashboard creation. Learn how to use AI to identify patterns, trends, and outliers in your data, enabling you to design more insightful and dynamic dashboards.
Advanced Charting Techniques:
Take your data visualisation skills to the next level with advanced charting techniques. Learn to create visually stunning and informative charts that effectively communicate your data insights.
More Practice Sheets:
Sharpen your skills with over 30 additional practice sheets, providing hands-on experience and reinforcing the concepts learned throughout the course.
As we step into 2024, Excel proficiency coupled with AI-driven insights is the key to staying ahead in the world of data analysis. Join us in this advanced learning experience, and let’s explore the future of Excel together.
– Kadhiravan
What's included
- 14 hours on-demand video
- 33 articles
- 39 downloadable resources
- Access on mobile and TV
- Full lifetime access
- Certificate of completion