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

Latest Course - Next Date: 24/01/12

Microsoft Project 1
Microsoft Project Introduction   In addition to delivering projects on schedule and within budget, today’s project teams must reduce time to market and cope with rapidly shifting conditions. Microsoft Project is a powerful tool to help you break - Book Now

Microsoft Excel Level 2 Southampton

Print Page


Level Intermediate
Date/Venue 20/02/12 - Southampton
29/03/12 - Southampton
Duration 1 day
Time 09:30 to 16:30
Price Net - £200.00
VAT - £40.00
Gross - £240.00

Enquire

Microsoft Excel [Southampton]
 
This Excel course has a focus on managing, manipulating 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.
 
Target Student: For those who want to interrogate lists of data using a range of simple techniques and to create more complex business formulas. Useful to have completed the level 1 course but not mandatory.
 
Microsoft Excel Versions: Please let us know if you want your training on version 2003, 2007 or 2010. There are significant differences between versions so its important that we know at the time of booking.
Course Aims
 
  • Apply visual elements and advanced formulas to a worksheet to display data in various formats
  • 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
  • Sort, Filter, Subtotal and use Pivot tables to analyse data
  • Manage complex formulas using Range Names
  • Create a simple template to improve efficiency
  • Create a range of IF and VLOOKUP functional examples
  • Create and modify charts
  • Use a range of useful shortcuts
Content
 
Conditional Formatting - Set up rules - Apply rules - Edit rules - Clear rules - Business examples
 
Interrogate lists of data - Sort data - Values - Dates - Colours - Grouping - Filter data - Simple filter - Complex filter - Dates - Colours - Subtotal data - Sort first - Exampes - Create Subtotals -  Edit - Remove - Pivot Tables - Create and Edit a Pivot Table - Update - Refresh - Graphs - Delete - Options - Sheet or with data
 
Range Names - Naming convention - Static Names - Dynamic Names - Create - Edit - Delete - Use in Formulas - Navigation
 
Business Formulas - IF functions - Various IF examples - Simple IFs - Complex IFs - VLOOKUP function - Create an example - Edit - Closest options - Exact options
 
Create Templates - Create a simple Template - Test the Template
 
Create and Modify Charts - Create a Chart - Format Chart Items - Change the Chart Type
 
Shortcuts - Use a range of shortcuts
Course Includes:
Lunch/refreshments, training manuals, training file created during the course, additional training files to practice with, certificate, post course support.
 
 
Our training venue is situated between Southampton and Portsmouth at J9 of the M27, The Solent Business Park, Whiteley.
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] Comment: The Southampton venue at Whiteley couldnt have been better for me. Trainer was brilliant and I enjoyed the whole course. [MP]
Excel Southampton

Enquire