Advanced Microsoft Excel
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
This Advanced Microsoft Excel training course is held in London in the South East, Birmingham in the Midlands, Bristol in the South West, Leeds and Manchester in the North and Edinburgh in Scotland. Please select the Course Dates Tab above to see current course dates, or select a category link above to see more course and location options. Advanced Microsoft Excel.

About the Course:
A detailed coverage of the advanced features of MS Excel providing you with the knowledge and confidence to manage complex and large data sets. This two day course also covers the additional features unique to the XP version

Course Overview:
- Advanced If statements
- Count functions
- Data consolidation
- Goal seeking
- Data projection using
- What If scenarios
- Data tables
- Data summarising with pivot tables
- Utilising the macro recorder
- Creating buttons on the worksheets
- Using outlining to handle large worksheets
- Advanced Filters
- Concatenate
- Text Functions
- Changing Case Data
- Import from text files
- Connecting to databases
- Setting up web queries
- Watch window
- Formula evaluation auditing
- Adding icons to the toolbars to run your macros
- Customising Menus
- Retrospective Validation
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
Tools
 
Key Details
Duration2 days
 
£350
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).