|
Excel 365 Essentials
|
|
|
|
Introduction to Excel 365
|
|
|
|
Overview of Excel for Business Analytics
|
|
|
|
Understanding Excel’s interface and functionalities
|
|
|
|
Formatting data and cells
|
|
|
|
Basic formulas and functions
|
|
|
|
Introduction to data validation
|
|
|
|
Working with Data
|
|
|
|
Importing and exporting data
|
|
|
|
Sorting, filtering, and conditional formatting
|
|
|
|
Using named ranges
|
|
|
|
Introduction to charts and graphs
|
|
|
|
Essential Functions
|
|
|
|
Logical functions (IF, AND, OR)
|
|
|
|
Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
|
|
|
|
Date and time functions
|
|
|
|
Text functions (CONCATENATE, TEXT, LEFT, RIGHT)
|
|
|
|
Basic Data Analysis
|
|
|
|
Creating pivot tables and charts
|
|
|
|
Understanding basic statistical analysis (mean, median, mode)
|
|
|
|
Using slicers to filter data
|
|
|
Advanced Excel Techniques
|
|
|
|
Advanced Functions and Formulas
|
|
|
|
Advanced Data Analysis
|
|
|
|
Automation and Macros
|
|
|
|
Dashboards in Excel
|
|
|
Data Visualization with Tableau
|
|
|
|
Introduction to Tableau
|
|
|
|
Advanced Visualization Techniques
|
|
|
|
Dashboard Design
|
|
|
|
Advanced Analytics
|
|
|
Advanced Analytics and Reporting with Power BI
|
|
|
|
Getting Started with Power BI
|
|
|
|
Data Modeling
|
|
|
|
Advanced Visualizations
|
|
|
|
Power BI Services and Integration
|
|
|
Capstone Project
|
|
|
|
Analyze a real-world business dataset
|
|
|
|
Use Excel for data cleaning and preparation
|
|
|
|
Visualize insights using Tableau and Power BI.
|
|
|
|
Build a dashboard and present findings in a final report.
|
|