|
|
01. A Column or a Bar.webm
|
WEBM
|
7.1 MB
|
|
|
01. Adding Data to A Spreadsheet.webm
|
WEBM
|
9.3 MB
|
|
|
01. Chart & Plot Area.webm
|
WEBM
|
13 MB
|
|
|
01. Finding and Importing Data.webm
|
WEBM
|
22.2 MB
|
|
|
01. Introducing Conditional Formatting.webm
|
WEBM
|
24.5 MB
|
|
|
01. Introducing Functions.webm
|
WEBM
|
13.8 MB
|
|
|
01. Introducing Pivot Tables.webm
|
WEBM
|
8.4 MB
|
|
|
01. Introducing the Course.webm
|
WEBM
|
6 MB
|
|
|
01. Overview of Data Visualization.webm
|
WEBM
|
27 MB
|
|
|
01. Practice Total Sales.webm
|
WEBM
|
11.6 MB
|
|
|
01. Retrieving Financial Statements.webm
|
WEBM
|
24.8 MB
|
|
|
01. Spreadsheet Formatting Best Practices.webm
|
WEBM
|
15.4 MB
|
|
|
01. Welcome and Prerequisites.webm
|
WEBM
|
5.7 MB
|
|
|
01. Welcome to Basic Statistics for Data Analysis.webm
|
WEBM
|
10.4 MB
|
|
|
01. Welcome.webm
|
WEBM
|
22.5 MB
|
|
|
01. What is Lifetime Value Analysis.webm
|
WEBM
|
19.6 MB
|
|
|
01. What is a spreadsheet.webm
|
WEBM
|
11.4 MB
|
|
|
01. What is the Balance Sheet.webm
|
WEBM
|
7.9 MB
|
|
|
01. What is the Cash Flow Statement.webm
|
WEBM
|
9.4 MB
|
|
|
01. What is the Profit & Loss Statement.webm
|
WEBM
|
11.1 MB
|
|
|
01. Why Error Checking is Important.webm
|
WEBM
|
14.5 MB
|
|
|
01. Why Microsoft Excel.webm
|
WEBM
|
4.2 MB
|
|
|
02. Accounting Principles.webm
|
WEBM
|
15.5 MB
|
|
|
02. Assets and Liabilities.webm
|
WEBM
|
20.4 MB
|
|
|
02. Building a Pivot Table.webm
|
WEBM
|
11.8 MB
|
|
|
02. Calculating Totals With SUM.webm
|
WEBM
|
16.5 MB
|
|
|
02. Chart Title.webm
|
WEBM
|
2.6 MB
|
|
|
02. Choosing Spreadsheet Software.webm
|
WEBM
|
9.5 MB
|
|
|
02. Common Errors.webm
|
WEBM
|
14 MB
|
|
|
02. Cost of Goods Sold (“COGS”) and Gross Profit.webm
|
WEBM
|
15.8 MB
|
|
|
02. Creating a Chart in Excel.webm
|
WEBM
|
13.5 MB
|
|
|
02. Formatting the Spreadsheet.webm
|
WEBM
|
29.7 MB
|
|
|
02. Getting Fancy with Conditional Formatting.webm
|
WEBM
|
21.2 MB
|
|
|
02. Introducing Lookup Functions.webm
|
WEBM
|
6.3 MB
|
|
|
02. Line Charts.md
|
MD
|
2.1 KB
|
|
|
02. Lookup Functions.webm
|
WEBM
|
13.4 MB
|
|
|
02. Microsoft Excel On Macs.webm
|
WEBM
|
14.2 MB
|
|
|
02. Operating Cash Flows.webm
|
WEBM
|
10.8 MB
|
|
|
02. Reading a 10-k filing.webm
|
WEBM
|
59.3 MB
|
|
|
02. Recurring Revenue.webm
|
WEBM
|
17.7 MB
|
|
|
02. Saving Spreadsheet Data.webm
|
WEBM
|
4.7 MB
|
|
|
02. Solution Total Sales.webm
|
WEBM
|
21.2 MB
|
|
|
02. The IF Function.webm
|
WEBM
|
13 MB
|
|
|
02. The Most Basic LTV Formula.webm
|
WEBM
|
8.3 MB
|
|
|
02. Why A Column Instead of Bar.webm
|
WEBM
|
10.9 MB
|
|
|
03. Adding Functions and Formulas.webm
|
WEBM
|
36.1 MB
|
|
|
03. Axis Labels.webm
|
WEBM
|
4.7 MB
|
|
|
03. Bar Charts vs. Histograms.md
|
MD
|
1.5 KB
|
|
|
03. Basic Spreadsheet Vocabulary.webm
|
WEBM
|
31.6 MB
|
|
|
03. Calculating Averages and Median Values.webm
|
WEBM
|
10.6 MB
|
|
|
03. Changing the Order of Your Bar Chart.webm
|
WEBM
|
6.2 MB
|
|
|
03. Conditional Formatting.webm
|
WEBM
|
12.3 MB
|
|
|
03. EBITDA vs Net Income.webm
|
WEBM
|
25.7 MB
|
|
|
03. Factoring in COGS.webm
|
WEBM
|
21.7 MB
|
|
|
03. Finishing the Pivot Table.webm
|
WEBM
|
9.9 MB
|
|
|
03. Fixed Assets.webm
|
WEBM
|
22.7 MB
|
|
|
03. Input and Output Tabs.webm
|
WEBM
|
14.6 MB
|
|
|
03. Investing and Financing Cash Flows.webm
|
WEBM
|
22.8 MB
|
|
|
03. Line Charts.webm
|
WEBM
|
8.8 MB
|
|
|
03. Microsoft Excel On Windows.webm
|
WEBM
|
17 MB
|
|
|
03. Practice Sales Details.webm
|
WEBM
|
3.2 MB
|
|
|
03. Prevent Errors Using Data Validation.webm
|
WEBM
|
12.3 MB
|
|
|
03. Selling, General & Administrative (“SG&A”) and EBITDA.webm
|
WEBM
|
22.1 MB
|
|
|
03. The COUNT Function.webm
|
WEBM
|
2.5 MB
|
|
|
03. The Concept of Recognition.webm
|
WEBM
|
18.7 MB
|
|
|
03. Using VLOOKUP to Search in a Column.webm
|
WEBM
|
26.8 MB
|
|
|
03. What is Churn.webm
|
WEBM
|
24.4 MB
|
|
|
04. Area and Stacked Area Charts.webm
|
WEBM
|
17.4 MB
|
|
|
04. Book Value vs Market Value.webm
|
WEBM
|
49.1 MB
|
|
|
04. Conclusion.webm
|
WEBM
|
4.8 MB
|
|
|
04. Data Tables.webm
|
WEBM
|
2.7 MB
|
|
|
04. Depreciation, Amortization and EBIT.webm
|
WEBM
|
28.7 MB
|
|
|
04. Different Types of Charts in Excel.webm
|
WEBM
|
3.8 MB
|
|
|
04. Free Cash Flow and Net Cash Flow.webm
|
WEBM
|
29.1 MB
|
|
|
04. Gross Churn vs Net Churn.webm
|
WEBM
|
19.8 MB
|
|
|
04. How To Check For Errors.webm
|
WEBM
|
29.6 MB
|
|
|
04. Other Pivot Table Tips and Tricks.webm
|
WEBM
|
13.2 MB
|
|
|
04. Pie Charts.md
|
MD
|
1.7 KB
|
|
|
04. Pivot Tables.webm
|
WEBM
|
14.4 MB
|
|
|
04. Shareholder Equity & Retained Earnings.webm
|
WEBM
|
16.5 MB
|
|
|
04. Solution Sales Details.webm
|
WEBM
|
28.1 MB
|
|
|
04. Sorting & Filtering.webm
|
WEBM
|
25.4 MB
|
|
|
04. Spreadsheet Templates.webm
|
WEBM
|
14.7 MB
|
|
|
04. The EDATE Function.webm
|
WEBM
|
4.7 MB
|
|
|
04. Using HLOOKUP to Search in a Row.webm
|
WEBM
|
3.6 MB
|
|
|
04. Why Does LTV Matter.webm
|
WEBM
|
15.8 MB
|
|
|
05. Cell Referencing.webm
|
WEBM
|
19.2 MB
|
|
|
05. Comments and Notes.webm
|
WEBM
|
13.9 MB
|
|
|
05. Data Labels.webm
|
WEBM
|
6.8 MB
|
|
|
05. Data Validation.webm
|
WEBM
|
20 MB
|
|
|
05. Forecasting LTV.webm
|
WEBM
|
8 MB
|
|
|
05. How the 3 Financial Statements Relate.webm
|
WEBM
|
22.4 MB
|
|
|
05. Interest, Taxes, Other Gains and Losses, and Net Profit.webm
|
WEBM
|
15.1 MB
|
|
|
05. LOOKUP Tips and Common Errors.webm
|
WEBM
|
7.6 MB
|
|
|
05. MRR Churn Example Pt. 1.webm
|
WEBM
|
14.6 MB
|
|
|
05. Practice Population Growth.webm
|
WEBM
|
7 MB
|
|
|
05. Scatter Plots.md
|
MD
|
1.4 KB
|
|
|
05. Stacked Charts Continued and 100% Stacked Charts.webm
|
WEBM
|
9.3 MB
|
|
|
05. The SUMIF Function.webm
|
WEBM
|
11.8 MB
|
|
|
05. Wrapping Up.webm
|
WEBM
|
2.5 MB
|
|
|
06. Cohort Reports.webm
|
WEBM
|
20.5 MB
|
|
|
06. IQR (Interquartile Range).md
|
MD
|
2.5 KB
|
|
|
06. Lines.webm
|
WEBM
|
4.5 MB
|
|
|
06. MRR Churn Example Pt. 2.webm
|
WEBM
|
15.7 MB
|
|
|
06. Pie Charts.webm
|
WEBM
|
16.9 MB
|
|
|
06. Solution Population Growth.webm
|
WEBM
|
19.4 MB
|
|
|
06. The CHOOSE Function.webm
|
WEBM
|
6.7 MB
|
|
|
07. Box-and-whisker Plots.md
|
MD
|
2.4 KB
|
|
|
07. Legends.webm
|
WEBM
|
2.5 MB
|
|
|
07. Realized LTV.webm
|
WEBM
|
24.8 MB
|
|
|
07. Scatter Plots.webm
|
WEBM
|
9.1 MB
|
|
|
07. The ROUNDDOWN & ROUNDUP Functions.webm
|
WEBM
|
4.4 MB
|
|
|
08. Conclusion.webm
|
WEBM
|
7.1 MB
|
|
|
08. Keyboard Shortcuts.webm
|
WEBM
|
21.5 MB
|
|
|
08. Standard Deviation.md
|
MD
|
3.4 KB
|
|
|
08. The CORREL Function.webm
|
WEBM
|
7.4 MB
|
|
|
08. Trendlines.webm
|
WEBM
|
3.3 MB
|
|
|
09. Chart Design.webm
|
WEBM
|
2.9 MB
|
|
|
10. Changing Colors For a Data Series or Point.webm
|
WEBM
|
7.2 MB
|
|
|
11. Line Markers.webm
|
WEBM
|
4.5 MB
|
|
|
12. Create A Chart Format Template.webm
|
WEBM
|
7.3 MB
|
|
|
Basic Statistics for Data Analysis.md
|
MD
|
3.5 KB
|
|
|
Conditional_Formatting.xlsx
|
XLSX
|
11.7 KB
|
|
|
Data Visualization with Excel.md
|
MD
|
5.4 KB
|
|
|
Errors.xlsx
|
XLSX
|
27.1 KB
|
|
|
Financial Statement Basics.md
|
MD
|
5.8 KB
|
|
|
Intermediate Excel.md
|
MD
|
4.4 KB
|
|
|
Intermediate Spreadsheets.md
|
MD
|
1.5 KB
|
|
|
Introducing Microsoft Excel.md
|
MD
|
1.1 KB
|
|
|
Introduction to Churn and Lifetime Value (LTV) Analysis.md
|
MD
|
3.2 KB
|
|
|
Introduction to Marketing and Sales Analytics.md
|
MD
|
5.4 KB
|
|
|
LOOKUPS.xlsx
|
XLSX
|
48.9 KB
|
|
|
Measuring Company Performance with MRR, Churn and Lifetime Values.md
|
MD
|
1.1 KB
|
|
|
Pivot_Tables.xlsx
|
XLSX
|
67 KB
|
|
|
README.txt
|
TXT
|
2.2 KB
|
|
|
Spreadsheet Basics.md
|
MD
|
6.9 KB
|
|
|
TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas].jpg
|
JPG
|
207.4 KB
|
|
|
TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas].png
|
PNG
|
618.2 KB
|
![TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas]](/static/img/no-torrent-image.png "TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas]")
