Computer Tutoring Logo
Est. 2002
Menu Button

Cost Calculator

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live Online Face-to-Face
First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

West Midlands Fire Service

"It was great - delivered at our pace with lots of chances to ask questions. It was really useful to develop some reports using some of our real data, not just "training" data."

Uniserve

"Very informative and energetic. Definitely explained in a way which made sense."

TCN UK

Live Online Excel Training "Great. Enthusiastic trainer. Engaging with everyone involved. Runs through things at a good speed. Able to explain at a technical and non-technical level that is easy to digest."

South Norfolk Council

"The training was exactly what I needed to enhance my self-taught skills in Power BI. To be shown the capability and understand the programming (DAX) will enable me to produce templates for use within the organisation. The pace and interactivity was great and Simon was a fantastic trainer in getting everyone involved and imparting his knowledge of the product."

Microsoft Excel 2007 Training Course Intermediate

Microsoft Excel 2007 Overview

In this training course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts and graphics. You will use advanced formulas to display data in various formats, giving your documents a more professional look.

Other Excel training courses

Course Duration: 1 Day

Course Outline

Enhancing Workbooks using Microsoft Excel 2007

  • Customize the Excel Environment
  • Customize an Excel Worksheet
  • Enhance Worksheets Using Themes
  • Work with Comments
  • Access External Resources Using Hyperlinks
  • Use Web-Based Research Tools

Creating Workbooks Using Templates in Excel 2007

  • Create a Workbook from a Template
  • Create a Custom Template

Organizing Data Using Tables in Excel 2007

  • Create Tables
  • Modify Tables
  • Format Tables

Presenting Data Using Charts in Excel 2007

  • Create a Chart
  • Modify Charts
  • Format Charts
  • Create a Chart Template
  • Share Excel Charts

Analyzing Data Using PivotTables and PivotCharts in Excel 2007

  • Create a PivotTable
  • Perform Calculations Using PivotTables
  • Analyze Data Using PivotCharts

Enhancing Visual Appeal Using Graphic Objects in Excel 2007

  • Insert Graphics
  • Modify Graphic Objects
  • Emphasize an Area of a Worksheet
  • Illustrate Workflow Using SmartArt Graphics
  • Format Graphic Objects
  • Change the Order of Layered Graphic Objects
  • Group Graphic Objects
  • Organize Graphic Objects

Calculating Data with Advanced Formulas in Excel 2007

  • Refer to a Range of Cells
  • Calculate Data Across Worksheets
  • Perform Date and Time Calculations
  • Format Text Using Formulas
  • Perform Numeric Calculations
  • Calculate Data with Lookup & Reference Functions
  • Perform Logical Analysis
  • Print Formulas

Sorting and Filtering Data in Excel 2007

  • Sort Data in a Spreadsheet
  • Filter Data in a Spreadsheet
  • Calculate Large Volumes of Data
  • Add Subtotals to a Worksheet

Classroom based Intermediate Excel Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the following form to calculate how much.

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

Live Online Classroom
First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

I would like to receive software tips and special offers





Microsoft Excel 2007 Training Course Intermediate