Excel IKM Test 2025, IKM Excel assessment, Excel functions and formulas, data analysis exam, pivot t
Excel text function for computer proficiency test, Basic excel skills test,A dvanced excel test OJAS
AuditExcel Advanced Excel and Financial Model Training and Consulting
PowerQuery in Excel Data Ribbon (Get & Transform)
AuditExcel Advanced Excel and Financial Model Training and Consulting
Password User Only Sees Their Info
AuditExcel Advanced Excel and Financial Model Training and Consulting
Heat maps to compare IRR matrix results
AuditExcel Advanced Excel and Financial Model Training and Consulting
Excel main window options- scroll, minimize, freeze rows/ columns
AuditExcel Advanced Excel and Financial Model Training and Consulting
2 & 3 way lookup function in Excel (row, column & matrix area)
AuditExcel Advanced Excel and Financial Model Training and Consulting
Adding a last minute sensitivity option to Excel
AuditExcel Advanced Excel and Financial Model Training and Consulting
Ungroup sparklines in Excel (different scales)
AuditExcel Advanced Excel and Financial Model Training and Consulting
Introduction to Excel charts and graphs
AuditExcel Advanced Excel and Financial Model Training and Consulting
Time flag headers for Excel financial models
AuditExcel Advanced Excel and Financial Model Training and Consulting
Absolute & Relative referencing in Excel ($)- understand all versions
AuditExcel Advanced Excel and Financial Model Training and Consulting
Shortcut to add $ to Excel formula
AuditExcel Advanced Excel and Financial Model Training and Consulting
Conditional formatting examples
AuditExcel Advanced Excel and Financial Model Training and Consulting
Working with the colored boxes that appear on F2 shortcut
AuditExcel Advanced Excel and Financial Model Training and Consulting
Two variable sensitivity in Excel- property valuation
AuditExcel Advanced Excel and Financial Model Training and Consulting
Cell movement in Excel (select cell/s in quickest ways)
AuditExcel Advanced Excel and Financial Model Training and Consulting
Sparklines- mini charts WITHIN a single Excel cell (trend analysis)
AuditExcel Advanced Excel and Financial Model Training and Consulting
Expand Pivot tables with new Excel data (automatically)
AuditExcel Advanced Excel and Financial Model Training and Consulting
Add descriptions to cells with Excel comments
AuditExcel Advanced Excel and Financial Model Training and Consulting
Dollar signs in Excel- alternate explanation
AuditExcel Advanced Excel and Financial Model Training and Consulting
Customize cell borders in Excel
AuditExcel Advanced Excel and Financial Model Training and Consulting
Simple data filter in Excel example
AuditExcel Advanced Excel and Financial Model Training and Consulting
Paste special examples in Excel
AuditExcel Advanced Excel and Financial Model Training and Consulting
Basic Excel Calculations (plus, minus, multiply)
AuditExcel Advanced Excel and Financial Model Training and Consulting
Intro to Excel Beginners course
AuditExcel Advanced Excel and Financial Model Training and Consulting
Make Excel ALWAYS refer to a static input cell
AuditExcel Advanced Excel and Financial Model Training and Consulting
Format cells in Excel (23 tips)
AuditExcel Advanced Excel and Financial Model Training and Consulting
Limit what users enter into Excel cell e.g. whole number less than 10
AuditExcel Advanced Excel and Financial Model Training and Consulting
Product mix impacts using Conditional Formatting