📊 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:

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

• The Workbooks to solve practice problems
  • Purchase the problems here

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