Description
Course Outline
Description
Course Overview:
Join our comprehensive course to seamlessly integrate Microsoft Excel skills with ChatGPT capabilities. Whether you’re a beginner or an experienced user, enhance your Excel proficiency and explore ChatGPT’s collaborative potential. Learn Excel tips and tricks, analyze data using provided samples, and elevate your work with smarter conversations and decision-making through ChatGPT. Our hands-on methodology accommodates learners of all levels, guiding you from foundational understanding to adept mastery.
Prerequisite:
Basic excel background is recommended. We recommend that attendees have experience managing teams.
Audience:
- Business professionals
- SME or corporate professionals
Course Outline
Topic 1: Formulas and Functions
- Apply ChatGPT in Basic Formulas (Sum, Average, Count)
- ChatGPT for Functions (IF, VLOOKUP)
- Relative and Absolute Cell References
- Mini Project 1
Topic 2: Data Management
- Sorting, Filtering Data and Slicers
- Data Validation
- Introduction to Tables
- Collaborate and Securing Excel Files
Topic 3: Advanced Formulas
- ChatGPT for Nested Functions
- ChatGPT for Lookup Functions (INDEX-MATCH)
- ChatGPT in Text and Date Functions
- Mini Project
Topic 4: Data Analysis Tools and Data Visualization
- Conditional Formatting
- Creating Basic Charts
- PivotTables: Introduction and Basics
- Data Consolidation and Dashboards
Topic 5: Macros and Automation
- Introduction to Macros
- ChatGPT for Basic Macro Recording
- Applying Macros in Work
