Want inspiration and special offers for your development? Sign up to our email alerts here!
Excel - AdvancedWise Owl
Learn Advanced Skills in Microsoft Excel 2016 - 2-Day Course in London & Manchester
When it comes to Microsoft Excel, the possibilities are endless. This 2-day training course is designed to provide delegates with the advanced skill set required to take their excel sheets and presentations to the highest level.
This course is targeted to excel users who are familiar with the program, but suspect that they could make better and broader use of the programme. Delegates of this course will work through exercises and practical activities to learn a new set of sophisticated and limitless excel functions.
Suitability - Who should attend?
This advanced training course is suitable for individuals who have an understanding of the excel programme, but feel that they could gain more benefit from the programme.
In order to make the most of each delegate's experience, class sizes are kept to a maximum of 6 delegates.
Outcome / Qualification etc.
Upon completion of this advanced course, delegates will become able to apply and manipulate the Microsoft Excel programme more effectively and efficiently.
Training Course Content
- Revision of single IFs
- Nesting =IF
- =IFS and =SWITCH
- Using VLOOKUP for continuous values
- Using VLOOKUP for exact matches
- List data validation for exact matches
- Dynamic range names
- Handling errors in lookup tables
Advanced lookup functions
- Using = MATCH to find values
- Combining =INDEX and =MATCH
- The OFFSET function
- The INDIRECT function
- Basic text functions
- Finding and replacing text
- Extracting and joining text
- Turning tracking on/off
- How tracking works
- Accepting and rejecting changes
- Group editing
- Formulae across sheets
- 3D summing across sheets
- Removing duplicates
- Advanced filters (multiple criteria)
- Adding and removing subtotals
- Grouping/outlining controls
- Creating pivot tables
- Changing the aggregation function
- Drilling down
- Filtering and sorting
Advanced pivot tables
- Grouping fields
- Showing % of grand totals, etc
- Slicers and timelines
Getting data (was Power Query)
- Using different data sources
- Query steps
- Massaging data before loading it
- The "Column by example" transform
Advanced charts (if time)
- Combination charts
- Regression and trendlines
- Picture charts
The cost of this course is £585 + VAT per delegate for most venues and £685 + VAT for London. Lunch at a local restaurant is included in course fees as well as a USB stick with course files.
This course can also be delivered on-site for groups, teams or companies.
Provider: Wise Owl
The Wise Owl team has made a name for itself delivering specialist Microsoft training for software enthusiasts, by software enthusiasts. With a team of six dedicated full-time trainers, Wise Owl have the knowledge, resources and enthusiasm to deliver Microsoft training...