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

Leicestershire Police

"Really informative ! The trainer was patient and knowledgeable and was able to answer all the questions we had. Going over things we have covered again if required .I really enjoyed the session"

Supply Chain Academy

"I would like to say a big thank you for Simon for all of his help. His training has helped to bring back some of my lost knowledge and also have expanded my knowledge too! Will definitely be recommending to others. Thank you so much once again."

Doppelmayr Cable Car

"This course shows me how to use Excel in a very good and understandable presentation"

Ground Control Ltd

"Very clear and easy to follow, brought the training to life with specific examples and tried to tailor the training to our needs and our needs of the business."

Adobe
Microsoft
Google
General
Web Design
Handling Information
Print & Desktop Publishing
Apple
Presentation
Virtual Meetings

Locations

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



Have a look at our range of Excel Training Courses

Other training courses you may be interested in:

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel Pivot Tables training course beginners

Microsoft Excel PowerPivot training course intermediate

Advanced Microsoft Excel 2007 Training Course

Or if you need to get back to basics
Beginners Microsoft Excel 2007 Training Course



Microsoft Excel 2007 Training Course Intermediate

Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.

We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.

We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

By using our website, you consent to our use of cookies for the purposes outlined above.

For more details, please read our full Privacy Policy.