Microsoft Excel Professional
Highly advanced Microsoft Excel course with CPD accredited certificate & free e-learning: become a proficient Excel user
Activia Training
Summary
Location & dates
46 The Priory, Queensway
Birmingham
B47LR
United Kingdom
Felix Road
Bristol
Avon
BS50HE
United Kingdom
Leeds
LS11BA
United Kingdom
23-25 Friar Lane
Leicester
LE15QQ
United Kingdom
Overview
Our Microsoft Excel Professional course will push your Microsoft Excel skills to a new level.
This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of tools and concepts for Excel 2007, 2010, 2013 or 2016 in order to further increase their knowledge and productivity.
CPD
Course media
Description
Advanced Conditional Formatting
- Editing Standard Formatting Rules
- Using Formulas in Conditional Formatting
Using Form Controls and Templates
- Using Form Controls
- Creating Templates
Advanced Lookup Functions
- Using the Index Function
- Using the Match Function
- Using Index and Match Together
- Using Index and Match with Array Formula
- Using the Indirect Function
Advanced Functions in Excel
- Using Error Functions
- Using Logical Functions
- Using Array Formulas
- Using Rounding Functions
Advanced Pivot Table Tools
- Importing Pivot Table Data
- Calculated Fields in Pivot Tables
- Showing Pivot Data as a Percentage
- Creating Custom Pivot Tables Styles
Introduction to User Defined Functions Using VBA
- Creating a User Defined Function
- Creating an Interactive Procedure
- Create and Share a Function Add-in
'
Who is this course for?
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.