MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 2.5 hours | Size: 1.74 GBBecoming a Professional user of Microsoft ExcelWhat you’ll learnThis intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of tools and concepts for Excel 2007, 2010, 2013 or 2016 in order to further increase their knowledge and productivity.

RequirementsDelegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.

DescriptionMODULE 1: Advanced Conditional FormattingLearning outcomes: Looking at the more advanced Conditional Formatting features and how to manage them effectively.

Topics covered:Editing Standard Formatting RulesUsing Formulas in Conditional FormattingMODULE 2: Using Form Controls and TemplatesLearning outcomes: Introducing Form controls and using them to manage user interaction to help ensure they enter/search for information both accurately and effectively.

Topics covered:Using Form ControlsCreating TemplatesMODULE 3: Advanced Lookup FunctionsLearning outcomes: An in-depth look into Excel’s specialist lookup functions and the concept of arrays.

Topics covered:Using the Index FunctionUsing the Match FunctionUsing Index and Match TogetherUsing Index and Match with Array FormulaUsing the Indirect FunctionMODULE 4: Advanced Functions in ExcelLearning outcomes: Effectively using Error, Logical and Rounding functions along with array formulas.

Topics covered:Using Error FunctionsUsing Logical FunctionsUsing Array FormulasUsing Rounding FunctionsMODULE 5: Advanced Pivot Table ToolsLearning outcomes: How to import Pivot Table data from external source along with adding custom fields and formulas.

Topics covered:Importing Pivot Table DataCalculated Fields in Pivot TablesShowing Pivot Data as a PercentageCreating Custom Pivot Tables StylesMODULE 6: Introduction to User Defined Functions Using VBALearning outcomes: Using VBA to create specialist procedure and to define your own Excel functions.

Topics covered:Creating a User Defined FunctionCreating an Interactive ProcedureCreate and Share a Function Add-inWho this course is for:Users with a solid understanding of, and experience with, Microsoft Excel 2007, 2010, 2013 or 2016 who want to increase their ability in a short space of time.