
Course content
What you'll learn
Advanced Excel with AI, ChatGPT and Co-Pilot: Mastering Productivity and Automation. Unlock the integration of AI with Excel, from streamlining tasks to mastering advanced features and automating processes, for Excel users of all levels.
Advanced Excel - Overview of the Basics of Excel
Customizing common options in Excel. · Absolute and relative cells. · Protecting and un-protecting worksheets and cells.
Advanced Excel - Working with Functions
Writing conditional expressions (using IF) · Using logical functions (AND, OR, NOT) · Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX) · +4 more
Advanced Excel - Data Validations
Specifying a valid range of values for a cell · Specifying a list of valid values for a cell · Specifying custom validations based on formula for a cell
Advanced Excel - Working with Templates
Designing the structure of a template · Using templates for standardization of worksheets
Advanced Excel - Sorting and Filtering Data
Sorting tables, Using multiple-level sorting, Using custom sorting · Filtering data for selected view (AutoFilter) · Using advanced filter options
Advanced Excel - Working with Reports
Creating subtotals · Multiple-level subtotals · Creating Pivot tables · +9 more
Advanced Excel - More Functions
Date and time functions · Text functions · Database functions · +1 more
Advanced Excel - Formatting
Using auto formatting option for worksheets · Using conditional formatting option for rows, columns and cells
Advanced Excel - Macros
Relative & Absolute Macros · Editing Macros
Advanced Excel - WhatIf Analysis
Goal Seek · Data Tables · Scenario Manager
Advanced Excel - Charts
Using Charts · Formatting Charts · Using 3D Graphs · +4 more
Advanced Excel - New Features Of Excel
Sparklines, Inline Charts, data Charts · Overview of all the new features
Excel AI & Co-Pilot: Introduction to AI Tools in Excel
Discover the potential of AI tools within Excel.
Excel with AI & Co-Pilot: Powering Up Excel with ChatGPT
Utilize Column From Examples in Power Query. · Quickly generate data insights with Analyze Data in Excel.
Excel with AI & Co-Pilot: Getting Started with ChatGPT
Learn how to access and utilize ChatGPT effectively. · Introduction to ChatGPT and its versions. · ChatGPT 3.5 and ChatGPT 4 Differences. · +1 more
Excel with AI & Co-Pilot: Unlock the power of ChatGPT for Excel formulas
Easily request simple Excel formulas from ChatGPT. · Seamlessly integrate ChatGPT with Excel tables. · Advance your skills by fixing errors, adding comments, and exploring more complex formulas. · +3 more
Excel with AI & Co-Pilot: Streamline data cleaning and transformation processes
Convert PDF data with ease. · Transform complex Excel files seamlessly. · Practice exercises for reinforcement.
Excel with AI & Co-Pilot: Unlock the potential of ChatGPT in Excel macros
Date and time functions · Learn the basics of macros with ChatGPT. · Dive into event procedures in Excel VBA. · +4 more
Final Assignment
The Final Assignment contains questions to be solved at the end of the Course










