Earn the prestigious credential of Microsoft Certified: Excel Expert with this comprehensive certification program. This Excel training pathway will prepare you thoroughly for the Microsoft Excel exam "Excel 2016 Expert: Interpreting Data for Insights." Master advanced formulas, functions, PivotTables, sophisticated charting techniques, and much more to successfully pass the certification exam.
Choose "Flexible Scheduling" to get started. After enrollment, contact us to schedule your three group classes, private training sessions, and certification exam. We offer weekday, evening, and weekend group classes plus personalized training options, allowing you to study at your preferred pace.
The Excel Expert Certification Program Includes:
Beginner Microsoft Excel
Get comfortable with Excel fundamentals and begin working on practical spreadsheets. Develop proficiency with calculations and formulas, visual data representations through charts and tables, worksheet and workbook formatting, and keyboard shortcuts that accelerate your work.
Intermediate Microsoft Excel
Advance your Excel proficiency in this intermediate-level course. Learn critical functions including VLOOKUP, conditional SUMs (SUMIFS), and Pivot Tables through practical, hands-on training. You will also master essential text manipulation features like text splitting, combining multiple values, removing duplicate entries, and implementing data validation rules.
Advanced Microsoft Excel
Become a proficient Excel user through this advanced course. Learn sophisticated functions such as INDEX-MATCH combinations, advanced Pivot Table operations, and an introduction to macro automation to streamline repetitive tasks. Prepare yourself to excel in any professional spreadsheet challenge with this advanced curriculum.
Additional Items:
Your program package includes four hours of one-on-one private training, the official Microsoft Excel Expert Exam (plus one complimentary retake if needed), and professional exam proctoring. Schedule your private training and exam after completing the group classes.
Excel Expert Exam Topics:
Our program provides complete preparation for the Microsoft Excel exam: Excel 2016 Expert: Interpreting Data for Insights
The following topics are covered on the exam, as outlined on the Microsoft Excel Expert Certification page:
- Manage workbook options and settings:
- Manage workbooks by saving as templates, copying macros between workbooks, referencing data in other workbooks, using structured references, enabling macros, and displaying hidden ribbon tabs
- Manage workbook review by restricting editing, protecting worksheets, configuring formula calculation settings, protecting workbook structure, managing document versions, and implementing password encryption
- Apply custom data formats and layouts
- Apply custom data formats and validation rules
- Apply advanced conditional formatting and data filtering
- Create and modify custom workbook elements
- Prepare a workbook for international distribution and use
- Advanced Formulas
- Logical operations, including AND, OR, NOT, SUMIFS, AVERAGEIFS, and COUNTIFS
- Lookup functions, including VLOOKUP, HLOOKUP, INDEX, and MATCH
- What-if analysis using Goal Seek and Scenario Manager
- Date and time functions
- Financial functions
- Troubleshoot formulas by tracing precedents and dependents, monitoring cells using the Watch Window, checking for errors, and evaluating formula results
- Defined named ranges: naming cells and ranges, managing and organizing names
- Advanced Charts and Tables
- Add trendlines to charts, creating dual-axis charts, and saving chart templates
- PivotTables: Creating and modifying PivotTables, adjusting field selections and options, creating slicers for interactive filtering, grouping PivotTable data, referencing data using GETPIVOTDATA, calculated fields, and formatting data
- PivotCharts: Creating PivotCharts, modifying options, applying styles, and drilling down into underlying details
Learn more about the Excel Expert Certification Program at NYC Career Centers.
