Home /
Training Courses /
Microsoft Excel XP Advanced
Microsoft Excel XP Advanced
Training Description
The skills and knowledge acquired in Microsoft Excel XP Advanced are sufficient to be able to use and operate the software at an efficient level.The Course Suits
Microsoft Excel XP Advanced is designed for users who are keen to extend their understanding and knowledge of the software. Microsoft Excel XP Advanced assumes the delegate has attended the Intermediate course or has equivalent knowledge.Training Benefits
At the completion of Microsoft Excel XP Advanced you should be able to:
- use names and labels
- use a wide range of paste special options
- use a variety of Financial functions
- create, use and modify data tables
- use advanced filters to analyse data in a list
- summarise data using subtotals and relative range naming
- use data forms to manage data in a list
- use the statistical functions in Excel
- use goal seeking to determine the values required to reach a desired result
- use Solver to resolve complex optimisation problems
- create and work with scenarios and the Scenario Manager
- import data into and export data from workbooks
- create, modify and work with PivotTables
- create recorded macros in Excel
- use the macro recorder to create a variety of macros
- confidently open workbooks that contain macros
- create and use a range of controls in a worksheet
- publish workbooks and worksheets for the web
Course Timetable
The course focuses on practical work within the product giving delegates ample opportunity to use their PC skills through a series of graded exercisesTopics covered include:Labels and Names
Labels And Names Explained
Accepting Labels In Formulas
Using Text Labels
Creating Labels
Creating Names Using The Name Box
Using Names To Select Cells
Using Names In Formulas
Creating Names Between Workbooks
Creating Names For Constants
Creating A List Of Names
Changing The Range For Names
Deleting Names
Paste Special
The Paste Special Options
Copy Formulas
Copy Formats
Copy Validation Settings
Copy Column Widths
Copy Values
Copy Comments
Add Values
Multiply Values
Transpose Cells
Financial Functions
Financial Functions Listing
Regular Payments With PMT
Calculating Future Values With FV
Net Present Value With NPV
Present Value With PV
The Interest Rate With RATE
Data Tables
Using A Simple What-If Model
Creating A One-Variable Table
Using One-Variable Data Tables
Creating A Two-Variable Data Table
Advanced Filters
Advanced Filter Concepts
Using An Advanced Filter
Extracting Records With Advanced Filter
Using Formulas In Criteria
Using Database Functions
The Database Functions
Using The DSUM Function
Using The DMIN Function
Using The DMAX Function
Using The DCOUNT Function
Summarising Data
Creating Subtotals
Using A Subtotalled Worksheet
Creating Nested Subtotals
Copying Subtotals
Using Subtotals With AutoFilter
Using The Conditional Sum Wizard
Creating Relative Names For Subtotals
Using Relative Names For Subtotals
Data Forms
Displaying A Data Form
Viewing Records By Criteria
Editing Records
Adding A New Record
Deleting Records
Statistical Functions
Statistical Functions Listing
Status Bar Statistics
Basic Statistical Functions
Counting Cells
Using MODE & MEDIAN
Calculating Standard Deviation
Conditional Counting
Goal Seeking
Goal Seek Components
Using Goal Seek
Solver
Installing Solver
Solver Theory
Using Solver and Solver Reports
Restricting Answers Using Solver Options
Scenarios
Creating A Default Scenario
Creating Scenarios
Using Names in Scenarios
Displaying Scenarios
Creating A Scenario Summary Report
Merging Scenarios
Importing & Exporting
Importing From Another Spreadsheet Program
Text File Formats
Importing Tab-Delimited Text
Exporting To Microsoft Word
Linking Data Into A Word Processing Document
Exporting Data As Text
Importing Comma-Delimited Text
Importing Space-Delimited Text
Importing An Object Into A Worksheet
Formatting An Imported Object
PivotTables
PivotTable Theory
Creating A Simple PivotTable
Adding Row Fields To A PivotTable
Using The Page Field In A PivotTable
Filtering Row And Column Values
Formatting A PivotTable
Counting With PivotTables
PivotTable Summary and Display Options
Show Data As Percentages In PivotTables
Calculated Fields In PivotTables
Calculated Items In PivotTables
Creating A PivotChart
Modifying A PivotChart Via The PivotTable
Refreshing A PivotTable
Recorded Macros
Setting Macro Security Levels
Recording A Simple Macro
Running A Recorded Macro
Relative Cell References
Running A Macro With Relative References
Viewing A Macro Module
Modifying A Recorded Macro
Assigning A Macro To A Toolbar Button
Running A Macro From A Custom Button
Removing A Custom Button From The Toolbar
Recorder Workshop
Preparing Data For An Application
Recording A Summation Macro
Recording Consolidations
Recording Divisional Macros
Testing Macros
Creating Objects To Run Macros
Assigning A Macro To An Object
Macro Virus Control
Opening Workbooks With Macros
Setting Macro Security Levels
Trusting Publishers
Creating A Digital Signature
Removing A Trusted Publisher
Controls
Control Types
How Controls Work
Preparing A Worksheet For Controls
Adding A Combo Box Control
Changing Control Properties
Using The Cell Link To Display The Selection
Adding A List Box Control
Adding A Scroll Bar Control
Adding A Spinner Control
Adding Option Button Controls
Adding A Group Box Control
Adding A Check Box Control
Protecting A Workbook With Controls
Excel On The Web
Previewing Workbooks As Web Pages
Publishing A Static Worksheet
Adding To An Existing Web Page
Publishing An Interactive Web Page
© PTP/X4M3
Please Choose from the list below:
Quick Training Search
-
- Training Courses
- Customer Care Training
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Brand Building with the Public
- Call Centre - Achieving Best Practice
- Customer Care
- Customer Excellence for Finance Staff
- Customer Satisfaction as a Selling Tool
- Dealing with Difficult People
- Dealing with Incoming Calls Positively
- Enhancing the Visitors Experience
- Excellent Customer Care - Incoming Calls
- How to say 'No' and retain Customer Satisfaction
- Introduction to Account Management
- Outstanding Customer Service Skills
- Professional Writing Skills
- Relationship Marketing
- Through the Customers' Eyes
- Finance and Planning Training
- Finance and Planning Training
- Business Skills for Administrators
- Credit Control
- Customer Excellence for Finance Staff
- Cutting Costs and Waste in Your Office
- Finance for Marketing and Sales People
- Finance For Non-Finance Managers
- Interpreting Financial Statements
- Investor and Entrepreneur Skills
- Managing Budgets
- Practical Project Management (2 day course)
- Prince2 Practitioner - 5 Day Course
- Project Management
- Successfully Setting and Achieving Business Objectives
- Sustaining Effective Financial Control
- Finance Management
- Time Management Training
- Managing Effective Meetings
- Personal Organisation Skills for Secretaries & PAs
- Planning & Prioritisation for the Busy Sales Person
- Planning Sales Activity to Help Meet & Exceed Targets
- Speed Reading & Information Management
- Successfully Setting and Achieving Business Objectives
- Time Management
- Work-Life Balance
- Finance and Planning Training
- IT Courses
- Microsoft Access Courses
- Microsoft Access 2000 Fundamentals (2 days)
- Microsoft Access 2000 Specialised (2 days)
- Microsoft Access 2003 Fundamentals (2 days)
- Microsoft Access 2003 Specialised (2 days)
- Microsoft Access 2007 Fundamentals (2 days)
- Microsoft Access 2007 Specialised (2 days)
- Microsoft Access VBA (2 days)
- Microsoft Access XP Fundamentals (2 days)
- Microsoft Access XP Specialised (2 days)
- Microsoft Excel Courses
- Microsoft Excel 2000 Advanced
- Microsoft Excel 2000 Fundamentals
- Microsoft Excel 2000 Intermediate (2 days)
- Microsoft Excel 2003 Advanced
- Microsoft Excel 2003 Fundamentals
- Microsoft Excel 2003 Intermediate (2 days)
- Microsoft Excel 2003 Upgrade
- Microsoft Excel 2007 Advanced
- Microsoft Excel 2007 Fundamentals
- Microsoft Excel 2007 Intermediate (2 days)
- Microsoft Excel 2007 Upgrade
- Microsoft Excel VBA (2 days)
- Microsoft Excel XP Advanced
- Microsoft Excel XP Fundamentals
- Microsoft Excel XP Intermediate (2 days)
- Microsoft Outlook Courses
- Microsoft Outlook 2000 Fundamentals
- Microsoft Outlook 2000 Specialised
- Microsoft Outlook 2002 Fundamentals
- Microsoft Outlook 2003 Fundamentals
- Microsoft Outlook 2003 Specialised
- Microsoft Outlook 2003 Upgrade
- Microsoft Outlook 2007 Fundamentals
- Microsoft Outlook 2007 Upgrade
- Microsoft Outlook XP Specialised
- Microsoft PowerPoint Courses
- Microsoft PowerPoint 2000 Fundamentals
- Microsoft PowerPoint 2000 Specialised
- Microsoft Powerpoint 2002 Fundamentals
- Microsoft Powerpoint 2002 Specialised
- Microsoft PowerPoint 2003 Fundamentals
- Microsoft PowerPoint 2003 Specialised
- Microsoft PowerPoint 2003 Upgrade
- Microsoft PowerPoint 2007 Fundamentals
- Microsoft PowerPoint 2007 Specialised
- Microsoft PowerPoint 2007 Upgrade
- Microsoft Word Courses
- Microsoft Word 2000 Advanced
- Microsoft Word 2000 Fundamentals
- Microsoft Word 2000 Intermediate
- Microsoft Word 2002 Fundamentals
- Microsoft Word 2002 Intermediate
- Microsoft Word 2003 Advanced
- Microsoft Word 2003 Fundamentals
- Microsoft Word 2003 Intermediate
- Microsoft Word 2003 Upgrade
- Microsoft Word 2007 Advanced
- Microsoft Word 2007 Fundamentals
- Microsoft Word 2007 Intermediate
- Microsoft Word 2007 Upgrade
- Microsoft Word VBA (2 days)
- Microsoft Word XP Advanced
- Miscellaneous Microsoft Courses
- Microsoft FrontPage 2000 Fundamentals
- Microsoft Project 2000 FastPath
- Microsoft Project 2000 Level 1 (2 days)
- Microsoft Project 2000 Level 2 (2 days)
- Microsoft Project 2002 Level 1 (2 days)
- Microsoft Project 2003 FastPath
- Microsoft Project 2003 Level 1 (2 days)
- Microsoft Project 2003 Level 2 (2 days)
- Microsoft Project 2007 FastPath
- Microsoft Project 2007 Level 1 (2 days)
- Microsoft Project 2007 Level 2 (2 days)
- Microsoft Project XP FastPath
- Microsoft Publisher 2003 Fundamentals
- Microsoft Visio 2000 Fundamentals
- Microsoft Visio 2000 Specialised
- Microsoft Visio 2002 Fundamentals
- Microsoft Visio 2002 Specialised
- Microsoft Visio 2003 Fundamentals
- Microsoft Visio 2003 Specialised
- Microsoft Visio 2007 Fundamentals
- Microsoft Visio 2007 Specialised
- Microsoft Windows Vista New Features
- Non-Microsoft Courses
- Microsoft Access Courses
- Management Training
- Green Management
- HR and Recruitment Training
- Appraisee Training
- Appraising Performance Effectively
- Developing Your PA Potential to Ensure Success
- HR Skills For Line Managers
- Influencing Skills
- Managing Appraisals
- Managing Difficult Staffing Situations
- Managing Sickness And Absences
- One-To-One and Small Group Training
- Performance Review Skills
- Recruiting the Best People
- Successful Interviewing
- Understanding Discipline and Grievance
- Walk, Talk, Stance for Maximum Impact
- Interview Training
- Introductory Skills
- Developing Your PA Potential to Ensure Success
- Essential Management Skills (2 Days)
- Introduction to Facilitation Skills
- Introduction to Green Office Management
- Introduction to Management and Supervisory Skills
- Introduction to NLP
- Introduction to Quality Management
- Managing Budgets
- Successfully Setting and Achieving Business Objectives
- Leadership Skills
- Creative Problem Solving
- Introduction to Management and Supervisory Skills
- Leadership & Management Skills
- Management by Coaching
- Senior Management Skills
- Success in Leadership & Motivation Skills
- Successful International Joint Venture Teamworking
- Successfully Setting and Achieving Business Objectives
- Team Building
- The Roles and Responsibilities of a Director
- Walk, Talk, Stance for Maximum Impact
- Management and People Skills
- Advanced Facilitation Skills (1 Day)
- Advanced Listening Skills
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Building Excellent Working Relationships
- Communication Skills
- Creativity and Innovation (1 day course)
- Dealing with Difficult People
- Effective Management of Your Team
- Essential Management Skills (2 Days)
- First Line Manager Skills
- Getting Results
- HR Skills For Line Managers
- Introduction to Facilitation Skills
- Introduction to Management and Supervisory Skills
- Management by Coaching
- Management Skills - How to Survive and Thrive
- Managing Change
- Managing Conflict
- Managing Effective Meetings
- Managing People on Projects
- Maximising Performance by Influencing and Persuading
- Motivation Skills
- People Management
- Performance Management
- Performance Review Skills
- Practical Project Management (2 day course)
- Re-Energising a Stalled Change Campaign
- Senior Management Skills
- Success in Leadership & Motivation Skills
- The Internal Consultant
- The Practical MBA - Managing By Your Actions (2 day course)
- Walk, Talk, Stance for Maximum Impact
- Work-Life Balance
- Working Globally Inter-Cultural Communications
- Management Finance
- Networking & Sales Skills for Managers
- Advanced Facilitation Skills - (2 Days)
- Coaching Skills for Sales Managers
- Introduction to Blogging
- Introduction to LinkedIn
- Introduction to Twitter
- Maximising Performance by Influencing and Persuading
- Negotiation Skills
- Networking For Success
- Referral Marketing
- Successful International Joint Venture Teamworking
- Walk, Talk, Stance for Maximum Impact
- Presentation
- Project Management
- Sales Management
- Strategy and Risk Management
- Time Management Skills
- Training and Coaching Skills
- Advanced Facilitation Skills (1 Day)
- Coaching and Mentoring
- Coaching Skills
- Introduction to Facilitation Skills
- Introduction to Management and Supervisory Skills
- Management by Coaching
- Managing the Training Function
- One-To-One and Small Group Training
- The Creative Trainer
- Train the Trainer (2 day course)
- Train the Trainer (one day course)
- Walk, Talk, Stance for Maximum Impact
- Personal Development
- Appraisee Training
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Building Excellent Working Relationships
- Building Personal & Professional Confidence
- Business Skills for Administrators
- Communication Skills
- Creative Problem Solving
- Creativity and Innovation (1 day course)
- Creativity and Innovation (2 Day Course)
- Cutting Costs and Waste in Your Office
- CV Writing and Interview Confidence Building
- Developing Your PA Potential to Ensure Success
- How to Learn Anything Quicker
- Influencing Skills
- Introduction to Twitter
- Maximising Performance by Influencing and Persuading
- People Management Skills for Secretaries & Pas
- Personal Development for Professionals
- Personal Effectiveness
- Personal Organisation Skills for Secretaries & PAs
- Preparing Yourself for Interview
- Professional Writing Skills
- Self-Discipline and Emotional Control in the Workplace
- Speed Reading & Information Management
- Stress Management
- The Effective Administrator
- The Green Worker
- Work-Life Balance
- Write to the Top! - Professional Report Writing
- Sales Training
- Face to Face Selling Skills
- Advanced Closing Skills
- Body Language - The Hidden Secret of Communicating Successfully
- Closing The Sale & Dealing With Objections
- Confidence in Making Face to Face Cold Calls
- Introduction to Sales - From Emerging Salesperson to Buying Advisor
- Successful Sales Presentations
- The Client Meeting - Face to Face Selling
- Walk, Talk, Stance for Maximum Impact
- Winning More Business in the Final Meeting (2 day course)
- General Sales Skills
- Advanced Closing Skills
- Advanced Listening Skills
- Advanced Selling Skills (2 day course)
- Closing The Sale & Dealing With Objections
- Consultative Selling
- Customer Satisfaction as a Selling Tool
- Developing Major Accounts
- How to Learn Anything Quicker
- Introduction to Account Management
- Introduction to Blogging
- Introduction to NLP
- Introduction to Sales - From Emerging Salesperson to Buying Advisor
- Introduction to Twitter
- Key Selling Skills
- Managing Major Accounts (2 day course)
- More Advanced Selling Skills
- Planning Sales Activity to Help Meet & Exceed Targets
- Selling for Non-Sales Professionals
- Successful Sales Presentations
- The Art of Retail Selling
- The Secrets of Low Cost Advertising
- Through the Customers' Eyes
- Marketing Skills
- Brand Building with the Public
- Essential Advertising
- Essential Marketing Skills
- Introduction to Account Management
- Introduction to Blogging
- Introduction to Twitter
- Networking For Success
- Referral Marketing
- Relationship Marketing
- The Secrets of Low Cost Advertising
- Walk, Talk, Stance for Maximum Impact
- Marketing Training
- Negotiation, Objection Handling and Closing Skills
- Presentation Skills
- Sales Management and Coaching Skills
- Sales Writing Skills
- Telemarketing Training
- Telephone Sales Skills
- Advanced Telephone Prospecting
- Closing Incoming Calls Effectively
- Gaining Commitment on the Telephone
- Generating New Business by Telephone
- Maximising Appointments on the Telephone
- Outgoing Calls - Maximising Effectiveness
- Telephone Techniques - Incoming & Outgoing Calls
- Winning More Business on the Telephone
- Face to Face Selling Skills
- Customer Care Training
- Training Courses
To perform a free text search for courses enter your chosen keyword/s below:
Special offers
Click here to find training related special offers in your area special offers
Open course schedule
One day open course schedule for the next month more info
U-Choose
Can't find the right date?
Can't find the right venue?
With U-Choose you can build the training package of your specification more info
Download our brochure
To download our brochure please click
here
To download our 2011 Open Schedule click
here
Special Offers Subscription
Subscribe to receive our special offers.