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
2 & 3 way lookup function in Excel (row, column & matrix area)
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
Budget and Forecast Ex 1 Step 2 SOL 5b c
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
Shortcut to add $ to Excel formula
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
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
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
Dollar signs in Excel- alternate explanation
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
Introduction to Excel charts and graphs
AuditExcel Advanced Excel and Financial Model Training and Consulting
Customize cell borders in Excel
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
Conditional formatting examples
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
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
Intro to Excel Beginners course
AuditExcel Advanced Excel and Financial Model Training and Consulting
Product mix impacts using Conditional Formatting
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
Choose which row to use in Excel formula based on cell input
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
Group favorite Excel button shortcuts
AuditExcel Advanced Excel and Financial Model Training and Consulting
Restrict users from entering duplicate entries in Excel
AuditExcel Advanced Excel and Financial Model Training and Consulting
Simple sorting example in Excel