Skip to main content
by learnformula
Explore courses
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
Explore courses
  1. Courses
  2. /Office Productivity
  3. /Data Analysis & Visualization

ChatGPT for Excel Professionals: Formulas, Reporting and Automation — 2027 Edition

Supercharge your productivity by using AI to write complex formulas, automate tedious workflows, and transform raw data into stunning reports in seconds.

Created byAlan Murray
BeginnerUpdated Nov 5, 2026

What You'll Learn

  • check_circleApply ChatGPT to write and audit complex Excel formulas
  • check_circleTroubleshoot formula errors using AI assistance
  • check_circleDevelop refreshable processes for importing and cleaning datasets
  • check_circleConstruct macros to automate repetitive spreadsheet tasks
  • check_circleBuild professional reports utilizing pivot tables and formulas

About This Course

This course details the integration of ChatGPT into Excel workflows to support formula generation, data management, and reporting tasks. It covers methods for drafting, troubleshooting, and documenting complex formulas, including those derived from screenshots or structured references. The material also addresses data cleaning techniques, the importation of external data formats like PDFs, and the development of refreshable preparation workflows using Power Query. Finally, it outlines the use of AI for performing sentiment analysis, generating data insights, and constructing professional charts and PivotTable reports.

Topics Covered:

  • Excel formula generation and auditing
  • Formula troubleshooting and documentation
  • PDF data importation workflows
  • Power Query data preparation
  • Sentiment analysis in text data
  • PivotTable report construction
  • Excel chart development and refinement

Course Content

6 activities • 32 videos • duration: 2h 30m

  • videocam1.1 ChatGPT for Excel: Course Introduction
    Duration 0:56
  • videocam1.2 Set Up ChatGPT and the Excel Add-in
    Duration 6:57
  • videocam1.3 Choose Between ChatGPT in the Browser and the Excel Add-in
    Duration 1:46
  • videocam1.4 Get Things Done in Excel with ChatGPT
    Duration 7:10

Your Instructor

Alan Murray

Excel Trainer, Microsoft MVP and Author | Founder of Computergaga

menu_book1 courses

Alan Murray is an Excel trainer, Microsoft MVP and founder of Computergaga. Through his books, courses and popular YouTube channel, he helps professionals solve practical problems and work more effectively with Excel. He also organises the London Excel Meetup and speaks at international Excel events.

Credit Information

Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.

What Students Are Saying

0.0 out of 5
Student's Choice
0 reviews

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(625 reviews)
    2 CPD hrs
  • Finance: NASBA - Finance

    Sensitivity Analysis and Scenario Planning

    starRated5.0out of 5,(151 reviews)
    1.5 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(693 reviews)
    2.5 CPD hrs