Ultimate Microsoft Excel Data Analytics Course: GPT4 Copilot

The comprehensive course is designed to enhance your proficiency in Excel by covering advanced tech such as GPT4 Copilot

Created by: Gavin Chappell
MS Office Specialist & Teacher

What Will I Learn?

• Learn and Understand Data Manipulation using Excel
• Learn How to Create Formulas to Help you Analyze Data
• Learn and Understand Data Cleansing
• Learn and Understand Tables in Excel
• Learn various ways to model data for businesses
• Build impressive tables and combine datasets using Excel's built-in functionality
• Learn basics of Pivot Tables and Charts
• Clean and prepare your data
• Create a basic Excel Pivot Table and format numbers in it
• Use multiple fields and dimension, and methods of aggregation
• Create Pivot Charts based on Pivot Table data
• Learning Power Query, Power Map and Power Pivot

Requirements

• You have an attitude to learn while having fun 🙂
• Basic Excel knowledge is helpful but not required

Target audience

• This course is for anyone who works with Microsoft Excel even if you’ve never used data analytics, Pivot Table and Pivot Charts