Overview
Aimed at the intermediate user, this will cover creating and editing spreadsheets. Participants should have some pre-existing knowledge of Excel.
Attending this intermediate-level Excel workshop will help you to:
- Learn great shortcuts of navigation, selection and commands
- Apply exciting formula to save you time, such as if statements, nested if statements, sum-if and count-if – to name a few
- Protect your worksheets and workbooks
- Apply great data validation techniques, allowing you to automate functions off entered text
- Manipulate text data through formula
- Work efficiently with relative and absolute referencing
- Link cells, worksheets and workbooks to create dynamic automatic reports
- Using templates within excel
Duration: 1 Day
Study Mode: Online via Teams
Time: 9.30am-4pm
Price: £90
Date:
Group pricing is also available - just ask!
For further information on this course, contact businesstraining@wcs.ac.uk or call 0141 468 4163.
