How lukebarousse/excel_data_analytics_course works
This repository is a downloadable Excel course, not an application: learners follow chapter workbooks, practice with problem workbooks, and use supplied datasets and project workbooks. The README documents the chapter topics and practice-problem collection; the tree shows datasets and two projects, but their contents and relationships were not sampled, so those are represented without inferred workflow edges.
Main entry points: 1_Spreadsheets_Intro Spreadsheet foundations · 2_Formulas_Functions Formulas and functions · 3_Charts_Graphs Charts and graphs · 4_Spreadsheets_Advanced Advanced spreadsheets
Components 14
Course chapters
- Spreadsheet foundations
1_Spreadsheets_Intro - Formulas and functions
2_Formulas_Functions - Charts and graphs
3_Charts_Graphs - Advanced spreadsheets
4_Spreadsheets_Advanced
Analysis workflows
- Pivot tables
5_Pivot_Tables - Advanced analysis
6_Advanced_Data_Analysis - Power Query
7_Power_Query - Power Pivot and DAX
8_Power_Pivot
Practice and projects
- Course problem workbooks
0_Resources/Problems - Salary dashboard project
Project_1-Dashboard - Analysis project
Project_2-Analysis
Learning resources
- Datasets
0_Resources/Datasets - Excel shortcuts
0_Resources/Excel Shortcuts.xlsx
Other components
- Learner
Connections 9
- Learner → Spreadsheet foundations: studies
README.md - Learner → Formulas and functions: studies
README.md - Learner → Charts and graphs: studies
README.md - Learner → Advanced spreadsheets: studies
README.md - Learner → Pivot tables: studies
README.md - Learner → Advanced analysis: studies
README.md - Learner → Power Query: studies
README.md - Learner → Power Pivot and DAX: studies
README.md - Learner → Course problem workbooks: practices with
README.md