
Course content
What you'll learn
Unlock the seamless integration of AI with Excel: from streamlining tasks to mastering advanced features and automating processes. Microsoft Copilot brings generative AI into Microsoft 365, turning Excel, Word, PowerPoint, Outlook and Teams into intelligent productivity partners.
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










