Are you lookingto 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 inMicrosoftExcel. We will assume you have all the knowledge taught in ourprerequisitecourse, 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- 18minutes long, withno lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a MicrosoftCertified Trainer who has beentraining MicrosoftExcel 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

Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place. In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master!

See you there!

-Richard Walters (Microsoft Excel Trainer)

__________

Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project.