Mastering Microsoft Excel: Intermediate
Course Overview
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 Zoom
Date: tbc
Time: 9.30am-4pm
Price: £80
Group pricing is also available - just ask!
For further information on this course and its start dates contact corporate@wcs.ac.uk or call 0141 581 2121
Find out more and Apply
To apply to this course or find out how we can best meet your specific needs, including by delivering tailor-made courses, please contact us.
Need funding? Visit our dedicated page to find out how you can get support.
Learn more about West College Scotland
Online Learning
Looking for a flexible way to study that suits your lifestyle and commitments? Our Online learning options are for you!
More details about Online Learning
More details about Online Learning
Conference Facilities
Industry Stories
At West College Scotland we're proud of the partnerships we've developed with many businesses over the years. We've helped develop people and products for large and small companie...
More details about Industry Stories
More details about Industry Stories