UEN No.: 198802365N

Mastering Excel with AI and ChatGPT

COURSE synopsis

Course Details

Course Duration

8 HRS

Course Reference Number

N.A

Funding Validity Period

Mode of Training

Classroom

Introduction

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

Course Objectives

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.

Who is this course 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.

Assumed skills

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

Course Content

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
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored / Self Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$380.00 $34.20 $414.20

Related Courses

IT

24 HRS

WSQ

IT

16 HRS

WSQ

IT

16 HRS

WSQ

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8776 7397

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE