Courses / Advanced Microsoft Excel
Advanced Microsoft Excel
- Provider
- P-tek Development Solutions Limited
- Summary
- This one day course focuses on equipping delegates with a comprehensive understanding of all functions of Microsoft Excel, and can be delivered either on a 1:1 or group basis.
About the Course
- Target
- This course is aimed at any level of personnel within any business who already have a good understanding of Microsoft Excel and wish to develop their skills to an advanced level.
- Entry requirements
- Outcome
- By the end of this course, delegates will be able to;
- Demonstrate an advanced understanding of Microsoft Excel
- Successfully implement the use of Excel into their working role
- Demonstrate an advanced understanding of Microsoft Excel
- Content
- The course can be tailored to meet your specific requirements and deal with any issues you may wish to address. To give you an idea of the course content, we could cover the following areas for you...
- Custom Formatting
- Custom Number Format
- Custom Date Format codes
- Using Conditional Formats- Working with Named Ranges
- Creating Range Names
- Using the Go To command
- Range Names in calculations- Importing & Exporting Data
- Object Linking & Embedding
- Sharing data with other applications
- Importing a Text File into Excel- Lookups & Data Tables
- Creating Data Tables
- Using the Lookup function
- Using the VLookup function
- Using the HLookup function
- Preventing Lookup errors- Templates
- Creating Workbook Templates
- Custom Templates
- Storing Templates- Analytical Tools
- Using Goal Seek & Solver
- Working with scenarios
- Using Views- Using Pivot Tables
- Creating Pivot Tables
- Formatting Pivot Tables
- Rearranging Pivot Tables
- Working with Pivot Charts- Using Views & Creating Reports
- Creating Custom Views
- Creating a Workspace File
- Using Workspace Files
- Using the Report Manager
- Printing Reports- Using Macros
- Understanding Macros
- Recording a basic Macro
- Running a Macro
- Assigning a Macro to a Toolbar
- Button Image Editor
- Editing a Macro
- Macros virus protection
Each delegate will receive individual feedback and assistance and may be asked to complete a personal action plan / checklist identifying key skills to practice. - Custom Formatting
- Cost
- Please contact the provider for details
- Enrolment
- Please contact the provider
Availability
- Starts
- Please contact the provider for details
- Duration
- 1 day
- Timetable
- Please contact the provider for details
- Provider
- P-tek Development Solutions Limited
Venues/Contact
Main (View map)
16 Kitchener Way
Shotley Gate
Ipswich
Suffolk
IP9 1RW
UNITED KINGDOM
Telephone 08448 011733
Fax 0709 202 9439
Email bookings@ptekdevelopment.com
Website http://www.ptekdevelopment.com
Venue Notes 0
Contact Notes Telephone: 08448 011 733 Fax: 07092 029 439
Courses
Syndicate
