Mastering Excel with AI and ChatGPT

Funding Validity Period

Course Overview

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 ChatGPT training to enhance productivity and data-driven decision-making skills

Skills Acquired

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

Learning Modules

Learning Unit 1: Leveraging AI Tools in Excel

Automating Tasks with Flash Fill
Streamlining Data Transformation with Power Query
Insights and Analysis with AI in Excel
Visualizing Data with Recommended Charts
Visualizing Data with Recommended Pivot Table
Forecasting Trends with Excel's AI

Learning Unit 2: Integrating ChatGPT with Excel

What is ChatGPT
How to Get ChatGPT
Understanding the Capabilities of Different ChatGPT Versions
Practical Applications of ChatGPT in Excel

Learning Unit 3: Enhancing Excel Formulas with ChatGPT

Crafting Formulas from Simple to Advanced
Utilizing ChatGPT for Excel Table Enhancements
Documenting and Commenting on Formulas with ChatGPT's Help

Learning Unit 4: Advanced Formula Assistance with ChatGPT

Simplifying Lookup Formulas
Working with ChatGPT to write advanced Excel formulas
Deciphering Complex Formulas
Debugging and Optimizing Formulas
Improving existing formulas with ChatGPT

Learning Unit 5: Data Cleaning and Transformation

Transforming Data from PDFs
Transforming Data from Excel
Cleaning and Preparing Data for Analysis

Learning Unit 6: Advanced Data Analysis Techniques

Conducting Comparative Analysis
Generate non Excel visual using ChatGPT
Performing Sentiment Analysis on Customer Feedback

Learning Unit 7: Automating Excel Tasks with Macros and ChatGPT

Writing Macros with ChatGPT
Understanding and Enhancing VBA Code
Adding Comments and Enhancing Code
Debugging VBA code with ChatGPT assistance

Automating Tasks with Flash Fill
Streamlining Data Transformation with Power Query
Insights and Analysis with AI in Excel
Visualizing Data with Recommended Charts
Visualizing Data with Recommended Pivot Table
Forecasting Trends with Excel’s AI

What is ChatGPT
How to Get ChatGPT
Understanding the Capabilities of Different ChatGPT Versions
Practical Applications of ChatGPT in Excel

Crafting Formulas from Simple to Advanced
Utilizing ChatGPT for Excel Table Enhancements
Documenting and Commenting on Formulas with ChatGPT’s Help

Simplifying Lookup Formulas
Working with ChatGPT to write advanced Excel formulas
Deciphering Complex Formulas
Debugging and Optimizing Formulas
Improving existing formulas with ChatGPT

Transforming Data from PDFs
Transforming Data from Excel
Cleaning and Preparing Data for Analysis

Conducting Comparative Analysis
Generate non Excel visual using ChatGPT
Performing Sentiment Analysis on Customer Feedback

Writing Macros with ChatGPT
Understanding and Enhancing VBA Code
Adding Comments and Enhancing Code
Debugging VBA code with ChatGPT assistance

Who is this course is for

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.

Academic prerequisites

Familiarity with Excel basics and fundamental data analysis skills. Familiarity with AI concepts are prerequisites. No prior experience with ChatGPT is required.

Course Fees

Company Sponsored / Self Sponsored

Fees	Company / Self Sponsored
Full Fee	$380.00
GST	$34.20
Nett Fee Payable (incl. GST)	$414.20