Basic Excel
Week 1 : Column Width & Row Height / Formatting / Paste Special / Filter / Sort
Week 2 : Freeze Panes / Find / Conditional Formatting / Print Range & Page Set Up
Week 3 : Basic formula; we will look at 11 simple formula and different ways of entering them and how to check if they’re right.
Intermediate Excel
Week 1 : Keyboard Shortcuts / Dollar Symbol / Concatenate Formula / Blobby (Fill Handle)
Week 2 : Named Ranges / Data Validation / Protect Workbooks
Advanced Excel
Week 1 : Data Set Up / If Formula / Nested If Formula / VLOOKUP
Week 2 : Pivot Tables / Pivot Charts / Timelines & Slicers
Week 3: Linking Files / Macros’ (Basic)
8 hours
A range of ACE ready made products, from book-keeping to absence tracking, which you can use straight away to help keep your business moving.
Take a look at our range of Free Products ready to download and use today
EXCELACE ALL RIGHTS RESERVED.
WEBSITE BY FARM FACTORy