4 Hour Live Virtual Training on MS Excel Formulas and Tools of t (Fremont, CA)

4 Hour Live Virtual Training on MS Excel Formulas and Tools of t

About the CourseIn this practical and interactive webinar you will work along with the instructor. As you progress through the provided spreadsheet of exercises you will learn a handful of the most often used formulas in Excel. These will include VLookup HLookup Index and Match (solved at last ) Text to Columns Concatenate remove Duplicates IF Functions Flash Fill and more You will also discover the tools Andy uses almost daily but are overlooked and mostly forgotten in Excel. These include Formula Auditing Formula Watch Show Formulas and special tools to add to the Quick Access Toolbar. Course ObjectiveText To Columns and then Reverse w ConcatonateUse two types of IF Functions (Logical and Error)Understand the syntax of the VLookup and HLookup formulas Understand the syntax of the Index and Match formulas (finally simply explained) Transpose Data that may be organized incorrectlyRemove Duplicates while staying in charge of the process with Conditional FormattingFlash Fill (new in 2016)Absolute Ref vs Named Range in FormulasFormula Auditing Show CodesFormula Watch WindowAnd hidden tools to add to your Quick Access ToolbarRegister now