Select Page

Intermediate Microsoft Excel – Part 1 – Charts and Managing Data Lists

Non-member price

£120.00 +VAT

Please login to purchase

Places Available

Location: Cisco Webex, Virtual Training, Online, .

Start: 2nd Dec 2020 9:00am to 12:30pm


This half day session covers creating Excel charts, Sorting, Data Sub totaling and Filtering and conditional formatting and removal of duplicate rows of data.

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.

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

Business Benefits

  • 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 25 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.

Your Feedback
Your Feedback
Questions? We're here to help you!
Thanks for using our brand new website. We would love to hear your thoughts and suggestions.
Our operators are busy. Please try again later
Have you got a question? Write to us!
This chat session has ended
Was this conversation useful? Vote this chat session.
Good Bad