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: 18/06/12

Microsoft Excel Level 4 Southampton
Microsoft Excel [Southampton]   A part of this course will explore some of the new features of Excel 2010 that will enable you to manage and manipulate data more effectively. The remainder of the course will focus on array formulas t - Book Now

Microsoft Excel Level 3 Basingstoke

Print Page


Level Advanced
Date/Venue
Duration 1 day
Time 09:30 to 16:30
Price Net - £200.00
VAT - £40.00
Gross - £240.00

Enquire

Microsoft Excel [Basingstoke]
 
This course will cover a range of tools, techniques and formulas that will enable you to protect, control, analyse and manipulate spreadsheets and their data.
 
Target Student: For those who want to improve efficiency and control when when working with company spreadsheets.
 
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
 
  • To improve your efficiency using a range of advanced Excel tools and techniques.
Course Objectives
By the end of this level you will be able to:

  • Audit a spreadsheet for errors
  • Protect a workbook, worksheet and specific cells
  • Validate cells to control data entry
  • Use Pivot Table to analyse and report
  • Use complex formulas to manipulate data
  • Conduct What if Analysis using a range of techniques
  • Carry out Data Analysis using the Analysis tools
  • Create a simple Macro
Content
 
Validate Data - Control data entry - Lists - Text Strings - Values
 
Protect Data - Protect Workbooks - Protect Worksheets - Protect Cells - Use single and multiple passwords
 
Audit Worksheets - Trace Cell Precedents - Trace Cell Dependents - Locate Errors in Formulas - Watch and Evaluate Formulas
 
Analyze Data using Pivot Tables - Develop a PivotTable Report - Develop a PivotChart Report

Manipulate data - Extract parts of data - Combine data - [Left, Right, Mid, Concatenate, Find]

Perform What-If Analysis - Goal Seek - Solver - Scenarios
 
Analyse Data using the Analysis ToolPack - Regression - Descriptive Statistics - Histograms
 
Working with Multiple Workbooks - Create a Workspace - Consolidate Data - Link Cells in Different Workbooks

Create a Macro - Simple recorded macro
Course Includes:
Lunch/refreshments and course materials.
 
Related Courses:
 
Our Basingstoke training venue at Worting House is situated close to the M3 junctions 6 and 7.
Testimonials
Comment: An excellent use of my time! I will be able to use what I've learned daily. [KM - MOD] Comment: Particularly worthwhile course for my current role, delivered at the right pace by a first class instructor. [SG - MOD] Comment: I found the course very helpful and gained a much more indepth knowledge of Excel and its capibilities. Comment: Fantastic facilities at Basingstoke, lunch and trainer. A great day. [PL]
Microsoft Excel Basingstoke

Enquire