Microsoft Excel Advanced 2010/2013

Course

In London-City, Birmingham and Reading

£ 195 + VAT

Description

  • Type

    Course

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010 or 2013 tools and concepts in order to increase their knowledge and productivity.

Target AudienceUsers with a good understanding of Microsoft Excel 2007, 2010 or 2013 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Class sizes Maximum class size for Excel Advanced (2007, 2010 & 2013) courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates. What happens on the day If you are coming to our centre, dress code is smart casual.   Refreshments and a free buffet lunch will be provided, but please note that, as a training company who relies on caterers, we are unable to reliably provide for differing dietary requirements, so if you are in any doubt then please bring your own.  The timetable is roughly as follows: 9:15: - Arrival time9:30: - Training starts11:00: - Mid-morning break1:00: - Lunch break (one hour)3:15: - Mid-afternoon break4:30: - Wrap up Note: break times can vary according to the needs of the training, and course duration for smaller class sizes can be shorter because fewer delegates have fewer questions! Learning Objectives Understand how to Outline, Group and apply SubTotals to summarise a spreadsheetDemonstrate usage and understanding of Goal Seek, Scenario Manager and Solver toolsSummarise and present data effectively by adding and customising Pivot TablesDemonstrate the use and customisation of Pivot Charts to enhance data summaryUnderstand and file sharing functions, create special lists and add hyperlinksUnderstand and use Vlookup, HLookup and Lookup Functions to retrieve data withCreate basic Macros and use VBA...

Facilities

Location

Start date

Birmingham ((select))
B3 2HJ

Start date

On request
London-City ((select))
EC3V 9LJ

Start date

On request
Reading ((select))
RG1 1LX

Start date

On request

About this course

A sound working knowledge of Excel

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • Microsoft excel training
  • Spreadsheet
  • Microsoft Excel
  • Excel

Course programme

MODULE 1: Grouping & Outlining and Subtotals

Learning outcomes:

Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.

Topics covered:

  • Outlining and Grouping Data
  • Using the Subtotals Tool

MODULE 2: What-If Analysis

Learning outcomes:

Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas.

Topics covered:

  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

MODULE 3: PivotTables

Learning outcomes:

Creating Pivot Tables in order to display and summarise large quantities of data effectively.

Topics covered:

  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers

MODULE 4: Charting Pivoted Data

Learning outcomes:

Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.

Topics covered:

  • Getting Started with PivotCharts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart

MODULE 5: Advanced Excel Tasks

Learning outcomes:

Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.

Topics covered:

  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks

MODULE 6: Creating HLOOKUP and VLOOKUP Functions

Learning outcomes:

Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.

Topics covered:

  • Using the VLOOKUP Function
  • Using the LOOKUP Function

MODULE 7: Introduction to Macros in Excel

Learning outcomes:

Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.

Topics covered:

  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros

Microsoft Excel Advanced 2010/2013

£ 195 + VAT