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
Password User Only Sees Their Info
AuditExcel Advanced Excel and Financial Model Training and Consulting
Ungroup sparklines in Excel (different scales)
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
Dollar signs in Excel- alternate explanation
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
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
Shortcut to add $ to Excel formula
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
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
Basic Excel Calculations (plus, minus, multiply)
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
Customize cell borders in Excel