About This Course
With the introduction of advanced natural language artificial intelligence (AI) technology, practically anyone with a little programming experience can create complex scripts that automate many repetitive tasks. This can increase productivity and free up time for work on more value-add projects. Therefore, this course is designed for anyone who wants to use ChatGPT to create Excel Office Scripts for automating your repetitive tasks.
Learning Objectives
Upon successful completion of this course, participant will be able to:
- use ChatGPT to create Excel Office Scripts for basic tasks (data transformation, calculations, charts, PivotTable, and PivotChart).
- use ChatGPT to create a complete Excel Automation Project in Office Scripts.
Prerequisites
- Participant must have good Excel skills and understand key concepts of spreadsheets or equivalent.
- It is not necessary to have prior programming knowledge.
Target Audience
Anyone who wants to record and create Excel Office Scripts for daily routine tasks.
Training Outline
- Introduction To ChatGPT
- Getting Started To Use ChatGPT In Microsoft Excel
- About Office Scripts
- Using ChatGPT To Create Excel Office Scripts For Basic Tasks
- Using ChatGPT To Create Excel Automation Project In Office Scripts