Microsoft Excel - 2010 Intermediate

Focus on Training

Course

In London-City, Birmingham and Peterborough

£ 195 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

You will use advanced formulas and work with various tools to analyse data in spreadsheets. You will also organise table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects. Learning Objectives Delegates will learn how toUse advanced formulasOrganise worksheet and table data using various techniquesCreate and modify chartsAnalyse data using PivotTables, Slicers, and PivotChartsInsert and modify graphic objects in a worksheetCustomise and enhance workbooks and the Microsoft Office Excel environment

Facilities

Location

Start date

Birmingham ((select))
B3 2HJ

Start date

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

Start date

On request
Peterborough (Cambridgeshire )
See map
Marriott Hotel, PE2 6GB

Start date

On request

About this course

Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

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
  • Microsoft Excel
  • Excel

Course programme

Lesson 1: Calculating Data with Advanced Formulas

  • 1A: Apply Cell and Range Names
  • 1B: Calculate Data Across Worksheets
  • 1C: Use Specialized Functions
  • 1D: Analyze Data with Logical and Lookup (vLookup) Function


Lesson 2: Organizing Worksheet and Table Data

  • 2A: Create and Modify Tables
  • 2B: Format Tables
  • 2C: Sort or Filter Data
  • 2D: Use Functions to Calculate Data


Lesson 3: Presenting Data Using Charts

  • 3A: Create a Chart
  • 3B: Modify Charts
  • 3C: Format Charts


Lesson 4: Analyzing Data Using PivotTables, Slicers and PivotCharts

  • 4A: Create a PivotTable Report
  • 4B: Filter Data Using Slicers
  • 4C: Analyze Data Using PivotCharts


Lesson 5: Inserting Graphic Objects

  • 5A: Insert and Modify Pictures and ClipArt
  • 5B: Draw and Modify Shapes
  • 5C: Illustrate Workflow Using SmartArt Graphics
  • 5D: Layer and Group Graphic Objects


Lesson 6: Customizing and Enhancing the Excel Environment

  • 6A: Customize the Excel Environment
  • 6B: Customize Workbooks
  • 6C: Manage Themes
  • 6D: Create and Use Templates

See related categories

Microsoft Excel - 2010 Intermediate

£ 195 + VAT

The best Excel courses

See all

See all