Udemy - MO-220 Exam Prep - Microsoft Excel For Accounting

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 - Introduction.mp4 (74.2 MB)
• 2 - Welcome to Udemy.html (0.9 KB)
• 3 - How to get the best out of your Udemy course.mp4 (38.3 MB)
• 4 - Do you want autotranslated subtitles in more languages.html (2.7 KB)
• 5 - Curriculum.mp4 (32.3 MB)
• 6 - AccountingData.xlsx (21.0 KB)
• 6 - MO-220Notes250930.pdf (272.2 KB)
• 6 - Resources.html (0.2 KB)
• 6 - TransactionsCSV.csv (1.0 KB)
• 6 - TransactionsFixed.txt (1.1 KB)
• 6 - TransactionsTab.txt (0.8 KB)
10 - Well done for finishing the Excel course
• 58 - Whats Next.mp4 (11.3 MB)
• 59 - Congratulations for finishing the Excel course.mp4 (38.8 MB)
2 - Importingexporting data and cleaning accounting data
• 10 - 1 Import data from various sources.mp4 (71.4 MB)
• 11 - Moving data using cut copy and paste.mp4 (37.4 MB)
• 12 - 3 4 Remove duplicate data and deletehideresize rows columns and cells.mp4 (77.9 MB)
• 13 - 5 Format cells for consistency.mp4 (171.0 MB)
• 14 - Practice Activity Number 1.html (1.7 KB)
• 7 - Microsoft Excel a quick tour.mp4 (74.6 MB)
• 8 - Inserting data and moving the cursor.mp4 (36.6 MB)
• 9 - 2 Save and export workbooks in various file formats.mp4 (43.6 MB)
3 - Verify accounting data integrity and transform accounting data
• 15 - 6 Apply Data Validation rules to restrict input.mp4 (72.8 MB)
• 16 - 7 Identify data outside defined standards or expected values.mp4 (84.2 MB)
• 17 - 8 Split a single data column into multiple columns.mp4 (33.3 MB)
• 18 - 11 Use Fill features to extend series and patterns.mp4 (64.8 MB)
• 19 - Practice Activity Number 2.html (1.4 KB)
4 - Using text and date functions
• 20 - 9 Using the to combine values and copying formulas to other cells.mp4 (54.9 MB)
• 20 - TransactionsStartOfSection4.xlsx (20.2 KB)
• 21 - 9 Using text functions to combine values.mp4 (94.0 MB)
• 22 - 9 Using text functions to extract values.mp4 (154.2 MB)
• 23 - 10 Use date functions to transform transaction dates.mp4 (71.8 MB)
• 24 - Practice Activity Number 3.html (1.4 KB)
5 - Manipulating accounting data
• 25 - 12 Sort transactions.mp4 (73.4 MB)
• 25 - TransactionsStartOfSection5.xlsx (16.7 KB)
• 26 - 13 Filter transactions.mp4 (116.3 MB)
• 27 - 14 Math functions.mp4 (112.0 MB)
• 28 - Practice Activity Number 4.html (1.0 KB)
• 29 - 15 Using the logical functions IF AND OR and NOT.mp4 (44.6 MB)
• 30 - 15 Using more advanced logical functions.mp4 (60.0 MB)
• 31 - 16 The VLOOKUP function and fixing references to rows and columns.mp4 (96.3 MB)
• 32 - 16 The XLOOKUP function.mp4 (84.2 MB)
• 33 - Practice Activity Number 5.html (1.0 KB)
6 - Preparing and analyzing financial statements
• 34 - 17 Using formulas to aggregate data SUM COUNT MAX MIN AVERAGE functions.mp4 (103.2 MB)
• 34 - TransactionsStartOfSection6.xlsx (20.0 KB)
• 35 - 17 Using conditional formulas to create a trial balance SUMIF function.mp4 (96.9 MB)
• 36 - 18 Formatting our trial balance for preparation.mp4 (82.7 MB)
• 37 - 17 Creating a trial balance based on a date using the SUMIFS function.mp4 (116.2 MB)
• 38 - 17 Creating a Balance Sheet.mp4 (94.8 MB)
• 39 - 17 Create an Income Statement Profit and Loss Account.mp4 (30.2 MB)
• 40 - Calculating profitability liquidity and solvency ratios.mp4 (59.1 MB)
7 - Correct errors and presenting information visually
• 41 - 22 Use Conditional Formatting to identify data anomalies.mp4 (59.9 MB)
• 41 - TransactionsStartOfSection7.xlsx (33.2 KB)
• 42 - 22 More Conditional Formatting rules and managing Conditional Formatting.mp4 (112.8 MB)
• 43 - 23 Using Formula Auditing features to verify and correct calculations.mp4 (94.0 MB)
• 44 - 24 Creating PivotTables to summarize financial data.mp4 (146.6 MB)
• 45 - 25 Creating a dashboard.mp4 (77.3 MB)
• 46 - 25 Creating charts.mp4 (59.9 MB)
• 47 - 25 Creating PivotCharts.mp4 (62.4 MB)
• 48 - 26 Evaluating and improving accessibility and usability.mp4 (70.4 MB)
8 - Preparing amortization and depreciation schedules
• 49 - 27 Calculating fixed monthly payments.mp4 (48.3 MB)
• 49 - AccountingData.xlsx (21.0 KB)
• 50 - 28 Creating amortization schedules.mp4 (59.7 MB)
• 51 - 38 39 Calculating periodic and projecting future straightline depreciation.mp4 (39.9 MB)
• 52 - 38 39 Calculating depreciation using other depreciation methods.mp4 (71.4 MB)
9 - Payroll activities bank reconciliations managing accounts receivablepayable
• 53 - 35 36 37 Performing payroll activities in Excel.mp4 (81.8 MB)
• 54 - 29 30 Preparing bank reconciliations in Excel.mp4 (34.1 MB)
• 55 - 29 30 31 Expanding our reconciliation and calculating adjusted cash balances.mp4 (37.8 MB)
• 56 - 32 33 Managing accounts receivable and accounts payable.mp4 (22.4 MB)
• 57 - 32 33 34 Creating an aging report and estimating bad debt.mp4 (71.6 MB)
• Bonus Resources.txt (0.1 KB)