Project Management
IT Courses
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 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 Salisbury
| Level | Intermediate |
| Date/Venue | 01/03/12 - Salisbury |
| Duration | 1 day |
| Time | 09:30 to 16:30 |
| Price | Net - £200.00 VAT - £40.00 Gross - £240.00 |
Microsoft Excel [Salisbury]
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.
Related Courses:
Microsoft Excel level 1 - Microsoft Excel level 2 - Microsoft Excel level 3
Microsoft Excel VBA level 1 - Microsoft Excel VBA level 2
Microsoft Excel level 1 - Microsoft Excel level 2 - Microsoft Excel level 3
Microsoft Excel VBA level 1 - Microsoft Excel VBA level 2
Our training venue is situated between Salisbury and the A303, The Portway Centre
Testimonials
Comment: A very useful course, constantly relating back to individual requirements. Good pace and kept everyone involved. [LA DSTL] Comment: Very easy to follow and taught at a good pace. There is so much I can take away to make my life at work easier. [SR Matchtech] Comment: The IPSO FACTO Salisbury training rooms were perfect for me, free parking and easy to find. Enjoyed the course. Very useful. [PA]
Microsoft Excel Salisbury