Get Bonus Downloads Here.url

   1. Introduction to this course syllabus.mp4

   1. ALL keyboard shortcuts in Excel.mp4

   1.2 Excel Shortucts - Function Keys.png

   1.4 Excel Shortucts - Special Keys - 2.png

   3. Selecting Data in Excel and Navigating through file.mp4

   3.2 Selecting Data.xlsx

   1. Watch Window - keep selected cells results displayed at all times.mp4

   3. Go To Window and Special - detailed explanation of all items.mp4

   4. Find & select with formatting of selected cell or as per selected format setting.mp4

   5. Printing set up in Excel explained in detail with various settings.mp4

   1. Introduction to Inquire Add-in and activating it in Excel.mp4

   2.1 Inquire Add in in Excel.docx

   3. Workbook Analysis Report - Part 1.mp4

   4. Workbook Analysis Report - Part 2.mp4

   6. Compare files.mp4

   7. Clean Excess Cell Formatting and Workbook Passwords.mp4

   1. Operators and Order of operations used in Excel for calculations.mp4

   2. Precedents dependent cells, Evaluate partial or full formula stepwise.mp4

   4. Checking the Formula Text to locate errors and deceptions in spreadsheets.mp4

   5. Referencing - Relative & Absolute, Structured, Named Ranges cells - Part 1.mp4

   6. Referencing - Relative & Absolute, Structured, Named Ranges cells - Part 2.mp4

   7.1 Precision as Displayed.xlsx

   1. Introduction to Pivot Tables, Data Models and Power Pivot.mp4

   10.1 Calculated fields and Items.xlsx

   11.1 FAQ on Pivot Tables.xlsx

   2.1 Single Sheet.xlsx

   3.1 External Data.xlsx

   4. Simple Data Model and Power Pivot.mp4

   5. Filtering the data - Report Level, Slicers, Timelines - Label & Value filters.mp4

   6. Sort the data in Pivot Table - Ascending, Descending, Manual or Custom Sort.mp4

   7. Grouping Records and rename fields or groups.mp4

   8. Different options for summarize values by.mp4

   9. Conditional Formatting - Heat Map, Data Bars, Sparklines.mp4

   1. Overall Governance around spreadsheets.mp4

   1.2 Spreadsheet Modelling Best Practice.pdf

   2. SIPOC Model - suggested approach to create, maintain and monitor spreadsheets.mp4

   3. Inventory of all FILES in a folder and creating Index of sheets within a File.mp4

   1. Bonus Lecture - discount on my other courses.html

  Bonus Resources.txt