Download link
File List
-
文件过大导致无法格式化,将以元数据展示。
[{"path": "01 Welcome Course Introduction/001 What Does the Course Cover.mp4", "length": 11059901}, {"path": "01 Welcome Course Introduction/002 Everything We Will Learn Has a Practical Application.mp4", "length": 10708225}, {"path": "01 Welcome Course Introduction/003 The Best Way to Take This Course.mp4", "length": 9275867}, {"path": "01 Welcome Course Introduction/attached_files/002 Everything We Will Learn Has a Practical Application/Quick-win.xlsx", "length": 9972}, {"path": "01 Welcome Course Introduction/attached_files/003 The Best Way to Take This Course/The-Best-way-to-take-it-new.mov", "length": 10927267}, {"path": "02 Microsoft Excel - Quick Introduction/004 Microsoft Excel The Worlds 1 Software for the Office.mp4", "length": 20449348}, {"path": "02 Microsoft Excel - Quick Introduction/005 Excel Made Easy A Beginners Guide to Excel Spreadsheets.mp4", "length": 8486221}, {"path": "02 Microsoft Excel - Quick Introduction/006 Data Entry Techniques in Excel.mp4", "length": 7356976}, {"path": "02 Microsoft Excel - Quick Introduction/007 How to Make Your Spreadsheets Look Professional.mp4", "length": 15413317}, {"path": "02 Microsoft Excel - Quick Introduction/008 Inserting Deleting and Modifying Rows Columns.mp4", "length": 4279680}, {"path": "02 Microsoft Excel - Quick Introduction/009 Excel Formulas for Beginners.mp4", "length": 5696499}, {"path": "02 Microsoft Excel - Quick Introduction/010 A Beginners Introduction to Excel Functions.mp4", "length": 7778188}, {"path": "02 Microsoft Excel - Quick Introduction/011 Work Efficiently by Using Cut Copy and Paste.mp4", "length": 5903662}, {"path": "02 Microsoft Excel - Quick Introduction/012 Pasting Values Formulas and Formats with Paste Special.mp4", "length": 5888169}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/004 Microsoft Excel The Worlds 1 Software for the Office/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/005 Excel Made Easy A Beginners Guide to Excel Spreadsheets/02-6-Overview-of-Excel-Exercise-Text.xlsx", "length": 10718}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/005 Excel Made Easy A Beginners Guide to Excel Spreadsheets/02-6-Overview-of-Excel-Solved.xlsx", "length": 11141}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/005 Excel Made Easy A Beginners Guide to Excel Spreadsheets/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/006 Data Entry Techniques in Excel/02-9-Data-Entry-Exercise-Text.xlsx", "length": 11233}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/006 Data Entry Techniques in Excel/02-9-Data-Entry-Solved.xlsx", "length": 33547}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/006 Data Entry Techniques in Excel/Data-Entry.xlsx", "length": 8261}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/006 Data Entry Techniques in Excel/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/007 How to Make Your Spreadsheets Look Professional/02-10-Formatting-Exercise-Text.xlsx", "length": 11888}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/007 How to Make Your Spreadsheets Look Professional/02-10-Formatting-Solved.xlsx", "length": 11872}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/007 How to Make Your Spreadsheets Look Professional/Formatting-Solved.xlsx", "length": 10082}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/007 How to Make Your Spreadsheets Look Professional/Formatting-Unsolved.xlsx", "length": 9119}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/007 How to Make Your Spreadsheets Look Professional/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/008 Inserting Deleting and Modifying Rows Columns/02-7-Basic-Manipulations-Exercise-Text.xlsx", "length": 11324}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/008 Inserting Deleting and Modifying Rows Columns/02-7-Basic-Manipulations-Solved.xlsx", "length": 33209}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/008 Inserting Deleting and Modifying Rows Columns/Data-Entry.xlsx", "length": 8261}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/008 Inserting Deleting and Modifying Rows Columns/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/009 Excel Formulas for Beginners/02-11-Formulas-Exercise-Text.xlsx", "length": 11998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/009 Excel Formulas for Beginners/02-11-Formulas-Solved.xlsx", "length": 82054}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/009 Excel Formulas for Beginners/Formulas-Solved.xlsx", "length": 9588}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/009 Excel Formulas for Beginners/Formulas-Unsolved.xlsx", "length": 9524}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/009 Excel Formulas for Beginners/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/010 A Beginners Introduction to Excel Functions/02-12-Functions-Exercise-Text.xlsx", "length": 13582}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/010 A Beginners Introduction to Excel Functions/02-12-Functions-Solved.xlsx", "length": 83046}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/010 A Beginners Introduction to Excel Functions/Functions-Solved.xlsx", "length": 9563}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/010 A Beginners Introduction to Excel Functions/Functions-Unsolved.xlsx", "length": 9462}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/010 A Beginners Introduction to Excel Functions/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/011 Work Efficiently by Using Cut Copy and Paste/02-13-Copy-Cut-Paste-Exercise-Text.xlsx", "length": 11615}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/011 Work Efficiently by Using Cut Copy and Paste/02-13-Copy-Cut-Paste-Solved.xlsx", "length": 12864}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/011 Work Efficiently by Using Cut Copy and Paste/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/012 Pasting Values Formulas and Formats with Paste Special/02-14-Paste-Special-Exercise-Text.xlsx", "length": 13798}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/012 Pasting Values Formulas and Formats with Paste Special/02-14-Paste-Special-Solved.xlsx", "length": 13778}, {"path": "02 Microsoft Excel - Quick Introduction/attached_files/012 Pasting Values Formulas and Formats with Paste Special/Introduction-to-Excels-basic-features.pdf", "length": 2364998}, {"path": "02 Microsoft Excel - Quick Introduction/quizzes/001 Data Entry Techniques in Excel.html", "length": 2501}, {"path": "02 Microsoft Excel - Quick Introduction/quizzes/002 Inserting Deleting and Modifying Rows Columns.html", "length": 3067}, {"path": "02 Microsoft Excel - Quick Introduction/quizzes/003 Excel Formulas for Beginners.html", "length": 2636}, {"path": "02 Microsoft Excel - Quick Introduction/quizzes/004 Work Efficiently by Using Cut Copy and Paste.html", "length": 2898}, {"path": "03 Microsoft Excel - Useful Tools/013 Inserting a Line Break with Alt Enter.mp4", "length": 3628052}, {"path": "03 Microsoft Excel - Useful Tools/014 Do More with Your Sales Data with Excels Text to Columns Feature.mp4", "length": 4396405}, {"path": "03 Microsoft Excel - Useful Tools/015 Create Easily Printable Excel Documents.mp4", "length": 3559873}, {"path": "03 Microsoft Excel - Useful Tools/016 How to Wrap Text in Excel and Adjust a Cells Size.mp4", "length": 1493229}, {"path": "03 Microsoft Excel - Useful Tools/017 Insert Hyperlinks in Excel Spreadsheets.mp4", "length": 3258567}, {"path": "03 Microsoft Excel - Useful Tools/018 Using Excels Freeze Panes to Handle Large Datasets.mp4", "length": 5992127}, {"path": "03 Microsoft Excel - Useful Tools/019 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4", "length": 5695895}, {"path": "03 Microsoft Excel - Useful Tools/020 A Quick Introduction to Excels Pivot Tables.mp4", "length": 14079068}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/013 Inserting a Line Break with Alt Enter/03-20-Alt-Enter-Exercise-Text.xlsx", "length": 11391}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/013 Inserting a Line Break with Alt Enter/03-20-Alt-Enter-Solved.xlsx", "length": 11669}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/013 Inserting a Line Break with Alt Enter/Alt-Enter-Solved.xlsx", "length": 9881}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/013 Inserting a Line Break with Alt Enter/Alt-Enter-Unsolved.xlsx", "length": 9870}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/013 Inserting a Line Break with Alt Enter/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/014 Do More with Your Sales Data with Excels Text to Columns Feature/03-21-Text-to-Columns-Exercise-Text.xlsx", "length": 10820}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/014 Do More with Your Sales Data with Excels Text to Columns Feature/03-21-Text-to-Columns-Solved.xlsx", "length": 11573}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/014 Do More with Your Sales Data with Excels Text to Columns Feature/Text-to-columns-Solved.xlsx", "length": 10137}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/014 Do More with Your Sales Data with Excels Text to Columns Feature/Text-to-columns-Unsolved.xlsx", "length": 9999}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/014 Do More with Your Sales Data with Excels Text to Columns Feature/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/015 Create Easily Printable Excel Documents/Set-Print-Area-Solved.xlsx", "length": 11493}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/015 Create Easily Printable Excel Documents/Set-Print-Area-Unsolved.xlsx", "length": 11690}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/015 Create Easily Printable Excel Documents/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/016 How to Wrap Text in Excel and Adjust a Cells Size/03-22-Wrap-Text-Exercise-Text.xlsx", "length": 10416}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/016 How to Wrap Text in Excel and Adjust a Cells Size/03-22-Wrap-Text-Solved.xlsx", "length": 10446}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/016 How to Wrap Text in Excel and Adjust a Cells Size/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/016 How to Wrap Text in Excel and Adjust a Cells Size/Wrap-text-Solved.xlsx", "length": 9843}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/016 How to Wrap Text in Excel and Adjust a Cells Size/Wrap-text-Unsolved.xlsx", "length": 9845}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/017 Insert Hyperlinks in Excel Spreadsheets/03-31-Hyperlinks-Exercise-Text.xlsx", "length": 140176}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/017 Insert Hyperlinks in Excel Spreadsheets/03-31-Hyperlinks-Solved.xlsx", "length": 140351}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/017 Insert Hyperlinks in Excel Spreadsheets/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/018 Using Excels Freeze Panes to Handle Large Datasets/Freeze-Panes-Solved.xlsx", "length": 659397}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/018 Using Excels Freeze Panes to Handle Large Datasets/Freeze-Panes-Unsolved.xlsx", "length": 659323}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/018 Using Excels Freeze Panes to Handle Large Datasets/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/019 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/020 A Quick Introduction to Excels Pivot Tables/Pivot-Table-solved.xlsm", "length": 875392}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/020 A Quick Introduction to Excels Pivot Tables/Pivot-Table-unsolved.xlsm", "length": 662018}, {"path": "03 Microsoft Excel - Useful Tools/attached_files/020 A Quick Introduction to Excels Pivot Tables/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "03 Microsoft Excel - Useful Tools/quizzes/005 Do More with Your Sales Data with Excels Text to Columns Feature.html", "length": 2649}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/021 Initial Formatting Is Key for Creating Professional - Looking Spreadsheets.mp4", "length": 7853465}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/022 Macros Are a Great Timesaver Heres Why..mp4", "length": 10404244}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/023 The Secret to Faster Scrolling in Excel.mp4", "length": 7598190}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/024 Using Absolute and Relative Cell References.mp4", "length": 15847812}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/025 Find and Select Cells That Meet Specific Conditions.mp4", "length": 4141374}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/026 How to Create Dynamic Names in Excel Spreadsheets.mp4", "length": 5460875}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/027 Using Named Ranges to Make Formulas More Readable.mp4", "length": 3415629}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/028 Custom Number Formatting.mp4", "length": 3594788}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/029 How to Add a Drop-down List in Excel.mp4", "length": 4695174}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/030 Using Custom-sort to Sort Multiple Columns Within a Table.mp4", "length": 7499547}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4", "length": 13957696}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/021 Initial Formatting Is Key for Creating Professional - Looking Spreadsheets/Formatting-a-worksheet-Solved.xlsx", "length": 9786}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/021 Initial Formatting Is Key for Creating Professional - Looking Spreadsheets/Formatting-a-worksheet-Unsolved.xlsx", "length": 9191}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/021 Initial Formatting Is Key for Creating Professional - Looking Spreadsheets/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/022 Macros Are a Great Timesaver Heres Why/03-28-Macros-Exercise-Text.xlsx", "length": 10589}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/022 Macros Are a Great Timesaver Heres Why/03-28-Macros-Solved.xlsx", "length": 148501}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/022 Macros Are a Great Timesaver Heres Why/Creating-a-Macro-Solved.xlsx", "length": 11435}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/022 Macros Are a Great Timesaver Heres Why/Creating-a-Macro-Unsolved.xlsx", "length": 9890}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/022 Macros Are a Great Timesaver Heres Why/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/023 The Secret to Faster Scrolling in Excel/03-18-Fast-Scrolling-Exercise-Text.xlsx", "length": 44958}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/023 The Secret to Faster Scrolling in Excel/03-18-Fast-Scrolling-Solved.xlsx", "length": 45415}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/023 The Secret to Faster Scrolling in Excel/Fast-scrolling-Solved.xlsx", "length": 10255}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/023 The Secret to Faster Scrolling in Excel/Fast-scrolling-Unsolved.xlsx", "length": 10302}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/023 The Secret to Faster Scrolling in Excel/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/024 Using Absolute and Relative Cell References/03-19-Fixing-Cells-Exercise-Text.xlsx", "length": 10928}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/024 Using Absolute and Relative Cell References/03-19-Fixing-Cells-Solved.xlsx", "length": 11078}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/024 Using Absolute and Relative Cell References/Fixing-references-Solved.xlsx", "length": 660654}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/024 Using Absolute and Relative Cell References/Fixing-references-Unsolved.xlsx", "length": 659431}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/024 Using Absolute and Relative Cell References/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/025 Find and Select Cells That Meet Specific Conditions/03-24-Select-Special-F5-Exercise-Text.xlsx", "length": 22108}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/025 Find and Select Cells That Meet Specific Conditions/03-24-Select-Special-F5-Solved.xlsx", "length": 22801}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/025 Find and Select Cells That Meet Specific Conditions/Select-Special.xlsx", "length": 10818}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/025 Find and Select Cells That Meet Specific Conditions/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/026 How to Create Dynamic Names in Excel Spreadsheets/03-25-Assigning-Dynamic-Names-Exercise-Text.xlsx", "length": 11496}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/026 How to Create Dynamic Names in Excel Spreadsheets/03-25-Assigning-Dynamic-Names-Solved.xlsx", "length": 12013}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/026 How to Create Dynamic Names in Excel Spreadsheets/Dynamic-Naming-Solved.xlsx", "length": 14161}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/026 How to Create Dynamic Names in Excel Spreadsheets/Dynamic-Naming-Unsolved.xlsx", "length": 13868}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/026 How to Create Dynamic Names in Excel Spreadsheets/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/027 Using Named Ranges to Make Formulas More Readable/03-26-Defining-a-Named-Range-Exercise-Text.xlsx", "length": 11339}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/027 Using Named Ranges to Make Formulas More Readable/03-26-Defining-a-Named-Range-Solved.xlsx", "length": 11931}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/027 Using Named Ranges to Make Formulas More Readable/Naming-ranges-Solved.xlsx", "length": 10586}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/027 Using Named Ranges to Make Formulas More Readable/Naming-ranges-Unsolved.xlsx", "length": 8996}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/027 Using Named Ranges to Make Formulas More Readable/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/028 Custom Number Formatting/03-27-Assigning-Custom-Formats-Exercise-Text.xlsx", "length": 11624}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/028 Custom Number Formatting/03-27-Assigning-Custom-Formats-Solved.xlsx", "length": 11341}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/028 Custom Number Formatting/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/029 How to Add a Drop-down List in Excel/03-29-Drop-down-List-Exercise-Text.xlsx", "length": 11608}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/029 How to Add a Drop-down List in Excel/03-29-Drop-down-List-Solved.xlsx", "length": 78867}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/029 How to Add a Drop-down List in Excel/Data-Validation-Solved.xlsx", "length": 11102}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/029 How to Add a Drop-down List in Excel/Data-Validation-Unsolved.xlsx", "length": 11098}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/029 How to Add a Drop-down List in Excel/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/030 Using Custom-sort to Sort Multiple Columns Within a Table/03-30-Custom-Sort-Exercise-Text.xlsx", "length": 11647}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/030 Using Custom-sort to Sort Multiple Columns Within a Table/03-30-Custom-Sort-Solved.xlsx", "length": 11737}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/030 Using Custom-sort to Sort Multiple Columns Within a Table/Sort-data-Solved.xlsx", "length": 149142}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/030 Using Custom-sort to Sort Multiple Columns Within a Table/Sort-data-Unsolved.xlsx", "length": 148836}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/030 Using Custom-sort to Sort Multiple Columns Within a Table/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts/Microsoft-Excel-Keyboard-Shortcuts.pdf", "length": 1322039}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts/Useful-Tips-Tools.pdf", "length": 3464951}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/attached_files/031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts/Useful-tips-and-tools-Excel-file.xlsx", "length": 2346438}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/quizzes/006 Macros Are a Great Timesaver Heres Why..html", "length": 2790}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/quizzes/007 The Secret to Faster Scrolling in Excel.html", "length": 2837}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/quizzes/008 Using Absolute and Relative Cell References.html", "length": 2901}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/quizzes/009 Find and Select Cells That Meet Specific Conditions.html", "length": 2778}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/quizzes/010 How to Create Dynamic Names in Excel Spreadsheets.html", "length": 2937}, {"path": "04 Microsoft Excel - Best Practices That Will Make a Difference/quizzes/011 Quiz Number 1.html", "length": 6139}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/032 Key Excel Functions Sum Sumif Sumifs.mp4", "length": 11161756}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/033 Key Excel Functions Count Counta Countif Countifs.mp4", "length": 15502704}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/034 Key Excel Functions Average Averageif.mp4", "length": 7957014}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate.mp4", "length": 17599675}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/036 Find the Highest and the Lowest Values in a Range Max Min.mp4", "length": 5689702}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/037 Use Round in Your Financial Models.mp4", "length": 2563397}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/038 Excels Lookup Functions Vlookup Hlookup Made Easy.mp4", "length": 20181298}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/039 Index Match and Their Combination - The Perfect Substitute of Vlookup.mp4", "length": 33033714}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/040 Using Excels Iferror Function to Trap Spreadsheet Errors.mp4", "length": 5941272}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/041 Create Flexible Financial Models with Choose.mp4", "length": 10241545}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/042 Goal Seek Will Help You Find the Result You Are Looking For.mp4", "length": 8017962}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/043 Perform Sensitivity Analysis with Excels Data Tables Functionality.mp4", "length": 13445525}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/032 Key Excel Functions Sum Sumif Sumifs/05-37-Sum-Sumif-Sumifs-Exercise-Text.xlsx", "length": 14810}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/032 Key Excel Functions Sum Sumif Sumifs/05-37-Sum-Sumif-Sumifs-Solved.xlsx", "length": 15196}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/032 Key Excel Functions Sum Sumif Sumifs/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/032 Key Excel Functions Sum Sumif Sumifs/Sum-Sumif-Sumifs-Solved.xlsx", "length": 13322}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/032 Key Excel Functions Sum Sumif Sumifs/Sum-Sumif-Sumifs-Unsolved.xlsx", "length": 13243}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/033 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Exercise-Text.xlsx", "length": 15626}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/033 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Solved.xlsx", "length": 16053}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/033 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Unsolved.xlsx", "length": 11561}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/033 Key Excel Functions Count Counta Countif Countifs/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/034 Key Excel Functions Average Averageif/05-39-Average-AverageIF-Exercise-Text.xlsx", "length": 14950}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/034 Key Excel Functions Average Averageif/05-39-Average-AverageIF-Solution.xlsx", "length": 15382}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/034 Key Excel Functions Average Averageif/Average-Averageif-Solved.xlsx", "length": 9628}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/034 Key Excel Functions Average Averageif/Average-Averageif-Unsolved.xlsx", "length": 9242}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/034 Key Excel Functions Average Averageif/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate/05-40-2-Left-Right-etc-Exercise-Text.xlsx", "length": 11989}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate/05-40-2-Left-Right-etc-Solved.xlsx", "length": 12538}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate/Text-Functions-Solved.xlsx", "length": 11371}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate/Text-Functions-Unsolved.xlsx", "length": 10855}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/036 Find the Highest and the Lowest Values in a Range Max Min/05-41-MIN-MAX-Exercise-Text.xlsx", "length": 14737}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/036 Find the Highest and the Lowest Values in a Range Max Min/05-41-MIN-MAX-Solved.xlsx", "length": 15158}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/036 Find the Highest and the Lowest Values in a Range Max Min/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/036 Find the Highest and the Lowest Values in a Range Max Min/Max-min-Solved.xlsx", "length": 9447}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/036 Find the Highest and the Lowest Values in a Range Max Min/Max-min-Unsolved.xlsx", "length": 9161}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/037 Use Round in Your Financial Models/05-42-Round-Exercise-Text.xlsx", "length": 11615}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/037 Use Round in Your Financial Models/05-42-Round-Solved.xlsx", "length": 11993}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/037 Use Round in Your Financial Models/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/037 Use Round in Your Financial Models/Excel-functions.xlsx", "length": 994325}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/038 Excels Lookup Functions Vlookup Hlookup Made Easy/05-43-Vlookup-Hlookup-Exercise-Text.xlsx", "length": 12235}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/038 Excels Lookup Functions Vlookup Hlookup Made Easy/05-43-Vlookup-Hlookup-Solved.xlsx", "length": 14009}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/038 Excels Lookup Functions Vlookup Hlookup Made Easy/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/038 Excels Lookup Functions Vlookup Hlookup Made Easy/Vlookup-Hlookup-Solved.xlsx", "length": 11395}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/038 Excels Lookup Functions Vlookup Hlookup Made Easy/Vlookup-Hlookup-Unsolved.xlsx", "length": 10997}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/039 Index Match and Their Combination - The Perfect Substitute of Vlookup/05-44-Index-Match-Exercise-Text.xlsx", "length": 11868}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/039 Index Match and Their Combination - The Perfect Substitute of Vlookup/05-44-Index-Match-Solved.xlsx", "length": 12374}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/039 Index Match and Their Combination - The Perfect Substitute of Vlookup/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/039 Index Match and Their Combination - The Perfect Substitute of Vlookup/Index-Match-Solved.xlsx", "length": 11976}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/039 Index Match and Their Combination - The Perfect Substitute of Vlookup/Index-Match-Unsolved.xlsx", "length": 11566}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/040 Using Excels Iferror Function to Trap Spreadsheet Errors/05-45-IFERROR-Exercise-Text.xlsx", "length": 14605}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/040 Using Excels Iferror Function to Trap Spreadsheet Errors/05-45-IFERROR-Solved.xlsx", "length": 15735}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/040 Using Excels Iferror Function to Trap Spreadsheet Errors/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/040 Using Excels Iferror Function to Trap Spreadsheet Errors/Iferror-Solved.xlsx", "length": 11967}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/040 Using Excels Iferror Function to Trap Spreadsheet Errors/Iferror-Unsolved.xlsx", "length": 11925}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/041 Create Flexible Financial Models with Choose/05-46-Choose-Exercise-Text.xlsx", "length": 11587}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/041 Create Flexible Financial Models with Choose/05-46-Choose-Solved.xlsx", "length": 12010}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/041 Create Flexible Financial Models with Choose/Choose-Solved.xlsx", "length": 9927}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/041 Create Flexible Financial Models with Choose/Choose-Unsolved.xlsx", "length": 9551}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/041 Create Flexible Financial Models with Choose/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/042 Goal Seek Will Help You Find the Result You Are Looking For/05-47-Goal-Seek-Exercise-Text.xlsx", "length": 16477}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/042 Goal Seek Will Help You Find the Result You Are Looking For/05-47-Goal-Seek-Solved.xlsx", "length": 16600}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/042 Goal Seek Will Help You Find the Result You Are Looking For/Excel-Functions.pdf", "length": 3331713}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/042 Goal Seek Will Help You Find the Result You Are Looking For/Goal-Seek-Solved.xlsx", "length": 9076}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/042 Goal Seek Will Help You Find the Result You Are Looking For/Goal-Seek-Unsolved.xlsx", "length": 9058}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/043 Perform Sensitivity Analysis with Excels Data Tables Functionality/05-48-Sensitivity-Analysis-Exercise-Text.xlsx", "length": 12892}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/043 Perform Sensitivity Analysis with Excels Data Tables Functionality/05-48-Sensitivity-Analysis-Solved.xlsx", "length": 13364}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/043 Perform Sensitivity Analysis with Excels Data Tables Functionality/Data-Tables-Solved.xlsx", "length": 9690}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/attached_files/043 Perform Sensitivity Analysis with Excels Data Tables Functionality/Data-Tables-Unsolved.xlsx", "length": 9474}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/quizzes/012 Key Excel Functions Average Averageif.html", "length": 2718}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/quizzes/013 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate.html", "length": 2753}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/quizzes/014 Index Match and Their Combination - The Perfect Substitute of Vlookup.html", "length": 2617}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/quizzes/015 Goal Seek Will Help You Find the Result You Are Looking For.html", "length": 2987}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/quizzes/016 Perform Sensitivity Analysis with Excels Data Tables Functionality.html", "length": 3180}, {"path": "05 Microsoft Excel - Beginner Intermediate Advanced Functions/quizzes/017 Quiz Number 2.html", "length": 6265}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/044 Understand Your Data Source Before You Start Working on It.mp4", "length": 29575502}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/045 Ordering the Source Worksheet.mp4", "length": 14399152}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/046 Create a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4", "length": 16717632}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/047 Learn How to Create a Database.mp4", "length": 15195301}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/048 Using Lookup Functions Vlookup to Fill the Database Sheet.mp4", "length": 39575459}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/049 Use Sumif to Complete the Database Sheet.mp4", "length": 31243910}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/050 Using Index Match as a Substitute of Vlookup.mp4", "length": 35522464}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/051 Mapping of the Rows in the Database Sheet.mp4", "length": 22520817}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/052 Building the Structure of the PL Sheet.mp4", "length": 10589059}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/053 A Practical Example of Professional Formatting in Excel.mp4", "length": 13733355}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/054 Populate the PL Sheet with Sumif.mp4", "length": 16190869}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/055 Learn How to Find Mistakes with Countif.mp4", "length": 19960971}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/056 Calculating Growth Rates in Excel.mp4", "length": 17145246}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/044 Understand Your Data Source Before You Start Working on It/Database-Case-study-1-before-exercises.xlsm", "length": 43315}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/045 Ordering the Source Worksheet/4.Order-a-worksheet-Solved.xlsm", "length": 37453}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/045 Ordering the Source Worksheet/4.Order-a-worksheet-Unsolved.xlsx", "length": 29328}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/046 Create a Code The Best Way to Organize Your Data and Work Efficiently with It/5.Creating-a-code-Solved.xlsx", "length": 34654}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/046 Create a Code The Best Way to Organize Your Data and Work Efficiently with It/5.Creating-a-code-Unsolved.xlsm", "length": 33548}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/047 Learn How to Create a Database/6.Creating-a-database-Solved.xlsx", "length": 36253}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/047 Learn How to Create a Database/6.Creating-a-database-Unsolved.xlsx", "length": 31396}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/048 Using Lookup Functions Vlookup to Fill the Database Sheet/7.Vlookup-Solved.xlsx", "length": 38306}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/048 Using Lookup Functions Vlookup to Fill the Database Sheet/7.Vlookup-Unsolved.xlsx", "length": 33263}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/049 Use Sumif to Complete the Database Sheet/8.Sumif-Solved.xlsx", "length": 48369}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/049 Use Sumif to Complete the Database Sheet/8.Sumif-Unsolved.xlsx", "length": 38306}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/050 Using Index Match as a Substitute of Vlookup/9.Index-Match-Solved.xlsx", "length": 43920}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/050 Using Index Match as a Substitute of Vlookup/9.Index-Match-Unsolved.xlsx", "length": 39369}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/051 Mapping of the Rows in the Database Sheet/10.Mapping-Solved.xlsx", "length": 48638}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/051 Mapping of the Rows in the Database Sheet/10.Mapping-Unsolved.xlsx", "length": 39980}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/052 Building the Structure of the PL Sheet/11.Building-a-P-L-Solved.xlsx", "length": 55127}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/052 Building the Structure of the PL Sheet/11.Building-a-P-L-Unsolved.xlsx", "length": 44654}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/053 A Practical Example of Professional Formatting in Excel/12.Formatting-the-P-L-Unsolved.xlsx", "length": 50549}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/053 A Practical Example of Professional Formatting in Excel/12.Formatting-the-P-L-sheet-Solved.xlsx", "length": 54843}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/054 Populate the PL Sheet with Sumif/13.Populating-the-P-L-sheet-Solved.xlsm", "length": 60434}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/054 Populate the PL Sheet with Sumif/13.Populating-the-P-L-sheet-Unsolved.xlsx", "length": 50409}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/055 Learn How to Find Mistakes with Countif/14.Countif-Solved.xlsx", "length": 58692}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/055 Learn How to Find Mistakes with Countif/14.Countif-Unsolved.xlsm", "length": 55287}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/056 Calculating Growth Rates in Excel/15.Adding-variations-Solved.xlsx", "length": 57885}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/attached_files/056 Calculating Growth Rates in Excel/15.Adding-variations-Unsolved.xlsx", "length": 52385}, {"path": "06 Microsoft Excel - Practical Exercise Build a PL From Scratch/quizzes/018 Quiz Number 3.html", "length": 4532}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/057 Introduction to Excel Charts.mp4", "length": 6868992}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/058 Beginners Guide to Inserting Charts in Excel.mp4", "length": 11467118}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/059 Modifying Excel Charts - The Easy Way to Do It.mp4", "length": 13651291}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/060 Make Your Excel Charts Look Sexier - Proven Tips.mp4", "length": 16582793}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/061 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4", "length": 6455405}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/062 New Ways to Visualize Your Data - Treemap Charts.mp4", "length": 5959500}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/063 How to Represent Trends with Sparklines.mp4", "length": 13290181}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/attached_files/058 Beginners Guide to Inserting Charts in Excel/2.Inserting-Charts.xlsm", "length": 12003193}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/attached_files/059 Modifying Excel Charts - The Easy Way to Do It/3.Formatting-a-Chart.xlsm", "length": 12009316}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/attached_files/060 Make Your Excel Charts Look Sexier - Proven Tips/3.Formatting-a-Chart.xlsm", "length": 12009316}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/attached_files/061 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets/Bridge-Charts.xlsx", "length": 13418}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/attached_files/062 New Ways to Visualize Your Data - Treemap Charts/Treemap-Charts.xlsx", "length": 12919}, {"path": "07 Microsoft Excel - Building Professional Charts in Excel/attached_files/063 How to Represent Trends with Sparklines/Sparklines.xlsx", "length": 9816}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/064 Pivot Tables - Excels Dynamic and Interactive Tables.mp4", "length": 6286410}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/065 Creating a Pivot Table Choosing Row and Column Parameters.mp4", "length": 20315089}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/066 Design the Layout and Format of Your Pivot Tables.mp4", "length": 11819176}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/067 Additional Techniques That Will Ease Your Work with Pivot Tables.mp4", "length": 24120883}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/068 One of the Most Useful Excel Functions - GetPivotData.mp4", "length": 18932096}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/069 Welcome to the Future - Pivot Table Slicers.mp4", "length": 23238134}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/070 Introduction to the Course Challenge.mp4", "length": 4256908}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/071 COURSE CHALLENGE - Part 1.mp4", "length": 8274050}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/attached_files/065 Creating a Pivot Table Choosing Row and Column Parameters/2.Creating-a-Pivot-Table.xlsx", "length": 1495369}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/attached_files/066 Design the Layout and Format of Your Pivot Tables/3.Formatting-a-Pivot-Table.xlsx", "length": 1495369}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/attached_files/067 Additional Techniques That Will Ease Your Work with Pivot Tables/4.Working-with-Pivot-Tables.xlsx", "length": 1973069}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/attached_files/068 One of the Most Useful Excel Functions - GetPivotData/5.GetPivotData.xlsx", "length": 1968935}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/attached_files/069 Welcome to the Future - Pivot Table Slicers/6.Slicers.xlsx", "length": 1969948}, {"path": "08 Microsoft Excel - Working with Pivot Tables in Excel/attached_files/071 COURSE CHALLENGE - Part 1/1.Course-Challenge.xlsx", "length": 517617}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/072 Introduction to the Case Study.mp4", "length": 22091741}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/073 Working with an SAP data extraction.mp4", "length": 23016501}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/074 Preliminary mapping of the data extraction.mp4", "length": 23698911}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/075 Creating an output structure of the FMCG model.mp4", "length": 12220560}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/076 Improving the layout and appearance of the FMCG report.mp4", "length": 13262162}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/077 Inserting formulas and automating calculations.mp4", "length": 9254460}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/078 Creating a Master Pivot Table The main data source for the FMCG report.mp4", "length": 14490740}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/079 GetPivotData is great Extracting data from the Master Pivot Table.mp4", "length": 32544889}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/080 Combining Slicers and GetPivotData The key to our success.mp4", "length": 18701305}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/081 Getting fancy with Excel slicers - Good-looking Excel slicers.mp4", "length": 17945524}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/082 This is how the report can be used in practice by high-level executives.mp4", "length": 20766669}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/attached_files/072 Introduction to the Case Study/0.Exercise-Build-an-FMCG-Model-before.xlsx", "length": 13902890}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/attached_files/074 Preliminary mapping of the data extraction/1.Exercise-Build-an-FMCG-Model-Mapping.xlsx", "length": 15613249}, {"path": "09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/attached_files/075 Creating an output structure of the FMCG model/2.Exercise-Build-an-FMCG-Model-Structure.xlsx", "length": 15637698}, {"path": "10 Building a complete 3-statement model/083 Introduction to the Exercise.mp4", "length": 12846093}, {"path": "10 Building a complete 3-statement model/084 Lets create a mapping of financials.mp4", "length": 11640514}, {"path": "10 Building a complete 3-statement model/085 Building an output PL sheet.mp4", "length": 11597638}, {"path": "10 Building a complete 3-statement model/086 Filling in the output PL sheet with historical financials.mp4", "length": 8670246}, {"path": "10 Building a complete 3-statement model/087 Calculating percentage variances and applying conditional formatting.mp4", "length": 9020451}, {"path": "10 Building a complete 3-statement model/088 Building an output Balance sheet.mp4", "length": 11053908}, {"path": "10 Building a complete 3-statement model/089 Using Index Match Match to fill in the output Balance sheet.mp4", "length": 15103354}, {"path": "10 Building a complete 3-statement model/090 Adding the forecast period.mp4", "length": 11348562}, {"path": "10 Building a complete 3-statement model/attached_files/083 Introduction to the Exercise/1.1-after.xlsx", "length": 33508}, {"path": "10 Building a complete 3-statement model/attached_files/083 Introduction to the Exercise/1.1-before.xlsx", "length": 19191}, {"path": "10 Building a complete 3-statement model/attached_files/083 Introduction to the Exercise/Financial-Modeling-Notes.pdf", "length": 706640}, {"path": "10 Building a complete 3-statement model/attached_files/084 Lets create a mapping of financials/1.2-after.xlsx", "length": 35066}, {"path": "10 Building a complete 3-statement model/attached_files/084 Lets create a mapping of financials/1.2-before.xlsx", "length": 31181}, {"path": "10 Building a complete 3-statement model/attached_files/085 Building an output PL sheet/1.3-after.xlsx", "length": 42476}, {"path": "10 Building a complete 3-statement model/attached_files/085 Building an output PL sheet/1.3-before.xlsx", "length": 33137}, {"path": "10 Building a complete 3-statement model/attached_files/086 Filling in the output PL sheet with historical financials/1.4-after.xlsx", "length": 42246}, {"path": "10 Building a complete 3-statement model/attached_files/086 Filling in the output PL sheet with historical financials/1.4-before.xlsx", "length": 38535}, {"path": "10 Building a complete 3-statement model/attached_files/087 Calculating percentage variances and applying conditional formatting/1.5-after.xlsx", "length": 42729}, {"path": "10 Building a complete 3-statement model/attached_files/087 Calculating percentage variances and applying conditional formatting/1.5-before.xlsx", "length": 40217}, {"path": "10 Building a complete 3-statement model/attached_files/088 Building an output Balance sheet/1.6-after.xlsx", "length": 55740}, {"path": "10 Building a complete 3-statement model/attached_files/088 Building an output Balance sheet/1.6-before.xlsx", "length": 48636}, {"path": "10 Building a complete 3-statement model/attached_files/089 Using Index Match Match to fill in the output Balance sheet/1.7-after.xlsx", "length": 58485}, {"path": "10 Building a complete 3-statement model/attached_files/089 Using Index Match Match to fill in the output Balance sheet/1.7-before.xlsx", "length": 50991}, {"path": "10 Building a complete 3-statement model/attached_files/090 Adding the forecast period/1.8-after.xlsx", "length": 56272}, {"path": "10 Building a complete 3-statement model/attached_files/090 Adding the forecast period/1.8-before.xlsx", "length": 51486}, {"path": "11 Lets build a flexible model with multiple scenarios/091 Calculating historical percentage ratios and use Index and Match for scenarios.mp4", "length": 15973814}, {"path": "11 Lets build a flexible model with multiple scenarios/092 Building a flexible model with Choose Match.mp4", "length": 4535061}, {"path": "11 Lets build a flexible model with multiple scenarios/093 Building a flexible model with Vlookup Columns.mp4", "length": 11215640}, {"path": "11 Lets build a flexible model with multiple scenarios/094 Calculating historical DSO DPO DIO Other assets and Other liabilities.mp4", "length": 15428356}, {"path": "11 Lets build a flexible model with multiple scenarios/095 Forecasting DSO DPO DIO Other assets and Other liabilities.mp4", "length": 9478779}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/091 Calculating historical percentage ratios and use Index and Match for scenarios/1.9-after.xlsx", "length": 56263}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/091 Calculating historical percentage ratios and use Index and Match for scenarios/1.9-before.xlsx", "length": 54068}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/092 Building a flexible model with Choose Match/1.10-after.xlsx", "length": 55980}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/092 Building a flexible model with Choose Match/1.10-before.xlsx", "length": 54355}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/093 Building a flexible model with Vlookup Columns/1.11-after.xlsx", "length": 56439}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/093 Building a flexible model with Vlookup Columns/1.11-before.xlsx", "length": 54355}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/094 Calculating historical DSO DPO DIO Other assets and Other liabilities/1.12-after.xlsx", "length": 57957}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/094 Calculating historical DSO DPO DIO Other assets and Other liabilities/1.12-before.xlsx", "length": 54842}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/095 Forecasting DSO DPO DIO Other assets and Other liabilities/1.13-after.xlsx", "length": 59051}, {"path": "11 Lets build a flexible model with multiple scenarios/attached_files/095 Forecasting DSO DPO DIO Other assets and Other liabilities/1.13-before.xlsx", "length": 55952}, {"path": "12 We are almost there Completing the 3-statement model/096 Building a Fixed asset roll forward.mp4", "length": 15037308}, {"path": "12 We are almost there Completing the 3-statement model/097 Building a Financial liabilities schedule.mp4", "length": 17521625}, {"path": "12 We are almost there Completing the 3-statement model/098 Building an Equity schedule.mp4", "length": 13669262}, {"path": "12 We are almost there Completing the 3-statement model/099 Preparing a Cash flow structure.mp4", "length": 6497981}, {"path": "12 We are almost there Completing the 3-statement model/100 Calculating Cash flows and completing the model.mp4", "length": 21050070}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/096 Building a Fixed asset roll forward/1.14-after.xlsx", "length": 63569}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/096 Building a Fixed asset roll forward/1.14-before.xlsx", "length": 57084}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/097 Building a Financial liabilities schedule/1.15-after.xlsx", "length": 69186}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/097 Building a Financial liabilities schedule/1.15-before.xlsx", "length": 60316}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/098 Building an Equity schedule/1.16-after.xlsx", "length": 71214}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/098 Building an Equity schedule/1.16-before.xlsx", "length": 60316}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/099 Preparing a Cash flow structure/1.17-after.xlsx", "length": 72039}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/099 Preparing a Cash flow structure/1.17-before.xlsx", "length": 67171}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/100 Calculating Cash flows and completing the model/1.18-after.xlsx", "length": 74336}, {"path": "12 We are almost there Completing the 3-statement model/attached_files/100 Calculating Cash flows and completing the model/1.18-before.xlsx", "length": 69311}, {"path": "13 Accounting - Introduction to Accounting Bookkeeping/101 Accounting The Science Behind Financial Figures.mp4", "length": 28417503}, {"path": "13 Accounting - Introduction to Accounting Bookkeeping/102 What is Accounting and Why Do You Need It.mp4", "length": 20705202}, {"path": "13 Accounting - Introduction to Accounting Bookkeeping/103 The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4", "length": 11504643}, {"path": "13 Accounting - Introduction to Accounting Bookkeeping/104 An Introduction to Financial Accounting.mp4", "length": 13969248}, {"path": "13 Accounting - Introduction to Accounting Bookkeeping/attached_files/101 Accounting The Science Behind Financial Figures/Introduction-to-Accounting-Notes.pdf", "length": 1243439}, {"path": "13 Accounting - Introduction to Accounting Bookkeeping/attached_files/102 What is Accounting and Why Do You Need It/Accounting-Financial-Statement-Analysis-Notes.pdf", "length": 1242469}, {"path": "13 Accounting - Introduction to Accounting Bookkeeping/attached_files/104 An Introduction to Financial Accounting/Accounting-Financial-Statement-Analysis-Notes.pdf", "length": 1242469}, {"path": "13 Accounting - Introduction to Accounting Bookkeeping/quizzes/019 Quiz Number 3.html", "length": 3360}, {"path": "14 Accounting - The Three Main Statements in Financial Accounting/105 The Three Core Financial Statements PL Balance Sheet and Cash Flow.mp4", "length": 10179364}, {"path": "14 Accounting - The Three Main Statements in Financial Accounting/106 The Key Accounts You Will Find in a PL.mp4", "length": 28538199}, {"path": "14 Accounting - The Three Main Statements in Financial Accounting/107 The Main Balance Sheet Items.mp4", "length": 19468476}, {"path": "14 Accounting - The Three Main Statements in Financial Accounting/attached_files/107 The Main Balance Sheet Items/5.Balance-Sheet-items.mp4", "length": 29250626}, {"path": "14 Accounting - The Three Main Statements in Financial Accounting/quizzes/020 Quiz Number 4.html", "length": 4413}, {"path": "15 Accounting - Understanding the Big Picture Why What When and How Much/108 The Revenue Recognition Principle - Why Is it so Important.mp4", "length": 9276737}, {"path": "15 Accounting - Understanding the Big Picture Why What When and How Much/109 The Expense Recognition Principle - When to Recognize Expenses.mp4", "length": 10356836}, {"path": "15 Accounting - Understanding the Big Picture Why What When and How Much/110 Historical Cost vs. Fair Value Accounting.mp4", "length": 7909345}, {"path": "16 Accounting - The Core Principles of Accounting/111 The Accounting Equation and Its Importance.mp4", "length": 11209730}, {"path": "16 Accounting - The Core Principles of Accounting/112 Elements of the Accounting System General Ledger.mp4", "length": 7862041}, {"path": "16 Accounting - The Core Principles of Accounting/113 T-Accounts The Best Way to Understand Debits and Credits.mp4", "length": 10449176}, {"path": "16 Accounting - The Core Principles of Accounting/114 PL T-Accounts.mp4", "length": 7109931}, {"path": "16 Accounting - The Core Principles of Accounting/115 How to Calculate Depreciation Expense.mp4", "length": 14588308}, {"path": "16 Accounting - The Core Principles of Accounting/116 The Double-Entry Principle - The Core Principle of Bookkeeping.mp4", "length": 10640558}, {"path": "16 Accounting - The Core Principles of Accounting/attached_files/112 Elements of the Accounting System General Ledger/General-Ledgers.mp4", "length": 12043704}, {"path": "16 Accounting - The Core Principles of Accounting/quizzes/021 Quiz Number 5.html", "length": 5352}, {"path": "17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/117 Case Study - The Accounting Transactions of a Lemonade Stand 14.mp4", "length": 31729607}, {"path": "17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/118 Case Study - The Accounting Transactions of a Lemonade Stand 24.mp4", "length": 22801874}, {"path": "17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/119 Case Study - The Accounting Transactions of a Lemonade Stand 34.mp4", "length": 17888878}, {"path": "17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/120 Case Study - The Accounting Transactions of a Lemonade Stand 44.mp4", "length": 28712307}, {"path": "17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/attached_files/117 Case Study - The Accounting Transactions of a Lemonade Stand 14/Exercise-Part-One.xlsx"
Download Info
-
Tips
“[FreeTutorials.Us] the-complete-financial-analyst-course” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.