
Course content
Full course content
19 modules, 74 topics.
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)
- VLOOKUP with Exact Match, Approximate Match
- Nested VLOOKUP with Exact Match
- VLOOKUP with Tables, Dynamic Ranges
- Using VLOOKUP to consolidate Data from Multiple Sheets
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
- Formatting and customizing Pivot tables
- Using advanced options of Pivot tables
- Pivot charts
- Consolidating data from multiple sheets and files using Pivot tables
- Using external data sources
- Using data consolidation feature to consolidate data
- Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
- Viewing Subtotal under Pivot
- Creating Slicers ( Version 2010 & Above)
Advanced Excel - More Functions
- Date and time functions
- Text functions
- Database functions
- Power Functions (CountIf, CountIFS, SumIF, SumIfS)
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
- Using Bar and Line Chart together
- Using Secondary Axis in Graphs
- Sharing Charts with PowerPoint / MS Word, Dynamically
- (Data Modified in Excel, Chart would automatically get updated)
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.
- Getting started guide.
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.
- Utilize ChatGPT to write lookup formulas and formulas from image data.
- Collaborate with ChatGPT to develop advanced Excel formulas and understand complex ones.
- Improve existing formulas and troubleshoot with the aid of your ChatGPT assistant.
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.
- Utilize ChatGPT for writing and understanding complex VBA code.
- Easily add comments and improve macro code with ChatGPT.
- Debug and troubleshoot VBA code effectively.
- Practice exercises for hands-on learning.
Final Assignment
- The Final Assignment contains questions to be solved at the end of the Course










