ADVANCED EXCEL CLASS
Audience: Professionals, Students and Non-Tech Professionals
What you’ll learn in this Advanced Excel Training
Explore our comprehensive Advanced Excel class designed to empower you with essential skills in Advanced Excel for data analysis.
Course Overview
- No Prerequisite Knowledge required: Beginners to Pro
- Live Online Session: Class is purely online on zoom on weekdays and weekends
- Get Course content: Get downloadable course materials and recorded videos
- Purely Hands-on: Do a project work after each module to use as portfolio
- Certificate of completion: Get a certificate of completion after the class
- Master Advanced Excel: Functions and Formulas, macros, data validation, Pivot Table and advanced data visualization.
What You will learn in Excel
Introduction to Data Analytics
- Data analytics and Business Intelligence
- Data Analysis Pipeline, Data Literacy, Data Privacy etc
- Skills required as a Data Analyst
Microsoft Excel fundamentals
- Working with sheets and workbooks
- Excel formulas and functions
Advanced Excel formulas and Functions
- Using Defined names
- Dynamic Arrays
Analyzing Data with PivotTables and Charts
- Analyzing data with PivotTables and charts
- Slicers and Timelines
What You will learn in Excel
Introduction to Power Query
- Working with External Data sources such as Databases, folders, PDF etc
Cleaning and transforming Data
- Data transformation
- Merging and appending data
- Grouping and summarizing data
Data Modeling and Power Pivot
- Introduction to Data Modeling
- Dimensions and fact tables
- Primary and foreign keys
- Creating and managing relationships
Excel Automation
- Introduction to Macros