Excel Level 2 (Intermediate)

Short course

In Guildford

£ 195 + VAT

Description

  • Type

    Short course

  • Location

    Guildford

  • Duration

    1 Day

For people who need more advanced Excel training. Suitable for: People who have a good understanding of the basic of Excel.

Facilities

Location

Start date

Guildford (Surrey)
See map
1 Portsmouth Road, GU2 4BL

Start date

On request

About this course

A good understanding 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

Course programme

Excel Level 2

Course Content

Lesson 1: Creating and Applying Templates

Topic 1A: Create a Workbook from a Template

Topic 1B: Create a Custom Template

Topic 1C: Working with Comments

Topic 1D: Create a Hyperlink

Topic 1E: Use Web-based Research Tools



Lesson 2: Creating and Modifying Charts

Topic 2A: Create a Chart

Topic 2B: Format Chart Items

Topic 2C: Change the Chart Type

Topic 2D: Create a Diagram



Lesson 3: Working with Graphic Objects

Topic 3A: Insert Graphics

Topic 3B: Create AutoShapes

Topic 3C: Format Graphic Objects

Topic 3D: Change the Order of Graphic Objects

Topic 3E: Group Graphic Objects

Topic 3F: Move, Copy, and Resize Graphic Objects



Lesson 4: Calculating with Advanced Formulas

Topic 4A: Create and Apply a Name for a Range of Cells

Topic 4B: Calculate Across Worksheets

Topic 4C: Calculate with Date and Time Functions

Topic 4D: Calculate with Financial Functions

Topic 4E: Calculate with Statistical Functions

Topic 4F: Calculate with Lookup and Reference Functions

Topic 4G: Calculate with Logical Functions



Lesson 5: Sorting and Filtering Data

Topic 5A: Sort Data Lists

Topic 5B: Filter Data Lists

Topic 5C: Create and Apply Advanced Filters

Topic 5D: Calculate with Database Functions

Topic 5E: Add Subtotals to a Worksheet



Lesson 6: Using Excel with the Web

Topic 6A: Export Excel Data

Topic 6B: Publish a Worksheet to the Web

Topic 6C: Import Data from the Web

Topic 6D: Create a Web Query


Additional information

Support: None
Payment options: Fee includes lunch, workbook and refreshments.
Students per class: 300

Excel Level 2 (Intermediate)

£ 195 + VAT