Advanced Excel for Business (Live Online)

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more.Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you.Prerequisite:Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.What You’ll Learn at a GlanceWhat-if Analysis: Goal Seek & Data TablesAdvanced cell lockingCreate more flexible lookup functions with INDEX-MATCHAdvanced Pivot Table techniquesRecord relative and absolute macrosAdvanced nested functionsWork without a mouse using Hot KeysCourse SyllabusAdvanced NavigationAdvanced NavigationFill ReviewCell ManagementAdvanced Cell LockingHot KeysCell AuditingGo To SpecialSpecial FormattingConditional Formatting-FormulasDate FunctionsCustom Number FormatsAdvanced FunctionsNested IF statementsIF statements with AND/ORWhat If AnalysisGoal SeekData TablesAdvanced Analytical ToolsCalculation OptionsConditional SumProductPivot Table-Base Fields & SetsPivot Table-CalculationsPivot ChartsAdvanced Database FunctionsXMATCH functionINDEX-MATCHINDEX-Double MATCHIntroduction to MacrosRecording MacrosDynamic ArraysDynamic ArraysEnd of Class ProjectsProjectsLearn more about Advanced Excel for Business at NYIM Training.