GigaCourse Com Udemy The Complete Financial Analyst Course 2024 | 470FABB2FE3E7A5F37D5D50B648B96250B9C3EA6

GigaCourse Com Udemy The Complete Financial Analyst Course 2024

Name	[GigaCourse.Com] Udemy - The Complete Financial Analyst Course 2024	DOWNLOAD Copy Link
Total Size	12.6 GB
Total Files	1323
Last Seen	2024-11-07 23:58
Hash	470FABB2FE3E7A5F37D5D50B648B96250B9C3EA6

/0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/1. Welcome! Course Introduction/
1. What Does the Course Cover.mp4	70.6 MB
1. What Does the Course Cover.srt	10.3 KB
1.1 Financial Analyst - Course Curriculum.pdf	595.3 KB
1.2 Who Does What in Finance - Infographic.pdf	1.3 MB
2. Everything We Will Learn Has a Practical Application.mp4	43.8 MB
2. Everything We Will Learn Has a Practical Application.srt	4.2 KB
2.1 Quick win.xlsx	10.0 KB
3. The Best Way to Take This Course.mp4	32.6 MB
3. The Best Way to Take This Course.srt	4.5 KB
4. Download All Course Materials and FAQ.html	5.3 KB
4.1 Download all resources - Dropbox.html	0.1 KB
/10. Microsoft Excel - Creating Complete Professional Charts from Scratch/
1. Introduction.mp4	6.2 MB
1. Introduction.srt	0.8 KB
2. Stacked Column Chart with a Secondary Axis.mp4	43.3 MB
2. Stacked Column Chart with a Secondary Axis.srt	7.4 KB
2.1 82. Column stacked chart-Lecture-after.xlsm	12.1 MB
2.2 82. Column stacked chart-Lecture-before.xlsm	12.1 MB
3. Doughnut Chart.mp4	36.2 MB
3. Doughnut Chart.srt	7.0 KB
3.1 83. Doughnut chart-Lecture-after.xlsm	12.1 MB
3.2 83. Doughnut chart-Lecture-before.xlsm	12.1 MB
4. Area Chart.mp4	26.6 MB
4. Area Chart.srt	4.7 KB
4.1 84. Area chart-Lecture-after.xlsm	12.1 MB
4.2 84. Area chart-Lecture-before.xlsm	12.1 MB
5. Bridge Chart.mp4	48.8 MB
5. Bridge Chart.srt	9.6 KB
5.1 85. Bridge chart-Lecture-after.xlsm	12.1 MB
5.2 85.Bridge-chart-Lecture-before.xlsm	12.0 MB
/11. Microsoft Excel - Working with Pivot Tables in Excel/
1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4	23.7 MB
1. Pivot Tables - Excel's Dynamic and Interactive Tables.srt	2.4 KB
2. Creating a Pivot Table Choosing Row and Column Parameters.mp4	30.8 MB
2. Creating a Pivot Table Choosing Row and Column Parameters.srt	5.4 KB
2.1 87. Creating-a-Pivot-Table-Lecture.xlsx	1.5 MB
3. Design the Layout and Format of Your Pivot Tables.mp4	16.3 MB
3. Design the Layout and Format of Your Pivot Tables.srt	2.7 KB
3.1 88. Formatting-a-Pivot-Table-Lecture.xlsx	1.5 MB
4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4	37.6 MB
4. Additional Techniques That Will Ease Your Work with Pivot Tables.srt	6.0 KB
4.1 89. Working-with-Pivot-Tables-Lecture.xlsx	2.0 MB
5. One of the Most Useful Excel Functions - GETPIVOTDATA.mp4	28.8 MB
5. One of the Most Useful Excel Functions - GETPIVOTDATA.srt	5.1 KB
5.1 90. GetPivotData-Lecture.xlsx	2.0 MB
6. Welcome to the Future - Pivot Table Slicers.mp4	38.0 MB
6. Welcome to the Future - Pivot Table Slicers.srt	5.6 KB
6.1 91. Slicers-Lecture.xlsx	2.0 MB
7. Introduction to the Course Challenge.mp4	12.9 MB
7. Introduction to the Course Challenge.srt	1.5 KB
8. COURSE CHALLENGE - Part 1.mp4	24.4 MB
8. COURSE CHALLENGE - Part 1.srt	1.8 KB
8.1 93. Course-challenge-before-solutions.xlsx	518.1 KB
/12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/
1. Introduction to the Case Study.mp4	43.3 MB
1. Introduction to the Case Study.srt	2.9 KB
1.1 94. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx	13.9 MB
10. FAQ My GETPIVOTDATA Function Doesn't Work.html	0.6 KB
11. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4	35.2 MB
11. Combining Slicers and GETPIVOTDATA The Key to Our Success.srt	4.1 KB
11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx	21.8 MB
11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx	21.8 MB
12. Getting Fancy with Excel Slicers.mp4	34.0 MB
12. Getting Fancy with Excel Slicers.srt	4.1 KB
12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx	19.1 MB
12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx	21.8 MB
13. This is How the Report Can be Used in Practice by High-level Executives.mp4	37.9 MB
13. This is How the Report Can be Used in Practice by High-level Executives.srt	5.2 KB
13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx	23.9 MB
13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx	19.1 MB
2. Working with an SAP Data Extraction.mp4	38.8 MB
2. Working with an SAP Data Extraction.srt	4.6 KB
3. Preliminary Mapping of the Data Extraction.mp4	31.7 MB
3. Preliminary Mapping of the Data Extraction.srt	2.8 KB
3.1 1. Exercise - Build an FMCG Model_Mapping_after.xlsx	15.6 MB
3.2 1. Exercise - Build an FMCG Model_Mapping_before.xlsx	13.9 MB
4. Creating an Output Structure of the FMCG Model.mp4	20.7 MB
4. Creating an Output Structure of the FMCG Model.srt	3.3 KB
4.1 2. Exercise - Build an FMCG Model_Layout_after.xlsx	15.6 MB
4.2 2. Exercise - Build an FMCG Model_Layout_before.xlsx	15.6 MB
5. Improving the Layout and Appearance of the FMCG Report.mp4	25.0 MB
5. Improving the Layout and Appearance of the FMCG Report.srt	5.1 KB
5.1 3. Exercise - Build an FMCG Model_Formatting_after.xlsx	15.6 MB
5.2 3. Exercise - Build an FMCG Model_Formatting_before.xlsx	15.6 MB
6. Inserting Formulas and Automating Calculations.mp4	16.9 MB
6. Inserting Formulas and Automating Calculations.srt	3.0 KB
6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx	15.6 MB
6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx	15.6 MB
7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4	21.1 MB
7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.srt	2.5 KB
7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx	21.8 MB
7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx	15.6 MB
8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4	52.4 MB
8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.srt	7.9 KB
8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx	21.8 MB
8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx	21.8 MB
9. GETPIVOTDATA Fix.mp4	12.5 MB
9. GETPIVOTDATA Fix.srt	2.0 KB
/13. Modeling in Excel - Building a Complete 3-statement Model/
1. Introduction to the Exercise.mp4	34.4 MB
1. Introduction to the Exercise.srt	4.5 KB
1.1 106. Exercise-after.xlsx	33.5 KB
1.2 106. Exerxise-before.xlsx	19.2 KB
1.3 Financial Modeling Notes.pdf	706.6 KB
2. Let's Create a Mapping of Financials.mp4	28.5 MB
2. Let's Create a Mapping of Financials.srt	3.1 KB
2.1 107. Exercise - after.xlsx	35.1 KB
2.2 107. Exercise - before.xlsx	31.2 KB
3. Building an Output P&L Sheet.mp4	28.1 MB
3. Building an Output P&L Sheet.srt	4.4 KB
3.1 108. Exercise - after.xlsx	42.5 KB
3.2 108. Exercise - before.xlsx	33.1 KB
4. Filling in the Output P&L Sheet with Historical Financials.mp4	21.6 MB
4. Filling in the Output P&L Sheet with Historical Financials.srt	3.1 KB
4.1 109. Exersice - after.xlsx	42.2 KB
4.2 109. Exersice - before.xlsx	38.5 KB
5. Calculating Percentage Variances and Applying Conditional Formatting.mp4	25.1 MB
5. Calculating Percentage Variances and Applying Conditional Formatting.srt	3.5 KB
5.1 110. Exercise - after.xlsx	53.0 KB
5.2 110. Exercise - before.xlsx	40.2 KB
6. Building an Output Balance Sheet.mp4	27.5 MB
6. Building an Output Balance Sheet.srt	4.1 KB
6.1 111. Exercise - after.xlsx	55.7 KB
6.2 111. Exercise - before.xlsx	48.6 KB
7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.mp4	39.5 MB
7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.srt	5.8 KB
7.1 112. Exersice - before.xlsx	51.0 KB
7.2 112. Exersise - after.xlsx	58.5 KB
8. Adding the Forecast Period.mp4	29.3 MB
8. Adding the Forecast Period.srt	4.2 KB
8.1 113. Exersice - after.xlsx	56.3 KB
8.2 113. Exersice - before.xlsx	51.5 KB
/14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/
1. Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.mp4	46.1 MB
1. Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.srt	5.9 KB
1.1 114. Exercise - aft.xlsx	56.3 KB
1.2 114. Exercise - bef.xlsx	54.1 KB
2. Building a Flexible Model with CHOOSE & MATCH.mp4	14.6 MB
2. Building a Flexible Model with CHOOSE & MATCH.srt	1.8 KB
2.1 115. Exercise - after.xlsx	56.0 KB
2.2 115. Exercise - before.xlsx	54.4 KB
3. Building a Flexible Model with VLOOKUP & COLUMNS.mp4	34.2 MB
3. Building a Flexible Model with VLOOKUP & COLUMNS.srt	3.7 KB
3.1 116. Exercise - after.xlsx	56.4 KB
3.2 116. Exercise - before.xlsx	54.4 KB
4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4	41.3 MB
4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.srt	5.8 KB
4.1 117. Exercise -after.xlsx	58.0 KB
4.2 117. Exercise before.xlsx	54.8 KB
4.3 Course notes - Building a financial model.pdf	589.0 KB
4.4 Working Capital Days.pdf	349.0 KB
5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4	28.3 MB
5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.srt	3.6 KB
5.1 118. Exercise - after.xlsx	59.1 KB
5.2 118. Exercise - before.xlsx	56.0 KB
/15. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/
1. Building a Fixed Asset Roll Forward.mp4	38.1 MB
1. Building a Fixed Asset Roll Forward.srt	5.0 KB
1.1 119. Exercise - after.xlsx	63.6 KB
1.2 119. Exercise - before.xlsx	57.1 KB
2. Building a Financial Liabilities Schedule.mp4	43.9 MB
2. Building a Financial Liabilities Schedule.srt	6.3 KB
2.1 120. Exercise - after.xlsx	69.2 KB
2.2 120. Exercise - before.xlsx	60.3 KB
3. Building an Equity Schedule.mp4	34.5 MB
3. Building an Equity Schedule.srt	4.8 KB
3.1 121. Exercise - after.xlsx	71.2 KB
3.2 121. Exercise - before.xlsx	60.3 KB
4. Preparing a Cash Flow Structure.mp4	13.1 MB
4. Preparing a Cash Flow Structure.srt	2.5 KB
4.1 122. Exercise - after.xlsx	72.0 KB
4.2 122. Exercise - before.xlsx	67.2 KB
5. Calculating Cash Flows and Completing the Model.mp4	53.5 MB
5. Calculating Cash Flows and Completing the Model.srt	7.7 KB
5.1 123. Exercise - after.xlsx	74.3 KB
5.2 123. Exercise - before.xlsx	69.3 KB
/16. Accounting - Introduction to Accounting & Bookkeeping/
1. Accounting The Science Behind Financial Figures.mp4	56.6 MB
1. Accounting The Science Behind Financial Figures.srt	2.0 KB
1.1 Accounting & Financial Statement Analysis - Notes_UPDATE.pdf	686.3 KB
2. What is Accounting and Why Do You Need It.mp4	48.0 MB
2. What is Accounting and Why Do You Need It.srt	8.9 KB
2.1 Accounting & Financial Statement Analysis - Notes_UPDATE.pdf	686.3 KB
3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4	30.6 MB
3. The Importance of Bookkeeping - Good Accounting Records Are Essential.srt	4.3 KB
4. An Introduction to Financial Accounting.mp4	23.3 MB
4. An Introduction to Financial Accounting.srt	4.7 KB
5. Quiz Number 3.html	0.1 KB
/17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/
1. The Different Types of Accounting Standards.mp4	24.1 MB
1. The Different Types of Accounting Standards.srt	4.6 KB
1.1 The Complete Financial Analyst Course - Financial items.pdf	911.4 KB
10. Asset Categories - Practical Example.mp4	32.0 MB
10. Asset Categories - Practical Example.srt	5.6 KB
10.1 P-G-Annual_Report_2021.pdf	5.8 MB
11. Liability Categories - Practical Example.mp4	31.2 MB
11. Liability Categories - Practical Example.srt	5.5 KB
11.1 P-G-Annual_Report_2021.pdf	5.8 MB
12. Equity.mp4	15.8 MB
12. Equity.srt	3.4 KB
13. Equity Categories - Practical Example.mp4	41.9 MB
13. Equity Categories - Practical Example.srt	8.0 KB
13.1 P-G-Annual_Report_2021.pdf	5.8 MB
14. Quiz Number 4.html	0.1 KB
2. The Three Financial Statements.mp4	20.1 MB
2. The Three Financial Statements.srt	3.5 KB
3. Types of Revenues.mp4	54.7 MB
3. Types of Revenues.srt	11.2 KB
4. Types of Revenues - Exercise.mp4	16.5 MB
4. Types of Revenues - Exercise.srt	3.2 KB
5. Types of Expenses.mp4	45.4 MB
5. Types of Expenses.srt	9.3 KB
6. Income Taxes.mp4	16.2 MB
6. Income Taxes.srt	3.2 KB
7. Depreciation & Amortization.mp4	39.3 MB
7. Depreciation & Amortization.srt	7.4 KB
8. The Two Types of Income Statement Formats.mp4	11.4 MB
8. The Two Types of Income Statement Formats.srt	2.0 KB
9. Balance Sheet Items.mp4	37.1 MB
9. Balance Sheet Items.srt	7.0 KB
/18. Accounting - Revenue Recognition/
1. Accrual Accounting.mp4	62.3 MB
1. Accrual Accounting.srt	9.2 KB
2. Revenue Recognition Criteria - Technical.mp4	41.7 MB
2. Revenue Recognition Criteria - Technical.srt	6.2 KB
3. Potential Conflicts of Interest When Recognizing Revenue.mp4	17.1 MB
3. Potential Conflicts of Interest When Recognizing Revenue.srt	3.4 KB
4. A Practical Example.mp4	52.7 MB
4. A Practical Example.srt	8.9 KB
5. FAQ Doubts Regarding Calculation.html	0.7 KB
/19. Accounting - Cost Recognition/
1. Cost recognition principles.mp4	23.8 MB
1. Cost recognition principles.srt	4.2 KB
2. Technical Aspects of Cost Recognition.mp4	24.3 MB
2. Technical Aspects of Cost Recognition.srt	5.1 KB
/2. Microsoft Excel - Quick Introduction/
1. Microsoft Excel The World's #1 Office Software.mp4	38.1 MB
1. Microsoft Excel The World's #1 Office Software.srt	1.3 KB
1.1 Introduction to Excel's basic features.pdf	2.4 MB
10. A Beginner's Introduction to Excel Functions.mp4	19.2 MB
10. A Beginner's Introduction to Excel Functions.srt	4.5 KB
10.1 6. Functions - Lecture -Solved.xlsx	9.6 KB
10.2 6. Functions- Exercise - Solved.xlsx	83.0 KB
10.3 6. Functions- Lecture - Unsolved.xlsx	9.5 KB
10.4 6. Functions-Exercise - Unsolved.xlsx	13.6 KB
10.5 Introduction-to-Excels-basic-features.pdf	2.4 MB
11. Format Cells.mp4	32.5 MB
11. Format Cells.srt	8.2 KB
11.1 10. Format cells_after.xlsx	10.0 KB
11.2 10. Format cells_before.xlsx	10.0 KB
12. Work Efficiently by Using Cut, Copy, and Paste.mp4	13.1 MB
12. Work Efficiently by Using Cut, Copy, and Paste.srt	2.7 KB
12.1 7. Copy-Cut-Paste-Exercise - Solved.xlsx	12.9 KB
12.2 7. Copy-Cut-Paste-Exercise - Unsolved.xlsx	11.6 KB
12.3 Introduction-to-Excels-basic-features.pdf	2.4 MB
13. Work Efficiently by Using Cut, Copy, and Paste.html	0.1 KB
14. Pasting Values, Formulas and Formats with Paste Special.mp4	10.2 MB
14. Pasting Values, Formulas and Formats with Paste Special.srt	1.9 KB
14.1 8. Paste-Special-Exercise-Text.xlsx	13.8 KB
14.2 8. Paste-Special-Solved.xlsx	13.8 KB
14.3 Introduction-to-Excels-basic-features.pdf	2.4 MB
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4	18.4 MB
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.srt	5.0 KB
2.1 1. Introduction to Excel.pdf	2.4 MB
2.2 1. Overview-of-Excel-Exercise-Solved.xlsx	11.1 KB
2.3 1. Overview-of-Excel-Exercise-Unsolved.xlsx	10.7 KB
3. Data Entry Techniques in Excel.mp4	28.1 MB
3. Data Entry Techniques in Excel.srt	4.1 KB
3.1 2. Data-Entry - Lecture.xlsx	8.3 KB
3.2 2. Data-Entry- Exercise -Solved.xlsx	33.5 KB
3.3 2. Data-Entry-Exercise - Unsolved.xlsx	11.2 KB
4. How to Make Your Spreadsheets Look Professional.mp4	37.6 MB
4. How to Make Your Spreadsheets Look Professional.srt	7.3 KB
4.1 3. Formatting - Lecture - Solved.xlsx	10.1 KB
4.2 3. Formatting- Exercise - Solved.xlsx	11.9 KB
4.3 3. Formatting- Lecture - Unsolved.xlsx	9.1 KB
4.4 3. Formatting-Exercise - Unsolved.xlsx	11.9 KB
5. Data Entry Techniques in Excel.html	0.1 KB
6. Inserting, Deleting, and Modifying Rows & Columns.mp4	9.9 MB
6. Inserting, Deleting, and Modifying Rows & Columns.srt	2.4 KB
6.1 4. Basic-Manipulations - Exercise - Solved.xlsx	33.2 KB
6.2 4. Basic-Manipulations - Exercise - Unsolved.xlsx	11.3 KB
6.3 4. Data Entry - Lecture.xlsx	8.3 KB
7. Inserting, Deleting, and Modifying Rows & Columns.html	0.1 KB
8. Excel Formulas for Beginners.mp4	12.7 MB
8. Excel Formulas for Beginners.srt	3.6 KB
8.1 5. Formulas - Exercise - Unsolved.xlsx	12.0 KB
8.2 5. Formulas- Exercise - Solved.xlsx	82.1 KB
8.3 5. Formulas- Lecture - Solved.xlsx	9.6 KB
8.4 5. Formulas- Lecture - Unsolved.xlsx	9.5 KB
8.5 Introduction-to-Excels-basic-features.pdf	2.4 MB
9. Excel Formulas for Beginners.html	0.1 KB
/20. Accounting - Understanding the Big Picture Why, What, When, and How Much/
1. The Revenue Recognition Principle - Why Is It So Important.mp4	24.3 MB
1. The Revenue Recognition Principle - Why Is It So Important.srt	4.8 KB
2. The Expense Recognition Principle - When to Recognize Expenses.mp4	23.7 MB
2. The Expense Recognition Principle - When to Recognize Expenses.srt	4.2 KB
3. Historical Cost vs. Fair Value Accounting.mp4	21.4 MB
3. Historical Cost vs. Fair Value Accounting.srt	4.1 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/21. Accounting - The Core Principles of Accounting/
1. The Accounting Equation and Its Importance.mp4	15.8 MB
1. The Accounting Equation and Its Importance.srt	3.3 KB
2. Elements of the Accounting System General Ledger.mp4	15.2 MB
2. Elements of the Accounting System General Ledger.srt	2.6 KB
3. T-Accounts The Best Way to Understand Debits and Credits.mp4	30.9 MB
3. T-Accounts The Best Way to Understand Debits and Credits.srt	7.5 KB
4. P&L T-Accounts.mp4	22.8 MB
4. P&L T-Accounts.srt	4.5 KB
5. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4	42.5 MB
5. The Double-Entry Principle - The Core Principle of Bookkeeping.srt	8.1 KB
6. Quiz Number 5.html	0.1 KB
/22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/
1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4	74.2 MB
1. Case Study - The Accounting Transactions of a Lemonade Stand (14).srt	15.1 KB
1.1 Exercise - Before Solutions.xlsx	17.5 KB
1.2 Exercise Part One.xlsx	17.9 KB
1.3 Practical Exercise - List of transactions.pdf	186.9 KB
2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4	46.1 MB
2. Case Study - The Accounting Transactions of a Lemonade Stand (24).srt	11.2 KB
2.1 Exercise - Part Two.xlsx	20.6 KB
2.2 Practical Exercise - List of transactions.pdf	186.9 KB
3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4	49.2 MB
3. Case Study - The Accounting Transactions of a Lemonade Stand (34).srt	10.4 KB
3.1 Exercise - Part Three.xlsx	19.8 KB
3.2 Practical Exercise - List of transactions.pdf	186.9 KB
4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4	54.5 MB
4. Case Study - The Accounting Transactions of a Lemonade Stand (44).srt	10.0 KB
4.1 Exercise - Part Four.xlsx	21.2 KB
4.2 Practical Exercise - List of transactions.pdf	186.9 KB
/23. Accounting - The Importance of Timing/
1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4	10.2 MB
1. Timing of Cash Flows and Why It Plays an Important Role in a Business.srt	1.8 KB
2. Timing of Income Principles of Revenue Recognition.mp4	46.8 MB
2. Timing of Income Principles of Revenue Recognition.srt	9.1 KB
3. Timing of Expenses Principles of Cost Recognition.mp4	24.3 MB
3. Timing of Expenses Principles of Cost Recognition.srt	5.3 KB
4. Quiz Number 6.html	0.1 KB
/24. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/
1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4	25.0 MB
1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.srt	4.5 KB
2. The Three Parts of Cash Flow Statements Explained.mp4	24.5 MB
2. The Three Parts of Cash Flow Statements Explained.srt	3.9 KB
3. Cash Flow Computations - The Direct Method.mp4	19.4 MB
3. Cash Flow Computations - The Direct Method.srt	3.4 KB
4. Cash Flow Computations - The Indirect Method.mp4	27.1 MB
4. Cash Flow Computations - The Indirect Method.srt	5.9 KB
5. Calculating Cash Flow in Practice A Complete Example.mp4	55.1 MB
5. Calculating Cash Flow in Practice A Complete Example.srt	12.3 KB
5.1 Cash Flow Statement_after.xlsx	16.6 KB
5.2 Cash Flow Statement_pre-solution.xlsx	16.2 KB
6. FAQ Why D&A Has Been Added in Capex.html	2.3 KB
/25. Advanced Accounting - Trade Receivables/
1. Why a Company Needs to Pay Attention to Trade Receivables.mp4	24.4 MB
1. Why a Company Needs to Pay Attention to Trade Receivables.srt	4.6 KB
1.1 The Complete Financial Analyst Course - Trade receivables, Inventory, Fixed assets.pdf	723.5 KB
2. What If Clients Do Not Pay on Time.mp4	25.5 MB
2. What If Clients Do Not Pay on Time.srt	5.6 KB
3. How to Handle Non-paying Customers A Case-study.mp4	23.9 MB
3. How to Handle Non-paying Customers A Case-study.srt	4.4 KB
4. A Technique to Collect Trade Receivables Sooner.mp4	14.5 MB
4. A Technique to Collect Trade Receivables Sooner.srt	3.1 KB
/26. Advanced Accounting - Inventory/
1. The Different Types of Inventory We Can Have.mp4	25.1 MB
1. The Different Types of Inventory We Can Have.srt	4.5 KB
2. The Connection Between Cost of Goods Sold and Inventory.mp4	15.2 MB
2. The Connection Between Cost of Goods Sold and Inventory.srt	4.4 KB
3. Cost Flow Methods.mp4	25.5 MB
3. Cost Flow Methods.srt	7.8 KB
4. Cost Flow Methods - a Practical Exercise.mp4	6.8 MB
4. Cost Flow Methods - a Practical Exercise.srt	1.8 KB
4.1 Inventory Cost Flow Methods_solved.xlsx	12.7 KB
4.2 Inventory Cost Flow Methods_unsolved.xlsx	11.8 KB
4.3 Inventory Cost Flow Methods.pptx	172.6 KB
4.4 Inventory-Cost-Flow-Methods-with-solutions.pptx	179.3 KB
5. FAQ How to Apply the Weighted Average Cost Method.html	0.9 KB
/27. Advanced Accounting - Fixed Assets/
1. The Different Types of Fixed Assets.mp4	19.4 MB
1. The Different Types of Fixed Assets.srt	5.3 KB
2. Capitalizing Interest Expenses.mp4	7.4 MB
2. Capitalizing Interest Expenses.srt	3.3 KB
3. Fair Value Accounting.mp4	43.2 MB
3. Fair Value Accounting.srt	4.2 KB
4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp4	33.8 MB
4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.srt	6.7 KB
5. The Revaluation Model.mp4	36.9 MB
5. The Revaluation Model.srt	7.8 KB
6. The Revaluation Model - Practical Exercise.mp4	35.7 MB
6. The Revaluation Model - Practical Exercise.srt	6.7 KB
7. Intangible Assets Created Internally.mp4	17.1 MB
7. Intangible Assets Created Internally.srt	3.6 KB
/28. Advanced Accounting - Trade Payables/
1. How We Account for Trade Payables.mp4	20.9 MB
1. How We Account for Trade Payables.srt	4.4 KB
2. What Is the Difference Between Accounts Payable and Notes Payable.mp4	10.1 MB
2. What Is the Difference Between Accounts Payable and Notes Payable.srt	2.3 KB
3. Why Use E-invoicing.mp4	23.8 MB
3. Why Use E-invoicing.srt	4.8 KB
/29. Advanced Accounting - Financial Liabilities/
1. The Difference Between Debt and Equity.mp4	13.8 MB
1. The Difference Between Debt and Equity.srt	3.8 KB
2. Amortizing a Loan.mp4	19.1 MB
2. Amortizing a Loan.srt	4.4 KB
3. Debt Covenants.mp4	24.4 MB
3. Debt Covenants.srt	5.6 KB
4. Debt Covenants - A Practical Example.mp4	12.8 MB
4. Debt Covenants - A Practical Example.srt	2.8 KB
/3. Microsoft Excel - Useful Tools/
1. Inserting a Line Break with Alt + Enter.mp4	10.3 MB
1. Inserting a Line Break with Alt + Enter.srt	1.1 KB
1.1 9. Alt-Enter- Lecture - Solved.xlsx	9.9 KB
1.2 9. Alt-Enter- Lecture - Unsolved.xlsx	9.9 KB
1.3 9. Alt-Enter-Exercise - Solved.xlsx	11.7 KB
1.4 9. Alt-Enter-Exercise - Unsolved.xlsx	11.4 KB
2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp4	12.3 MB
2. Do More with Your Sales Data with Excel's Text to Columns Feature.srt	2.5 KB
2.1 10. Text-to-Columns-Exercise - Solved.xlsx	11.6 KB
2.2 10. Text-to-Columns-Exercise - Unsolved.xlsx	10.8 KB
2.3 10. Text-to-columns-Lecture - Solved.xlsx	10.1 KB
2.4 10. Text-to-columns-Lecture - Unsolved.xlsx	10.0 KB
3. Do More with Your Sales Data with Excel's Text to Columns Feature.html	0.1 KB
4. Create Easily Printable Excel Documents.mp4	8.8 MB
4. Create Easily Printable Excel Documents.srt	1.5 KB
4.1 11. Set-Print-Area-Lecture - Solved.xlsx	11.5 KB
4.2 11. Set-Print-Area-Lecture - Unsolved.xlsx	11.7 KB
4.3 Useful-Tips-Tools.pdf	3.5 MB
5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4	3.3 MB
5. How to Wrap Text in Excel and Adjust a Cell's Size.srt	0.9 KB
5.1 12. Wrap-Text-Exercise - Solved.xlsx	10.4 KB
5.2 12. Wrap-Text-Exercise - Unsolved.xlsx	10.4 KB
5.3 12. Wrap-text-Lecture - Solved.xlsx	9.8 KB
5.4 12. Wrap-text-Lecture - Unsolved.xlsx	9.8 KB
6. Insert Hyperlinks into Excel Spreadsheets.mp4	7.5 MB
6. Insert Hyperlinks into Excel Spreadsheets.srt	1.4 KB
6.1 13. Hyperlinks-Exercise - Solved.xlsx	140.4 KB
6.2 13. Hyperlinks-Exercise - Unsolved.xlsx	140.2 KB
6.3 Useful-Tips-Tools.pdf	3.5 MB
7. Using Excel's Freeze Panes to Handle Large Datasets.mp4	15.2 MB
7. Using Excel's Freeze Panes to Handle Large Datasets.srt	1.5 KB
7.1 14. Freeze-Panes-Lecture - Solved.xlsx	659.4 KB
7.2 14. Freeze-Panes-Lecture - Unsolved.xlsx	659.3 KB
7.3 Useful-Tips-Tools.pdf	3.5 MB
8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4	15.8 MB
8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.srt	1.1 KB
8.1 Useful Tips & Tools.pdf	3.5 MB
9. A Quick Introduction to Excel's Pivot Tables.mp4	42.1 MB
9. A Quick Introduction to Excel's Pivot Tables.srt	2.7 KB
9.1 21. Pivot Tables - Exercise - Solved.xlsx	195.0 KB
9.2 21. Pivot Tables - Exercise - Unsolved.xlsx	155.8 KB
9.3 21. Pivot tables - Lecture - Solved.xlsm	918.8 KB
9.4 21. Pivot tables - Lecture - Unsolved.xlsm	704.3 KB
9.5 Useful-Tips-Tools.pdf	3.5 MB
/30. Advanced Accounting - Leasing Liabilties/
1. The Reason Companies Lease Assets.mp4	10.5 MB
1. The Reason Companies Lease Assets.srt	2.1 KB
2. Solving a Complete Leasing Exercise.mp4	42.1 MB
2. Solving a Complete Leasing Exercise.srt	9.5 KB
2.1 Leasing Exercise - Solved.xlsx	15.5 KB
2.2 Leasing Exercise - Unsolved.xlsx	9.9 KB
2.3 Leasing exercise_lecture.xlsx	14.4 KB
/31. Advanced Accounting - Using Leverage/
1. What is Leverage and Why Companies Use Financial Leverage.mp4	56.1 MB
1. What is Leverage and Why Companies Use Financial Leverage.srt	7.4 KB
2. The Implications of Using Excessive Leverage.mp4	33.7 MB
2. The Implications of Using Excessive Leverage.srt	5.6 KB
/32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/
1. The Different Types of Equity.mp4	56.0 MB
1. The Different Types of Equity.srt	6.4 KB
2. Raising Equity in Different Stages of a Company's Lifecycle.mp4	71.3 MB
2. Raising Equity in Different Stages of a Company's Lifecycle.srt	10.1 KB
3. The Types of Dividends Companies Pay to Shareholders.mp4	44.4 MB
3. The Types of Dividends Companies Pay to Shareholders.srt	5.8 KB
4. Dividend Payments - a Timeline.mp4	35.1 MB
4. Dividend Payments - a Timeline.srt	5.0 KB
5. What Are Share Repurchases and Why Companies Do Them.mp4	44.5 MB
5. What Are Share Repurchases and Why Companies Do Them.srt	5.1 KB
6. The Idea Behind Stock Splits.mp4	35.9 MB
6. The Idea Behind Stock Splits.srt	4.8 KB
/33. Assessment - Accounting/
1. Assessment - Accounting.html	0.1 KB
/34. Financial Statement Analysis - An Introduction/
1. What is a 10-K Report and Why Is It important for Investors.mp4	22.9 MB
1. What is a 10-K Report and Why Is It important for Investors.srt	3.9 KB
2. Finding, Downloading and Going Through the Annual Report of P&G.mp4	81.3 MB
2. Finding, Downloading and Going Through the Annual Report of P&G.srt	11.3 KB
2.1 P-G-Annual_Report_2021.pdf	5.8 MB
3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4	27.6 MB
3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.srt	4.4 KB
4. Indispensable Tools for Financial Statement Analysis.mp4	15.0 MB
4. Indispensable Tools for Financial Statement Analysis.srt	3.6 KB
5. Quiz Number 7.html	0.1 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/35. Financial Statement Analysis - Subtleties/
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4	17.6 MB
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.srt	3.1 KB
1.1 Financial Statement Analysis - Notes.pdf	791.4 KB
2. First Steps in Financial Statement Analysis.mp4	26.9 MB
2. First Steps in Financial Statement Analysis.srt	4.6 KB
3. Horizontal vs. Vertical Financial Statement Analysis.mp4	28.6 MB
3. Horizontal vs. Vertical Financial Statement Analysis.srt	5.8 KB
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4	18.9 MB
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).srt	3.1 KB
4.1 Working Capital Days.pdf	349.0 KB
5. Using Accounting Ratios to Assess Business Performance.mp4	65.3 MB
5. Using Accounting Ratios to Assess Business Performance.srt	14.2 KB
6. Quiz Number 8.html	0.1 KB
/36. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/
1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4	58.3 MB
1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).srt	11.3 KB
1.1 P-G-Annual_Report_2021.pdf	5.8 MB
1.2 P-G-Financials-Before.xlsx	15.2 KB
1.3 P-G-Financials-With-Ratios.xlsx	16.0 KB
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4	34.0 MB
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).srt	7.5 KB
2.1 P-G-Annual_Report_2021.pdf	5.8 MB
2.2 P-G-Financials-Before.xlsx	15.0 KB
2.3 P-G-Financials-With-Ratios.xlsx	16.1 KB
3. COURSE CHALLENGE - Part 2.mp4	32.1 MB
3. COURSE CHALLENGE - Part 2.srt	2.2 KB
3.1 2. Course Challenge.xlsx	642.7 KB
/37. Financial Statement Analysis - Tesla Exercise/
1. What You Will See Next In This Section.mp4	18.5 MB
1. What You Will See Next In This Section.srt	1.9 KB
2. How to Download Tesla's Historical Financials.mp4	17.5 MB
2. How to Download Tesla's Historical Financials.srt	4.1 KB
2.1 Tesla 2015.pdf	1.4 MB
2.2 Tesla 2016.pdf	2.3 MB
2.3 Tesla 2017.pdf	2.6 MB
2.4 Tesla 2018.pdf	3.6 MB
2.5 Tesla 2019.pdf	2.5 MB
3. Calculating and Analyzing Growth and Profitability Ratios.mp4	111.7 MB
3. Calculating and Analyzing Growth and Profitability Ratios.srt	15.9 KB
3.1 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx	1.1 MB
3.2 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx	1.1 MB
4. Calculating and Analyzing Liquidity Ratios.mp4	75.1 MB
4. Calculating and Analyzing Liquidity Ratios.srt	9.0 KB
4.1 Tesla - Financial Statement Analysis - Liquidity_after.xlsx	1.1 MB
4.2 Tesla - Financial Statement Analysis - Liquidity_before.xlsx	1.1 MB
5. Calculating and Analyzing Solvency Ratios.mp4	25.7 MB
5. Calculating and Analyzing Solvency Ratios.srt	3.5 KB
5.1 Tesla - Financial Statement Analysis - Solvency_after.xlsx	1.1 MB
5.2 Tesla - Financial Statement Analysis - Solvency_before.xlsx	1.1 MB
/38. Working Capital Management/
1. Introduction.mp4	23.3 MB
1. Introduction.srt	4.4 KB
10. Symptoms of Inefficient Working Capital - Trade Payables.mp4	16.6 MB
10. Symptoms of Inefficient Working Capital - Trade Payables.srt	3.6 KB
10.1 Working capital test_solved.xlsx	13.9 KB
10.2 Working capital test_unsolved.xlsx	13.0 KB
11. Symptoms of Inefficient Working Capital - Trade Receivables.mp4	14.5 MB
11. Symptoms of Inefficient Working Capital - Trade Receivables.srt	3.2 KB
2. The Importance of Working Capital Optimization Case Study.mp4	84.6 MB
2. The Importance of Working Capital Optimization Case Study.srt	14.7 KB
3. Overtrading vs. Excessive Investment.mp4	31.6 MB
3. Overtrading vs. Excessive Investment.srt	5.4 KB
4. Trade Receivables Management.mp4	72.1 MB
4. Trade Receivables Management.srt	13.2 KB
5. Re-order Level.mp4	29.8 MB
5. Re-order Level.srt	5.4 KB
6. Economic Order Quantity (EOQ).mp4	29.5 MB
6. Economic Order Quantity (EOQ).srt	6.5 KB
7. Inventory Optimization Techniques.mp4	47.3 MB
7. Inventory Optimization Techniques.srt	8.3 KB
8. Trade Payables Management.mp4	18.2 MB
8. Trade Payables Management.srt	3.3 KB
9. Working Capital Optimization - a Roadmap.mp4	45.6 MB
9. Working Capital Optimization - a Roadmap.srt	8.8 KB
/39. Fundamentals of Business & Financial Analysis/
1. Fundamentals of Business & Financial Analysis.html	0.2 KB
/4. Microsoft Excel - Best Practices That Will Make a Difference/
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4	22.3 MB
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.srt	2.2 KB
1.1 17. Formatting-a-Worksheet-Exercise - Solved.xlsx	11.0 KB
1.2 17. Formatting-a-Worksheet-Exercise - Unsolved.xlsx	10.9 KB
1.3 17. Formatting-a-worksheet-Lecture - Solved.xlsx	9.8 KB
1.4 17. Formatting-a-worksheet-Lecture - Unsolved.xlsx	9.2 KB
1.5 Useful-Tips-Tools.pdf	3.5 MB
10. Using Absolute and Relative Cell References.html	0.1 KB
11. Find and Select Cells That Meet Specific Conditions.mp4	12.5 MB
11. Find and Select Cells That Meet Specific Conditions.srt	1.9 KB
11.1 23. Select-Special-F5-Exercise - Solved.xlsx	22.8 KB
11.2 23. Select-Special-F5-Exercise - Unsolved.xlsx	22.1 KB
11.3 23. Select-Special-Lecture.xlsx	10.8 KB
11.4 Useful-Tips-Tools.pdf	3.5 MB
12. Find and Select Cells That Meet Specific Conditions.html	0.1 KB
13. How to Create Dynamic Names in Excel Spreadsheets.mp4	14.7 MB
13. How to Create Dynamic Names in Excel Spreadsheets.srt	1.7 KB
13.1 24. Assigning-Dynamic-Names-Exercise - Solved.xlsx	12.0 KB
13.2 24. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx	11.5 KB
13.3 24. Dynamic-Naming-Lecture - Solved.xlsx	14.2 KB
13.4 24. Dynamic-Naming-Lecture - Unsolved.xlsx	13.9 KB
13.5 Useful-Tips-Tools.pdf	3.5 MB
14. How to Create Dynamic Names in Excel Spreadsheets.html	0.1 KB
15. Using Named Ranges to Make Formulas More Readable.mp4	8.0 MB
15. Using Named Ranges to Make Formulas More Readable.srt	1.9 KB
15.1 25. Defining-a-Named-Range-Exercise - Solved.xlsx	11.9 KB
15.2 25. Defining-a-Named-Range-Exercise - Unsolved.xlsx	11.3 KB
15.3 25. Naming-ranges-Lecture - Solved.xlsx	10.6 KB
15.4 25. Naming-ranges-Lecture - Unsolved.xlsx	9.0 KB
15.5 Useful-Tips-Tools.pdf	3.5 MB
16. Introduction to Custom Formatting in Excel.mp4	42.9 MB
16. Introduction to Custom Formatting in Excel.srt	9.5 KB
16.1 19. Custom formatting_after.xlsx	11.0 KB
16.2 19. Custom formatting_before.xlsx	10.9 KB
17. Custom Number Formatting.mp4	8.7 MB
17. Custom Number Formatting.srt	2.0 KB
17.1 31. Assigning Custom Formats - Exercise - Solved.xlsx	11.3 KB
17.2 31. Assigning Custom Formats - Exercise - Unsolved.xlsx	11.6 KB
17.3 Useful-Tips-Tools.pdf	3.5 MB
18. How to Add a Drop-down List in Excel.mp4	14.7 MB
18. How to Add a Drop-down List in Excel.srt	2.4 KB
18.1 27. Data-Validation-Lecture - Solved.xlsx	11.1 KB
18.2 27. Data-Validation-Lecture - Unsolved.xlsx	11.1 KB
18.3 27. Drop-down-List-Exercise - Solved.xlsx	78.9 KB
18.4 27. Drop-down-List-Exercise - Unsolved.xlsx	11.6 KB
19. Using Custom-sort to Sort Multiple Columns Within a Table.mp4	23.0 MB
19. Using Custom-sort to Sort Multiple Columns Within a Table.srt	1.8 KB
19.1 28. Custom-Sort-Exercise - Solved.xlsx	11.7 KB
19.2 28. Custom-Sort-Exercise - Unsolved.xlsx	11.6 KB
19.3 28. Sort-data-Lecture - Solved.xlsx	149.1 KB
19.4 28. Sort-data-Lecture - Unsolved.xlsx	148.8 KB
19.5 Useful-Tips-Tools.pdf	3.5 MB
2. Macros Are a Great Timesaver! Here's Why..mp4	35.2 MB
2. Macros Are a Great Timesaver! Here's Why..srt	3.5 KB
2.1 18. Creating-a-Macro-Lecture - Solved.xlsx	11.4 KB
2.2 18. Creating-a-Macro-Lecture - Unsolved.xlsx	9.9 KB
2.3 18. Macros-Exercise - Solved.xlsx	148.5 KB
2.4 18. Macros-Exercise - Unsolved.xlsx	10.6 KB
2.5 Useful-Tips-Tools.pdf	3.5 MB
20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4	43.9 MB
20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.srt	5.2 KB
20.1 29. Microsoft-Excel-Keyboard-Shortcuts.pdf	1.3 MB
20.2 29. Microsoft-Excel-Shortcuts-for-MAC.pdf	787.7 KB
20.3 Useful-Tips-Tools.pdf	3.5 MB
21. Multiply by 1.mp4	14.4 MB
21. Multiply by 1.srt	2.4 KB
21.1 30. Multiply-by-1-Lecture-after.xlsx	17.6 KB
21.2 30.+Multiply-by-1-Lecture_before.xlsx	16.9 KB
22. Find and Replace - References.mp4	23.0 MB
22. Find and Replace - References.srt	4.6 KB
22.1 31. Find-and-Replace-references-Lecture-after.xlsx	38.8 KB
22.2 31. Find-and-Replace-references-Lecture-before.xlsx	39.7 KB
23. FAQ Why Do We Replace External References and How Does This Help Us.html	0.7 KB
24. Find and Replace - Formatting.mp4	13.2 MB
24. Find and Replace - Formatting.srt	2.5 KB
24.1 32. Find-replace-Lecture-after.xlsx	17.6 KB
24.2 32. Find-replace-Lecture-before.xlsx	17.6 KB
25. Green References.mp4	12.1 MB
25. Green References.srt	2.3 KB
25.1 33. Green-references-Lecture.xlsx	12.3 KB
26. Beauty Saving - The Professional Way of Saving Files.mp4	13.6 MB
26. Beauty Saving - The Professional Way of Saving Files.srt	3.3 KB
26.1 34. Beauty-saving-Lecture-after.xlsx	17.5 KB
26.2 34. Beauty-saving-Lecture-before.xlsx	17.6 KB
27. The Power of F2.mp4	17.5 MB
27. The Power of F2.srt	3.0 KB
27.1 43. F2-Lecture.xlsm	51.1 KB
28. Conditional Formatting.mp4	54.5 MB
28. Conditional Formatting.srt	7.4 KB
28.1 41. Conditional formatting - Lecture.xlsx	42.7 KB
29. Quiz Number 1.html	0.1 KB
3. How to Use the Same Macro On Multiple Workbooks.mp4	11.2 MB
3. How to Use the Same Macro On Multiple Workbooks.srt	2.2 KB
3.1 19. Another-file.xlsx	9.0 KB
3.2 19. How-to-save-macros-Lecture-after.xlsm	12.9 KB
3.3 19. How-to-save-macros-Lecture-before.xlsx	6.2 KB
4. Macros Are a Great Timesaver! Here's Why..html	0.1 KB
5. The Secret to Faster Scrolling in Excel.mp4	20.5 MB
5. The Secret to Faster Scrolling in Excel.srt	1.9 KB
5.1 25. Fast-Scrolling - Lecture.xlsx	658.2 KB
5.2 25. Fast-Scrolling-Exercise - Solved.xlsx	45.4 KB
5.3 25. Fast-Scrolling-Exercise - Unsolved.xlsx	45.0 KB
5.4 Useful-Tips-Tools.pdf	3.5 MB
6. Be even quicker F5 + Enter.mp4	20.1 MB
6. Be even quicker F5 + Enter.srt	2.8 KB
6.1 21. F5-go-to - Lecture.xlsm	52.0 KB
7. FAQ F5 + Enter didn't work for me.html	0.4 KB
8. The Secret to Faster Scrolling in Excel.html	0.1 KB
9. Using Absolute and Relative Cell References.mp4	45.6 MB
9. Using Absolute and Relative Cell References.srt	2.8 KB
9.1 22. Fixing-Cells-Exercise - Solved.xlsx	11.1 KB
9.2 22. Fixing-Cells-Exercise - Unsolved.xlsx	10.9 KB
9.3 22. Fixing-references-Lecture - Solved.xlsx	660.7 KB
9.4 22. Fixing-references-Lecture - Unsolved.xlsx	659.4 KB
9.5 Useful-Tips-Tools.pdf	3.5 MB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/40. Business Analysis in Excel/
1. Trend analysis - theory.html	2.0 KB
10. Time series analysis.mp4	70.6 MB
10. Time series analysis.srt	9.8 KB
10.1 5. Time series_after.xlsx	65.0 KB
10.2 5. Time series_before.xlsx	60.1 KB
11. Regression analysis - theory.html	5.0 KB
12. Regression analysis.mp4	44.9 MB
12. Regression analysis.srt	6.6 KB
12.1 6.1 Regression analysis_after.xlsx	71.3 KB
12.2 6.1 Regression analysis_before.xlsx	70.2 KB
12.3 6.2 Multiple regression analysis_after.xlsx	78.1 KB
12.4 6.2 Multiple regression analysis_before.xlsx	76.6 KB
2. Trend analysis.mp4	73.7 MB
2. Trend analysis.srt	9.2 KB
2.1 1. Trend analysis_after.xlsx	41.7 KB
2.2 1. Trend analysis_before.xlsx	33.6 KB
3. Comparative analysis - theory.html	2.7 KB
4. Comparative analysis.mp4	33.9 MB
4. Comparative analysis.srt	6.4 KB
4.1 2. Comparative analysis_after.xlsx	45.0 KB
4.2 2. Comparative analysis_before.xlsx	44.5 KB
5. Value-based analysis - theory.html	3.8 KB
6. Value-based analysis.mp4	39.4 MB
6. Value-based analysis.srt	7.0 KB
6.1 3. Value-based analysis_after.xlsx	48.4 KB
6.2 3. Value-based analysis_before.xlsx	47.9 KB
7. Correlation analysis - theory.html	4.0 KB
8. Correlation analysis.mp4	38.1 MB
8. Correlation analysis.srt	4.9 KB
8.1 4. Correlation_after.xlsx	56.9 KB
8.2 4. Correlation_before.xlsx	52.1 KB
9. Time series analysis - theory.html	2.1 KB
/41. Finance 101 - The Time Value of Money and Interest Rate Components/
1. Finance 101 Important Financial Principles That You Will Need.mp4	27.9 MB
1. Finance 101 Important Financial Principles That You Will Need.srt	0.9 KB
1.1 Finance 101 - Introduction to the World of Finance.pdf	706.3 KB
2. Understanding the Time Value of Money.mp4	10.1 MB
2. Understanding the Time Value of Money.srt	1.8 KB
2.1 Finance 101 - Introduction to the World of Finance.pdf	706.3 KB
2.2 Time value of money.pdf	795.9 KB
3. How Interest Rates Play an Important Role in the Economy.mp4	22.6 MB
3. How Interest Rates Play an Important Role in the Economy.srt	2.0 KB
3.1 Finance 101 - Introduction to the World of Finance.pdf	706.3 KB
4. The Components Forming Interest Rates in Real Life.mp4	27.3 MB
4. The Components Forming Interest Rates in Real Life.srt	3.8 KB
4.1 Finance 101 - Introduction to the World of Finance.pdf	706.3 KB
4.2 Interest rate components.pdf	826.9 KB
5. What Is Libor and What Purpose Does It Serve.mp4	29.0 MB
5. What Is Libor and What Purpose Does It Serve.srt	1.4 KB
5.1 Finance 101 - Introduction to the World of Finance.pdf	706.3 KB
6. The Difference Between Fixed and Variable Interest Rates.mp4	27.7 MB
6. The Difference Between Fixed and Variable Interest Rates.srt	2.5 KB
6.1 Finance 101 - Introduction to the World of Finance.pdf	706.3 KB
7. What Is Default Risk and How Does a Bank Account For It.mp4	50.1 MB
7. What Is Default Risk and How Does a Bank Account For It.srt	9.3 KB
7.1 Default risk.pdf	902.0 KB
7.2 Finance 101 - Introduction to the World of Finance.pdf	706.3 KB
8. Corporate Loan Specifics.mp4	42.8 MB
8. Corporate Loan Specifics.srt	2.2 KB
8.1 Finance 101 - Introduction to the World of Finance.pdf	706.3 KB
/42. Finance 101 - The Value of Cash Flows with Different Timing/
1. Calculating the Present Value of Future Cash Flows.mp4	49.1 MB
1. Calculating the Present Value of Future Cash Flows.srt	6.3 KB
1.1 1. Calculating Future Cash Flows.pdf	829.7 KB
1.2 3.1 Present Value of Cash Flows.xlsx	10.1 KB
2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4	48.1 MB
2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.srt	5.2 KB
2.1 2. NPV.pdf	196.8 KB
/43. Finance 101 - Loan Calculations/
1. Using Annuities.mp4	23.3 MB
1. Using Annuities.srt	5.0 KB
2. Calculating a Complete Loan Schedule.mp4	46.9 MB
2. Calculating a Complete Loan Schedule.srt	9.3 KB
3. COURSE CHALLENGE - Part 3.mp4	23.5 MB
3. COURSE CHALLENGE - Part 3.srt	1.7 KB
3.1 3. Course Challenge.xlsx	550.6 KB
/44. Capital Budgeting - Basic Notions/
1. What is Capital Budgeting.mp4	12.9 MB
1. What is Capital Budgeting.srt	2.4 KB
2. When Do We Use Capital Budgeting.mp4	20.1 MB
2. When Do We Use Capital Budgeting.srt	3.6 KB
3. The Time Value of Money in a Capital Budgeting Setting.mp4	17.7 MB
3. The Time Value of Money in a Capital Budgeting Setting.srt	3.6 KB
4. Calculating Present and Future Value.mp4	33.1 MB
4. Calculating Present and Future Value.srt	8.4 KB
5. Cost of Equity.mp4	54.0 MB
5. Cost of Equity.srt	10.5 KB
6. Project-specific Beta.mp4	26.0 MB
6. Project-specific Beta.srt	4.8 KB
7. The Weighted Average Cost of Capital (WACC).mp4	14.7 MB
7. The Weighted Average Cost of Capital (WACC).srt	3.1 KB
8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4	22.9 MB
8. The Different Cash Flow Types in a Capital Budgeting Exercise.srt	5.2 KB
9. Modeling Future Cash Flows.mp4	52.9 MB
9. Modeling Future Cash Flows.srt	9.1 KB
/45. Capital Budgeting - A Complete Case Study/
1. An Introduction to the Case Study.mp4	23.4 MB
1. An Introduction to the Case Study.srt	4.4 KB
10. Estimating Cost of Equity.mp4	37.8 MB
10. Estimating Cost of Equity.srt	10.2 KB
10.1 8. WACC_unsolved.xlsx	36.8 KB
10.2 8. WACC.xlsx	38.9 KB
11. Discounting Project Cash Flows.mp4	25.2 MB
11. Discounting Project Cash Flows.srt	5.2 KB
11.1 9. Discounted cash flow.xlsx	40.7 KB
11.2 9.Discounted-cash-flow-unsolved.xlsx	39.7 KB
12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4	44.0 MB
12. Performing Sensitivity Analysis and Wrapping Up the Case Study.srt	7.5 KB
12.1 10. Sensitivity analysis_unsolved.xlsx	40.6 KB
12.2 10. Sensitivity analysis.xlsx	41.6 KB
12.3 Capital budgeting_exercise_unsolved.xlsx	13.5 KB
12.4 Capital-budgeting-exercise-solved.xlsx	43.8 KB
13. FAQ Data Does Not Change in the DCF Sheet, It Changes From the Drivers Sheet.html	0.4 KB
2. Organizing Inputs In the Drivers Sheet.mp4	33.5 MB
2. Organizing Inputs In the Drivers Sheet.srt	8.3 KB
2.1 1. Drivers.xlsx	11.8 KB
3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp4	33.6 MB
3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.srt	5.5 KB
3.1 2. Savings Forecast_unsolved.xlsx	15.1 KB
3.2 2. Savings Forecast.xlsx	17.0 KB
4. Preparing a Fixed Asset Rollforward Schedule.mp4	46.7 MB
4. Preparing a Fixed Asset Rollforward Schedule.srt	6.9 KB
4.1 3. Fixed Asset Rollforward_unsolved.xlsx	19.0 KB
4.2 3. Fixed Asset Rollforward.xlsx	20.1 KB
5. Calculating the Cash Impact of Extra Working Capital Required.mp4	17.1 MB
5. Calculating the Cash Impact of Extra Working Capital Required.srt	3.9 KB
5.1 4. Working Capital_unsolved.xlsx	21.7 KB
5.2 4. Working Capital.xlsx	22.5 KB
6. Debt Repayment and Interest Expenses Calculation.mp4	20.9 MB
6. Debt Repayment and Interest Expenses Calculation.srt	4.6 KB
6.1 5. Financing_unsolved.xlsx	30.7 KB
6.2 5. Financing.xlsx	31.7 KB
7. The Project's P&L Sheet.mp4	13.5 MB
7. The Project's P&L Sheet.srt	2.8 KB
7.1 6. P&L_unsolved.xlsx	30.4 KB
7.2 6. P&L.xlsx	31.8 KB
8. The Project's Cash Flow Calculation.mp4	30.5 MB
8. The Project's Cash Flow Calculation.srt	5.1 KB
8.1 7. Cash flow_unsolved.xlsx	30.4 KB
8.2 7. Cash flow.xlsx	32.1 KB
9. Calculating WACC (Weighted Average Cost of Capital).mp4	17.1 MB
9. Calculating WACC (Weighted Average Cost of Capital).srt	4.1 KB
9.1 8. WACC_unsolved.xlsx	36.8 KB
9.2 8. WACC.xlsx	38.9 KB
/46. Tesla Practical Case Study - Building a Financial Planning Model/
1. Organizing External Inputs in a 'Drivers' Sheet.mp4	36.8 MB
1. Organizing External Inputs in a 'Drivers' Sheet.srt	5.9 KB
1.1 0. Drivers_after.xlsx	1.5 MB
1.2 0. Drivers_before.xlsx	1.5 MB
1.3 Tesla Company Valuation - Detailed walkthrough.pdf	2.8 MB
10. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4	25.0 MB
10. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.srt	3.9 KB
10.1 7. Energy and Other gross profit_after.xlsx	1.6 MB
10.2 7. Energy and Other gross profit_before.xlsx	1.6 MB
11. Forecasting Operating Expenses.mp4	28.8 MB
11. Forecasting Operating Expenses.srt	6.4 KB
11.1 8. Opex_after.xlsx	1.6 MB
11.2 8. Opex_before.xlsx	1.6 MB
12. Building a Fixed Asset Roll Forward PP&E.mp4	34.3 MB
12. Building a Fixed Asset Roll Forward PP&E.srt	6.2 KB
12.1 9. PP&E forecasting_after.xlsx	1.6 MB
12.2 9. PP&E forecasting_before.xlsx	1.6 MB
13. Building a Fixed Asset Roll Forward Estimating Capex.mp4	41.2 MB
13. Building a Fixed Asset Roll Forward Estimating Capex.srt	5.6 KB
13.1 10. Capex forecasting_after.xlsx	1.6 MB
13.2 10. Capex forecasting_before.xlsx	1.6 MB
14. Building a Fixed Asset Roll Forward D&A Schedule.mp4	35.7 MB
14. Building a Fixed Asset Roll Forward D&A Schedule.srt	4.6 KB
14.1 11. D&A schedule_after.xlsx	1.6 MB
14.2 11. D&A schedule_before.xlsx	1.6 MB
15. Calculating DSO, DIO, DPO.mp4	17.5 MB
15. Calculating DSO, DIO, DPO.srt	2.9 KB
16. Producing a Clean P&L Output Sheet.mp4	15.2 MB
16. Producing a Clean P&L Output Sheet.srt	2.1 KB
16.1 12. P&L_after.xlsx	1.6 MB
16.2 12. P&L_before.xlsx	1.6 MB
17. Calculating Investments in Working Capital.mp4	19.6 MB
17. Calculating Investments in Working Capital.srt	2.9 KB
17.1 13. Working capital_after.xlsx	1.6 MB
17.2 13. Working capital_before.xlsx	1.6 MB
18. Forecasting Unlevered Free Cash Flow.mp4	32.7 MB
18. Forecasting Unlevered Free Cash Flow.srt	4.8 KB
18.1 14. Cash flow - UFCF_after.xlsx	1.6 MB
18.2 14. Cash flow - UFCF_before.xlsx	1.6 MB
19. Forecasting Other Assets.mp4	46.6 MB
19. Forecasting Other Assets.srt	7.1 KB
19.1 15. Balance sheet forecasting - assets_after.xlsx	1.6 MB
19.2 15. Balance sheet forecasting - assets_before.xlsx	1.6 MB
2. Forecasting Tesla's Expected Deliveries.mp4	108.4 MB
2. Forecasting Tesla's Expected Deliveries.srt	19.2 KB
2.1 1. Deliveries_after.xlsx	1.5 MB
2.2 1. Deliveries_before.xlsx	1.5 MB
20. Forecasting Other Liabilities.mp4	21.1 MB
20. Forecasting Other Liabilities.srt	3.0 KB
20.1 15a. Balance sheet forecasting - liabilities_after.xlsx	1.6 MB
20.2 15a. Balance sheet forecasting - liabilities_before.xlsx	1.6 MB
21. Completing Unlevered Free Cash Flow.mp4	70.1 MB
21. Completing Unlevered Free Cash Flow.srt	8.3 KB
21.1 16. Complete UFCF_after.xlsx	1.6 MB
21.2 16. Complete UFCF_before.xlsx	1.6 MB
22. Modeling Tesla's Financing Needs in the Forecast Period.mp4	40.7 MB
22. Modeling Tesla's Financing Needs in the Forecast Period.srt	6.9 KB
22.1 17. Financing_after.xlsx	1.6 MB
22.2 17. Financing_before.xlsx	1.6 MB
23. Calculating Net Income.mp4	14.5 MB
23. Calculating Net Income.srt	1.8 KB
23.1 18. P&L complete_after.xlsx	1.6 MB
23.2 18. P&L complete_before.xlsx	1.6 MB
24. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4	42.5 MB
24. Bridging Unlevered Free Cash Flow to Net Cash Flow.srt	5.1 KB
24.1 19. Net cash flow_after.xlsx	1.6 MB
24.2 19. Net cash flow_before.xlsx	1.6 MB
25. Balancing the Balance Sheet.mp4	12.5 MB
25. Balancing the Balance Sheet.srt	1.5 KB
25.1 20. Complete the BS_after.xlsx	1.6 MB
25.2 20. Complete the BS_before.xlsx	1.6 MB
3. Comparing Delivery Figures with the Ones of industry Peers.mp4	20.7 MB
3. Comparing Delivery Figures with the Ones of industry Peers.srt	4.8 KB
3.1 1a. Deliveries development_after.xlsx	1.5 MB
3.2 1a. Deliveries development_before.xlsx	1.5 MB
4. Estimating an Average Selling Price of Tesla Vehicles.mp4	48.2 MB
4. Estimating an Average Selling Price of Tesla Vehicles.srt	7.2 KB
4.1 2. Average of price models_after.xlsx	1.5 MB
4.2 2. Average of price models_before.xlsx	1.5 MB
5. Calculating Automotive Revenue.mp4	42.5 MB
5. Calculating Automotive Revenue.srt	6.5 KB
5.1 3. Revenue calculation_after.xlsx	1.5 MB
5.2 3. Revenue calculation_before.xlsx	1.5 MB
6. Peer Comparison Gross Profit %.mp4	37.5 MB
6. Peer Comparison Gross Profit %.srt	7.4 KB
6.1 4. Gross profit automotive_after.xlsx	1.5 MB
6.2 4. Gross profit automotive_before.xlsx	1.5 MB
7. Calculating Automotive Gross Profit.mp4	23.4 MB
7. Calculating Automotive Gross Profit.srt	3.8 KB
7.1 5. Gross profit and cost of sales_after.xlsx	1.5 MB
7.2 5. Gross profit and cost of sales_before.xlsx	1.5 MB
8. Calculating Automotive Cost of Sales.mp4	13.3 MB
8. Calculating Automotive Cost of Sales.srt	2.6 KB
9. Forecasting 'Energy' and 'Services' Revenue.mp4	20.0 MB
9. Forecasting 'Energy' and 'Services' Revenue.srt	3.5 KB
9.1 6. Energy and Other revenue_after.xlsx	1.6 MB
9.2 6. Energy and Other revenue_before.xlsx	1.6 MB
/47. Data Analysis with ChatGPT - Intro/
1. How ChatGPT Advanced Data Analysis Will Boost Your Productivity.mp4	29.9 MB
1. How ChatGPT Advanced Data Analysis Will Boost Your Productivity.srt	3.0 KB
2. The Limitations of ChatGPT Advanced Data Analysis.mp4	50.3 MB
2. The Limitations of ChatGPT Advanced Data Analysis.srt	4.4 KB
/48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/
1. Exploratory Data Analysis - Intro.mp4	59.9 MB
1. Exploratory Data Analysis - Intro.srt	5.5 KB
1.1 2.1_source.xlsx	174.6 KB
2. Extracting Descriptive Statistics with ChatGPT.mp4	20.3 MB
2. Extracting Descriptive Statistics with ChatGPT.srt	2.9 KB
3. Identifying Outliers.mp4	18.9 MB
3. Identifying Outliers.srt	3.8 KB
4. Correlation Analysis Hypothesis Formulation and Feature Ideas.mp4	20.2 MB
4. Correlation Analysis Hypothesis Formulation and Feature Ideas.srt	2.8 KB
5. Crafting a Comprehensive EDA Prompt.mp4	97.6 MB
5. Crafting a Comprehensive EDA Prompt.srt	11.2 KB
/49. Data Analysis with ChatGPT - Deal with Inconsistent Data/
1. Identifying and Handling Erroneous Data.mp4	34.9 MB
1. Identifying and Handling Erroneous Data.srt	4.6 KB
1.1 3.1_output.xlsx	17.6 KB
1.2 3.1_source.xlsx	15.9 KB
2. Verifying Data for Errors.mp4	38.6 MB
2. Verifying Data for Errors.srt	4.7 KB
2.1 3.2_output.xlsx	11.9 KB
2.2 3.2_source.xlsx	16.6 KB
3. Eliminating Duplicate Rows.mp4	13.0 MB
3. Eliminating Duplicate Rows.srt	1.8 KB
3.1 3.3_output.xlsx	8.3 KB
3.2 3.3_source.xlsx	17.1 KB
4. Addressing Unit Discrepancies in Data.mp4	19.9 MB
4. Addressing Unit Discrepancies in Data.srt	2.6 KB
4.1 3.4_output.xlsx	9.1 KB
4.2 3.4_source.xlsx	17.4 KB
5. Dividing Cell Content into Multiple Cells.mp4	48.5 MB
5. Dividing Cell Content into Multiple Cells.srt	5.7 KB
5.1 3.5_source.xlsx	17.2 KB
/5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/
1. Key Excel Functions IF.mp4	15.6 MB
1. Key Excel Functions IF.srt	4.0 KB
1.1 37. IF-function--Lecture-before.xlsm	17.4 KB
1.2 37. IF-function-Lecture-after.xlsm	18.4 KB
1.3 Functions - English to German.pdf	104.8 KB
1.4 Functions - English to Portuguese.pdf	149.6 KB
1.5 Functions - English to Spanish.pdf	104.8 KB
10. Working with Text in Excel.mp4	14.0 MB
10. Working with Text in Excel.srt	3.8 KB
10.1 43. Work-with-text-Lecture-after.xlsx	11.2 KB
10.2 43. Work-with-text-Lecture-before.xlsx	10.6 KB
11. Find the Highest and Lowest Values in a Range Max & Min.mp4	13.0 MB
11. Find the Highest and Lowest Values in a Range Max & Min.srt	1.1 KB
11.1 44. Excel-functions.xlsx	994.3 KB
11.2 44. Max-min-Lecture - Solved.xlsx	9.4 KB
11.3 44. Max-min-Lecture - Unsolved.xlsx	9.2 KB
11.4 44. MIN-MAX-Exercise - Solved.xlsx	15.2 KB
11.5 44. MIN-MAX-Exercise - Unsolved.xlsx	14.7 KB
11.6 Excel-Functions.pdf	3.3 MB
12. = and + are Interchangeable When You Start Typing a Formula.mp4	5.3 MB
12. = and + are Interchangeable When You Start Typing a Formula.srt	1.3 KB
12.1 45. Show-that-and-are-interchangeable-Lecture-after.xlsm	17.4 KB
12.2 45. Show-that-and-are-interchangeable-Lecture-before.xlsm	17.4 KB
13. Use ROUND in Your Financial Models.mp4	8.9 MB
13. Use ROUND in Your Financial Models.srt	1.2 KB
13.1 51. Excel-functions-Lecture.xlsx	911.3 KB
13.2 51. Round-Exercise - Solved.xlsx	12.0 KB
13.3 51. Round-Exercise - Unsolved.xlsx	11.6 KB
13.4 Excel-Functions.pdf	3.3 MB
14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4	55.1 MB
14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.srt	9.2 KB
14.1 47. Vlookup-Hlookup- Lecture - Solved.xlsx	11.4 KB
14.2 47. Vlookup-Hlookup- Lecture - Unsolved.xlsx	11.0 KB
14.3 47. Vlookup-Hlookup-Exercise - Solved.xlsx	14.0 KB
14.4 47. Vlookup-Hlookup-Exercise - Unsolved.xlsx	12.2 KB
14.5 Excel-Functions.pdf	3.3 MB
15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4	104.4 MB
15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.srt	8.8 KB
15.1 48. Index-Match-Exercise - Solved.xlsx	12.4 KB
15.2 48. Index-Match-Exercise - Unsolved.xlsx	11.9 KB
15.3 48. Index-Match-Lecture - Solved.xlsx	12.0 KB
15.4 48. Index-Match-Lecture - Unsolved.xlsx	11.6 KB
15.5 Excel-Functions.pdf	3.3 MB
16. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html	0.1 KB
17. XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).mp4	42.2 MB
17. XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).srt	10.7 KB
17.1 9. XLOOKUP_lecture_after.xlsm	19.4 KB
17.2 9. XLOOKUP_lecture_before.xlsm	19.2 KB
18. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4	20.1 MB
18. Using Excel's IFERROR Function to Trap Spreadsheet Errors.srt	2.2 KB
18.1 54. Iferror - Lecture - Solved.xlsm	917.9 KB
18.2 54. Iferror - Lecture - Unsolved.xlsm	918.8 KB
18.3 54. Iferror-Exercise - Solved.xlsx	15.7 KB
18.4 54. Iferror-Exercise - Unsolved.xlsx	14.6 KB
18.5 Excel-Functions.pdf	3.3 MB
19. A Useful Tool for Financial Analysis - The RANK Function.mp4	21.1 MB
19. A Useful Tool for Financial Analysis - The RANK Function.srt	4.0 KB
19.1 50. Rank-function-Lecture-after.xlsx	12.9 KB
19.2 50. Rank-function-Lecture-before.xlsx	12.6 KB
2. Enlarge the Formula Bar.mp4	6.0 MB
2. Enlarge the Formula Bar.srt	1.8 KB
2.1 38. Enlarge-the-formula-bar-Lecture.xlsm	48.0 KB
20. Create Flexible Financial Models with CHOOSE.mp4	33.6 MB
20. Create Flexible Financial Models with CHOOSE.srt	2.8 KB
20.1 51. Choose-Exercise - Unsolved.xlsx	11.6 KB
20.2 51. Choose-Exercise-Solved.xlsx	12.0 KB
20.3 51. Choose-Lecture - Solved.xlsx	9.9 KB
20.4 51. Choose-Lecture - Unsolved.xlsx	9.6 KB
20.5 Excel-Functions.pdf	3.3 MB
21. Goal Seek Will Help You Find the Result You Are Looking For.mp4	26.6 MB
21. Goal Seek Will Help You Find the Result You Are Looking For.srt	2.8 KB
21.1 57. Goal-Seek-Exercise - Unsolved.xlsx	16.5 KB
21.2 57. Goal-Seek-Exercise-Solved.xlsx	16.6 KB
21.3 57. Goal-Seek-Lecture - Solved.xlsx	9.4 KB
21.4 57. Goal-Seek-Lecture - Unsolved.xlsx	9.4 KB
21.5 Excel-Functions.pdf	3.3 MB
22. Goal Seek Will Help You Find the Result You Are Looking For.html	0.1 KB
23. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4	43.8 MB
23. Perform Sensitivity Analysis with Excel's Data Tables Functionality.srt	5.4 KB
23.1 58. Sensitivity analysis - Lecture - Solved.xlsm	918.8 KB
23.2 58. Sensitivity analysis - Lecture - Unsolved.xlsm	918.6 KB
23.3 58.Sensitivity-analysis-Exercise_Unsolved.xlsx	63.4 KB
23.4 58.Sensitivity-analysis-Exercise-Solved.xlsx	63.8 KB
24. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html	0.1 KB
25. Quiz Number 2.html	0.1 KB
3. Key Excel Functions SUM, SUMIF, SUMIFS.mp4	28.8 MB
3. Key Excel Functions SUM, SUMIF, SUMIFS.srt	5.3 KB
3.1 39. Sum-Sumif-Sumifs-Exercise - Solved.xlsx	15.2 KB
3.2 39. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx	14.8 KB
3.3 39. Sum-Sumif-Sumifs-Lecture - Solved.xlsx	13.3 KB
3.4 39. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx	13.2 KB
3.5 Excel-Functions.pdf	3.3 MB
4. A Helpful Consideration.html	1.4 KB
5. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4	52.3 MB
5. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt	4.6 KB
5.1 05 38 Counts Exercise & Text.xlsx	16.0 KB
5.2 05 38 Counts Solved.xlsx	16.4 KB
5.3 Excel-Functions.pdf	3.3 MB
5.4 Lecture-Count-Countif-Countifs-Solved.xlsx	12.0 KB
5.5 Lecture-Count-Countif-Countifs-Unsolved.xlsx	11.6 KB
6. Key Excel Functions AVERAGE & AVERAGEIF.mp4	25.3 MB
6. Key Excel Functions AVERAGE & AVERAGEIF.srt	2.4 KB
6.1 41. Average-Averageif- Lecture - Solved.xlsx	9.6 KB
6.2 41. Average-Averageif- Lecture - Unsolved.xlsx	9.2 KB
6.3 41. Average-AverageIF-Exercise - Solved.xlsx	15.4 KB
6.4 41. Average-AverageIF-Exercise - Unsolved.xlsx	15.0 KB
6.5 Excel-Functions.pdf	3.3 MB
7. Key Excel Functions Average & Averageif.html	0.1 KB
8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4	51.3 MB
8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.srt	5.0 KB
8.1 47. Text functions - Exercise - Solved.xlsx	12.5 KB
8.2 47. Text functions - Exercise - Unsolved.xlsx	12.0 KB
8.3 47. Text-Functions- Lecture - Solved.xlsx	11.4 KB
8.4 47. Text-Functions- Lecture - Unsolved.xlsx	10.9 KB
9. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html	0.1 KB
/50. Data Analysis with ChatGPT - Organize Messy Data/
1. Organize Messy Data.mp4	53.1 MB
1. Organize Messy Data.srt	5.6 KB
1.1 4.1_output.xlsx	63.5 KB
1.2 4.1_source.xlsx	85.7 KB
2. Data Mapping.mp4	24.2 MB
2. Data Mapping.srt	3.8 KB
2.1 4.2_output.xlsx	14.6 KB
2.2 4.2_source.xlsx	9.5 KB
3. Effective Data Classification.mp4	14.9 MB
3. Effective Data Classification.srt	2.7 KB
3.1 4.3_output.xlsx	6.7 KB
3.2 4.3_source.xlsx	16.0 KB
4. Order Data with ChatGPT.mp4	19.0 MB
4. Order Data with ChatGPT.srt	2.9 KB
4.1 4.4_output.xlsx	5.7 KB
4.2 4.4_source.xlsx	18.4 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/51. Data Analysis with ChatGPT - Working with Functions/
1. COUNTIFS, SUMIFS.mp4	26.0 MB
1. COUNTIFS, SUMIFS.srt	3.3 KB
1.1 5.1_output.xlsx	18.0 KB
1.2 5.1_source.xlsx	17.5 KB
2. Data Lookup.mp4	27.6 MB
2. Data Lookup.srt	3.9 KB
2.1 5.2_output.xlsx	18.8 KB
2.2 5.2_source.xlsx	17.8 KB
3. Data Ranking.mp4	25.7 MB
3. Data Ranking.srt	3.6 KB
3.1 5.3_output.xlsx	8.5 KB
3.2 5.3_source.xlsx	17.8 KB
4. Fill Until Non-blank Values.mp4	23.7 MB
4. Fill Until Non-blank Values.srt	4.3 KB
4.1 5.4_output.xlsx	6.2 KB
4.2 5.4_source.xlsx	14.8 KB
5. Translating Logic into Excel Formulas with ChatGPT.mp4	12.4 MB
5. Translating Logic into Excel Formulas with ChatGPT.srt	3.2 KB
5.1 5.5_output.xlsx	14.8 KB
5.2 5.5_source.xlsx	14.3 KB
/52. Data Analysis with ChatGPT - Clean Text Data/
1. Correcting Inverted Names.mp4	16.3 MB
1. Correcting Inverted Names.srt	2.7 KB
1.1 6.1_source.xlsx	11.7 KB
2. Dealing with Trailing and Leading Spaces in Text Data.mp4	18.8 MB
2. Dealing with Trailing and Leading Spaces in Text Data.srt	2.8 KB
2.1 6.2_source.xlsx	12.7 KB
3. Standardizing Letter Capitalization.mp4	16.5 MB
3. Standardizing Letter Capitalization.srt	2.9 KB
3.1 6.3_source.xlsx	18.7 KB
4. Handling Multi-lingual Text Data.mp4	37.6 MB
4. Handling Multi-lingual Text Data.srt	4.5 KB
4.1 6.4_source.xlsx	13.3 KB
5. Multiple Find and Replace at the Same Time with ChatGPT.mp4	25.1 MB
5. Multiple Find and Replace at the Same Time with ChatGPT.srt	3.5 KB
5.1 6.5_source.xlsx	18.4 KB
6. Criteria-based Duplicate Removal.mp4	15.1 MB
6. Criteria-based Duplicate Removal.srt	3.3 KB
6.1 6.6_source.xlsx	14.9 KB
7. Removing Duplicates Across Multiple Columns.mp4	15.3 MB
7. Removing Duplicates Across Multiple Columns.srt	2.8 KB
7.1 6.7_source.xlsx	15.3 KB
/53. Data Analysis with ChatGPT - Dates and Time Data/
1. Obtain Day and Month From Date.mp4	28.9 MB
1. Obtain Day and Month From Date.srt	3.5 KB
1.1 7.1_output.xlsx	19.4 KB
1.2 7.1_source.xlsx	17.4 KB
2. Converting Hours to Decimals.mp4	10.4 MB
2. Converting Hours to Decimals.srt	2.2 KB
2.1 7.2_output.xlsx	16.5 KB
2.2 7.2_source.xlsx	14.5 KB
3. Obtaining Age in Years, Months, Days.mp4	9.6 MB
3. Obtaining Age in Years, Months, Days.srt	2.2 KB
3.1 7.3_output.xlsx	14.8 KB
3.2 7.3_source.xlsx	14.4 KB
4. Order Dates Chronologically.mp4	13.1 MB
4. Order Dates Chronologically.srt	2.1 KB
4.1 7.4_output.xlsx	18.6 KB
4.2 7.4_source.xlsx	401.7 KB
/54. Data Analysis with ChatGPT - Complete Practical Example/
1. Intro to the Exercise and Preprocessing Ideas from ChatGPT.mp4	41.7 MB
1. Intro to the Exercise and Preprocessing Ideas from ChatGPT.srt	6.5 KB
1.1 8.1 Free_Plan_Users_output.xlsx	149.6 KB
1.2 8.1_source.xlsx	173.5 KB
1.3 8.1_Transactions_output.xlsx	75.8 KB
2. Preprocessing the 'Free plan users' Sheet (12).mp4	67.9 MB
2. Preprocessing the 'Free plan users' Sheet (12).srt	9.7 KB
3. Preprocessing the 'Free plan users' Sheet (22).mp4	37.4 MB
3. Preprocessing the 'Free plan users' Sheet (22).srt	4.7 KB
4. Working on the 'Transactions' Sheet.mp4	82.6 MB
4. Working on the 'Transactions' Sheet.srt	7.1 KB
5. Dealing with the Country Mapping Issue.mp4	24.4 MB
5. Dealing with the Country Mapping Issue.srt	3.9 KB
/55. PowerPoint - Introduction to PowerPoint/
1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4	31.9 MB
1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.srt	1.2 KB
10. Practical Learning - Exercise 1.mp4	28.8 MB
10. Practical Learning - Exercise 1.srt	5.4 KB
10.1 Practical Example - Organizing Notes.docx	15.9 KB
10.2 Practical Example - Organizing Notes.pptx	1.3 MB
11. Changing an Object's Size and Rotation.mp4	11.8 MB
11. Changing an Object's Size and Rotation.srt	2.8 KB
11.1 Resizing and Rotating Objects.pptx	1.3 MB
12. Using Slide Masters.mp4	23.5 MB
12. Using Slide Masters.srt	6.4 KB
12.1 Slide Masters Presentation - example.pptx	44.5 KB
13. Bring to Front and Send to Back - An Important PowerPoint Technique.mp4	16.0 MB
13. Bring to Front and Send to Back - An Important PowerPoint Technique.srt	4.6 KB
13.1 Bring to Front and Send to Back.pptx	1.3 MB
14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4	29.0 MB
14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.srt	7.6 KB
14.1 Insert table.pptx	1.3 MB
2. The Structure of the PowerPoint Ribbon.mp4	29.0 MB
2. The Structure of the PowerPoint Ribbon.srt	7.5 KB
2.1 Introduction to PowerPoint.pdf	2.7 MB
3. General Considerations About Slide Structure.mp4	27.6 MB
3. General Considerations About Slide Structure.srt	6.1 KB
3.1 Spacing within PowerPoint.pptx	1.9 MB
3.2 Spacing-within-PowerPoint-chart.xlsx	58.7 KB
4. Learn How to Insert Objects in PowerPoint.mp4	33.5 MB
4. Learn How to Insert Objects in PowerPoint.srt	6.0 KB
4.1 Insert objects.pptx	1.7 MB
4.2 Kinemax Data.xlsx	37.3 KB
5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4	17.5 MB
5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.srt	3.9 KB
5.1 Power-Point-Master-Class-Shortcuts-For-Mac.pdf	545.2 KB
5.2 PowerPoint Master Class - Shortcuts.pdf	451.0 KB
6. Add Frequently Used Buttons to the Quick Access Toolbar.mp4	22.4 MB
6. Add Frequently Used Buttons to the Quick Access Toolbar.srt	4.9 KB
6.1 Quick Access Toolbar buttons.pptx	1.3 MB
7. How to Easily Align Objects in PowerPoint.mp4	21.5 MB
7. How to Easily Align Objects in PowerPoint.srt	6.4 KB
7.1 Align and Distribute objects in Ppt.pptx	1.3 MB
8. How to Edit Shapes in Your Presentation.mp4	27.6 MB
8. How to Edit Shapes in Your Presentation.srt	7.3 KB
8.1 Format Shape Menu.pptx	649.4 KB
9. How to Format Text Boxes in a PowerPoint Presentation.mp4	20.9 MB
9. How to Format Text Boxes in a PowerPoint Presentation.srt	5.7 KB
9.1 Working with text.pptx	791.5 KB
/56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/
1. An Introduction to PowerPoint Animations.mp4	15.3 MB
1. An Introduction to PowerPoint Animations.srt	5.2 KB
1.1 Animation effects.pptx	1.3 MB
10. Practical Exercise - Creating an Organisational Chart.mp4	55.4 MB
10. Practical Exercise - Creating an Organisational Chart.srt	9.7 KB
10.1 List of executives.png	64.4 KB
10.2 Practical Example - completed.pptx	1.3 MB
10.3 Practical Example.pptx	1.3 MB
11. COURSE CHALLENGE - Part 4.mp4	43.8 MB
11. COURSE CHALLENGE - Part 4.srt	3.6 KB
11.1 4. Course Challenge - Tasks.pdf	289.8 KB
11.2 4. Course Challenge.pptx	1.2 MB
11.3 Sending Files with Dropbox - YouTube Tutorial.html	0.1 KB
2. Modifying the Beginning and Ending of a Line Object.mp4	10.7 MB
2. Modifying the Beginning and Ending of a Line Object.srt	2.9 KB
2.1 Line Begin and End type.pptx	1.3 MB
3. Join Shapes Together By Using Connector Lines.mp4	25.0 MB
3. Join Shapes Together By Using Connector Lines.srt	6.5 KB
3.1 Connectors.pptx	1.3 MB
4. Edit Points - Learn How to Customize PowerPoint Shapes.mp4	8.7 MB
4. Edit Points - Learn How to Customize PowerPoint Shapes.srt	3.0 KB
4.1 Edit Points.pptx	1.3 MB
5. Group or Ungroup Shapes, Pictures or Other Objects.mp4	15.4 MB
5. Group or Ungroup Shapes, Pictures or Other Objects.srt	3.1 KB
5.1 Group.pptx	1.3 MB
6. This is How You Can Fit Text When It Is Larger Than a Shape.mp4	14.5 MB
6. This is How You Can Fit Text When It Is Larger Than a Shape.srt	3.3 KB
6.1 Internal Margins.pptx	1.3 MB
7. Nudge Objects.mp4	4.6 MB
7. Nudge Objects.srt	1.8 KB
7.1 Nudge objects.pptx	1.3 MB
8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4	22.0 MB
8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.srt	5.5 KB
8.1 Smart Art.pptx	1.3 MB
9. Creating Eye-Catching Text Effects in PowerPoint.mp4	13.1 MB
9. Creating Eye-Catching Text Effects in PowerPoint.srt	3.4 KB
9.1 Text effects.pptx	1.3 MB
/57. Who Does What in the World of Finance/
1. Who Does What in the World of Finance.mp4	680.9 MB
1. Who Does What in the World of Finance.srt	104.3 KB
1.1 Who Does What in Finance - Infographic.pdf	1.3 MB
/58. Next Steps/
1. Next Steps.html	3.0 KB
/6. Microsoft Excel - Financial Functions in Excel/
1. Discounting Cash Flows in Microsoft Excel.mp4	41.5 MB
1. Discounting Cash Flows in Microsoft Excel.srt	7.4 KB
1.1 54. FV and PV-Lecture.xlsx	10.9 KB
2. Calculating Internal Rate of Return (IRR) in Excel.mp4	20.8 MB
2. Calculating Internal Rate of Return (IRR) in Excel.srt	3.9 KB
2.1 55. IRR-Lecture.xlsx	11.5 KB
3. Using the PMT Function to Create a Complete Loan Schedule.mp4	37.0 MB
3. Using the PMT Function to Create a Complete Loan Schedule.srt	7.0 KB
3.1 56. Loan Schedule-Lecture.xlsx	20.7 KB
4. Date Functions in Excel.mp4	28.8 MB
4. Date Functions in Excel.srt	7.4 KB
4.1 57. Date Functions-Lecture.xlsx	12.5 KB
/7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/
1. Introduction to the Case Study.mp4	10.0 MB
1. Introduction to the Case Study.srt	1.3 KB
10. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4	49.4 MB
10. Using INDEX & MATCH as a Substitute for VLOOKUP.srt	5.6 KB
10.1 66. Index Match_before.xlsm	42.0 KB
10.2 66. Index Match-Lecture-after.xlsm	14.5 MB
11. XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.mp4	35.0 MB
11. XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.srt	4.3 KB
11.1 9a. XLOOKUP_after.xlsm	46.9 KB
11.2 9a. XLOOKUP_before.xlsm	42.0 KB
12. The Mapping Exercise.mp4	21.3 MB
12. The Mapping Exercise.srt	2.8 KB
12.1 67. Mapping-Lecture-after.xlsm	51.7 KB
12.2 67. Mapping-Lecture-before.xlsm	51.8 KB
12.3 Mapping-exercise-explained.pdf	248.9 KB
13. Mapping the Rows in the Database Sheet.mp4	38.0 MB
13. Mapping the Rows in the Database Sheet.srt	8.5 KB
13.1 68. Mapping-Lecture-after.xlsm	51.7 KB
13.2 68. Mapping-Lecture-before.xlsm	51.8 KB
13.3 Mapping-exercise-explained.pdf	248.9 KB
14. Building the Structure of the P&L Sheet.mp4	18.8 MB
14. Building the Structure of the P&L Sheet.srt	3.1 KB
14.1 69. Building a P&L-Lecture-after.xlsm	53.1 KB
14.2 69. Building a P&L-Lecture-before.xlsm	51.4 KB
15. A Practical Example of Professional Formatting in Excel.mp4	24.3 MB
15. A Practical Example of Professional Formatting in Excel.srt	4.5 KB
15.1 70 Formatting the P&L-Lecture-after.xlsm	53.2 KB
15.2 70. Formatting a P&L-Lecture-before.xlsm	53.1 KB
16. Populating the P&L Sheet with SUMIF.mp4	30.6 MB
16. Populating the P&L Sheet with SUMIF.srt	3.8 KB
16.1 71. Formatting the P&L-Lecture-after.xlsm	54.8 KB
16.2 71. Formatting the P&L-Lecture-before.xlsm	53.2 KB
17. Learn How to Find Mistakes with COUNTIF.mp4	28.9 MB
17. Learn How to Find Mistakes with COUNTIF.srt	3.8 KB
17.1 72. Countif-Lecture-after.xlsm	56.1 KB
17.2 72. Countif-Lecture-before.xlsm	54.8 KB
18. Calculating Growth Rates in Excel.mp4	29.7 MB
18. Calculating Growth Rates in Excel.srt	4.3 KB
18.1 73. Adding % variations-Lecture-after.xlsm	57.9 KB
18.2 73. Adding % variations-Lecture-before.xlsm	56.1 KB
18.3 Y-o-Y Function explanation.pdf	168.9 KB
19. Quiz Number 3.html	0.1 KB
2. What You Will See Next.mp4	10.2 MB
2. What You Will See Next.srt	1.5 KB
3. Understand Your Data Source Before You Start Working on It.mp4	26.7 MB
3. Understand Your Data Source Before You Start Working on It.srt	4.2 KB
3.1 60. Get to know the data source - Lecture.xlsm	44.1 KB
4. Ordering the Source Worksheet.mp4	26.0 MB
4. Ordering the Source Worksheet.srt	3.3 KB
4.1 61. Order a worksheet_after.xlsm	42.0 KB
4.2 61. Order a worksheet_before.xlsm	44.1 KB
5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4	24.0 MB
5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.srt	2.9 KB
5.1 62. Creating a code_after.xlsm	42.7 KB
5.2 62. Creating a code_before.xlsm	42.0 KB
6. Learn How to Create a Database.mp4	19.7 MB
6. Learn How to Create a Database.srt	2.7 KB
6.1 63. Creating a database_after.xlsm	40.3 KB
6.2 63. Creating a database_before.xlsm	36.2 KB
7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4	59.7 MB
7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.srt	7.2 KB
7.1 64. Vlookup_after.xlsm	45.5 KB
7.2 64. Vlookup_before.xlsm	40.5 KB
8. Using SUMIF to Complete the Database Sheet.mp4	46.9 MB
8. Using SUMIF to Complete the Database Sheet.srt	5.7 KB
8.1 65. Sumif_after.xlsm	50.7 KB
8.2 65. Sumif_before.xlsm	45.5 KB
9. FAQ Why Net income should be 0.html	1.3 KB
/8. Practical Exercise - SUMIFS/
1. Practical Exercise - SUMIFS.mp4	72.3 MB
1. Practical Exercise - SUMIFS.srt	12.6 KB
1.1 SUMIFS_Exercise_after.xlsx	1.3 MB
1.2 SUMIFS_Exercise_before.xlsx	1.3 MB
/9. Microsoft Excel - Building Professional Charts in Excel/
1. Introduction to Excel Charts.mp4	20.9 MB
1. Introduction to Excel Charts.srt	1.4 KB
2. Beginner's Guide to Inserting Charts in Excel.mp4	38.0 MB
2. Beginner's Guide to Inserting Charts in Excel.srt	2.8 KB
2.1 75. Inserting-Charts-Lecture.xlsm	12.0 MB
3. Modifying Excel Charts - The Easy Way.mp4	44.2 MB
3. Modifying Excel Charts - The Easy Way.srt	3.3 KB
3.1 76. Formatting-a-Chart-Lecture.xlsm	12.0 MB
4. Making Your Excel Charts Sexier - Proven Tips.mp4	55.9 MB
4. Making Your Excel Charts Sexier - Proven Tips.srt	3.9 KB
4.1 77. Modifying-a-Chart-Lecture.xlsm	12.0 MB
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4	22.5 MB
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.srt	1.4 KB
5.1 78. Bridge-Charts-Lecture.xlsx	13.4 KB
6. New Ways to Visualize Your Data - Treemap Charts.mp4	19.2 MB
6. New Ways to Visualize Your Data - Treemap Charts.srt	1.8 KB
6.1 79. Treemap-Charts-Lecture.xlsx	12.9 KB
7. How to Represent Trends with Sparklines.mp4	45.0 MB
7. How to Represent Trends with Sparklines.srt	4.6 KB
7.1 80. Sparklines-Lecture.xlsx	9.8 KB
/
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
Total files 1323