| Available 24 Hours Monday - Friday | 01344208452
Please enter course

Got a quick question or comment?
Send us enquiry.

Enter your details and we will call you back to discuss your requirements

Excel Training | Excel Courses | Microsoft Excel Training

  • Learn how to Use & Apply Excel by your Accredited Microsoft Partner
  • Enhance Your Productivity at work with our Excel Tutorial
  • Gain a more advanced understanding of Microsoft Excel with this Masterclass
  • Courses delivered by Highly Experienced certified Excel instructors
  • Excel Training in Luxury Nationwide Venues
  • Book Online or Call 01344 203999 to speak to an Excel advisor today
Schedule
Course Dates, Locations & Prices (Top) | View Course Info
Course Name Date Location Duration Price Book Online
Microsoft Excel Masterclass 28/07/2017 Aberdeen
1 day £795 Book now Enquire
Microsoft Excel Masterclass 28/07/2017 Cardiff
1 day £795 Book now Enquire
Microsoft Excel Masterclass 28/07/2017 Liverpool
1 day £795 Book now Enquire
Microsoft Excel Masterclass 28/07/2017 Cambridge
1 day £795 Book now Enquire
Microsoft Excel Masterclass 04/08/2017 3 places left Manchester
1 day £499 Book now Enquire
Microsoft Excel Masterclass 04/08/2017 Belfast
1 day £795 Book now Enquire
Microsoft Excel Masterclass 04/08/2017 Glasgow
1 day £795 Book now Enquire
Microsoft Excel Masterclass 11/08/2017 Dublin
1 day €795 Book now Enquire
Microsoft Excel Masterclass 11/08/2017 Sheffield
1 day £795 Book now Enquire
Microsoft Excel Masterclass 17/08/2017 3 places left London
1 day £499 Book now Enquire
Microsoft Excel Masterclass 18/08/2017 3 places left Birmingham
1 day £499£199 Book now Enquire
Microsoft Excel Masterclass 18/08/2017 Southampton
1 day £795 Book now Enquire
Microsoft Excel Masterclass 18/08/2017 Newcastle
1 day £795 Book now Enquire
Microsoft Excel Masterclass 25/08/2017 Norwich
1 day £795 Book now Enquire
Microsoft Excel Masterclass 25/08/2017 Nottingham
1 day £795 Book now Enquire
Microsoft Excel Masterclass 01/09/2017 4 places left Manchester
1 day £499£199 Book now Enquire
Microsoft Excel Masterclass 01/09/2017 Edinburgh
1 day £795 Book now Enquire
Microsoft Excel Masterclass 08/09/2017 4 places left London
1 day £499 Book now Enquire
Microsoft Excel Masterclass 08/09/2017 Milton Keynes
1 day £795 Book now Enquire
Microsoft Excel Masterclass 15/09/2017 4 places left Birmingham
1 day £499 Book now Enquire

Course Information (Top) | View Dates & Pricing

Overview

Microsoft Excel Training

Introduction to Microsoft Excel Masterclass Course

Microsoft Excel course provides delegates with the vital knowledge and skills of creating and editing worksheets or workbooks. Microsoft Excel helps candidates to work with basic formulas, lists, illustrations, charts, and basic formatting tools and styles. This introductory course provides necessary skills to use pivot tables, assess or analyse worksheet data, utilise data tools, as well as create and manage macros.

Prerequisites

There are some prerequisites required for this course:
 
Candidates will need to have familiarity with using a computer as well as Windows 10.

Course Outline

1. Getting Started with Excel:
  • Starting Excel from the Desktop
  • Understanding the Excel Start Screen
  • The Excel Tab Interface
  • The Excel Workbook Screen
  • How Excel 2013 Works
  • Using the Ribbon
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Using Shortcut Menus
  • Understanding Dialogue Boxes
  • Launching Dialogue Boxes
  • Understanding the Quick Access Toolbar
  • Adding Commands to the QAT
  • Understanding the Status Bar
2. Sorting Data:
  • Understanding lists
  • Performing an alphabetical sort
  • Performing a numerical sort
  • Sorting on more than one column
  • Sorting numbered lists
  • Sorting by rows
  • Understanding filtering
  • Applying and using a filter
  • Clearing a filter
  • Creating compound filters
  • Multiple value filters
  • Creating custom filters
  • Using wildcards
 
3. Managing Tables
  • Creating a table
  • Inserting or deleting table records
  • Removing duplicates
  • Modifying a table
  • Sorting data in a table
  • Filtering data in a table
  • Adding and removing table columns
  • Naming tables
  • Resizing tables
  • Playing with table styles
  • Converting a table to a range
  • Deleting a table
4. Conditional Formatting:
  • Understanding conditional formatting
  • Highlighting cells containing values
  • Highlighting cells containing text
  • Highlighting duplicate values
  • Using top and bottom rules
  • Using data bars
  • Using colour scales
  • Using icon sets
  • Creating custom rules
  • The conditional formatting rules manager
  • Managing rules
  • Clearing rules
  • Using Sparklines
5. Working with Functions and Formulas:
  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Working with Names and Ranges
  • Working with Array Formulas
  • What if Formulas
  • Common Error Messages
6. Pivot Tables:
  • Create a PivotTable from an Excel data list
  • Add/remove/reorganise data fields
  • View data in more detail
  • Change how values are summarised
  • Refresh data/change data source
  • Filter PivotTable with Slicers/Timelines
  • Create and modify a PivotChart
  • VLOOKUP’s
7. Charts
  • Create and modify charts such as Pie, Column & Line
  • Format charts to enhance their presentation
  • Print charts​

TIPS and TIRCKs – Top 10 Shortcuts

  • Enter data or formulas in nonadjacent cells simultaneously
  • Copy data or formulas down a column instantly
  • Instantly enter today's date or time
  • Convert formulas to values with a simple drag
  • Adjust all or selected column widths or row heights in a flash
  • Display all worksheet formulas instantly
  • Create charts instantly with either of these keystroke shortcuts
  • Display Print Preview instantly
  • Undo, redo, and repeat with keystrokes
  • Zoom in and out quickly
FAQs

There hasn't been any questions asked about this course

What's Included?
  • Delegate pack consisting of course notes and exercises.
  • Manual.
  • Experienced Instructor.
  • Refreshments.

best-price      customer-charter

Why Choose us?
  • Certified and Approved

    We're accredited by leading training organisations including AXELOS, BCS, The Chartered Institute of IT, APMG, PMI, The Open Group and many more.


  • Best Price Guarantee

    As well as providing the best training in the industry, we'll also provide it at the best price. We'll beat any like for like quote from our competitors.


  • World's Largest Global Training Provider

    We offer training in the more locations than any other provider with over 1200 training locations globally.


  • Trusted by Industry Leading Brands

    We're proud of our range of high-profile clients including brands such as JP Morgan, HSBC, British Airways, BskyB, Sony, AT&T to name only a few


  • Hands-on, Expert Instructor-led Classroom Training

    All our trainers are hand-picked, highly experienced, subject matter experts, who can not only train you but also use real world and practical examples.


  • Dedicated 24/7 Support

    We are here to provide help and guidance before, during and after your training course to make sure you get the most from your training

Reviews
 Contact Us  More Courses

Happy Customers

Good materials, excellent tutor
518
Great course, value and tutor
I don't have the motivation to study after a long day's work nor did I want to spend months learning material which I need to apply in my role today, but The Knowledge Academy gave me the opportunity to learn what I needed to in a shorter space of time, and helped me pass the exam in order for me to get to where I wanted to be.
I received fantastic service from The Knowledge Academy before and during the training course. I would recommend this company to anyone who wanted to take part in the Excel Advanced training course
The trainer we were provided with had the ability to make the course come to life. I would like to thank him for helping me pass my exam and get to where I am today.
I felt extremely comfortable attending the course with The Knowledge Academy. We received refreshments throughout the day and regular breaks to ensure we could keep up with the instructor. I found this all helpful and would use this company again.
Fantastic experience with The Knowledge Academy! They were cheap, provided great service and an experienced trainer.
I was impressed by The Knowledge Academy and their ability to provide a great training course, with an experienced trainer at such a good price. I was asked to take this course by my employer - I was so impressed by them that our company will be using this company in the future.
Yes, this company is the cheapest...but they are also the best in the market. I have used a training provider before and The Knowledge Academy were by far the best. They were professional, cheap and experienced. I would most definitely use them again.
I recently completed the Excel training course with The Knowledge Academy and had an enjoyable week. I found that the experienced trainer made the concepts seem to simple and easy that I can now apply it everyday to my working life. Moreover, this training provider was also the cheapest in the market. It just proves you don't need to pay a fortune to get a great training course.
Course was just what I was after, thank you.
At first I found the content challenging, but with the help of the trainer I was soon on my way to success. Thank you.
Very happy with the course, I will be the tackling the advanced certificate next.
I would like to thank The Knowledge Academy for an excellent service, enquiring and booking was hassle free. I learned a lot and the trainer was great.
The trainer was great, he made it enjoyable learning the subject.
I have tried learning Excel on my own before but always found it confusing, this course was great.
Great course, really informative.
Really good course, and really good company, will be using TKA again.