Excel Expert Certification Program (Live Online)

This Excel certification program will prepare you for the Microsoft Excel exam "Excel 2016 Expert: Interpreting Data for Insights." Learn formulas, functions, Pivot Tables, charts, and more, and ace the Microsoft Excel Expert exam. Check out using "Flexible Scheduling" on the right. Once you've signed up, email us to schedule your three group classes, private training, and exam date. We offer weekday, weeknight, and weekend group classes and private training options, so you can work on your own schedule.The Excel Expert Certification Program IncludesBeginner Microsoft ExcelGet going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow. Intermediate Microsoft ExcelTake your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.Advanced Microsoft ExcelBecome an expert Excel user with this Advanced Excel course. Learn powerful functions like INDEX-MATCH, work with advanced Pivot Table functions, and start recording macros to automate workflows. Prepare yourself for any Excel challenge with this advanced Excel course.Additional ItemsThis package also includes four hours of private training, the Microsoft Excel Expert Exam (with a free retake), and proctoring for the exam. Schedule the private training and exam after you complete the group classes.Excel Expert Exam TopicsOur program will train you for the Microsoft Excel exam: Excel 2016 Expert: Interpreting Data for InsightsHere are the topics covered on the exam, from the Microsoft Excel Expert Certification page:Manage workbook options and settings:Manage workbooks: Saving workbooks as templates, copying macros between workbooks, referencing data in other workbooks, structured references, enabling macros, displaying hidden ribbon tabsManage workbook review: Restrict editing, protecting worksheets, configuring formula calculation options, protecting workbook structure, managing versions, and encrypting with passwordsApply custom data formats and layoutsApply custom data formats and validationApply advanced conditional formatting and filteringCreate and modify custom workbook elementsPrepare a workbook for internalizationAdvanced FormulasLogical operations including AND, OR, NOT, SUMIFS, AVERAGEIFS, and COUNTIFSLookup functions including VLOOKUP, HLOOKUP, INDEX and MATCHWhat-if analysis using Goal Seek and Scenario ManagerDate and time functionsFinancial functionsTroubleshoot formulas: trace precedents and dependents, monitor cells using the Watch Window, error checking, evaluate formulasDefined named ranges: naming cells and ranges, managing namesAdvanced Charts & TablesAdd trendlines to charts, creating dual-axis charts, and saving chart templatesPivotTables: Creating PivotTables, modifying field selections and options, creating slicers, grouping PivotTable data, referencing data using GETPIVOTDATA, calculated field, and formatting dataPivotCharts: Creating PivotCharts, manipulating options, applying styles, and drilling down into detailsLearn more about Excel Expert Certification Program at NYC Career Centers.