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 UsersPaste SpecialConditional FormattingLocking and ProtectionAdvanced ChartsData ValidationScenariosFormula Auditing and CommentsSubtotallingSparklinesFiltering and Advanced FilteringPivot Tables and Pivot ChartsNamed Cells and Named RangesMixed Cell ReferencingMathematical & Statistical FunctionsVlookup FunctionNested FunctionsDatabase FunctionsText FunctionsDate Functions and CalculationsWhether 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.