Excel Level 3

Short course

In Newcastle Upon Tyne and Washington

£ 165 + VAT

Description

  • Duration

    1 Day

Description

This course will enable delegates to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data.

Facilities

Location

Starts

Newcastle Upon Tyne (Tyne and Wear)
See map
Cuthbert House, City Road, Newcastle Upon Tyne, NE1 2ET

Starts

On request
Washington (Tyne and Wear)
See map
Suite 13, Vermont, House Concorde, NE37 2SQ

Starts

On request

To take into account

To ensure your success, we recommend that you have completed the Excel Level 2 course or have the equivalent skills. A basic understanding of mathematics is also required.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Course programme

Course Overview

This course will enable delegates to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data.
Prerequisites
  • To ensure your success, we recommend that you have completed the Excel Level 2 course or have the equivalent skills. A basic understanding of mathematics is also required.


Objectives


    Delegates will be able to :
  • Change the view of a spreadsheet to show a different layout without using any formatting tools, then change the data on the sheet to display different data values.
  • Create a PivotTable to manipulate and extract data, then create a chart to display the results.
  • Create a spreadsheet that will display multiple groups of records that can be updated from a single source.
  • Use the Goal Seek and Solver facilities to enable results to be predicted in a spreadsheet where data may be missing or unavailable.
  • Create a formula that will only add up or count records that match specific criteria.
  • Record a Macro that will automate a repetitive task and then assign it to a new button on a new toolbar.
Follow on Courses
  • Excel Pivot Tables
Training Options
  • Scheduled public course at one of our training venues
  • Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
  • Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
Whats Included
  • 1 delegate per computer
  • 12 Months telephone and email support
  • Comprehensive colour course manual and exercises
  • Use of a Modern Training suite with 19 inch flat screen monitors
  • Lunch (When at our training venue)
  • Refreshments (When at our training venue)
  • Relaxed refreshment area at our training room
Course Content
Lesson 1 : Outlining
  • Using the outline symbol
  • Removing the outline from a worksheet
  • Creating an outline automatically and manually
Lesson 2: Custom views
  • Displaying a different view
  • Deleting a custom view
  • Creating a custom view
Scenario
  • Deleting a Scenario
  • Editing a Scenario
  • Viewing a scenario
  • Setting up a scenario
Pivot tables
  • Modifying the settings for a pivot table field
  • Delete a pivot table
  • Refreshing a pivot table
  • Removing a field from a pivot table
  • Edit a pivot table at a later date
  • Creating a pivot table from an Excel list
  • Creating a PivotChart
  • Filtering the fields once your pivot table is created
  • Formatting your pivot table
  • Adding summary rows and columns and/or hiding certain field values
Macros
  • Setting a security option for your macros
  • Removing a button from a toolbar
  • Assigning a macro to a toolbar button
  • Creating your own toolbar
  • Editing a button on a worksheet
  • Assigning a macro to a button on a worksheet
  • Deleting a macro
  • Running a macro
  • Using relative references when recording a macro
  • Recording a macro
Look-up tables
  • Creating a HLOOKUP
  • Tips using VLOOKUP
  • Creating a VLOOKUP
Using tracers to help audit a worksheet
  • Removing all tracer arrows
  • Tracing dependents
  • Tracing precedents
  • Description of tracer arrows
Complex formulas
  • Entering a workbooks name, path and worksheet name into a cell
  • Now()
  • Round: To round a number to so many decimal places
  • The COUNTBLANK function
  • The COUNTIF function
  • The SUMIF function
  • The IF function
Styles
  • Copying styles from another workbook
  • Redefining a style using a formatted cell as an example
  • Applying a style using the menu
  • Deleting a style
  • Creating a style using the format cell dialogue box
  • Creating a style by example using the style command
Goal seek & solver
  • Solver
  • Goal Seek

Excel Level 3

£ 165 + VAT