Microsoft Excel - Advanced
Sponsored links
Who is it for?
This course is suitable for people who have attended the intermediate course or have good knowledge and understanding of Excel and would like to explore the more complex functionality Excel can offer
What is it about?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
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
What do I get out of it?
- Learn how to use advanced If statements and macros to automate repetitive tasks
- Be able to use analysis tools to forecast figures based on a range of scenarios
- Ensure important data is highlighted by summarising large workbooks and sorting data into key elements
- 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
This Training Course is taught in classrooms in the following locations:
London WC
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
