Connect: Excel Essentials

This workshop will teach you how to use Excel more confidently and efficiently - from essential tools and shortcuts to techniques that boost accuracy and save time. If you are using Excel on a regular basis but you feel that you could be using it better, this course is for you.

The workshop will cover:

An overview of the Excel screen, tabs, ribbons and basic navigational tools.

Understanding how you can help Excel deal with text, dates and number formats.

Organise your data with ease using sort, show only what you need using filter or slicers.

Use simple formula to add, subtract or multiply and generate a function to sum or average. Functions included: SUM, AVERAGE

Visually highlight important information automatically with colours or icons.

Define rules to control what users can enter into a cell to keep your data accurate.

Use simple logical questions to test conditions and provide true/false options. Functions included: IF

Best practice for saving, autosave and file formats

Structure your data into a table to make it easier to read and work with.

Also check out other Workshops in Stockton-on-Tees.