Free MO-211 Exam Prep

Copy macros between workbooks, reference data in other workbooks, enable macros, manage workbook versions, restrict editing, protect worksheets and cell ranges, protect workbook structure, and configure formula calculation options

Fill cells with Flash Fill and advanced Fill Series options, generate numeric data with RANDARRAY(), create custom number formats, configure data validation, group and ungroup data, insert subtotals and totals, remove duplicate records, and apply custom and formula-driven conditional formatting rules

Nest logical and conditional-aggregate functions (IF, IFS, SWITCH, SUMIF(S), AVERAGEIF(S), COUNTIF(S), MAXIFS, MINIFS, AND, OR, NOT, LET), look up data with XLOOKUP/VLOOKUP/HLOOKUP/MATCH/INDEX, use NOW, TODAY, WEEKDAY and WORKDAY, perform data analysis with Consolidate, Goal Seek, Scenario Manager, NPER, PMT, FILTER and SORTBY, troubleshoot formulas, and record, name and edit simple macros

Create and modify dual-axis charts and Box & Whisker, Combo, Funnel, Histogram, Sunburst and Waterfall charts; create PivotTables, modify field selections and options, create slicers, group PivotTable data, add calculated fields, configure value field settings; and create, restyle and drill into PivotCharts