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

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4

74 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 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 MB

~Get Your Files Here !/1 - Introduction/6 - AccountingData.xlsx

21 kB

~Get Your Files Here !/1 - Introduction/6 - MO-220Notes250930.pdf

272 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 MB

~Get Your Files Here !/10 - Well done for finishing the Excel course/59 - Congratulations for finishing the Excel course.mp4

39 MB

~Get Your Files Here !/2 - Importingexporting data and cleaning accounting data/10 - 1 Import data from various sources.mp4

71 MB

~Get Your Files Here !/2 - Importingexporting data and cleaning accounting data/11 - Moving data using cut copy and paste.mp4

37 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

78 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

75 MB

~Get Your Files Here !/2 - Importingexporting data and cleaning accounting data/8 - Inserting data and moving the cursor.mp4

37 MB

~Get Your Files Here !/2 - Importingexporting data and cleaning accounting data/9 - 2 Save and export workbooks in various file formats.mp4

44 MB

~Get Your Files Here !/3 - Verify accounting data integrity and transform accounting data/15 - 6 Apply Data Validation rules to restrict input.mp4

73 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 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 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

65 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

55 MB

~Get Your Files Here !/4 - Using text and date functions/20 - TransactionsStartOfSection4.xlsx

20 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 MB

~Get Your Files Here !/4 - Using text and date functions/23 - 10 Use date functions to transform transaction dates.mp4

72 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 MB

~Get Your Files Here !/5 - Manipulating accounting data/25 - TransactionsStartOfSection5.xlsx

17 kB

~Get Your Files Here !/5 - Manipulating accounting data/26 - 13 Filter transactions.mp4

116 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

45 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 MB

~Get Your Files Here !/5 - Manipulating accounting data/32 - 16 The XLOOKUP function.mp4

84 MB

~Get Your Files Here !/5 - Manipulating accounting data/33 - Practice Activity Number 5.html

1.0 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 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

97 MB

~Get Your Files Here !/6 - Preparing and analyzing financial statements/36 - 18 Formatting our trial balance for preparation.mp4

83 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 MB

~Get Your Files Here !/6 - Preparing and analyzing financial statements/38 - 17 Creating a Balance Sheet.mp4

95 MB

~Get Your Files Here !/6 - Preparing and analyzing financial statements/39 - 17 Create an Income Statement Profit and Loss Account.mp4

30 MB

~Get Your Files Here !/6 - Preparing and analyzing financial statements/40 - Calculating profitability liquidity and solvency ratios.mp4

59 MB

~Get Your Files Here !/7 - Correct errors and presenting information visually/41 - 22 Use Conditional Formatting to identify data anomalies.mp4

60 MB

~Get Your Files Here !/7 - Correct errors and presenting information visually/41 - TransactionsStartOfSection7.xlsx

33 kB

~Get Your Files Here !/7 - Correct errors and presenting information visually/42 - 22 More Conditional Formatting rules and managing Conditional Formatting.mp4

113 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

147 MB

~Get Your Files Here !/7 - Correct errors and presenting information visually/45 - 25 Creating a dashboard.mp4

77 MB

~Get Your Files Here !/7 - Correct errors and presenting information visually/46 - 25 Creating charts.mp4

60 MB

~Get Your Files Here !/7 - Correct errors and presenting information visually/47 - 25 Creating PivotCharts.mp4

62 MB

~Get Your Files Here !/7 - Correct errors and presenting information visually/48 - 26 Evaluating and improving accessibility and usability.mp4

70 MB

~Get Your Files Here !/8 - Preparing amortization and depreciation schedules/49 - 27 Calculating fixed monthly payments.mp4

48 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

60 MB

~Get Your Files Here !/8 - Preparing amortization and depreciation schedules/51 - 38 39 Calculating periodic and projecting future straightline depreciation.mp4

40 MB

~Get Your Files Here !/8 - Preparing amortization and depreciation schedules/52 - 38 39 Calculating depreciation using other depreciation methods.mp4

71 MB

~Get Your Files Here !/9 - Payroll activities bank reconciliations managing accounts receivablepayable/53 - 35 36 37 Performing payroll activities in Excel.mp4

82 MB

~Get Your Files Here !/9 - Payroll activities bank reconciliations managing accounts receivablepayable/54 - 29 30 Preparing bank reconciliations in Excel.mp4

34 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

38 MB

~Get Your Files Here !/9 - Payroll activities bank reconciliations managing accounts receivablepayable/56 - 32 33 Managing accounts receivable and accounts payable.mp4

22 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

72 MB

~Get Your Files Here !/Bonus Resources.txt

70 B