-
A hands-on, instructor-led Microsoft Excel training course allowing people with an existing knowledge of Excel fundamentals to improve their skills and create better spreadsheets. Delegates will learn how to create advanced tables and spreadsheets, alongside gaining the capability to analyse, share and present this data with Excel. This is achieved through open learning, discussion and practice with an expert trainer in a professional classroom environment.
Pricing
- 1 Day of group training is £799 + VAT per day
- 2 Days of group training is £699 + VAT per day
- 3 Days of group training is £649 + VAT per day
- Solo training is available for £350 + VAT per day
Whats covered in this course
-
Working with Multiple Worksheets
-
Using multiple worksheets
-
Linking worksheets
-
Managing workbooks
-
-
Working with Large Spreadsheets
-
View options
-
Hiding/displaying data
-
Printing large worksheets
-
Outline a Worksheet
-
-
List Management
-
Sorting individual and multiple columns
-
Create a custom sort
-
Filtering
-
Advanced filtering
-
-
Advanced Formatting
-
Dates
-
Styles
-
Conditional Formatting
-
Custom Formatting
-
-
Advanced Functions
-
Logical Functions (E.g. IF)
-
Lookup Functions
-
-
Documenting and Auditing
-
Comments and Text Boxes
-
Formula Auditing Features
-
-
Advanced Charts
-
Combination Charts
-
Adding and removing data
-
Moving a chart
-
Other chart options
-
-
A fully interactive, instructor-led training course you can attend from the comfort of your own home or office. Enjoy an interactive learning session online with our most convenient and accessible method yet.
-
We regularly host training courses in our city-centre venue. Join our experienced trainers in person for a fully interactive training session, and enjoy access to our comfortable breakout room and on-site café.
-
Looking for private training in central Scotland? Our qualified trainers can make the trip to your office, providing professional on-site training in an environment that's comfortable and familiar to you.