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

1. ~Get Your Files Here !/1. Introduction and requirements for the course/1. Introduction to this course syllabus.mp411.01MB
2. ~Get Your Files Here !/1. Introduction and requirements for the course/2. Download and Install - Power Query and ASAP Utilities.mp417.7MB
3. ~Get Your Files Here !/2. Get started with Excel/1. ALL keyboard shortcuts in Excel.mp47.7MB
4. ~Get Your Files Here !/2. Get started with Excel/2. Ribbon and Quick access toolbar.mp420.47MB
5. ~Get Your Files Here !/2. Get started with Excel/3. Selecting Data in Excel and Navigating through file.mp424.23MB
6. ~Get Your Files Here !/3. Features that will speed up your review and auditing process/1. Watch Window - keep selected cells results displayed at all times.mp410MB
7. ~Get Your Files Here !/3. Features that will speed up your review and auditing process/2. Compare multiple files side by side on single monitor.mp419.67MB
8. ~Get Your Files Here !/3. Features that will speed up your review and auditing process/3. Go To Window and Special - detailed explanation of all items.mp470.06MB
9. ~Get Your Files Here !/3. Features that will speed up your review and auditing process/4. Find & select with formatting of selected cell or as per selected format setting.mp455.06MB
10. ~Get Your Files Here !/3. Features that will speed up your review and auditing process/5. Printing set up in Excel explained in detail with various settings.mp470.05MB
11. ~Get Your Files Here !/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.mp411.79MB
12. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/2. Introduction to Workbook Analysis Report.mp415.12MB
13. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/3. Workbook Analysis Report - Part 1.mp426.52MB
14. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/4. Workbook Analysis Report - Part 2.mp412.58MB
15. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/5. Workbook, Worksheet and Cell relationships.mp432.54MB
16. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/6. Compare files.mp433.53MB
17. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/7. Clean Excess Cell Formatting and Workbook Passwords.mp410.58MB
18. ~Get Your Files Here !/5. Formula Auditing/1. Operators and Order of operations used in Excel for calculations.mp412.56MB
19. ~Get Your Files Here !/5. Formula Auditing/2. Precedents dependent cells, Evaluate partial or full formula stepwise.mp432.51MB
20. ~Get Your Files Here !/5. Formula Auditing/3. Formula Auditing - Identifying Errors.mp4122.48MB
21. ~Get Your Files Here !/5. Formula Auditing/4. Checking the Formula Text to locate errors and deceptions in spreadsheets.mp425.37MB
22. ~Get Your Files Here !/5. Formula Auditing/5. Referencing - Relative & Absolute, Structured, Named Ranges cells - Part 1.mp443.25MB
23. ~Get Your Files Here !/5. Formula Auditing/6. Referencing - Relative & Absolute, Structured, Named Ranges cells - Part 2.mp423.53MB
24. ~Get Your Files Here !/5. Formula Auditing/7. Precision as displayed.mp411.21MB
25. ~Get Your Files Here !/6. Pivot Tables/1. Introduction to Pivot Tables, Data Models and Power Pivot.mp412.1MB
26. ~Get Your Files Here !/6. Pivot Tables/10. Issues with usage of calculated fields and items.mp418.64MB
27. ~Get Your Files Here !/6. Pivot Tables/11. Solution for FAQ for pivot table related issues.mp417.07MB
28. ~Get Your Files Here !/6. Pivot Tables/2. Legacy Pivot Table - Data Source - Single Sheets.mp445.52MB
29. ~Get Your Files Here !/6. Pivot Tables/3. Other Data Sources - Multiple Sheets, External Data and Existing pivot table.mp416.57MB
30. ~Get Your Files Here !/6. Pivot Tables/4. Simple Data Model and Power Pivot.mp424.87MB
31. ~Get Your Files Here !/6. Pivot Tables/5. Filtering the data - Report Level, Slicers, Timelines - Label & Value filters.mp442.07MB
32. ~Get Your Files Here !/6. Pivot Tables/6. Sort the data in Pivot Table - Ascending, Descending, Manual or Custom Sort.mp429.44MB
33. ~Get Your Files Here !/6. Pivot Tables/7. Grouping Records and rename fields or groups.mp410.71MB
34. ~Get Your Files Here !/6. Pivot Tables/8. Different options for summarize values by.mp417.82MB
35. ~Get Your Files Here !/6. Pivot Tables/9. Conditional Formatting - Heat Map, Data Bars, Sparklines.mp410.3MB
36. ~Get Your Files Here !/7. Overall governance around spreadsheets/1. Overall Governance around spreadsheets.mp43.39MB
37. ~Get Your Files Here !/7. Overall governance around spreadsheets/2. SIPOC Model - suggested approach to create, maintain and monitor spreadsheets.mp412.96MB
38. ~Get Your Files Here !/7. Overall governance around spreadsheets/3. Inventory of all FILES in a folder and creating Index of sheets within a File.mp419.02MB