At the end of the course, participants will confidently integrate AI into Excel, use Copilot for advanced tasks, automate processes, and enhance productivity, ensuring data-driven decision-making proficiency at course completion. 

In today’s rapidly evolving digital landscape, the capability to efficiently manipulate, analyse, and derive insights from data is more crucial than ever. This course combines AI integration in Microsoft Office Excel with focused Copilot training to enhance productivity and data-driven decision-making skills

Full Time

Excel users seeking to elevate data analysis skills with AI, office workers aiming for advanced Excel proficiency, and individuals interested in automating tasks using macros and AI in spreadsheets. 

1 Day

8

Unit 1: Excel Essentials Refresher 

1. Excel Interface & Navigation  
2. Excel Functions  
3. Cell Referencing Techniques  
4. Importing Data into Excel  
5. Tables  
6. Introduction to PivotTables  

7. Workbook & Worksheet Protection 

Unit 2: Leveraging AI Tools in Excel 

 1. Automating Tasks with Flash Fill  

2. Streamlining Data Transformation with Power Query  

3. Insights and Analysis with AI in Excel  

4. Visualizing Data with Recommended Charts  

5. Visualizing Data with Recommended Pivot Table 

6. Forecasting Trends with Excel's AI  

Unit 3:  Integrating Copilot with Excel 

 1. What is AI chat interface  

2. How to get AI chat interface  

3. Understanding the Capabilities of Different AI chat interface  

4. Practical Applications of AI chat interface in Excel

Unit 4: Enhancing Excel Formulas with Copilot 

 1. Crafting Formulas from Simple to Advanced  

2. Utilizing Copilot for Excel Table Enhancements 

3. Documenting and Commenting on Formulas with Copilot's Help 

 Unit 5: Advanced Formula Assistance with Copilot 

1. Simplifying Lookup Formulas  

2. Working with Copilot to write advanced Excel formulas  

3. Deciphering Complex Formulas  

4. Debugging and Optimizing Formulas 

5. Improving existing formulas with Copilot  

Unit 6: Data Cleaning and Transformation 

 1. Transforming Data from PDFs  

2. Transforming Data from Excel 

3. Cleaning and Preparing Data for Analysis 

Unit 7: Advanced Data Analysis Techniques 

1. Conducting Comparative Analysis  

2. Generate non Excel visual using Copilot  

3. Performing Sentiment Analysis on Customer Feedback 

Unit 8: Automating Excel Tasks with Macros and Copilot 

1. Writing Macros with Copilot  

2. Understanding and Enhancing VBA Code  

3. Adding Comments and Enhancing Code  

4. Debugging VBA code with Copilot assistance