ChatGPT can act as a helpful assistant for Excel users. This 75-minute ChatGPT for Excel training starts with the differences between the free and pro versions of ChatGPT and best practices for combining it with Excel.
You'll then move to tables and PivotTables, with guidance on building PivotTables that match your goals, whether you track sales figures, market research or budgets. Next, you'll see four ways to work with Excel formulas and functions through ChatGPT, so you can understand what a function does and apply the right one to a real problem.
The last segment uses Excel 365's built-in AI tools together with ChatGPT to create charts, graphs and dashboards that present your data clearly.
WHY SHOULD YOU ATTEND?
Many Excel users struggle to understand functions in workbooks they receive, feel unsure about PivotTables, or don't know which formula or chart to choose. This session shows how ChatGPT can guide you through each of these tasks.
It suits beginner to intermediate Excel users in any profession, including business owners, who want more confidence and a faster workflow.
AREA COVERED
- Introduction
- Using ChatGPT and Excel together
- Free vs pro versions of ChatGPT
- ChatGPT basics and best practices for Excel users
- Tables and PivotTables tailored to your data and goals
- Four ways to use ChatGPT for formulas and functions
- Excel 365 embedded AI with ChatGPT for charts, graphs and dashboards
LEARNING OBJECTIVES
- Choose between the free and pro versions of ChatGPT for Excel work
- Apply best practices for using ChatGPT with Excel
- Build tables and PivotTables suited to your data and objectives
- Use ChatGPT to understand, find and apply formulas and functions
- Combine Excel 365 AI features with ChatGPT to create charts and dashboards
WHO WILL BENEFIT?
- Beginner to Intermediate Excel Users will benefit from this course
- Users in all Professions, including Business Owners, will benefit
Many Excel users struggle to understand functions in workbooks they receive, feel unsure about PivotTables, or don't know which formula or chart to choose. This session shows how ChatGPT can guide you through each of these tasks.
It suits beginner to intermediate Excel users in any profession, including business owners, who want more confidence and a faster workflow.
- Introduction
- Using ChatGPT and Excel together
- Free vs pro versions of ChatGPT
- ChatGPT basics and best practices for Excel users
- Tables and PivotTables tailored to your data and goals
- Four ways to use ChatGPT for formulas and functions
- Excel 365 embedded AI with ChatGPT for charts, graphs and dashboards
- Choose between the free and pro versions of ChatGPT for Excel work
- Apply best practices for using ChatGPT with Excel
- Build tables and PivotTables suited to your data and objectives
- Use ChatGPT to understand, find and apply formulas and functions
- Combine Excel 365 AI features with ChatGPT to create charts and dashboards
- Beginner to Intermediate Excel Users will benefit from this course
- Users in all Professions, including Business Owners, will benefit