Link
  •  Home
  •  
  •  
  •  
    Your Basket is empty

  •  

We are in business for your business,
Supporting you at every turn

Intermediate Microsoft Excel - Hereford

Home / Training / Business Training / IT and Microsoft / Intermediate Microsoft Excel - Hereford- 07-11-2017

Intermediate Microsoft Excel - Hereford

Hereford Business Solutions Centre, Hereford HR2 6JL
£150 Members
+ VAT
 
Tuesday 07 November 2017
Event begins from 09:30 AM
Tuesday 07 November 2017 Event begins from 09:30 AM
£0

Microsoft Excel is a key competency that supports many day to day functions in an organisation. A working knowledge of this application is important  for most employees operating  in a business Environment. Microsoft Excel is one of the most used applications, across a wide variety of sectors. Having staff that are effective, proficient and efficient in their work will support the smooth running of your business and will support your staff to become more productive.
  
Course Overview
You’ve been using simply and competently Excel for a while now and feel you would like to really start to get to grip with the major concepts in terms of managing data lists and understanding complex formulas for problem solving.
Here is your chance to learn how to sort and filter data lists whether they be parts, customer or any set of business data. You may also rise to the challenge of learning about IF statements and producing key kpi measures using charting techniques. Perhaps you have only used formulas on one sheet before now you will learn about multi worksheet and workbook linking. All in all a great course to give you valuable business skills in this popular package.
 
Prerequisites

Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential. A good knowledge of Excel or attendance on the introductory course.

 

Course Objectives
By the end of this course delegates will know:
 
·         How to create chart and format them
·         How to sort lists and create custom sorted lists
·         How to apply the Sub total command to a sorted list
·         What auto, custom and advanced filtering are all about
·         How to use the IF complex formula to resolve various business problems
·         To lock cells and apply sheet protection
·         To consolidate data across workbooks and worksheets by commands and formulas
·         How to use sheet grouping
  
Business Impact
·         Develop key performance measures
·         Simplify business data
·         Practical skills that delegates can implement immediately.
·         Empower delegates to make an impact in their departments
·         Reduce time to perform essential business activities
 
 Your Course Tutor
John Legge (BSc (hons) in Computational Science, MIITT, MBCS) has a wealth of experience working as an IT consultant and trainer within the UK. He has worked extensively for many blue chip companies, especially in the manufacturing arena. Within the last few years he has developed courses and run public and one to one IT training in Microsoft Products for a variety of companies, and especially for the H&W Chamber Of commerce. He is a TAP qualified trainer and member of the Institute of IT Trainers.
 
 What Our Customers Say
"John's course was really good. Admittedly, I've used excel quite a bit, but I took away 100 percent of the information to use again, and an understanding to apply to data analysis work"   Julie Ellis - 3SDL Ltd
 
“I wanted to let you know that I really enjoyed the Intermediate Excel course. It has definitely motivated me to put some of the things I learnt into practice!”   Catherine Myatt - Spal Automotive
       
 What Next?
·         Advanced Excel
·         Excel Master Class
  
Trusted By companies in Herefordshire and Worcestershire including:
·         Herefordshire and Worcestershire Fire & Rescue Service
·         Worcester Bosch
·         Tyrrell's Crisps
·         Kingspan Insulation
·         University of Worcester
·         SMH Fleet Solutions
·         Oakland International
·         CMCA UK
·         Andrew Grant
·         3SDL
and many more.....
 
£150+VAT Members
£188+VAT Non-members


£150.00 Members (excludes VAT) / £188.00 Non members (excludes VAT)

Membership Saving £38

Login is required to receive the membership discount while booking online

Dates Available:

For more information please contact the Training Team

  training@hwchamber.co.uk      01905 673611