|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| 01. A Column or a Bar.webm |
7.13MB |
| 01. Adding Data to A Spreadsheet.webm |
9.30MB |
| 01. Chart & Plot Area.webm |
13.05MB |
| 01. Finding and Importing Data.webm |
22.18MB |
| 01. Introducing Conditional Formatting.webm |
24.45MB |
| 01. Introducing Functions.webm |
13.84MB |
| 01. Introducing Pivot Tables.webm |
8.39MB |
| 01. Introducing the Course.webm |
6.02MB |
| 01. Overview of Data Visualization.webm |
26.97MB |
| 01. Practice Total Sales.webm |
11.64MB |
| 01. Retrieving Financial Statements.webm |
24.80MB |
| 01. Spreadsheet Formatting Best Practices.webm |
15.41MB |
| 01. Welcome.webm |
21.60MB |
| 01. Welcome.webm |
22.47MB |
| 01. Welcome and Prerequisites.webm |
5.72MB |
| 01. Welcome to Basic Statistics for Data Analysis.webm |
10.38MB |
| 01. What is a spreadsheet.webm |
11.44MB |
| 01. What is Lifetime Value Analysis.webm |
19.55MB |
| 01. What is the Balance Sheet.webm |
7.90MB |
| 01. What is the Cash Flow Statement.webm |
9.43MB |
| 01. What is the Profit & Loss Statement.webm |
11.09MB |
| 01. Why Error Checking is Important.webm |
14.50MB |
| 01. Why Microsoft Excel.webm |
4.20MB |
| 02. Accounting Principles.webm |
15.50MB |
| 02. Assets and Liabilities.webm |
20.36MB |
| 02. Building a Pivot Table.webm |
11.76MB |
| 02. Calculating Totals With SUM.webm |
16.46MB |
| 02. Chart Title.webm |
2.64MB |
| 02. Choosing Spreadsheet Software.webm |
9.51MB |
| 02. Common Errors.webm |
13.96MB |
| 02. Cost of Goods Sold (“COGS”) and Gross Profit.webm |
15.80MB |
| 02. Creating a Chart in Excel.webm |
13.45MB |
| 02. Formatting the Spreadsheet.webm |
29.72MB |
| 02. Getting Fancy with Conditional Formatting.webm |
21.19MB |
| 02. Introducing Lookup Functions.webm |
6.29MB |
| 02. Line Charts.md |
2.07KB |
| 02. Lookup Functions.webm |
13.44MB |
| 02. Microsoft Excel On Macs.webm |
14.21MB |
| 02. Operating Cash Flows.webm |
10.78MB |
| 02. Reading a 10-k filing.webm |
59.28MB |
| 02. Recurring Revenue.webm |
17.72MB |
| 02. Saving Spreadsheet Data.webm |
4.66MB |
| 02. Solution Total Sales.webm |
21.20MB |
| 02. The IF Function.webm |
12.99MB |
| 02. The Most Basic LTV Formula.webm |
8.30MB |
| 02. Why A Column Instead of Bar.webm |
10.90MB |
| 03. Adding Functions and Formulas.webm |
36.14MB |
| 03. Axis Labels.webm |
4.69MB |
| 03. Bar Charts vs. Histograms.md |
1.51KB |
| 03. Basic Spreadsheet Vocabulary.webm |
31.64MB |
| 03. Calculating Averages and Median Values.webm |
10.57MB |
| 03. Changing the Order of Your Bar Chart.webm |
6.20MB |
| 03. Conditional Formatting.webm |
12.25MB |
| 03. EBITDA vs Net Income.webm |
25.73MB |
| 03. Factoring in COGS.webm |
21.73MB |
| 03. Finishing the Pivot Table.webm |
9.91MB |
| 03. Fixed Assets.webm |
22.66MB |
| 03. Input and Output Tabs.webm |
14.63MB |
| 03. Investing and Financing Cash Flows.webm |
22.81MB |
| 03. Line Charts.webm |
8.84MB |
| 03. Microsoft Excel On Windows.webm |
17.00MB |
| 03. Practice Sales Details.webm |
3.20MB |
| 03. Prevent Errors Using Data Validation.webm |
12.27MB |
| 03. Selling, General & Administrative (“SG&A”) and EBITDA.webm |
22.10MB |
| 03. The Concept of Recognition.webm |
18.70MB |
| 03. The COUNT Function.webm |
2.50MB |
| 03. Using VLOOKUP to Search in a Column.webm |
26.85MB |
| 03. What is Churn.webm |
24.42MB |
| 04. Area and Stacked Area Charts.webm |
17.41MB |
| 04. Book Value vs Market Value.webm |
49.15MB |
| 04. Conclusion.webm |
4.84MB |
| 04. Data Tables.webm |
2.72MB |
| 04. Depreciation, Amortization and EBIT.webm |
28.68MB |
| 04. Different Types of Charts in Excel.webm |
3.79MB |
| 04. Free Cash Flow and Net Cash Flow.webm |
29.12MB |
| 04. Gross Churn vs Net Churn.webm |
19.76MB |
| 04. How To Check For Errors.webm |
29.60MB |
| 04. Other Pivot Table Tips and Tricks.webm |
13.24MB |
| 04. Pie Charts.md |
1.72KB |
| 04. Pivot Tables.webm |
14.39MB |
| 04. Shareholder Equity & Retained Earnings.webm |
16.52MB |
| 04. Solution Sales Details.webm |
28.10MB |
| 04. Sorting & Filtering.webm |
25.42MB |
| 04. Spreadsheet Templates.webm |
14.70MB |
| 04. The EDATE Function.webm |
4.69MB |
| 04. Using HLOOKUP to Search in a Row.webm |
3.58MB |
| 04. Why Does LTV Matter.webm |
15.76MB |
| 05. Cell Referencing.webm |
19.17MB |
| 05. Comments and Notes.webm |
13.89MB |
| 05. Data Labels.webm |
6.80MB |
| 05. Data Validation.webm |
20.01MB |
| 05. Forecasting LTV.webm |
8.02MB |
| 05. How the 3 Financial Statements Relate.webm |
22.39MB |
| 05. Interest, Taxes, Other Gains and Losses, and Net Profit.webm |
15.14MB |
| 05. LOOKUP Tips and Common Errors.webm |
7.59MB |
| 05. MRR Churn Example Pt. 1.webm |
14.60MB |
| 05. Practice Population Growth.webm |
7.02MB |
| 05. Scatter Plots.md |
1.36KB |
| 05. Stacked Charts Continued and 100% Stacked Charts.webm |
9.31MB |
| 05. The SUMIF Function.webm |
11.83MB |
| 05. Wrapping Up.webm |
2.51MB |
| 06. Cohort Reports.webm |
20.52MB |
| 06. IQR (Interquartile Range).md |
2.51KB |
| 06. Lines.webm |
4.51MB |
| 06. MRR Churn Example Pt. 2.webm |
15.67MB |
| 06. Pie Charts.webm |
16.86MB |
| 06. Solution Population Growth.webm |
19.42MB |
| 06. The CHOOSE Function.webm |
6.65MB |
| 07. Box-and-whisker Plots.md |
2.43KB |
| 07. Legends.webm |
2.48MB |
| 07. Realized LTV.webm |
24.84MB |
| 07. Scatter Plots.webm |
9.08MB |
| 07. The ROUNDDOWN & ROUNDUP Functions.webm |
4.44MB |
| 08. Conclusion.webm |
7.09MB |
| 08. Keyboard Shortcuts.webm |
21.46MB |
| 08. Standard Deviation.md |
3.42KB |
| 08. The CORREL Function.webm |
7.39MB |
| 08. Trendlines.webm |
3.34MB |
| 09. Chart Design.webm |
2.94MB |
| 10. Changing Colors For a Data Series or Point.webm |
7.21MB |
| 11. Line Markers.webm |
4.54MB |
| 12. Create A Chart Format Template.webm |
7.34MB |
| Basic Statistics for Data Analysis.md |
3.53KB |
| Conditional_Formatting.xlsx |
11.67KB |
| Data Visualization with Excel.md |
5.44KB |
| Errors.xlsx |
27.15KB |
| Financial Statement Basics.md |
5.78KB |
| Intermediate Excel.md |
4.42KB |
| Intermediate Spreadsheets.md |
1.47KB |
| Introducing Microsoft Excel.md |
1.11KB |
| Introduction to Churn and Lifetime Value (LTV) Analysis.md |
3.16KB |
| Introduction to Marketing and Sales Analytics.md |
5.35KB |
| LOOKUPS.xlsx |
48.88KB |
| Measuring Company Performance with MRR, Churn and Lifetime Values.md |
1.11KB |
| Pivot_Tables.xlsx |
67.04KB |
| README.txt |
2.25KB |
| Spreadsheet Basics.md |
6.87KB |
| TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas].jpg |
207.45KB |
| TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas].png |
618.18KB |