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