lukebarousse/Excel_Data_Analytics_Course
lukebarousse/Excel_Data_Analytics_Course has 1,218 GitHub stars and 464 forks. GitHot measured +7 in 7 days. Last checked 2026-11-10 21:28 UTC. Last push 2026-10-29.
My 'Excel for Data Analytics' course on YouTube
Measured star growth
- in 24h
- Update delayed
- in 7 days
- +7
- in 15 days
- Collecting history
- in 1 month
- Collecting history
Net star changes over overlapping periods, not daily totals. Missing measurements are left blank. Stars measure attention, not software quality.
README.md
Original📊 Excel for Data Analytics - Full Course
Data Nerds! This repo contains all the Excel files needed to follow along my free course: Excel for Data Analytics
⚠️ Downloading Excel Files
Known issue: If you download individual .xlsx files from GitHub, they can become corrupted and won't open in Excel.
Workarounds:
- Download the whole repo — click Code → Download ZIP at the top of this page.
- Use Google Drive instead 👉 https://lukeb.co/excel_files_alternate
Team Members 👥
🙋🏼♂️ Course Leader: Luke Barousse
🎬 Course Producer: Kelly Adams
📺 Video Editor: Brannon Linder
Table of Contents
Course Problem Workbooks
- The Workbooks to solve practice problems
Chapter 1: Spreadsheets_Intro
- Worksheets
- Workbooks
- Ribbon
- Menu
- Keyboard Shortcuts
Chapter 2: Formulas & Functions
- Formulas
- Functions
- Logical Functions
- Text Functions
- Date Functions
- Lookup Functions
- Math Functions
- Statistical Functions
Chapter 3: Charts
- Chart Types
- Chart Elements
- Chart Styles
- Chart Axes
- Chart Layouts
- Chart Templates
Chapter 4: Spreadsheets Advanced
- Tables
- Conditional Formatting
- Formatting
- Collaboration
Chapter 5: Pivot Tables
- Pivot Tables
- Pivot Charts
- Pivot Tables Advanced
Chapter 6: Advanced Data Analysis
- Analysis Add-ins
- Solver
- Scenario Manager
- Goal Seek
- Data Tables
Chapter 7: Power Query
- Power Query
- Power Query Editor
- Power Query M Language
- Power Query Advanced
Chapter 8: Power Pivot
- Power Pivot
- Power Pivot DAX
- Power Pivot Data Models
Found a Typo? Want to Contribute?
- If you find an error in this repo, please feel free to make a pull request by:
- Forking the repo
- Making any changes
- Submitting a pull request
Explore related projects
Asabeneh/30-Days-Of-Python
The 30 Days of Python programming challenge is a step-by-step guide to learn the Python programming language in 30 days. This challenge may take more than 100 days. Follow your own pace. These videos may help too: https://www.youtube.com/channel/UC7PNRuno1rzYPb1xLa4yktw
78,486 starsgrafana/grafana
The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
77,790 starsredis/redis
For developers, who are building real-time data-driven applications, Redis is the preferred, fastest, and most feature-rich cache, data structure server, and document and vector query engine.
77,332 starsapache/superset
Apache Superset is a Data Visualization and Data Exploration Platform
75,455 stars