Microsoft Excel 2007 Advanced Training Course London & UK Wide
Our Excel 2007 Advanced training course will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel 2007 users whom need to learn more complex functions, nesting, data manipulation and automation using basic macros.
We frequently get comments back from clients stating that they wish they attended our Excel 2007 Advanced course ages ago. It would have saved them so much time!
At Mouse Training, we can provide free TNA's and also create a bespoke Excel 2007 Advanced course to suit your exact needs. If you are not sure that this is the course you need, or would like to exclude/include more content, we are more than happy to do this. Remember, all our courses are closed courses, so you decide what you should know, not a pre-defined schedule.
So, if you need to save time, money and get more from your spreadsheets, let us be your learning partner. With clients such as HSBC, Google and many more, you can rest assured you will be getting the most from your investment on our Excel 2007 Advanced Training Course
Excel 2007 Advanced Training Course Information
Audience: This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros
Course Duration
This is a 1 day Excel 2007 Advanced Course. Course starts at 09:30 and runs until 16:30
Excel 2007 Advanced Course Objectives: After the course, you will be able to:
- Use Lookup & Informational Functions
- Create Pivot Tables
- Use What-If Tools
- Sharing and Tracking Workbooks
- Record Basic Macros
Requirements: You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.
Course Duration
This is a 1 day Excel 2007 Advanced Course. Course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This course can be run Onsite, at our Excel 2007 training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Excel 2007 Advanced Training Course Contents
Lookup & Information Functions
- Vertical Lookup (Vlookup)
- Horizontal Lookup (Hlookup)
- Match and Index
- IsText, IsValue, IsDate , IsErr, Is Error, IsNa
Advanced List Management
- Advanced Filters
- Using List Features
- Dynamic Lists (Tables)
Pivot Tables
- Using the Pivot Table Wizard
- Changing the pivot table layout
- Formatting
- Grouping items
- Inserting calculated fields
- Pivot Table Options
- Display and hide data in fields
- Lay out reports directly on worksheet
- Pivot Chart
What If Analysis
- Scenarios
- Goal Seek
- Solver
- Data Tables
Protecting & Sharing Files
- Sharing a file
- Tracking changes
- Accepting or rejecting changes
- Applying Data validation rules
- Inserting comments
Introduction to Macros
- Purpose of Macros
- Recording macros
- Where to save macros
- Absolute and relative record
- Running macros:
- Custom buttons, menu items, keyboard shortcuts
**You are able to include/exclude as much content as you need to create your own Excel 2007 Advanced Training Course**
Excel 2007 Courses
What can I expect?
