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 Salisbury

Print Page


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

Enquire

Microsoft Excel [Salisbury]
 
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.
 
 
Our training venue is situated between Salisbury and the A303. The Portway Centre, Salisbury.
Testimonials
Comment: Many thanks again Tim - an extremely useful course, 100% relevant to my day-to-day activities. [JN - BAE] Tailored examples, intimate facilities, excellent refreshments. [DO KP] Very relevant content to what I need at work. [JH] Excellent materials and examples, useful shortcuts. [LS]
Microsoft Excel Advanced

Enquire