Udemy - How to audit your Excel files to identify errors or mistakes

seeders: 12
leechers: 10
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ CourseWikia.com ] Udemy - How to audit your Excel files to identify errors or mistakes
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction and requirements for the course
    • 1. Introduction to this course syllabus.mp4 (11.0 MB)
    • 2. Download and Install - Power Query and ASAP Utilities.mp4 (17.7 MB)
    2. Get started with Excel
    • 1. ALL keyboard shortcuts in Excel.mp4 (7.7 MB)
    • 1.1 Excel Shortucts - Alphabet Keys.png (35.5 KB)
    • 1.2 Excel Shortucts - Function Keys.png (39.0 KB)
    • 1.3 Excel Shortucts - Special Keys - 1.png (37.2 KB)
    • 1.4 Excel Shortucts - Special Keys - 2.png (44.7 KB)
    • 2. Ribbon and Quick access toolbar.mp4 (20.5 MB)
    • 3. Selecting Data in Excel and Navigating through file.mp4 (24.2 MB)
    • 3.1 Navigate.png (336.4 KB)
    • 3.2 Selecting Data.xlsx (10.8 KB)
    • 3.3 Selection of Data in Excel.JPG (159.1 KB)
    3. Features that will speed up your review and auditing process
    • 1. Watch Window - keep selected cells results displayed at all times.mp4 (10.0 MB)
    • 2. Compare multiple files side by side on single monitor.mp4 (19.7 MB)
    • 3. Go To Window and Special - detailed explanation of all items.mp4 (70.1 MB)
    • 3.1 Go to window.xlsx (95.5 KB)
    • 4. Find & select with formatting of selected cell or as per selected format setting.mp4 (55.1 MB)
    • 4.1 Find & Replace.xlsx (121.3 KB)
    • 5. Printing set up in Excel explained in detail with various settings.mp4 (70.0 MB)
    4. Inquire tool add in to perform through analysis of any Excel file automatically
    • 1. Introduction to Inquire Add-in and activating it in Excel.mp4 (11.8 MB)
    • 2. Introduction to Workbook Analysis Report.mp4 (15.1 MB)
    • 2.1 Inquire Add in in Excel.docx (40.7 KB)
    • 2.2 Inquire Basics V1.xlsx (94.8 KB)
    • 3. Workbook Analysis Report - Part 1.mp4 (26.5 MB)
    • 3.1 Inquire Basics V1 - Workbook Analysis.xlsx (426.2 KB)
    • 4. Workbook Analysis Report - Part 2.mp4 (12.6 MB)
    • 5. Workbook, Worksheet and Cell relationships.mp4 (32.5 MB)
    • 6. Compare files.mp4 (33.5 MB)
    • 6.1 Inquire Basics V2.xlsx (93.0 KB)
    • 7. Clean Excess Cell Formatting and Workbook Passwords.mp4 (10.6 MB)
    5. Formula Auditing
    • 1. Operators and Order of operations used in Excel for calculations.mp4 (12.6 MB)
    • 1.1 Operators and Order of Operations.xlsx (10.5 KB)
    • 2. Precedents dependent cells, Evaluate partial or full formula stepwise.mp4 (32.5 MB)
    • 3. Formula Auditing - Identifying Errors.mp4 (122.5 MB)
    • 4. Checking the Formula Text to locate errors and deceptions in spreadsheets.mp4 (25.4 MB)
    • 4.1 Formula Auditing.xlsx (99.8 KB)
    • 5. Referencing - Relative & Absolute, Structured, Named Ranges cells - Part 1.mp4 (43.2 MB)
    • 5.1 Referencing.xlsx (70.3 KB)
    • 6. Referencing - Relative & Absolute, Structured, Named Ranges cells - Part 2.mp4 (23.5 MB)
    • 7. Precision as displayed.mp4 (11.2 MB)
    • 7.1 Precision as Displayed.xlsx (9.9 KB)
    6. Pivot Tables
    • 1. Introduction to Pivot Tables, Data Models and Power Pivot.mp4 (12.1 MB)
    • 10. Issues with usage of calculated fields and items.mp4 (18.6 MB)
    • 10.1 Calculated fields and Items.xlsx (2.3 MB)
    • 11. Solution for FAQ for pivot table related issues.mp4 (17.1 MB)
    • 11.1 FAQ on Pivot Tables.xlsx (1.1 MB)
    • 2. Legacy Pivot Table - Data Source - Single Sheets.mp4 (45.5 MB)
    • 2.1 Single Sheet.xlsx (927.8 KB)
    • 3. Other Data Sources - Multiple Sheets, External Data and Existing pivot table.mp4 (16.6 MB)
    • 3.1 External Data.xlsx (328.7 KB)
    • 3.2 Multiple Sheets.xlsx (16.1 KB)
    • 4. Simple Data Model and Power Pivot.mp4 (24.9 MB)
    • 4.1 Data Model.xlsx (232.0 KB)
    • 5. Filtering the data - Report Level, Slicers, Timelines - Label & Value filters.mp4 (42.1 MB)
    • 5.1 Filtering data in Pivot Table.xlsx (2.2 MB)
    • 6. Sort the data in Pivot Table - Ascending, Descending, Manual or Custom Sort.mp4 (29.4 MB)
    • 6.1 Sorting and grouping in pivot table.xlsx (2.2 MB)
    • 7. Grouping Records and rename fields or groups.mp4 (10.7 MB)
    • 7.1 Sorting and grouping in pivot table.xlsx (2.2 MB)
    • 8. Different options for summarize values by.mp4 (17.8 MB)
    • 8.1 Summarize Values by....xlsx (2.2 MB)
    • 9. Conditional Formatting - Heat Map, Data Bars, Sparklines.mp4 (10.3 MB)
    • 9.1 Conditional Formatting.xlsx (2.0 MB)
    7. Overall governance around spreadsheets
    • 1. Overall Governance around spreadsheets.mp4 (3.4 MB)
    • 1.1 Overall Governance.pdf (231.8 KB)
    • 1.2 Spreadsheet Modelling Best Practice.pdf (1.3 MB)
    • 1.3 Spreadsheet Policy # XYZ.pdf (494.3 KB)
    • 2. SIPOC Model - suggested approach to create, maintain and monitor spreadsheets.mp4 (13.0 MB)
    • 2.1 SIPOC Model.xlsx (16.2 KB)
    • 3. Inventory of all FILES in a folder and creating Index of sheets within a File.mp4 (19.0 MB)
    8. Bonus Lecture
    • 1. Bonus Lecture - discount on my other courses.html (0.3 KB)
    • Bonus Resources.txt (0.4 KB)

Description

How to audit your Excel files to identify errors or mistakes



https://CourseWikia.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 39 lectures (5h 6m) | Size: 1 GB

Perform Foresnic Auditing of Excel files to ensure that calculation are error free & not manipulated with hidden tools

What you'll learn
Protect against formula and operational errors
Be able to nstrate management of material spreadsheet risks
Reduce compliance costs for business in regulated sectors
Design and implement robust internal controls over spreadsheet based financial reporting

Requirements
You should have used Excel earlier
You should know Excel basics like - entering formulas, pivot tables, etc.
You should have Excel 2010 onwards and preferably professional plus editions



Download torrent
1019.5 MB
seeders:12
leechers:10
Udemy - How to audit your Excel files to identify errors or mistakes

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
1019.5 MB
seeders:12
leechers:10
Udemy - How to audit your Excel files to identify errors or mistakes

Torrent hash: 41238142C6D7CB603336D02EDDD293D8F867BCF5