Microsoft Excel Level 3 Training Course - Smarter Working

Tuesday 29th October 2019 from 9:30am
7th Floor, Municipal Building, Kingsway, Widnes, WA8 7QF

New 1-day course for Microsoft Excel from just £135 including VAT (for Chamber Members)

 

Excel - Smarter Working

 

29th October - 9:30 to 16:00

Duration 1 day

 

Overview
This course will extend your knowledge of Excel by introducing concepts which will allow you to analyse numerical data more stringently and to automate commonly used procedures.

Recommended for
Staff who are already using Excel to analyse data and want to be able to extend their knowledge and work more efficiently.

What do you need to know already?
We will assume that you are already quite an experienced user of Excel and are familiar with:

  • Creating, editing and formatting spreadsheets which include formulas and a range of functions
  • Creating charts
  • Linking books and sheets together in various ways
     

 

Objectives

At the end of the training you will be able to successfully:

  • Create, use and save Excel templates
  • Use PivotTables to analyse and format data at different levels of detail
  • Use macros to automate common tasks
  • Handle text in Excel using string functions
  • Use data validation to improve accuracy and efficiency using the documentation and support provided.

 

Modules covered in this course

1. Templates
Templates help you increase productivity and standardisation by allowing you to specify all the things that each instance of a given spreadsheet must contain.

2. Macros
By creating macros which mimic interactive processes you can speed up your handling of repetitive tasks.

3. String-Handling Features and Functions
This group of functions allows you to examine data values in a variety of detailed and sophisticated ways.

4. PivotTables
This section introduces pivot tables, an analysis method that allows you to rapidly summarise repetitive data in great detail.

5. Data Validation
Use Data Validation to ensure that users enter data into specific columns according to given content rules.
 

We recommend that you bring real-life examples and problems from work with you so that you can go back to work after training having made real progress.


All courses are accompanied by detailed training notes and exercises. 

 

Courses run from 9:30 – 4:00. Refreshments and lunch are provided.

This course is priced at £135 including VAT for Chamber Members and £155 including VAT for Non-Members. 

« back to events

'Although NP Projects are a new member of Halton chamber, we are already experiencing significant benefits from our membership. First Tues breakfast networking event is well attended, we have already received and generated leads from meeting other chamber members at this venue. More importantly are the contacts we have made within the chamber and the buzz membership has created'.

Managed IT services and solutions, Brian Cosgrove (Director)

With thanks to our brand partners
Halton growth hub Astmoor Halebank Dats

© Halton Chamber of Commerce and Enterprise 2014. Registered in England Company Number 3115981.
Halton Chamber of Commerce & Enterprise, 7th Floor, Municipal Building, Kingsway, Widnes, WA8 7QF Terms and Conditions Privacy Policy