Excel: operational level

Interface review

• Starting Excel.
• Exiting Excel.
• Using and managing the ribbon.
• Exploring the File tab.
• Undoing recent actions.
• Redoing previously undone actions.
• Repeating the last action.

Display

• Changing the view.
• Switching between Touch and Mouse modes.
• Changing the formula bar display.
• Showing and hiding gridlines and row and column headings.
• Changing the zoom level.
• Activating one or more windows.
• Freezing and unfreezing rows and columns.

Workbooks

• Creating a blank workbook.
• Creating a workbook from a template.
• Opening a workbook.
• Saving a workbook.
• Working with workbooks.
• Closing a workbook.
• Sending a workbook by email.

Navigation and selection

• Navigating a worksheet.
• Going to a specific cell.
• Finding a cell.
• Selecting cells.
• Selecting rows and columns.
• Selecting cells based on their contents.

Entering and editing data

• Entering constant data, including text and values.
• Inserting special characters.
• Inserting the system date or time in a cell.
• Using AutoComplete.
• Using Flash Fill to complete a column.
• Entering multiple lines of text in a cell.
• Creating a data series.
• Editing cell contents.
• Clearing cell contents.
• Replacing cell contents or formatting.
• Checking spelling.
• Sorting table data by a single value-based criterion.

Calculations

• Understanding formulas.
• Creating a simple formula.
• Making a cell reference absolute in a formula.
• Entering a formula across worksheets.
• Creating a formula containing a function.
• Using function AutoComplete.
• Summing a range of cells.
• Using basic statistical functions.

Copying and moving

• Copying contents to adjacent cells.
• Copying and moving cells.
• Copying cells to other worksheets.
• Using the Office Clipboard.
• Copying formatting.
• Copying cell contents, results and formatting.

Worksheets

• Activating a worksheet.
• Renaming a worksheet.
• Selecting worksheets.
• Changing tab colours.
• Showing and hiding a worksheet.
• Displaying a worksheet background image.
• Moving and copying one or more worksheets.
• Inserting and adding worksheets.
• Deleting worksheets.

Rows, columns and cells

• Inserting rows and columns.
• Deleting rows and columns.
• Changing column width and row height.
• Auto-fitting column width and row height.

Standard formatting

• Changing character emphasis.
• Formatting cell contents.
• Data alignment.
• Changing cell content orientation.
• Aligning cell contents.
• Indenting cell contents.
• Merging cells.

Borders and fills

• Applying cell borders.
• Applying cell background colours.
• Applying background patterns and gradients.
• Styles and themes.
• Applying a cell style.
• Applying a workbook theme.

Page layout

• Changing page layout settings.
• Creating a print area.
• Inserting and removing manual page breaks.
• Repeating rows and columns on each printed page.
• Creating and managing headers and footers.

Printing

• Using Print Preview.
• Printing a workbook, worksheet or selection.

Creating charts

• Creating a chart.
• Activating and deactivating an embedded chart.
• Changing chart location.
• Switching chart rows and columns.
• Changing the chart data source.
• Adding one or more data series.
• Removing a data series.
• Changing data series order.
• Creating and deleting sparklines.
• Editing a sparkline.

Chart options

• Selecting chart elements.
• Changing the chart or series type.
• Applying predefined chart formatting.
• Displaying a chart element.
• Applying a quick chart style.

Graphic objects

• Creating a graphic object.
• Inserting an image file or clip art.
• Inserting a screenshot.
• Inserting a SmartArt diagram.
• Managing shapes in a diagram.
• Changing a diagram's overall appearance.

Managing objects

• Selecting objects.
• Managing objects.
• Changing object formatting.
• Changing picture formatting.
• Emphasising text within an object.
• Keyboard shortcuts.
• Index.

PivotTables

• Choosing a recommended PivotTable.
• Creating a PivotTable.
• Creating a PivotTable from multiple tables.
• Managing PivotTable fields.
• Inserting a calculated field.
• Changing a field's summary function or custom calculation.
• Using totals and subtotals.
• Filtering a PivotTable.
• Grouping PivotTable data.
• Filtering dates interactively with a timeline.
• Changing PivotTable layout and presentation.
• Recalculating a PivotTable.
• Deleting a PivotTable.