589689.xyz

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

  • 收录时间:2022-05-12 11:48:41
  • 文件大小:1020MB
  • 下载次数:1
  • 最近下载:2022-05-12 11:48:41
  • 磁力链接:
立即下载 复制链接

文件列表

  1. ~Get Your Files Here !/5. Formula Auditing/3. Formula Auditing - Identifying Errors.mp4 122MB
  2. ~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 70MB
  3. ~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 70MB
  4. ~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 55MB
  5. ~Get Your Files Here !/6. Pivot Tables/2. Legacy Pivot Table - Data Source - Single Sheets.mp4 46MB
  6. ~Get Your Files Here !/5. Formula Auditing/5. Referencing - Relative & Absolute, Structured, Named Ranges cells - Part 1.mp4 43MB
  7. ~Get Your Files Here !/6. Pivot Tables/5. Filtering the data - Report Level, Slicers, Timelines - Label & Value filters.mp4 42MB
  8. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/6. Compare files.mp4 34MB
  9. ~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 33MB
  10. ~Get Your Files Here !/5. Formula Auditing/2. Precedents dependent cells, Evaluate partial or full formula stepwise.mp4 33MB
  11. ~Get Your Files Here !/6. Pivot Tables/6. Sort the data in Pivot Table - Ascending, Descending, Manual or Custom Sort.mp4 29MB
  12. ~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 27MB
  13. ~Get Your Files Here !/5. Formula Auditing/4. Checking the Formula Text to locate errors and deceptions in spreadsheets.mp4 25MB
  14. ~Get Your Files Here !/6. Pivot Tables/4. Simple Data Model and Power Pivot.mp4 25MB
  15. ~Get Your Files Here !/2. Get started with Excel/3. Selecting Data in Excel and Navigating through file.mp4 24MB
  16. ~Get Your Files Here !/5. Formula Auditing/6. Referencing - Relative & Absolute, Structured, Named Ranges cells - Part 2.mp4 24MB
  17. ~Get Your Files Here !/2. Get started with Excel/2. Ribbon and Quick access toolbar.mp4 20MB
  18. ~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 20MB
  19. ~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 19MB
  20. ~Get Your Files Here !/6. Pivot Tables/10. Issues with usage of calculated fields and items.mp4 19MB
  21. ~Get Your Files Here !/6. Pivot Tables/8. Different options for summarize values by.mp4 18MB
  22. ~Get Your Files Here !/1. Introduction and requirements for the course/2. Download and Install - Power Query and ASAP Utilities.mp4 18MB
  23. ~Get Your Files Here !/6. Pivot Tables/11. Solution for FAQ for pivot table related issues.mp4 17MB
  24. ~Get Your Files Here !/6. Pivot Tables/3. Other Data Sources - Multiple Sheets, External Data and Existing pivot table.mp4 17MB
  25. ~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 15MB
  26. ~Get Your Files Here !/7. Overall governance around spreadsheets/2. SIPOC Model - suggested approach to create, maintain and monitor spreadsheets.mp4 13MB
  27. ~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 13MB
  28. ~Get Your Files Here !/5. Formula Auditing/1. Operators and Order of operations used in Excel for calculations.mp4 13MB
  29. ~Get Your Files Here !/6. Pivot Tables/1. Introduction to Pivot Tables, Data Models and Power Pivot.mp4 12MB
  30. ~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 12MB
  31. ~Get Your Files Here !/5. Formula Auditing/7. Precision as displayed.mp4 11MB
  32. ~Get Your Files Here !/1. Introduction and requirements for the course/1. Introduction to this course syllabus.mp4 11MB
  33. ~Get Your Files Here !/6. Pivot Tables/7. Grouping Records and rename fields or groups.mp4 11MB
  34. ~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 11MB
  35. ~Get Your Files Here !/6. Pivot Tables/9. Conditional Formatting - Heat Map, Data Bars, Sparklines.mp4 10MB
  36. ~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 10MB
  37. ~Get Your Files Here !/2. Get started with Excel/1. ALL keyboard shortcuts in Excel.mp4 8MB
  38. ~Get Your Files Here !/7. Overall governance around spreadsheets/1. Overall Governance around spreadsheets.mp4 3MB
  39. ~Get Your Files Here !/6. Pivot Tables/10.1 Calculated fields and Items.xlsx 2MB
  40. ~Get Your Files Here !/6. Pivot Tables/7.1 Sorting and grouping in pivot table.xlsx 2MB
  41. ~Get Your Files Here !/6. Pivot Tables/6.1 Sorting and grouping in pivot table.xlsx 2MB
  42. ~Get Your Files Here !/6. Pivot Tables/8.1 Summarize Values by....xlsx 2MB
  43. ~Get Your Files Here !/6. Pivot Tables/5.1 Filtering data in Pivot Table.xlsx 2MB
  44. ~Get Your Files Here !/6. Pivot Tables/9.1 Conditional Formatting.xlsx 2MB
  45. ~Get Your Files Here !/7. Overall governance around spreadsheets/1.2 Spreadsheet Modelling Best Practice.pdf 1MB
  46. ~Get Your Files Here !/6. Pivot Tables/11.1 FAQ on Pivot Tables.xlsx 1MB
  47. ~Get Your Files Here !/6. Pivot Tables/2.1 Single Sheet.xlsx 928KB
  48. ~Get Your Files Here !/7. Overall governance around spreadsheets/1.3 Spreadsheet Policy # XYZ.pdf 494KB
  49. ~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 426KB
  50. ~Get Your Files Here !/2. Get started with Excel/3.1 Navigate.png 336KB
  51. ~Get Your Files Here !/6. Pivot Tables/3.1 External Data.xlsx 329KB
  52. ~Get Your Files Here !/6. Pivot Tables/4.1 Data Model.xlsx 232KB
  53. ~Get Your Files Here !/7. Overall governance around spreadsheets/1.1 Overall Governance.pdf 232KB
  54. ~Get Your Files Here !/2. Get started with Excel/3.3 Selection of Data in Excel.JPG 159KB
  55. ~Get Your Files Here !/3. Features that will speed up your review and auditing process/4.1 Find & Replace.xlsx 121KB
  56. ~Get Your Files Here !/5. Formula Auditing/4.1 Formula Auditing.xlsx 100KB
  57. ~Get Your Files Here !/3. Features that will speed up your review and auditing process/3.1 Go to window.xlsx 96KB
  58. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/2.2 Inquire Basics V1.xlsx 95KB
  59. ~Get Your Files Here !/4. Inquire tool add in to perform through analysis of any Excel file automatically/6.1 Inquire Basics V2.xlsx 93KB
  60. ~Get Your Files Here !/5. Formula Auditing/5.1 Referencing.xlsx 70KB
  61. ~Get Your Files Here !/2. Get started with Excel/1.4 Excel Shortucts - Special Keys - 2.png 45KB
  62. ~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 41KB
  63. ~Get Your Files Here !/2. Get started with Excel/1.2 Excel Shortucts - Function Keys.png 39KB
  64. ~Get Your Files Here !/2. Get started with Excel/1.3 Excel Shortucts - Special Keys - 1.png 37KB
  65. ~Get Your Files Here !/2. Get started with Excel/1.1 Excel Shortucts - Alphabet Keys.png 36KB
  66. ~Get Your Files Here !/7. Overall governance around spreadsheets/2.1 SIPOC Model.xlsx 16KB
  67. ~Get Your Files Here !/6. Pivot Tables/3.2 Multiple Sheets.xlsx 16KB
  68. ~Get Your Files Here !/2. Get started with Excel/3.2 Selecting Data.xlsx 11KB
  69. ~Get Your Files Here !/5. Formula Auditing/1.1 Operators and Order of Operations.xlsx 10KB
  70. ~Get Your Files Here !/5. Formula Auditing/7.1 Precision as Displayed.xlsx 10KB
  71. ~Get Your Files Here !/Bonus Resources.txt 386B
  72. ~Get Your Files Here !/8. Bonus Lecture/1. Bonus Lecture - discount on my other courses.html 352B
  73. Get Bonus Downloads Here.url 181B