MICROSOFT EXCEL EXPERT MO-211 CERTIFICATION BOOTCAMP

• How the MO-211 Expert exam is structured — about 50 minutes and roughly 35 task-based items completed in a live copy of Excel
• Navigating the Certiport testing interface, which is fully performance-based with no multiple-choice questions
• How each task and its individual sub-steps are scored, so you understand exactly where points come from
• Time-management and the skip-and-flag strategy for working efficiently against the clock
• The bookend method: sitting a live baseline attempt early in the course, then a focused retake at the end
• Reading every task prompt in full and confirming your changes actually applied before moving on

• Copy macros from one workbook into another so your automation travels with your files
• Build formulas and links that reference data stored in other workbooks
• Enable and run macros safely inside a macro-enabled workbook
• Manage workbook versions and recover earlier saved states of a file
• Restrict editing so collaborators can only change the ranges you allow
• Protect individual worksheets and specific cell ranges from changes
• Protect the overall workbook structure to lock sheet order and visibility
• Configure formula calculation options, switching between automatic and manual recalculation for large models

• Fill cells automatically with Flash Fill to split, combine, and reformat data by example
• Use advanced Fill Series options to generate dates, linear steps, and growth patterns
• Generate arrays of random numeric data with the RANDARRAY() function
• Create custom number formats to control exactly how values display
• Configure data validation rules and drop-down lists to control what can be entered
• Group and ungroup rows and columns to build collapsible outlines
• Calculate data by inserting subtotals and grand totals into grouped data
• Find and remove duplicate records from a data set
• Create custom conditional formatting rules beyond the built-in presets
• Write conditional formatting rules that are driven by your own formulas
• Edit, reorder, and manage existing conditional formatting rules

• Build nested logical formulas with the IF(), IFS(), and SWITCH() functions
• Run conditional calculations with SUMIF()/SUMIFS(), AVERAGEIF()/AVERAGEIFS(), and COUNTIF()/COUNTIFS()
• Return conditional minimums and maximums with the MAXIFS() and MINIFS() functions
• Combine multiple conditions using the AND(), OR(), and NOT() functions
• Simplify and speed up complex formulas by naming intermediate values with LET()
• Look up and retrieve data with the XLOOKUP(), VLOOKUP(), and HLOOKUP() functions
• Locate and return values by position using the MATCH() and INDEX() functions
• Reference the current date and time with the NOW() and TODAY() functions
• Calculate weekdays and working days with the WEEKDAY() and WORKDAY() functions
• Summarize data from multiple ranges using the Consolidate feature
• Perform what-if analysis with Goal Seek and Scenario Manager
• Forecast data using the AND(), IF(), and NPER() functions
• Calculate loan and payment figures with the PMT() function
• Return matching rows dynamically with the FILTER() function
• Reorder results dynamically with the SORTBY() function
• Trace precedents and dependents to map how your formulas connect
• Monitor key cells and formulas across the workbook with the Watch Window
• Validate formulas using Excel’s error-checking rules
• Step through a calculation piece by piece with Evaluate Formula
• Record, name, and edit simple macros to automate repetitive tasks

WHAT YOU WILL GET

• Two on-site attempts at the official MO-211 exam (when your exam history allows)
• The official proctored exam administered on-site at our Certiport Authorized Testing Center
• Practice exams with excel files and pdf instructions
• A personalized study plan based on your exam score report