Overview Step 1 creating a series Step 2 adjust row heights Step 3 add column totals Step 4 add a names column Step 5 add column headers Step 6 add currency formatting Step 7 freeze the column headings Step 8 add a Salary column Step 9 add a conditional formula Step 10 add a COUNTIF formula Step 11 utilising binary cells Step 12 applying Conditional Formatting Step 13 adding text cells Step 14 adding an AVERAGE Step 15 adding calculations Step 16 adding a Filter Step 17 add a Pie Chart graphic Step 18 using the IF and CONCAT functions ADDITIONAL Work with times ADDITIONAL Printing Advanced Topics Pivot Tables Advanced Topics Macros Advanced Topics VLOOKUPs Final Steps Articles/Excel101 Excel training
Written: Jan-2026
Final Steps Ok - Finally - you're hopefully ready to get going with Excel - and the only thing I can say here is - make sure you've customized your Quick Access Toolbar for quick access to those tools you might find you need regularly, and this is my suggestion:
using:
square chevron_left Advanced-Topics-VLOOKUPs
