AuditExcel Advanced Excel and Financial Model Training and Consulting
MS Excel micro learning. Subscribe to the 'Excel in 2 minutes' playlist for weekly clips in 2 minutes or less about a MS Excel tool, formula, tip or technique.
Our focus is on practical lessons that will immediately improve your Excel skills.
Occasionally we include some fun with Excel.
We offer a free MS Excel skills assessment on our site which will tell you what your Excel skill level is, and, based on what you do in excel, will recommend what you should be learning about (MS Excel is too big and too brilliant to learn everything in one go).
Stem Leaf Chart in Excel using dynamic arrays
Working through AuditExcel MS Excel online courses (& certificate download)
Online Excel Course Getting Started
Budget and Forecast Ex 1 Step 2 SOL 5a
Time flag headers for Excel financial models
Budget and Forecast Ex 1 Step 2 SOL 5b c
Using Pivot Tables to analyze soccer matches
Sales, Cost of Sales and Gross Profit in a Excel financial model
Turn monthly reports into an annual report in Excel
Changing multiple managements report sheets at the same time
Grouping ages using Excel (WITHOUT NESTED IFS)
Group number lists into text based categories in Excel
Sliding commission rate calculator for 3+ levels in Excel
Find tax payable where salary BETWEEN bands in Excel
How to remove quotation marks in Excel (with a formula)
Create custom calculations INSIDE a Pivot Table
Button to easily hide/ unhide Excel rows
Protect Excel Formula Cells from being changed/ overwritten
Sparklines- mini charts WITHIN a single Excel cell (trend analysis)
Budget vs Actuals Variance % and arrows- Example 1 Step 3 SOL
Budget vs Actuals Variance Chart Example 1 Step 2 SOL 1
Budget vs Actuals vs Forecast Example 1 Step 1 SOL 1
What is an Excel Spreadsheet
Add more data to Excel charts (recommended way and 2 shortcuts)
От ДД.ММ.ГГГГ до ГГГГ/ММ/ДД для дат Excel
Keep the Duplicates with Power Query in Excel
Fix "123.56" with PowerQuery to be usable number
Data Validation- dropdown lists/ stop wrong inputs in Excel
Working with the colored boxes that appear on F2 shortcut
Create simple Excel charts