Advanced Excel with AI (ChatGPT & Co-Pilot): Mastering Productivity
| Advanced Excel Content | ||
| 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 ~ Nested VlookUP with Exact Match ~ 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 Macro's |
||
| 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 with AI & Co-Pilot Content | ||
| 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 would test
contains questions to be solved at the end of the Course |
