W3siaWQiOiJqdWljX2JfTURfVF83Mjh4OTAiLCJhZHNwb3QiOiJiX01EX1RfNzI4eDkwIiwid2VpZ2h0IjoiOSIsImZjYXAiOmZhbHNlLCJzY2hlZHVsZSI6ZmFsc2UsIm1heFdpZHRoIjpmYWxzZSwibWluV2lkdGgiOiI3NjgiLCJ0aW1lem9uZSI6ZmFsc2UsImV4Y2x1ZGUiOmZhbHNlLCJkb21haW4iOmZhbHNlLCJjb2RlIjoiPCEtLSBKdWljeUFkcyB2My4xIC0tPlxyXG48c2NyaXB0IHR5cGU9XCJ0ZXh0XC9qYXZhc2NyaXB0XCIgZGF0YS1jZmFzeW5jPVwiZmFsc2VcIiBhc3luYyBzcmM9XCJodHRwczpcL1wvcG93ZXJlZGJ5LmphZHMuY29cL2pzXC9qYWRzLmpzXCI+PFwvc2NyaXB0PlxyXG48aW5zIGlkPVwiODQ1NTM0XCIgZGF0YS13aWR0aD1cIjcyOFwiIGRhdGEtaGVpZ2h0PVwiOTBcIj48XC9pbnM+XHJcbjxzY3JpcHQgdHlwZT1cInRleHRcL2phdmFzY3JpcHRcIiBkYXRhLWNmYXN5bmM9XCJmYWxzZVwiIGFzeW5jPihhZHNieWp1aWN5ID0gd2luZG93LmFkc2J5anVpY3kgfHwgW10pLnB1c2goeydhZHpvbmUnOjg0NTUzNH0pOzxcL3NjcmlwdD5cclxuPCEtLUp1aWN5QWRzIEVORC0tPiJ9XQ==
W3siaWQiOiJhZHN0X2JfTV8zMDB4NTAiLCJhZHNwb3QiOiJiX01fMzAweDUwIiwid2VpZ2h0IjoiNSIsImZjYXAiOmZhbHNlLCJzY2hlZHVsZSI6ZmFsc2UsIm1heFdpZHRoIjoiNzY4IiwibWluV2lkdGgiOmZhbHNlLCJ0aW1lem9uZSI6ZmFsc2UsImV4Y2x1ZGUiOmZhbHNlLCJkb21haW4iOmZhbHNlLCJjb2RlIjoiPHNjcmlwdCB0eXBlPVwidGV4dFwvamF2YXNjcmlwdFwiPlxyXG4gIGF0T3B0aW9ucyA9IHtcclxuICAgICdrZXknIDogJzdkMWNjMGUxYjk4MWM5NzY4ZGI3ODUxZmM1MzVhMTllJyxcclxuICAgICdmb3JtYXQnIDogJ2lmcmFtZScsXHJcbiAgICAnaGVpZ2h0JyA6IDUwLFxyXG4gICAgJ3dpZHRoJyA6IDMyMCxcclxuICAgICdwYXJhbXMnIDoge31cclxuICB9O1xyXG4gIGRvY3VtZW50LndyaXRlKCc8c2NyJyArICdpcHQgdHlwZT1cInRleHRcL2phdmFzY3JpcHRcIiBzcmM9XCJodHRwJyArIChsb2NhdGlvbi5wcm90b2NvbCA9PT0gJ2h0dHBzOicgPyAncycgOiAnJykgKyAnOlwvXC93d3cuYm5odG1sLmNvbVwvaW52b2tlLmpzXCI+PFwvc2NyJyArICdpcHQ+Jyk7XHJcbjxcL3NjcmlwdD4ifV0=
W3siaWQiOiJqYXZfYl9NRF9CXzcyOHg5MCIsImFkc3BvdCI6ImJfTURfQl83Mjh4OTAiLCJ3ZWlnaHQiOiI1IiwiZmNhcCI6ZmFsc2UsInNjaGVkdWxlIjpmYWxzZSwibWF4V2lkdGgiOmZhbHNlLCJtaW5XaWR0aCI6Ijc2OCIsInRpbWV6b25lIjpmYWxzZSwiZXhjbHVkZSI6ZmFsc2UsImRvbWFpbiI6ZmFsc2UsImNvZGUiOiI8YSBocmVmPVwiaHR0cHM6XC9cL3RlbGxtZS5wd1wvZ29cL2phdlwiIHRhcmdldD1cIl9ibGFua1wiPjxpbWcgc3JjPVwiXC9hcHBcL2phdlwvVmlld1wvaW1nXC9iNzI4OTAuanBnXCIgd2lkdGg9XCI3MjhcIiBoZWlnaHQ9XCI5MFwiIGJvcmRlcj1cIjBcIj48XC9hPiJ9LHsiaWQiOiJqYXZ1X2JfTURfQl83Mjh4OTAiLCJhZHNwb3QiOiJiX01EX0JfNzI4eDkwIiwid2VpZ2h0IjoiNCIsImZjYXAiOmZhbHNlLCJzY2hlZHVsZSI6ZmFsc2UsIm1heFdpZHRoIjpmYWxzZSwibWluV2lkdGgiOiI3NjgiLCJ0aW1lem9uZSI6ZmFsc2UsImV4Y2x1ZGUiOmZhbHNlLCJkb21haW4iOmZhbHNlLCJjb2RlIjoiPGEgaHJlZj1cImh0dHBzOlwvXC90ZWxsbWUucHdcL2dvXC9qYXZ1XC9cIiB0YXJnZXQ9XCJfYmxhbmtcIj48aW1nIHNyYz1cIlwvYXBwXC9qYXZ1XC9WaWV3XC9pbWdcL2I3Mjg5MC5qcGdcIj48XC9hPiJ9XQ==
02. Data Analysis Basics/01. Introducing Data Analysis/04. Getting Good Data is Hard.webm
37.57MB
TeamTreehouse - Beginning Data Analysis (Track) [Thomas].jpg
157.79KB
TeamTreehouse - Beginning Data Analysis (Track) [Thomas].png
558.6KB
01. Spreadsheet Basics/Spreadsheet Basics.md
6.87KB
01. Spreadsheet Basics/01. Introducing Spreadsheets/01. What is a spreadsheet.webm
11.44MB
01. Spreadsheet Basics/01. Introducing Spreadsheets/02. Choosing Spreadsheet Software.webm
9.51MB
01. Spreadsheet Basics/01. Introducing Spreadsheets/03. Basic Spreadsheet Vocabulary.webm
31.64MB
01. Spreadsheet Basics/02. Getting Started With Spreadsheets/01. Adding Data to A Spreadsheet.webm
9.3MB
01. Spreadsheet Basics/02. Getting Started With Spreadsheets/02. Calculating Totals With SUM.webm
16.46MB
01. Spreadsheet Basics/02. Getting Started With Spreadsheets/03. Calculating Averages and Median Values.webm
10.57MB
01. Spreadsheet Basics/02. Getting Started With Spreadsheets/04. Sorting & Filtering.webm
25.42MB
01. Spreadsheet Basics/02. Getting Started With Spreadsheets/05. Cell Referencing.webm
19.17MB
01. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/01. Introducing Functions.webm
13.84MB
01. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/02. The IF Function.webm
12.99MB
01. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/03. The COUNT Function.webm
2.5MB
01. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/04. The EDATE Function.webm
4.69MB
01. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/05. The SUMIF Function.webm
11.83MB
01. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/06. The CHOOSE Function.webm
6.65MB
01. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/07. The ROUNDDOWN & ROUNDUP Functions.webm
4.44MB
01. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/08. Keyboard Shortcuts.webm
21.46MB
01. Spreadsheet Basics/04. Spreadsheet Best Practices/01. Spreadsheet Formatting Best Practices.webm
15.41MB
01. Spreadsheet Basics/04. Spreadsheet Best Practices/02. Saving Spreadsheet Data.webm
4.66MB
01. Spreadsheet Basics/04. Spreadsheet Best Practices/03. Input and Output Tabs.webm
14.63MB
01. Spreadsheet Basics/04. Spreadsheet Best Practices/04. Spreadsheet Templates.webm
14.7MB
01. Spreadsheet Basics/04. Spreadsheet Best Practices/05. Comments and Notes.webm
13.89MB
01. Spreadsheet Basics/05. Build a Spreadsheet/01. Finding and Importing Data.webm
22.18MB
01. Spreadsheet Basics/05. Build a Spreadsheet/02. Formatting the Spreadsheet.webm
29.72MB
01. Spreadsheet Basics/05. Build a Spreadsheet/03. Adding Functions and Formulas.webm
36.14MB
01. Spreadsheet Basics/05. Build a Spreadsheet/04. Conclusion.webm
4.84MB
02. Data Analysis Basics/Data Analysis Basics.md
3.91KB
02. Data Analysis Basics/01. Introducing Data Analysis/01. Making Better Decisions with Data Analysis.webm
22.24MB
02. Data Analysis Basics/01. Introducing Data Analysis/02. Data is Everywhere.webm
25.82MB
02. Data Analysis Basics/01. Introducing Data Analysis/03. Creating a Spreadsheet.webm
17.91MB
Beginning Data Analysis.md
4.03KB
02. Data Analysis Basics/01. Introducing Data Analysis/Project Files/marathon_results_2017.csv
4MB
02. Data Analysis Basics/02. Getting to Know Your Data/01. Summarizing Data Maximum, Minimum, Range.webm
17.91MB
02. Data Analysis Basics/02. Getting to Know Your Data/02. Summarizing Data Mean, Median, Mode.webm
9.26MB
02. Data Analysis Basics/02. Getting to Know Your Data/03. Analyzing Data Spread.webm
9.54MB
02. Data Analysis Basics/02. Getting to Know Your Data/04. Is Our Data Normal.webm
10.71MB
02. Data Analysis Basics/02. Getting to Know Your Data/05. Visualizing Data.webm
15.99MB
02. Data Analysis Basics/02. Getting to Know Your Data/06. Charting Our Data Part 1.webm
9.12MB
02. Data Analysis Basics/02. Getting to Know Your Data/07. Charting Our Data Part 2.webm
12.63MB
02. Data Analysis Basics/03. The Data Analysis Process/01. Understanding Metrics.webm
28.73MB
02. Data Analysis Basics/03. The Data Analysis Process/02. Defining Terms.webm
20.44MB
02. Data Analysis Basics/03. The Data Analysis Process/03. Analyzing the Data.webm
14.43MB
02. Data Analysis Basics/03. The Data Analysis Process/04. Presenting Your Findings.webm
30.37MB
03. Google Sheets vs Microsoft Excel/Google Sheets vs Microsoft Excel.md
1.03KB
04. Introducing Microsoft Excel/01. Why Microsoft Excel.webm
4.2MB
04. Introducing Microsoft Excel/02. Microsoft Excel On Macs.webm
14.21MB
04. Introducing Microsoft Excel/03. Microsoft Excel On Windows.webm
17MB
04. Introducing Microsoft Excel/Introducing Microsoft Excel.md
1.11KB
05. Data Visualization with Excel/Data Visualization with Excel.md
5.44KB
05. Data Visualization with Excel/01. Introduction To Data Visualization/01. Overview of Data Visualization.webm
26.97MB
05. Data Visualization with Excel/01. Introduction To Data Visualization/02. Creating a Chart in Excel.webm
13.45MB
05. Data Visualization with Excel/01. Introduction To Data Visualization/03. Changing the Order of Your Bar Chart.webm
6.2MB
05. Data Visualization with Excel/01. Introduction To Data Visualization/04. Different Types of Charts in Excel.webm
3.79MB
05. Data Visualization with Excel/02. When To Use What Type of Chart/01. A Column or a Bar.webm
7.13MB
05. Data Visualization with Excel/02. When To Use What Type of Chart/02. Why A Column Instead of Bar.webm
10.9MB
05. Data Visualization with Excel/02. When To Use What Type of Chart/03. Line Charts.webm
8.84MB
05. Data Visualization with Excel/02. When To Use What Type of Chart/04. Area and Stacked Area Charts.webm
17.41MB
05. Data Visualization with Excel/02. When To Use What Type of Chart/05. Stacked Charts Continued and 100% Stacked Charts.webm
9.31MB
05. Data Visualization with Excel/02. When To Use What Type of Chart/06. Pie Charts.webm
16.86MB
05. Data Visualization with Excel/02. When To Use What Type of Chart/07. Scatter Plots.webm
9.08MB
05. Data Visualization with Excel/02. When To Use What Type of Chart/08. The CORREL Function.webm
7.39MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/01. Chart & Plot Area.webm
13.05MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/02. Chart Title.webm
2.64MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/03. Axis Labels.webm
4.69MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/04. Data Tables.webm
2.72MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/05. Data Labels.webm
6.8MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/06. Lines.webm
4.51MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/07. Legends.webm
2.48MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/08. Trendlines.webm
3.34MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/09. Chart Design.webm
2.94MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/10. Changing Colors For a Data Series or Point.webm
7.21MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/11. Line Markers.webm
4.54MB
05. Data Visualization with Excel/03. Chart Formatting and Layout/12. Create A Chart Format Template.webm
7.34MB
05. Data Visualization with Excel/04. Practicing Data Visualization in Excel/01. Practice Total Sales.webm
11.64MB
05. Data Visualization with Excel/04. Practicing Data Visualization in Excel/02. Solution Total Sales.webm
21.2MB
05. Data Visualization with Excel/04. Practicing Data Visualization in Excel/03. Practice Sales Details.webm
3.2MB
05. Data Visualization with Excel/04. Practicing Data Visualization in Excel/04. Solution Sales Details.webm
28.1MB
05. Data Visualization with Excel/04. Practicing Data Visualization in Excel/05. Practice Population Growth.webm
7.02MB
05. Data Visualization with Excel/04. Practicing Data Visualization in Excel/06. Solution Population Growth.webm
19.42MB
06. Data Visualization Foundations/Data Visualization Foundations.md
4.25KB
06. Data Visualization Foundations/01. Data Visualization Fundamentals/01. What is Data Visualization.webm
25.66MB
06. Data Visualization Foundations/01. Data Visualization Fundamentals/02. Before You Begin Preparing Your Story.webm
33.81MB
06. Data Visualization Foundations/01. Data Visualization Fundamentals/03. Before You Begin Preparing Your Data.webm
23.51MB
06. Data Visualization Foundations/02. Bar Charts, Histograms, and Pie Charts/01. Bar Charts.webm
19.25MB
06. Data Visualization Foundations/02. Bar Charts, Histograms, and Pie Charts/02. Histograms.webm
5.14MB
06. Data Visualization Foundations/02. Bar Charts, Histograms, and Pie Charts/03. Pie charts.webm
16.41MB
06. Data Visualization Foundations/03. Line and Area Charts, Scatter Plots, and Maps/01. Line and Area Charts.webm
14.77MB
06. Data Visualization Foundations/03. Line and Area Charts, Scatter Plots, and Maps/02. Scatter Plots.webm
18.77MB
06. Data Visualization Foundations/03. Line and Area Charts, Scatter Plots, and Maps/03. Maps.webm
21.19MB
06. Data Visualization Foundations/04. Practicing Data Visualization/01. Sketching.webm
12.63MB
06. Data Visualization Foundations/04. Practicing Data Visualization/02. Accessible Visualizations.webm
36.37MB
06. Data Visualization Foundations/04. Practicing Data Visualization/03. Ethical Visualizations.webm
21.61MB
07. Intermediate Spreadsheets/01. Welcome and Prerequisites.webm
5.72MB
07. Intermediate Spreadsheets/02. Lookup Functions.webm
13.44MB
07. Intermediate Spreadsheets/03. Conditional Formatting.webm
12.25MB
07. Intermediate Spreadsheets/04. Pivot Tables.webm
14.39MB
07. Intermediate Spreadsheets/05. Data Validation.webm
20.01MB
07. Intermediate Spreadsheets/Intermediate Spreadsheets.md
1.47KB
08. Data Visualization with Google Sheets/01. Introduction and Prerequisites.md
616B
08. Data Visualization with Google Sheets/01. Introduction and Prerequisites.webm
4.26MB
08. Data Visualization with Google Sheets/02. Column and Bar Charts.webm
17.35MB
08. Data Visualization with Google Sheets/03. Line Charts.webm
12.27MB
08. Data Visualization with Google Sheets/04. Scatter Plots.webm
14.66MB
08. Data Visualization with Google Sheets/05. Pie Charts.webm
9.51MB
08. Data Visualization with Google Sheets/06. Geo Charts.webm
19.47MB
08. Data Visualization with Google Sheets/Data Visualization with Google Sheets.md
1.52KB
W3siaWQiOiJhZHN0X2JfTV8zMDB4NTAiLCJhZHNwb3QiOiJiX01fMzAweDUwIiwid2VpZ2h0IjoiNSIsImZjYXAiOmZhbHNlLCJzY2hlZHVsZSI6ZmFsc2UsIm1heFdpZHRoIjoiNzY4IiwibWluV2lkdGgiOmZhbHNlLCJ0aW1lem9uZSI6ZmFsc2UsImV4Y2x1ZGUiOmZhbHNlLCJkb21haW4iOmZhbHNlLCJjb2RlIjoiPHNjcmlwdCB0eXBlPVwidGV4dFwvamF2YXNjcmlwdFwiPlxyXG4gIGF0T3B0aW9ucyA9IHtcclxuICAgICdrZXknIDogJzdkMWNjMGUxYjk4MWM5NzY4ZGI3ODUxZmM1MzVhMTllJyxcclxuICAgICdmb3JtYXQnIDogJ2lmcmFtZScsXHJcbiAgICAnaGVpZ2h0JyA6IDUwLFxyXG4gICAgJ3dpZHRoJyA6IDMyMCxcclxuICAgICdwYXJhbXMnIDoge31cclxuICB9O1xyXG4gIGRvY3VtZW50LndyaXRlKCc8c2NyJyArICdpcHQgdHlwZT1cInRleHRcL2phdmFzY3JpcHRcIiBzcmM9XCJodHRwJyArIChsb2NhdGlvbi5wcm90b2NvbCA9PT0gJ2h0dHBzOicgPyAncycgOiAnJykgKyAnOlwvXC93d3cuYm5odG1sLmNvbVwvaW52b2tlLmpzXCI+PFwvc2NyJyArICdpcHQ+Jyk7XHJcbjxcL3NjcmlwdD4ifV0=