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:

· Understanding The Interface

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

· Entering And Formatting Data

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

· Sort, Filter & Slicers

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

· Basic Formula & Functions

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

· Conditional Formatting

Visually highlight important information automatically with colours or icons.

· Data Validation

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

· Logical If Functions

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

· Saving Your Workbook

Best practice for saving, autosave and file formats

· Converting Datasets To Tables

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