23 OCT 2025 - We are back! If you have been following us over the last few years, you will know that the last 2 months have been rough. We website was practically not loading. Sorry for the mess. We are back though and everything should run smoothly now. New servers. Updated domains. And new owners. We invite you all to start uploading torrents again!
TORRENT DETAILS
[ WebToolTip.com ] Udemy - MO-220 Exam Prep - Microsoft Excel For Accounting
Language: English | Size: 3.57 GB | Duration: 5h 46m
Learn the skills for the new MO-220 Excel certification. Use Data Validation, Formula Auditing, create charts and more!
What you'll learn
Perform Accounting Data for Analysis
Prepare a Trial Balance
Prepare and Analyze Financial Statements
Perform Routine Accounting Activities
Requirements
Before beginning, you will need to know how to use a Windows computer, including a mouse.
It would be good if you have used Microsoft Excel before, but this is not essential.
You should have MS Excel (or Office) 2021 or later installed on your PC computer. This program is also known as a Microsoft 365 App.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~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
![[ WebToolTip.com ] Udemy - MO-220 Exam Prep - Microsoft Excel For Accounting](https://f.t0r.space/no-cover.webp)
