Intermediate Excel for Business (Live Online)

Master VLOOKUP, Pivot Tables, formulas and functions in this hands-on course. Learn the essential Excel skills with real-world projects from the experts.Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP and XLOOKUP, and learn techniques to expedite your workflow. Split and join text, create dropdown menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class, you'll unlock powerful techniques that will help you complete tasks more quickly.Prerequisite:Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.What You’ll Learn at a GlanceNavigation tricks & shortcutsSummarize data with Pivot TablesVLOOKUP & XLOOKUP functionsJoin and split textCreate drop-down menusSort & filter dataTricks to speed up workflowLogical functions: IF, AND, ORCourse SyllabusWorksheet ManagementNavigationFormula ReviewWorking with TextSplitting TextJoining TextCell RangesPaste SpecialPaste Special ValuesNamed RangesDatabase FunctionsVLOOKUP & XLOOKUPSort & FilterPivot TablesPivot TablesPivot Tables & GroupingMultiple Pivot TablesLogical FunctionsIF statementsAND, ORMath FunctionsSUBTOTALStatistical FunctionsSUMIFSCOUNTIFSImprove Data QualityData ValidationRemove DuplicatesAdvanced ChartsCombo ChartsEnd of Class ProjectProjectLearn more about Intermediate Excel for Business at NYIM Training.