Learn Backend Development Part-Time, Online
Earn a Michigan Engineering AI Certificate — Stay Ahead of the AI Revolution
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Master Excel tasks effortlessly through this 12-minute tutorial demonstrating how to leverage ChatGPT's artificial intelligence capabilities. Learn to write complex nested functions, perform unique value calculations, and create basic invoicing macros with minimal effort. Follow along with practical examples including sum calculations, profit analysis, lookup functions, and text manipulation using LEFT and FIND functions. Discover how to automate Excel tasks by generating VBA code through ChatGPT, complete with a downloadable workbook for hands-on practice. Access additional resources including a detailed article walkthrough and related tutorials on Excel macros and VBA programming for further skill development.
Syllabus
Introduction
Get ChatGPT
Simple sum example
Profit example
Lookup functions
Left and find nested function
Unique count nested function
Write macros
Wrap up
Taught by
Kevin Stratvert