-
A instructor-led training course helping people upskill their intermediate knowledge of Microsoft Excel to a fully proficient understanding of Excel's most advanced features. The course allows delegates to return to work with a confidence that they can achieve organisational tasks through an advanced knowledge of Excel's capabilities and an understanding of how to apply it practically to organisational processes and data management. This ability is achieved through learning, discussion and practice while working together with a master-class-level 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
- One-to-one training is £349 + VAT per day
Microsoft Excel Advanced
Whats covered in this course
-
Consolidating Data
-
Consolidate data in different workbooks
-
-
Advanced List Management
-
Subtotals
-
Data Validation
-
Database Functions
-
-
Pivot Tables
-
Creating a PivotTable
-
Rearranging PivotTables
-
Formatting PivotTables
-
PivotCharts
-
Create Slicers
-
-
Collaborating with Other Users
-
Protect a Worksheet
-
Protect Workbooks
-
Set a Workbook password
-
Share a Workbook
-
Set Revision Tracking
-
-
Advanced Formulas
-
Using Names
-
Decision-making
-
Nesting
-
Financial Functions
-
-
Macros
-
Record a Macro
-
Run a Macro
-
Attach a Macro to a button
-
-
Importing and Exporting Data
-
Importing Data
-
Exporting Data
-
-
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.
We at Etopia Training are committed to providing the best IT & business training services available in Scotland. If you are not 100% happy with the outcome of your course, you are entitled to a full refund through our 100% Satisfaction Guarantee.
1 Day of Group Training is £799 per day, 2 Days of Group Training is £699 per day, 3 Days of Group Training is £649 per day.