FileMood

Download [FreeTutorials.Us] the-complete-financial-analyst-course

FreeTutorials Us the complete financial analyst course

Name

[FreeTutorials.Us] the-complete-financial-analyst-course

  DOWNLOAD Copy Link

Total Size

2.6 GB

Total Files

491

Hash

F86F2BDE92130A08B58A420A4EB3D4D6997D40E7

/01 Welcome Course Introduction/

001 What Does the Course Cover.mp4

11.1 MB

002 Everything We Will Learn Has a Practical Application.mp4

10.7 MB

003 The Best Way to Take This Course.mp4

9.3 MB

/.../002 Everything We Will Learn Has a Practical Application/

Quick-win.xlsx

10.0 KB

/.../003 The Best Way to Take This Course/

The-Best-way-to-take-it-new.mov

10.9 MB

/02 Microsoft Excel - Quick Introduction/

004 Microsoft Excel The Worlds 1 Software for the Office.mp4

20.4 MB

005 Excel Made Easy A Beginners Guide to Excel Spreadsheets.mp4

8.5 MB

006 Data Entry Techniques in Excel.mp4

7.4 MB

007 How to Make Your Spreadsheets Look Professional.mp4

15.4 MB

008 Inserting Deleting and Modifying Rows Columns.mp4

4.3 MB

009 Excel Formulas for Beginners.mp4

5.7 MB

010 A Beginners Introduction to Excel Functions.mp4

7.8 MB

011 Work Efficiently by Using Cut Copy and Paste.mp4

5.9 MB

012 Pasting Values Formulas and Formats with Paste Special.mp4

5.9 MB

/.../004 Microsoft Excel The Worlds 1 Software for the Office/

Introduction-to-Excels-basic-features.pdf

2.4 MB

/.../005 Excel Made Easy A Beginners Guide to Excel Spreadsheets/

02-6-Overview-of-Excel-Exercise-Text.xlsx

10.7 KB

02-6-Overview-of-Excel-Solved.xlsx

11.1 KB

Introduction-to-Excels-basic-features.pdf

2.4 MB

/.../006 Data Entry Techniques in Excel/

02-9-Data-Entry-Exercise-Text.xlsx

11.2 KB

02-9-Data-Entry-Solved.xlsx

33.5 KB

Data-Entry.xlsx

8.3 KB

Introduction-to-Excels-basic-features.pdf

2.4 MB

/.../007 How to Make Your Spreadsheets Look Professional/

02-10-Formatting-Exercise-Text.xlsx

11.9 KB

02-10-Formatting-Solved.xlsx

11.9 KB

Formatting-Solved.xlsx

10.1 KB

Formatting-Unsolved.xlsx

9.1 KB

Introduction-to-Excels-basic-features.pdf

2.4 MB

/.../008 Inserting Deleting and Modifying Rows Columns/

02-7-Basic-Manipulations-Exercise-Text.xlsx

11.3 KB

02-7-Basic-Manipulations-Solved.xlsx

33.2 KB

Data-Entry.xlsx

8.3 KB

Introduction-to-Excels-basic-features.pdf

2.4 MB

/.../009 Excel Formulas for Beginners/

02-11-Formulas-Exercise-Text.xlsx

12.0 KB

02-11-Formulas-Solved.xlsx

82.1 KB

Formulas-Solved.xlsx

9.6 KB

Formulas-Unsolved.xlsx

9.5 KB

Introduction-to-Excels-basic-features.pdf

2.4 MB

/.../010 A Beginners Introduction to Excel Functions/

02-12-Functions-Exercise-Text.xlsx

13.6 KB

02-12-Functions-Solved.xlsx

83.0 KB

Functions-Solved.xlsx

9.6 KB

Functions-Unsolved.xlsx

9.5 KB

Introduction-to-Excels-basic-features.pdf

2.4 MB

/.../011 Work Efficiently by Using Cut Copy and Paste/

02-13-Copy-Cut-Paste-Exercise-Text.xlsx

11.6 KB

02-13-Copy-Cut-Paste-Solved.xlsx

12.9 KB

Introduction-to-Excels-basic-features.pdf

2.4 MB

/.../012 Pasting Values Formulas and Formats with Paste Special/

02-14-Paste-Special-Exercise-Text.xlsx

13.8 KB

02-14-Paste-Special-Solved.xlsx

13.8 KB

Introduction-to-Excels-basic-features.pdf

2.4 MB

/quizzes/

001 Data Entry Techniques in Excel.html

2.5 KB

002 Inserting Deleting and Modifying Rows Columns.html

3.1 KB

003 Excel Formulas for Beginners.html

2.6 KB

004 Work Efficiently by Using Cut Copy and Paste.html

2.9 KB

/03 Microsoft Excel - Useful Tools/

013 Inserting a Line Break with Alt Enter.mp4

3.6 MB

014 Do More with Your Sales Data with Excels Text to Columns Feature.mp4

4.4 MB

015 Create Easily Printable Excel Documents.mp4

3.6 MB

016 How to Wrap Text in Excel and Adjust a Cells Size.mp4

1.5 MB

017 Insert Hyperlinks in Excel Spreadsheets.mp4

3.3 MB

018 Using Excels Freeze Panes to Handle Large Datasets.mp4

6.0 MB

019 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4

5.7 MB

020 A Quick Introduction to Excels Pivot Tables.mp4

14.1 MB

/.../013 Inserting a Line Break with Alt Enter/

03-20-Alt-Enter-Exercise-Text.xlsx

11.4 KB

03-20-Alt-Enter-Solved.xlsx

11.7 KB

Alt-Enter-Solved.xlsx

9.9 KB

Alt-Enter-Unsolved.xlsx

9.9 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../014 Do More with Your Sales Data with Excels Text to Columns Feature/

03-21-Text-to-Columns-Exercise-Text.xlsx

10.8 KB

03-21-Text-to-Columns-Solved.xlsx

11.6 KB

Text-to-columns-Solved.xlsx

10.1 KB

Text-to-columns-Unsolved.xlsx

10.0 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../015 Create Easily Printable Excel Documents/

Set-Print-Area-Solved.xlsx

11.5 KB

Set-Print-Area-Unsolved.xlsx

11.7 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../016 How to Wrap Text in Excel and Adjust a Cells Size/

03-22-Wrap-Text-Exercise-Text.xlsx

10.4 KB

03-22-Wrap-Text-Solved.xlsx

10.4 KB

Useful-Tips-Tools.pdf

3.5 MB

Wrap-text-Solved.xlsx

9.8 KB

Wrap-text-Unsolved.xlsx

9.8 KB

/.../017 Insert Hyperlinks in Excel Spreadsheets/

03-31-Hyperlinks-Exercise-Text.xlsx

140.2 KB

03-31-Hyperlinks-Solved.xlsx

140.4 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../018 Using Excels Freeze Panes to Handle Large Datasets/

Freeze-Panes-Solved.xlsx

659.4 KB

Freeze-Panes-Unsolved.xlsx

659.3 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../019 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do/

Useful-Tips-Tools.pdf

3.5 MB

/.../020 A Quick Introduction to Excels Pivot Tables/

Pivot-Table-solved.xlsm

875.4 KB

Pivot-Table-unsolved.xlsm

662.0 KB

Useful-Tips-Tools.pdf

3.5 MB

/quizzes/

005 Do More with Your Sales Data with Excels Text to Columns Feature.html

2.6 KB

/04 Microsoft Excel - Best Practices That Will Make a Difference/

021 Initial Formatting Is Key for Creating Professional - Looking Spreadsheets.mp4

7.9 MB

022 Macros Are a Great Timesaver Heres Why..mp4

10.4 MB

023 The Secret to Faster Scrolling in Excel.mp4

7.6 MB

024 Using Absolute and Relative Cell References.mp4

15.8 MB

025 Find and Select Cells That Meet Specific Conditions.mp4

4.1 MB

026 How to Create Dynamic Names in Excel Spreadsheets.mp4

5.5 MB

027 Using Named Ranges to Make Formulas More Readable.mp4

3.4 MB

028 Custom Number Formatting.mp4

3.6 MB

029 How to Add a Drop-down List in Excel.mp4

4.7 MB

030 Using Custom-sort to Sort Multiple Columns Within a Table.mp4

7.5 MB

031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4

14.0 MB

/.../021 Initial Formatting Is Key for Creating Professional - Looking Spreadsheets/

Formatting-a-worksheet-Solved.xlsx

9.8 KB

Formatting-a-worksheet-Unsolved.xlsx

9.2 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../022 Macros Are a Great Timesaver Heres Why/

03-28-Macros-Exercise-Text.xlsx

10.6 KB

03-28-Macros-Solved.xlsx

148.5 KB

Creating-a-Macro-Solved.xlsx

11.4 KB

Creating-a-Macro-Unsolved.xlsx

9.9 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../023 The Secret to Faster Scrolling in Excel/

03-18-Fast-Scrolling-Exercise-Text.xlsx

45.0 KB

03-18-Fast-Scrolling-Solved.xlsx

45.4 KB

Fast-scrolling-Solved.xlsx

10.3 KB

Fast-scrolling-Unsolved.xlsx

10.3 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../024 Using Absolute and Relative Cell References/

03-19-Fixing-Cells-Exercise-Text.xlsx

10.9 KB

03-19-Fixing-Cells-Solved.xlsx

11.1 KB

Fixing-references-Solved.xlsx

660.7 KB

Fixing-references-Unsolved.xlsx

659.4 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../025 Find and Select Cells That Meet Specific Conditions/

03-24-Select-Special-F5-Exercise-Text.xlsx

22.1 KB

03-24-Select-Special-F5-Solved.xlsx

22.8 KB

Select-Special.xlsx

10.8 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../026 How to Create Dynamic Names in Excel Spreadsheets/

03-25-Assigning-Dynamic-Names-Exercise-Text.xlsx

11.5 KB

03-25-Assigning-Dynamic-Names-Solved.xlsx

12.0 KB

Dynamic-Naming-Solved.xlsx

14.2 KB

Dynamic-Naming-Unsolved.xlsx

13.9 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../027 Using Named Ranges to Make Formulas More Readable/

03-26-Defining-a-Named-Range-Exercise-Text.xlsx

11.3 KB

03-26-Defining-a-Named-Range-Solved.xlsx

11.9 KB

Naming-ranges-Solved.xlsx

10.6 KB

Naming-ranges-Unsolved.xlsx

9.0 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../028 Custom Number Formatting/

03-27-Assigning-Custom-Formats-Exercise-Text.xlsx

11.6 KB

03-27-Assigning-Custom-Formats-Solved.xlsx

11.3 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../029 How to Add a Drop-down List in Excel/

03-29-Drop-down-List-Exercise-Text.xlsx

11.6 KB

03-29-Drop-down-List-Solved.xlsx

78.9 KB

Data-Validation-Solved.xlsx

11.1 KB

Data-Validation-Unsolved.xlsx

11.1 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../030 Using Custom-sort to Sort Multiple Columns Within a Table/

03-30-Custom-Sort-Exercise-Text.xlsx

11.6 KB

03-30-Custom-Sort-Solved.xlsx

11.7 KB

Sort-data-Solved.xlsx

149.1 KB

Sort-data-Unsolved.xlsx

148.8 KB

Useful-Tips-Tools.pdf

3.5 MB

/.../031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts/

Microsoft-Excel-Keyboard-Shortcuts.pdf

1.3 MB

Useful-Tips-Tools.pdf

3.5 MB

Useful-tips-and-tools-Excel-file.xlsx

2.3 MB

/quizzes/

006 Macros Are a Great Timesaver Heres Why..html

2.8 KB

007 The Secret to Faster Scrolling in Excel.html

2.8 KB

008 Using Absolute and Relative Cell References.html

2.9 KB

009 Find and Select Cells That Meet Specific Conditions.html

2.8 KB

010 How to Create Dynamic Names in Excel Spreadsheets.html

2.9 KB

011 Quiz Number 1.html

6.1 KB

/05 Microsoft Excel - Beginner Intermediate Advanced Functions/

032 Key Excel Functions Sum Sumif Sumifs.mp4

11.2 MB

033 Key Excel Functions Count Counta Countif Countifs.mp4

15.5 MB

034 Key Excel Functions Average Averageif.mp4

8.0 MB

035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate.mp4

17.6 MB

036 Find the Highest and the Lowest Values in a Range Max Min.mp4

5.7 MB

037 Use Round in Your Financial Models.mp4

2.6 MB

038 Excels Lookup Functions Vlookup Hlookup Made Easy.mp4

20.2 MB

039 Index Match and Their Combination - The Perfect Substitute of Vlookup.mp4

33.0 MB

040 Using Excels Iferror Function to Trap Spreadsheet Errors.mp4

5.9 MB

041 Create Flexible Financial Models with Choose.mp4

10.2 MB

042 Goal Seek Will Help You Find the Result You Are Looking For.mp4

8.0 MB

043 Perform Sensitivity Analysis with Excels Data Tables Functionality.mp4

13.4 MB

/.../032 Key Excel Functions Sum Sumif Sumifs/

05-37-Sum-Sumif-Sumifs-Exercise-Text.xlsx

14.8 KB

05-37-Sum-Sumif-Sumifs-Solved.xlsx

15.2 KB

Excel-Functions.pdf

3.3 MB

Sum-Sumif-Sumifs-Solved.xlsx

13.3 KB

Sum-Sumif-Sumifs-Unsolved.xlsx

13.2 KB

/.../033 Key Excel Functions Count Counta Countif Countifs/

05-38-Counts-Exercise-Text.xlsx

15.6 KB

05-38-Counts-Solved.xlsx

16.1 KB

Count-Countif-Countifs-Unsolved.xlsx

11.6 KB

Excel-Functions.pdf

3.3 MB

/.../034 Key Excel Functions Average Averageif/

05-39-Average-AverageIF-Exercise-Text.xlsx

15.0 KB

05-39-Average-AverageIF-Solution.xlsx

15.4 KB

Average-Averageif-Solved.xlsx

9.6 KB

Average-Averageif-Unsolved.xlsx

9.2 KB

Excel-Functions.pdf

3.3 MB

/.../035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate/

05-40-2-Left-Right-etc-Exercise-Text.xlsx

12.0 KB

05-40-2-Left-Right-etc-Solved.xlsx

12.5 KB

Text-Functions-Solved.xlsx

11.4 KB

Text-Functions-Unsolved.xlsx

10.9 KB

/.../036 Find the Highest and the Lowest Values in a Range Max Min/

05-41-MIN-MAX-Exercise-Text.xlsx

14.7 KB

05-41-MIN-MAX-Solved.xlsx

15.2 KB

Excel-Functions.pdf

3.3 MB

Max-min-Solved.xlsx

9.4 KB

Max-min-Unsolved.xlsx

9.2 KB

/.../037 Use Round in Your Financial Models/

05-42-Round-Exercise-Text.xlsx

11.6 KB

05-42-Round-Solved.xlsx

12.0 KB

Excel-Functions.pdf

3.3 MB

Excel-functions.xlsx

994.3 KB

/.../038 Excels Lookup Functions Vlookup Hlookup Made Easy/

05-43-Vlookup-Hlookup-Exercise-Text.xlsx

12.2 KB

05-43-Vlookup-Hlookup-Solved.xlsx

14.0 KB

Excel-Functions.pdf

3.3 MB

Vlookup-Hlookup-Solved.xlsx

11.4 KB

Vlookup-Hlookup-Unsolved.xlsx

11.0 KB

/.../039 Index Match and Their Combination - The Perfect Substitute of Vlookup/

05-44-Index-Match-Exercise-Text.xlsx

11.9 KB

05-44-Index-Match-Solved.xlsx

12.4 KB

Excel-Functions.pdf

3.3 MB

Index-Match-Solved.xlsx

12.0 KB

Index-Match-Unsolved.xlsx

11.6 KB

/.../040 Using Excels Iferror Function to Trap Spreadsheet Errors/

05-45-IFERROR-Exercise-Text.xlsx

14.6 KB

05-45-IFERROR-Solved.xlsx

15.7 KB

Excel-Functions.pdf

3.3 MB

Iferror-Solved.xlsx

12.0 KB

Iferror-Unsolved.xlsx

11.9 KB

/.../041 Create Flexible Financial Models with Choose/

05-46-Choose-Exercise-Text.xlsx

11.6 KB

05-46-Choose-Solved.xlsx

12.0 KB

Choose-Solved.xlsx

9.9 KB

Choose-Unsolved.xlsx

9.6 KB

Excel-Functions.pdf

3.3 MB

/.../042 Goal Seek Will Help You Find the Result You Are Looking For/

05-47-Goal-Seek-Exercise-Text.xlsx

16.5 KB

05-47-Goal-Seek-Solved.xlsx

16.6 KB

Excel-Functions.pdf

3.3 MB

Goal-Seek-Solved.xlsx

9.1 KB

Goal-Seek-Unsolved.xlsx

9.1 KB

/.../043 Perform Sensitivity Analysis with Excels Data Tables Functionality/

05-48-Sensitivity-Analysis-Exercise-Text.xlsx

12.9 KB

05-48-Sensitivity-Analysis-Solved.xlsx

13.4 KB

Data-Tables-Solved.xlsx

9.7 KB

Data-Tables-Unsolved.xlsx

9.5 KB

/quizzes/

012 Key Excel Functions Average Averageif.html

2.7 KB

013 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate.html

2.8 KB

014 Index Match and Their Combination - The Perfect Substitute of Vlookup.html

2.6 KB

015 Goal Seek Will Help You Find the Result You Are Looking For.html

3.0 KB

016 Perform Sensitivity Analysis with Excels Data Tables Functionality.html

3.2 KB

017 Quiz Number 2.html

6.3 KB

/06 Microsoft Excel - Practical Exercise Build a PL From Scratch/

044 Understand Your Data Source Before You Start Working on It.mp4

29.6 MB

045 Ordering the Source Worksheet.mp4

14.4 MB

046 Create a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4

16.7 MB

047 Learn How to Create a Database.mp4

15.2 MB

048 Using Lookup Functions Vlookup to Fill the Database Sheet.mp4

39.6 MB

049 Use Sumif to Complete the Database Sheet.mp4

31.2 MB

050 Using Index Match as a Substitute of Vlookup.mp4

35.5 MB

051 Mapping of the Rows in the Database Sheet.mp4

22.5 MB

052 Building the Structure of the PL Sheet.mp4

10.6 MB

053 A Practical Example of Professional Formatting in Excel.mp4

13.7 MB

054 Populate the PL Sheet with Sumif.mp4

16.2 MB

055 Learn How to Find Mistakes with Countif.mp4

20.0 MB

056 Calculating Growth Rates in Excel.mp4

17.1 MB

/.../044 Understand Your Data Source Before You Start Working on It/

Database-Case-study-1-before-exercises.xlsm

43.3 KB

/.../045 Ordering the Source Worksheet/

4.Order-a-worksheet-Solved.xlsm

37.5 KB

4.Order-a-worksheet-Unsolved.xlsx

29.3 KB

/.../046 Create a Code The Best Way to Organize Your Data and Work Efficiently with It/

5.Creating-a-code-Solved.xlsx

34.7 KB

5.Creating-a-code-Unsolved.xlsm

33.5 KB

/.../047 Learn How to Create a Database/

6.Creating-a-database-Solved.xlsx

36.3 KB

6.Creating-a-database-Unsolved.xlsx

31.4 KB

/.../048 Using Lookup Functions Vlookup to Fill the Database Sheet/

7.Vlookup-Solved.xlsx

38.3 KB

7.Vlookup-Unsolved.xlsx

33.3 KB

/.../049 Use Sumif to Complete the Database Sheet/

8.Sumif-Solved.xlsx

48.4 KB

8.Sumif-Unsolved.xlsx

38.3 KB

/.../050 Using Index Match as a Substitute of Vlookup/

9.Index-Match-Solved.xlsx

43.9 KB

9.Index-Match-Unsolved.xlsx

39.4 KB

/.../051 Mapping of the Rows in the Database Sheet/

10.Mapping-Solved.xlsx

48.6 KB

10.Mapping-Unsolved.xlsx

40.0 KB

/.../052 Building the Structure of the PL Sheet/

11.Building-a-P-L-Solved.xlsx

55.1 KB

11.Building-a-P-L-Unsolved.xlsx

44.7 KB

/.../053 A Practical Example of Professional Formatting in Excel/

12.Formatting-the-P-L-Unsolved.xlsx

50.5 KB

12.Formatting-the-P-L-sheet-Solved.xlsx

54.8 KB

/.../054 Populate the PL Sheet with Sumif/

13.Populating-the-P-L-sheet-Solved.xlsm

60.4 KB

13.Populating-the-P-L-sheet-Unsolved.xlsx

50.4 KB

/.../055 Learn How to Find Mistakes with Countif/

14.Countif-Solved.xlsx

58.7 KB

14.Countif-Unsolved.xlsm

55.3 KB

/.../056 Calculating Growth Rates in Excel/

15.Adding-variations-Solved.xlsx

57.9 KB

15.Adding-variations-Unsolved.xlsx

52.4 KB

/quizzes/

018 Quiz Number 3.html

4.5 KB

/07 Microsoft Excel - Building Professional Charts in Excel/

057 Introduction to Excel Charts.mp4

6.9 MB

058 Beginners Guide to Inserting Charts in Excel.mp4

11.5 MB

059 Modifying Excel Charts - The Easy Way to Do It.mp4

13.7 MB

060 Make Your Excel Charts Look Sexier - Proven Tips.mp4

16.6 MB

061 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4

6.5 MB

062 New Ways to Visualize Your Data - Treemap Charts.mp4

6.0 MB

063 How to Represent Trends with Sparklines.mp4

13.3 MB

/.../058 Beginners Guide to Inserting Charts in Excel/

2.Inserting-Charts.xlsm

12.0 MB

/.../059 Modifying Excel Charts - The Easy Way to Do It/

3.Formatting-a-Chart.xlsm

12.0 MB

/.../060 Make Your Excel Charts Look Sexier - Proven Tips/

3.Formatting-a-Chart.xlsm

12.0 MB

/.../061 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets/

Bridge-Charts.xlsx

13.4 KB

/.../062 New Ways to Visualize Your Data - Treemap Charts/

Treemap-Charts.xlsx

12.9 KB

/.../063 How to Represent Trends with Sparklines/

Sparklines.xlsx

9.8 KB

/08 Microsoft Excel - Working with Pivot Tables in Excel/

064 Pivot Tables - Excels Dynamic and Interactive Tables.mp4

6.3 MB

065 Creating a Pivot Table Choosing Row and Column Parameters.mp4

20.3 MB

066 Design the Layout and Format of Your Pivot Tables.mp4

11.8 MB

067 Additional Techniques That Will Ease Your Work with Pivot Tables.mp4

24.1 MB

068 One of the Most Useful Excel Functions - GetPivotData.mp4

18.9 MB

069 Welcome to the Future - Pivot Table Slicers.mp4

23.2 MB

070 Introduction to the Course Challenge.mp4

4.3 MB

071 COURSE CHALLENGE - Part 1.mp4

8.3 MB

/.../065 Creating a Pivot Table Choosing Row and Column Parameters/

2.Creating-a-Pivot-Table.xlsx

1.5 MB

/.../066 Design the Layout and Format of Your Pivot Tables/

3.Formatting-a-Pivot-Table.xlsx

1.5 MB

/.../067 Additional Techniques That Will Ease Your Work with Pivot Tables/

4.Working-with-Pivot-Tables.xlsx

2.0 MB

/.../068 One of the Most Useful Excel Functions - GetPivotData/

5.GetPivotData.xlsx

2.0 MB

/.../069 Welcome to the Future - Pivot Table Slicers/

6.Slicers.xlsx

2.0 MB

/.../071 COURSE CHALLENGE - Part 1/

1.Course-Challenge.xlsx

517.6 KB

/09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/

072 Introduction to the Case Study.mp4

22.1 MB

073 Working with an SAP data extraction.mp4

23.0 MB

074 Preliminary mapping of the data extraction.mp4

23.7 MB

075 Creating an output structure of the FMCG model.mp4

12.2 MB

076 Improving the layout and appearance of the FMCG report.mp4

13.3 MB

077 Inserting formulas and automating calculations.mp4

9.3 MB

078 Creating a Master Pivot Table The main data source for the FMCG report.mp4

14.5 MB

079 GetPivotData is great Extracting data from the Master Pivot Table.mp4

32.5 MB

080 Combining Slicers and GetPivotData The key to our success.mp4

18.7 MB

081 Getting fancy with Excel slicers - Good-looking Excel slicers.mp4

17.9 MB

082 This is how the report can be used in practice by high-level executives.mp4

20.8 MB

/.../072 Introduction to the Case Study/

0.Exercise-Build-an-FMCG-Model-before.xlsx

13.9 MB

/.../074 Preliminary mapping of the data extraction/

1.Exercise-Build-an-FMCG-Model-Mapping.xlsx

15.6 MB

/.../075 Creating an output structure of the FMCG model/

2.Exercise-Build-an-FMCG-Model-Structure.xlsx

15.6 MB

/10 Building a complete 3-statement model/

083 Introduction to the Exercise.mp4

12.8 MB

084 Lets create a mapping of financials.mp4

11.6 MB

085 Building an output PL sheet.mp4

11.6 MB

086 Filling in the output PL sheet with historical financials.mp4

8.7 MB

087 Calculating percentage variances and applying conditional formatting.mp4

9.0 MB

088 Building an output Balance sheet.mp4

11.1 MB

089 Using Index Match Match to fill in the output Balance sheet.mp4

15.1 MB

090 Adding the forecast period.mp4

11.3 MB

/.../083 Introduction to the Exercise/

1.1-after.xlsx

33.5 KB

1.1-before.xlsx

19.2 KB

Financial-Modeling-Notes.pdf

706.6 KB

/.../084 Lets create a mapping of financials/

1.2-after.xlsx

35.1 KB

1.2-before.xlsx

31.2 KB

/.../085 Building an output PL sheet/

1.3-after.xlsx

42.5 KB

1.3-before.xlsx

33.1 KB

/.../086 Filling in the output PL sheet with historical financials/

1.4-after.xlsx

42.2 KB

1.4-before.xlsx

38.5 KB

/.../087 Calculating percentage variances and applying conditional formatting/

1.5-after.xlsx

42.7 KB

1.5-before.xlsx

40.2 KB

/.../088 Building an output Balance sheet/

1.6-after.xlsx

55.7 KB

1.6-before.xlsx

48.6 KB

/.../089 Using Index Match Match to fill in the output Balance sheet/

1.7-after.xlsx

58.5 KB

1.7-before.xlsx

51.0 KB

/.../090 Adding the forecast period/

1.8-after.xlsx

56.3 KB

1.8-before.xlsx

51.5 KB

/11 Lets build a flexible model with multiple scenarios/

091 Calculating historical percentage ratios and use Index and Match for scenarios.mp4

16.0 MB

092 Building a flexible model with Choose Match.mp4

4.5 MB

093 Building a flexible model with Vlookup Columns.mp4

11.2 MB

094 Calculating historical DSO DPO DIO Other assets and Other liabilities.mp4

15.4 MB

095 Forecasting DSO DPO DIO Other assets and Other liabilities.mp4

9.5 MB

/.../091 Calculating historical percentage ratios and use Index and Match for scenarios/

1.9-after.xlsx

56.3 KB

1.9-before.xlsx

54.1 KB

/.../092 Building a flexible model with Choose Match/

1.10-after.xlsx

56.0 KB

1.10-before.xlsx

54.4 KB

/.../093 Building a flexible model with Vlookup Columns/

1.11-after.xlsx

56.4 KB

1.11-before.xlsx

54.4 KB

/.../094 Calculating historical DSO DPO DIO Other assets and Other liabilities/

1.12-after.xlsx

58.0 KB

1.12-before.xlsx

54.8 KB

/.../095 Forecasting DSO DPO DIO Other assets and Other liabilities/

1.13-after.xlsx

59.1 KB

1.13-before.xlsx

56.0 KB

/12 We are almost there Completing the 3-statement model/

096 Building a Fixed asset roll forward.mp4

15.0 MB

097 Building a Financial liabilities schedule.mp4

17.5 MB

098 Building an Equity schedule.mp4

13.7 MB

099 Preparing a Cash flow structure.mp4

6.5 MB

100 Calculating Cash flows and completing the model.mp4

21.1 MB

/.../096 Building a Fixed asset roll forward/

1.14-after.xlsx

63.6 KB

1.14-before.xlsx

57.1 KB

/.../097 Building a Financial liabilities schedule/

1.15-after.xlsx

69.2 KB

1.15-before.xlsx

60.3 KB

/.../098 Building an Equity schedule/

1.16-after.xlsx

71.2 KB

1.16-before.xlsx

60.3 KB

/.../099 Preparing a Cash flow structure/

1.17-after.xlsx

72.0 KB

1.17-before.xlsx

67.2 KB

/.../100 Calculating Cash flows and completing the model/

1.18-after.xlsx

74.3 KB

1.18-before.xlsx

69.3 KB

/13 Accounting - Introduction to Accounting Bookkeeping/

101 Accounting The Science Behind Financial Figures.mp4

28.4 MB

102 What is Accounting and Why Do You Need It.mp4

20.7 MB

103 The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4

11.5 MB

104 An Introduction to Financial Accounting.mp4

14.0 MB

/.../101 Accounting The Science Behind Financial Figures/

Introduction-to-Accounting-Notes.pdf

1.2 MB

/.../102 What is Accounting and Why Do You Need It/

Accounting-Financial-Statement-Analysis-Notes.pdf

1.2 MB

/.../104 An Introduction to Financial Accounting/

Accounting-Financial-Statement-Analysis-Notes.pdf

1.2 MB

/quizzes/

019 Quiz Number 3.html

3.4 KB

/14 Accounting - The Three Main Statements in Financial Accounting/

105 The Three Core Financial Statements PL Balance Sheet and Cash Flow.mp4

10.2 MB

106 The Key Accounts You Will Find in a PL.mp4

28.5 MB

107 The Main Balance Sheet Items.mp4

19.5 MB

/.../107 The Main Balance Sheet Items/

5.Balance-Sheet-items.mp4

29.3 MB

/quizzes/

020 Quiz Number 4.html

4.4 KB

/15 Accounting - Understanding the Big Picture Why What When and How Much/

108 The Revenue Recognition Principle - Why Is it so Important.mp4

9.3 MB

109 The Expense Recognition Principle - When to Recognize Expenses.mp4

10.4 MB

110 Historical Cost vs. Fair Value Accounting.mp4

7.9 MB

/16 Accounting - The Core Principles of Accounting/

111 The Accounting Equation and Its Importance.mp4

11.2 MB

112 Elements of the Accounting System General Ledger.mp4

7.9 MB

113 T-Accounts The Best Way to Understand Debits and Credits.mp4

10.4 MB

114 PL T-Accounts.mp4

7.1 MB

115 How to Calculate Depreciation Expense.mp4

14.6 MB

116 The Double-Entry Principle - The Core Principle of Bookkeeping.mp4

10.6 MB

/.../112 Elements of the Accounting System General Ledger/

General-Ledgers.mp4

12.0 MB

/quizzes/

021 Quiz Number 5.html

5.4 KB

/17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/

117 Case Study - The Accounting Transactions of a Lemonade Stand 14.mp4

31.7 MB

118 Case Study - The Accounting Transactions of a Lemonade Stand 24.mp4

22.8 MB

119 Case Study - The Accounting Transactions of a Lemonade Stand 34.mp4

17.9 MB

120 Case Study - The Accounting Transactions of a Lemonade Stand 44.mp4

28.7 MB

/.../117 Case Study - The Accounting Transactions of a Lemonade Stand 14/

Exercise-Part-One.xlsx

17.9 KB

/.../118 Case Study - The Accounting Transactions of a Lemonade Stand 24/

Exercise-Part-Two.xlsx

20.6 KB

/.../119 Case Study - The Accounting Transactions of a Lemonade Stand 34/

Exercise-Part-Three.xlsx

19.8 KB

/.../120 Case Study - The Accounting Transactions of a Lemonade Stand 44/

Exercise-Part-Four.xlsx

21.2 KB

/18 Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/

121 Calculating Cash Flows - Understand if a business makes or burns cash.mp4

10.8 MB

122 The three parts of Cash Flow statements explained.mp4

7.6 MB

123 Cash Flow computations - The Direct method.mp4

7.7 MB

124 Cash Flow computations - The Indirect method.mp4

12.8 MB

125 Calculating Cash Flow in practice A complete example.mp4

21.1 MB

/.../125 Calculating Cash Flow in practice A complete example/

Cash-Flow.xlsx

56.7 KB

/19 Accounting - The Importance of Timing/

126 Timing of Cash Flows and Why It Plays an Important Role for a Business.mp4

5.3 MB

127 Timing of Income Principles of Revenue Recognition.mp4

13.3 MB

128 Timing of Expenses Principles of Cost Recognition.mp4

7.9 MB

129 The Four Type of Accruals Arising in Accounting Transactions.mp4

19.6 MB

/quizzes/

022 Quiz Number 6.html

4.6 KB

/20 Accounting - Introduction to Financial Statement Analysis/

130 What is a 10-K Report and Why Is It important for Investors.mp4

11.7 MB

131 Finding Downloading and Going Through the Annual Report of PG.mp4

55.3 MB

132 What is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4

10.4 MB

133 Indispensable Tools for Financial Statement Analysis.mp4

7.3 MB

/.../131 Finding Downloading and Going Through the Annual Report of PG/

P-G-Financial-Report.pdf

4.6 MB

/quizzes/

023 Quiz Number 7.html

3.5 KB

/21 Accounting - Subtleties of Financial Statement Analysis/

134 Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4

8.7 MB

135 First Steps in Financial Statement Analysis.mp4

13.1 MB

136 Horizontal vs. Vertical Financial Statement Analysis.mp4

15.8 MB

137 Calculating Days Payable DPO Days Receivable DSO and Days Inventory DIO.mp4

4.7 MB

138 Using Accounting Ratios to Assess Business Performance.mp4

19.9 MB

/.../137 Calculating Days Payable DPO Days Receivable DSO and Days Inventory DIO/

Working-Capital-Days.pdf

349.0 KB

/quizzes/

024 Quiz Number 8.html

3.4 KB

/22 Accounting - Practical Case Study Analyzing PGs Financials/

139 Case Study - Calculating Ratios and Analyzing PGs Financials 12.mp4

29.0 MB

140 Case Study - Calculating Ratios and Analyzing PGs Financials 22.mp4

19.7 MB

141 COURSE CHALLENGE - Part 2.mp4

10.2 MB

/.../139 Case Study - Calculating Ratios and Analyzing PGs Financials 12/

P-G-Financial-Report.pdf

4.6 MB

P-G-Financials-Before.xlsx

13.1 KB

P-G-Financials-WithRatios.xlsx

14.3 KB

P-G-Financials.xlsx

14.6 KB

/.../140 Case Study - Calculating Ratios and Analyzing PGs Financials 22/

P-G-Financial-Report.pdf

4.6 MB

P-G-Financials-Before.xlsx

13.1 KB

P-G-Financials-WithRatios.xlsx

14.3 KB

P-G-Financials.xlsx

14.6 KB

/.../141 COURSE CHALLENGE - Part 2/

2.Course-Challenge.xlsx

641.6 KB

/23 Fundamentals of Business Financial Analysis/

142 Fundamentals of Business Financial Analysis.pdf

8.6 MB

/.../142 Fundamentals of Business Financial Analysis/

Fundamentals-of-Business-Financial-Analysis.pdf

8.6 MB

/24 Finance 101 - The Time Value of Money and Interest Rate Components/

143 Finance 101 Important Financial Principles That You Will Need.mp4

15.6 MB

144 Understanding the Time Value of Money.mp4

3.5 MB

145 Why Interest Rates Play an Important Role in the Economy.mp4

6.6 MB

146 The Components Forming Interest Rates in Real Life.mp4

9.4 MB

147 What Is Libor and What Does It Serve For.mp4

9.6 MB

148 The Difference Between Fixed and Variable Interest Rates.mp4

7.7 MB

149 What Is Default Risk and How Does a Bank Account For It.mp4

16.4 MB

150 Corporate Loan Specifics.mp4

13.2 MB

/.../144 Understanding the Time Value of Money/

Finance-101-Introduction-to-the-World-of-Finance.pdf

706.3 KB

Time-value-of-money.pdf

795.9 KB

/.../146 The Components Forming Interest Rates in Real Life/

Finance-101-Introduction-to-the-World-of-Finance.pdf

706.3 KB

Interest-rate-components.pdf

826.9 KB

/.../147 What Is Libor and What Does It Serve For/

Finance-101-Introduction-to-the-World-of-Finance.pdf

706.3 KB

/.../149 What Is Default Risk and How Does a Bank Account For It/

Default-risk.pdf

902.0 KB

/.../150 Corporate Loan Specifics/

Finance-101-Introduction-to-the-World-of-Finance.pdf

706.3 KB

/25 Finance 101 - The Value of Cash Flows with Different Timing/

151 Calculating the Present Value of Future Cash Flows.mp4

14.3 MB

152 A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4

12.9 MB

/.../151 Calculating the Present Value of Future Cash Flows/

1.Calculating-Future-Cash-Flows.pdf

829.7 KB

3.1-Present-Value-of-Cash-Flows.xlsx

10.1 KB

/.../152 A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value/

2.NPV.pdf

196.8 KB

/26 Loan Calculations/

153 Using Annuities.mp4

9.1 MB

154 Calculating a Complete Loan Schedule.mp4

17.8 MB

155 COURSE CHALLENGE - Part 3.mp4

8.0 MB

/.../155 COURSE CHALLENGE - Part 3/

3.Course-Challenge.xlsx

550.6 KB

/27 PowerPoint - Introduction to PowerPoint/

156 Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4

17.6 MB

157 The Structure of the PowerPoint Ribbon.mp4

17.1 MB

158 General Considerations About Slide Structure.mp4

11.9 MB

159 Learn How to Insert Objects in PowerPoint.mp4

14.0 MB

160 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4

7.9 MB

161 Add Frequently Used Buttons to the Quick Access Toolbar.mp4

10.9 MB

162 How to Easily Align Objects in PowerPoint.mp4

9.9 MB

163 Editing Shapes in Your Presentation - The Format Shape Menu.mp4

14.2 MB

164 How to Format Text Boxes in a PowerPoint Presentation.mp4

9.5 MB

165 Changing an Objects Size and Learning About Rotation Options.mp4

4.5 MB

166 Work Efficiently By Using Slide Masters.mp4

14.7 MB

/.../157 The Structure of the PowerPoint Ribbon/

Introduction-to-PowerPoint.pdf

2.7 MB

/.../158 General Considerations About Slide Structure/

Introduction-to-PowerPoint.pdf

2.7 MB

/.../159 Learn How to Insert Objects in PowerPoint/

Introduction-to-PowerPoint.pdf

2.7 MB

Useful-maps-and-Shapes.pptx

3.2 MB

/.../160 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint/

Introduction-to-PowerPoint.pdf

2.7 MB

PowerPoint-Master-Class-Shortcuts.pdf

768.3 KB

/.../161 Add Frequently Used Buttons to the Quick Access Toolbar/

Introduction-to-PowerPoint.pdf

2.7 MB

/.../162 How to Easily Align Objects in PowerPoint/

Introduction-to-PowerPoint.pdf

2.7 MB

/.../163 Editing Shapes in Your Presentation - The Format Shape Menu/

Introduction-to-PowerPoint.pdf

2.7 MB

/.../164 How to Format Text Boxes in a PowerPoint Presentation/

Introduction-to-PowerPoint.pdf

2.7 MB

/.../165 Changing an Objects Size and Learning About Rotation Options/

Introduction-to-PowerPoint.pdf

2.7 MB

/.../166 Work Efficiently By Using Slide Masters/

Introduction-to-PowerPoint.pdf

2.7 MB

/28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/

167 Modifying the Beginning and Ending of a Line Object.mp4

6.8 MB

168 Join Shapes Together By Using Connector Lines.mp4

8.9 MB

169 Group or Ungroup Shapes Pircutres or Other Objects.mp4

4.3 MB

170 This is How You Can Fit Text When It Is Larger than a Shape.mp4

6.4 MB

171 PowerPoints Smart Art Feature Offers Great Return for Your Time.mp4

9.4 MB

172 Creating Eye-Catching Text Effects in PowerPoint.mp4

6.8 MB

173 Practical Exercise - Creating an Organisational Chart.mp4

23.8 MB

174 COURSE CHALLENGE - Part 4.mp4

13.4 MB

/.../174 COURSE CHALLENGE - Part 4/

4.Course-Challenge-Tasks.pdf

289.8 KB

4.Course-Challenge.pptx

1.2 MB

/

Freetutorials.us.url

0.1 KB

[FreeTutorials.us].txt

0.1 KB

 

Total files 491


Copyright © 2025 FileMood.com