• Copy macros between workbooks
• Reference data in other workbooks
• Enable macros in a workbook
• Manage workbook versions
• Restrict editing
• Protect worksheets and cell ranges
• Protect workbook structure
• Configure formula calculation options
• Manage comments
• Configure editing and display languages
• Use language-specific features
• Fill cells by using Flash Fill
• Fill cells by using advanced Fill Series options
• Create custom number formats
• Configure data validation
• Group and ungroup data
• Calculate data by inserting subtotals and totals
• Remove duplicate records
• Create custom conditional formatting rules
• Create conditional formatting rules that use formulas
• Manage conditional formatting rules
• Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions
• Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions
• Reference date and time by using the NOW() and TODAY() functions
• Calculate dates by using the WEEKDAY() and WORKDAY() functions
• Summarize data from multiple ranges by using the Consolidate feature
• Perform what-if analysis by using Goal Seek and Scenario Manager
• Forecast data by using the AND(), IF(), and NPER() functions
• Calculate financial data by using the PMT() function
• Trace precedence and dependence
• Monitor cells and formulas by using the Watch Window
• Validate formulas by using error checking rules
• Evaluate formulas
• Record simple macros
• Name simple macros
• Edit simple macros
• Create and modify dual axis charts
• Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts
• Create PivotTables
• Modify field selections and options
• Create slicers
• Group PivotTable data
• Add calculated fields
• Format data
• Create Pivot Charts
• Manipulate options in existing Pivot Charts
• Apply styles to Pivot Charts
• Drill down into PivotChart details