Skip to content
Projects

lukebarousse/Excel_Data_Analytics_Course

View on GitHub

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.

How these counts are measured

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

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:

  1. Download the whole repo — click Code → Download ZIP at the top of this page.
  2. 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

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