Microsoft Excel Level 1 (Basic)

Section 1: Creating, Opening and Saving Workbooks

What Is Excel?

Create a New Blank Workbook

Open Excel Files

Save Workbooks

Navigate a Workbook

Selection Types

Data Checkers

Help

Section 2: Exploring the User Interface

Backstage View

Ribbon Overview

Quick Access Toolbar

Status Bar

Shortcut Key Tips

Contextual Tabs

Section 3: Working with Data

Basic Data Types

Enter, Edit and Delete Data

Use Autocomplete and Autofill

Resize Columns and Rows

Insert and Delete Columns, Rows, Cells

Hide and Unhide Columns and Rows

Use Undo, Redo and Repeat

Spellcheck and AutoCorrect

Use Find, Replace and Go To

Cut, Copy, Paste and Paste Special

Use the Fill Handle

Section 4: Performing Calculations

Use Basic Formulas

Use Basic Functions

Understand Absolute and Relative Cell References

Section 5: Using Time Saving Tools

Flash Fill

AutoCalculate

Section 6: Formatting A Workbook

Work with Fonts and Font Attributes

Apply Borders and Shading

Use the Format Painter

Change Text Alignment

Wrap Text

Apply Manual Line Breaks

Rotate Text

Merge and Centre Text

Create and Modify Styles

Apply Number Formats

Clear Formatting

Section 7: Managing Large Workbooks

Rename Worksheets

Colour-code Worksheet Tab Colours

Copy, Move, Delete, and Group Worksheets

Work with Freeze Panes

Section 8: Printing and Viewing A Workbook

Work with Page Breaks

Work with Print Preview and Page Layout View

Change Margins and Page Orientation

Scale to Fit Worksheets

Insert Headers and Footers

Print Titles Across All Pages

Review Print Options