Microsoft Excel: Fundamentals for Advanced Level Users

Course details

Are you looking to improve your Excel skills to become an advanced level user?

This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. 

In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK.

Microsoft Excel - Fundamentals of Advanced Level Users

• Paste Special
• Conditional Formatting
• Locking and Protection
• Advanced Charts
• Data Validation
• Scenarios
• Formula Auditing and Comments
• Subtotalling
• Sparklines
• Filtering and Advanced Filtering
• Pivot Tables and Pivot Charts
• Named Cells and Named Ranges
• Mixed Cell Referencing
• Mathematical & Statistical Functions
• Vlookup Function
• Nested Functions
• Database Functions
• Text Functions
• Date Functions and Calculations