Microsoft® Office Excel for Business (Int – Adv Level) -0501045727

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 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. Mastering the latest functions of Microsoft Excel is one of the most sophisticated skills required in every domain from marketing to scientific research. Our experienced trainers will provide you with hands-on experience and help you understand a lot about Microsoft Excel in addition to valuable tips that will give you a competitive edge in the job market.

Mode: Face to Face/Online

• 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 Calculation