[ WebToolTip.com ] Udemy - MO-220 Exam Prep - Microsoft Excel For Accounting

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

No comments yet.