Microsoft Excel Advanced
Excel has long been a popular choice for creating spreadsheets, analysing data and creating graphical representations of information.
There are few things in life more impressive than a properly formatted and presented spreadsheet, so if you want to dazzle colleagues with your workbook wizardry or automate a process you repeat every day then this is the course for you!
This course can be run using Excel 2010, 2013 or 2016. Please discuss your version requirements with us when booking.
Book your team training at your premises
- Date
- Venue
- Cost
- More info
- Date and time to suit you
- VenueWe will train your team
at your offices - CostContact us for price
- Fill in the form and we'll be in touch
within 15 minutes (Mon-Fri 9-5)
Book your place
- There are no public, Worcester-based events for this course scheduled at the moment, but you can contact us to request a date or call 0800 018 5597
- Request dates at
Worcester Training Centre
Guaranteed to run
This course will continue your journey with Excel and give you the skills to use advanced functions and features.
Anyone that manages, stores or looks at data as part of their role.
- Create pivot tables and graphs
- Use Excel functions and formulae for mathematical processes and automation
- Program Excel using Visual Basic
If you wish to keep a copy of the exercises that you produce on this course, please remember to bring a USB memory stick along with you.
This course will enable delegates to format and present data in easier to understand ways, as well as improving their efficiency through the use of advanced Excel Macros and shortcuts.
An in depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.
Advanced Data Management
- Automatic grouping, outlining and subtotalling
- Scenario Manager
- Data analysis tools
- One and two data input tables
- Goal Seek
- Solver
Pivot Tables
- Creation and formatting of Pivot Tables
- External Data
- Slicers
- PowerPivot
Pivot Charts
- Creation and formatting of Pivot Charts
- Advanced Tasks
- Scenarios
Advanced Excel Tasks
- Advanced functions
- Vlookup
- Hlookup
- Logical functions
- Pivot consolidated data
Excel Programming
- Macros
- Keyboard Shortcuts
- Visual Basic
Delegates are expected to have attended Microsoft Excel Fundamentals or to have equivalent knowledge.