Courses / Microsoft Excel Advanced
Microsoft Excel Advanced
- Provider
- WS Training Ltd
- Summary
- Versions Available: 2003, 2007 and 2010
This one day course has been designed for those users who wish to discover the advanced features of excel. You will be able to do more complex “what if” scenarios and use conditional formula and pivot tables to manipulate information.
About the Course
- Target
- Those users who have attended the Intermediate course.
- Entry requirements
- Contact the provider for details
- Outcome
- By the end of the course, you will be confident in using some of Excel’s more advanced features.
- Content
- The course content includes:
•Recap;
•Partial Absolute Cell References;
•Using Paste Function;
•Consolidating Data
•Range Names;
•Auditing Your Worksheet
•Conditional Processing - Using the If Function;
•V lookup and H lookup
•Advanced Filters;
•Pivot Tables
•Introduction to Macros – Running and recording macros; Relative v Absolute;
•Assigning a macro to a button on a toolbar
•What-if Analysis – Goal Seek, Scenarios and Solver - Cost
- Contact course provider for details
- Enrolment
- Students can book courses online (see website below)
- Website
- www.wstraining.co.uk
Availability
- Starts
- Contact WS training for details
- Duration
- 1 day
- Timetable
- Please contact the provider for details
- Provider
- WS Training Ltd
Venues/Contact
Main (View map)
Manor Barn
Church Road
Great Barton
BURY ST EDMUNDS
IP31 2QR
UNITED KINGDOM
Telephone 01284 788005
Fax 01284 788470
Email info@wstraining.co.uk
Website http://www.wstraining.co.uk
Venue Notes 77852
Contact Richard Dean
3rd (View map)
IP City Centre
Bath Street
Ipswich
Suffolk
IP2 8SD
Telephone 01473 604260
Fax 01473 686149
Venue Notes 77852
Contact Richard Dean
2nd (View map)
Chauntry Mills (2nd Floor)
High Street
HAVERHILL
Suffolk
CB9 8AZ
Telephone 01440 702454
Fax 01440 706422
Venue Notes 77852
Contact Richard Dean
Courses
Syndicate
