All Excel Workshops

All Excel Workshops

Duration

8 hours

All Excel Workshops

The Workshops will be delivered 1 Hour each Week.

Content of this workshop

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)

Duration

8 hours

Book All Excel Workshops

We have a range of great Excel products ready to use or to be customised to your needs

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.