x

Contact Us


Please fill out this form to send us an enquiry.





01489 588453
Contact Us
Contact Us
icon

Project Management

icon

IT Courses

icon

Business Skills

Health & Safety

Microsoft Excel 2 - 2007

Print Page


Level Intermediate
Date/Venue 24/08/10 - Southampton
23/09/10 - Salisbury
Duration 1 day
Time 9:30 to 16:30
Price Net - £150.00
VAT - £26.25
Gross - £176.25

Enquire

Introduction
 
You understand the basics of Microsoft Excel 2007 but need to use more complex elements to make your job easier. This course has a focus on managing, manupulating and analysing data using a range of simple and complex techniques. It also explores the use of more complex formulas in a business environment and includes techniques to simplify what could be complicated. We also investigate visual techniques that can be used to monitor information by users and managers.The course builds on shortcuts and techniques learnt during the introduction course.
Course Aims
 
  • To apply visual elements and advanced formulas to a worksheet to display data in various formats
  • To manage, manipulate and analyse data using a range of techniques.
Course Objectives
 
By the end of this level you will be able to:
 
  • Use Conditional Formatting to manage data
  • Create and apply templates
  • Sort, Filter, Subtotal and use Pivot tables to analyse data
  • Manage complex formulas using Range Names
  • Calculate with advanced formulas including IF's and Vlookup
  • Create and modify charts
  • Work with graphic objects
  • Use a range of useful shortcuts
Content
 
Creating and Applying Templates - Create a Workbook from a Template - Create a Custom Template - Working with Comments - Create a Hyperlink - Use Web-based Research Tools
 
Creating and Modifying Charts - Create a Chart - Format Chart Items - Change the Chart Type - Create a Diagram
 
Working with Graphic Objects - Insert Graphics - Create AutoShapes - Format Graphic Objects - Change the Order -  Graphic Objects - Group Graphic Objects - Move, Copy, and Resize Graphic Objects
 
Calculating with Advanced Formulas - Create and Apply a Name for a Range of Cells - Calculate Across Worksheets - Calculate with Date and Time Functions - Calculate with Financial Functions - Calculate with Statistical Functions - Calculate with Lookup and Reference Functions - Calculate with Logical Functions
 
Sorting and Filtering Data - Sort Data Lists - Filter Data Lists - Create and Apply Advanced Filters - Calculate with Database Functions - Add Subtotals to a Worksheet
 
Using Excel with the Web - Export Excel Data - Publish a Worksheet to the Web - Import Data from the Web - Create a Web Query
Course Includes
 
Lunch/refreshments, training manuals, training file created during the course, additional training files to practice with, certificate, post course support.
 
Training Venues for scheduled courses at: Whiteley - Southampton, Salisbury, Basingstoke
 
 
Testimonials
Comment: Low class numbers helped and gave time to focus on specific issues as required. The location was ideal living in Southern Hampshire. [Adam Tait]  Comment: Particularly worthwhile course for my current role, delivered at the right pace by a first class instructor. [SG - MOD]
Excel 2

Enquire