This intermediate Microsoft Excel training course is suitable whatever version of Excel you use, from 2007 – 2016, you will expand your knowledge and skills. By the end of this course, you will be able to create charts, work effectively with multiple sheets in workbooks, use basic functions effectively, use productivity tools and work with the Excel list/database features.

Led by highly experienced Microsoft Excel trainers with many years of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks.

This course is instructor led, involving the use of numerous examples and exercises in a workshop environment in order to allow you plenty of time to practice and consolidate your learning. We  train on version 2016 which is almost identical to 2007, 2010 and 2013, please make the trainer aware on the day if you use a another version and they can point out anything that may be slightly different.

Once you have completed this you will be ready to move onto our Advanced Excel course.
Course Walk-Through Video


Download the course details

By the end of this course, students will be able to create and format charts, work effectively with multiple sheets in workbooks,  use productivity tools, copy and paste data in the format you want it in, quick analysis tools and work with the Excel list/database features.

Having practiced all of these new skills extensively during the course you will be able to hit the ground running on your return to the office and should be able to complete your Excel work far more quickly.

This course assumes that you have gained a basic understanding of Windows. Additionally, students should have an understanding of concepts covered in the Excel Essentials course. These include creating workbooks, using AutoFill and AutoSum, constructing formulae, Absolute Cell References and formatting worksheets.

If you are unsure if this course is the appropriate level for you please either contact us or use our Excel level analyser tool to advise you.

Our courses run from 9.30 am to approximately 4.15pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with us you get the following:

  • A full colour training manual/book.
  • The exercises that you have worked on during your course to allow you to practice afterwards.
  • USB stick to take the exercises away.
  • Certificate of attendance
  • Freshly prepared lunch.
  • Refreshments throughout the day.
  • Training in fully air conditioned facilities from an experienced instructor.

Being able to manipulate and control worksheets is a key skill in Excel. This will show you how to make your worksheets do exactly what you want them to, and also how to format them to make working with them clearer. It also covers hiding and unhiding rows and columns within a worksheet.

The key topics covered include:

  • Renaming, Inserting And Deleting Worksheets
  • Copying And Moving Worksheets
  • Hiding And Unhiding A Worksheet
  • Copying a worksheet to new and other workbooks
  • Changing Worksheet Tab Colours
  • Grouping Worksheets
  • Hiding and Unhiding Rows And Columns
  • Freezing Rows And Columns
  • Splitting Windows

As you become a more proficient Excel user it is very likely that your spreadsheets will contain more than one worksheet. This means that you then need to be able to link data from one worksheet to another worksheet, and potentially from one workbook to another workbook. This lesson leads you through how to do that quickly and simply.

The key topics covered include:

  • Understanding Data Linking
  • Linking Between Worksheets
  • Linking Between Workbooks
  • Updating Links Between Workbooks

The ability to quickly and simply create a chart or graph to illustrate the data in your spreadsheet is one of the most used parts of Excel. The chart wizard offers a huge number of potential chart types and presentation options. This session shows you how to create a simple chart and the basics of how to work with it.

The key topics covered include:

  • Understanding The Charting Process
  • Choosing The Chart Type
  • Creating A New Chart
  • Working With An Embedded Chart
  • Resizing The Chart
  • Dragging A Chart
  • Printing An Embedded Chart
  • Creating A Chart Sheet
  • Changing The Chart Type
  • Changing the Chart Layout
  • Changing The Chart Style
  • Printing A Chart Sheet
  • Embedding A Chart Into A Worksheet
  • Deleting A Chart
  • Understanding Chart Elements
  • Adding a Chart Title
  • Adding Axes Titles
  • Repositioning the Legend
  • Showing Data Labels
  • Showing Gridlines
  • Formatting the Chart Area
  • Adding a Trendline
  • Adding Error Bars
  • Adding a Data Table

Cutting and pasting in Excel can be tricky when working with different data types. As ever, Excel offers a number of options to ensure that it all works smoothly. This session will make sure that you get it right first time.

The key topics covered include:

  •  understanding pasting options
  •  pasting formulas
  •  paste values
  •  pasting without borders
  •  paste as a link
  •  paste as a picture
  • Transposing ranges
  • Copying comments
  • Copying validations
  • Copying column widths
  • Performing arithmetic with paste special
  • Copying formats with paste special
  • Add values and multiply values
  • Understanding Quick Analysis
  • Quick Formatting
  • Quick Charting
  • Quick Totals
  • Quick Sparklines
  • Quick Tables
  • Understanding Custom Views
  • Adding a Custom View
  • Creating a Custom View
  • Working With Custom Views
  • 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

Excel offers the ability to only change the formatting of cells meeting certain criteria. This can make finding key data in a large spreadsheet very quick and simple. This session shows you how to set the criteria that you are looking for and also how to format those cells to ensure that you can easily see them.

The key topics covered include:

  • 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
Dates & Prices

Course duration: 1 day

Choose location:

£275 (+VAT)

Have a question?

We're here to answer them

01483 688488

Contact us
We’re trusted by