~Get Your Files Here !/1. Introduction and requirements for the course/1. Introduction to this course syllabus.mp4
11 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 !/2. Get started with Excel/1. ALL keyboard shortcuts in Excel.mp4
7.7 MB
~Get Your Files Here !/2. Get started with Excel/1.1 Excel Shortucts - Alphabet Keys.png
35.5 KB
~Get Your Files Here !/2. Get started with Excel/1.2 Excel Shortucts - Function Keys.png
39 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.4 Excel Shortucts - Special Keys - 2.png
44.7 KB
~Get Your Files Here !/2. Get started with Excel/2. Ribbon and Quick access toolbar.mp4
20.5 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 !/2. Get started with Excel/3.1 Navigate.png
336.4 KB
~Get Your Files Here !/2. Get started with Excel/3.2 Selecting Data.xlsx
10.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/1. Watch Window - keep selected cells results displayed at all times.mp4
10 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 !/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/3.1 Go to window.xlsx
95.5 KB
~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 !/3. Features that will speed up your review and auditing process/4.1 Find & Replace.xlsx
121.3 KB
~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 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 !/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 !/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 !/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/3. Workbook Analysis Report - Part 1.mp4
26.5 MB
~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 !/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 !/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 !/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/6.1 Inquire Basics V2.xlsx
93 KB
~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 !/5. Formula Auditing/1. Operators and Order of operations used in Excel for calculations.mp4
12.6 MB
~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/2. Precedents dependent cells, Evaluate partial or full formula stepwise.mp4
32.5 MB
~Get Your Files Here !/5. Formula Auditing/3. Formula Auditing - Identifying Errors.mp4
122.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 !/5. Formula Auditing/4.1 Formula Auditing.xlsx
99.8 KB
~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 !/5. Formula Auditing/5.1 Referencing.xlsx
70.3 KB
~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 !/5. Formula Auditing/7. Precision as displayed.mp4
11.2 MB
~Get Your Files Here !/5. Formula Auditing/7.1 Precision as Displayed.xlsx
9.9 KB
~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 !/6. Pivot Tables/10. Issues with usage of calculated fields and items.mp4
18.6 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/11. Solution for FAQ for pivot table related issues.mp4
17.1 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. Legacy Pivot Table - Data Source - Single Sheets.mp4
45.5 MB
~Get Your Files Here !/6. Pivot Tables/2.1 Single Sheet.xlsx
927.8 KB
~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 !/6. Pivot Tables/3.1 External Data.xlsx
328.7 KB
~Get Your Files Here !/6. Pivot Tables/3.2 Multiple Sheets.xlsx
16.1 KB
~Get Your Files Here !/6. Pivot Tables/4. Simple Data Model and Power Pivot.mp4
24.9 MB
~Get Your Files Here !/6. Pivot Tables/4.1 Data Model.xlsx
232 KB
~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 !/6. Pivot Tables/5.1 Filtering data in Pivot Table.xlsx
2.2 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 !/6. Pivot Tables/6.1 Sorting and grouping in pivot table.xlsx
2.2 MB
~Get Your Files Here !/6. Pivot Tables/7. Grouping Records and rename fields or groups.mp4
10.7 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/8. Different options for summarize values by.mp4
17.8 MB
~Get Your Files Here !/6. Pivot Tables/8.1 Summarize Values by....xlsx
2.2 MB
~Get Your Files Here !/6. Pivot Tables/9. Conditional Formatting - Heat Map, Data Bars, Sparklines.mp4
10.3 MB
~Get Your Files Here !/6. Pivot Tables/9.1 Conditional Formatting.xlsx
2 MB
~Get Your Files Here !/7. Overall governance around spreadsheets/1. Overall Governance around spreadsheets.mp4
3.4 MB
~Get Your Files Here !/7. Overall governance around spreadsheets/1.1 Overall Governance.pdf
231.8 KB
~Get Your Files Here !/7. Overall governance around spreadsheets/1.2 Spreadsheet Modelling Best Practice.pdf
1.3 MB
~Get Your Files Here !/7. Overall governance around spreadsheets/1.3 Spreadsheet Policy # XYZ.pdf
494.3 KB
~Get Your Files Here !/7. Overall governance around spreadsheets/2. SIPOC Model - suggested approach to create, maintain and monitor spreadsheets.mp4
13 MB
~Get Your Files Here !/7. Overall governance around spreadsheets/2.1 SIPOC Model.xlsx
16.2 KB
~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 MB
~Get Your Files Here !/8. Bonus Lecture/1. Bonus Lecture - discount on my other courses.html