Microsoft Excel - Beginner

Course subjects

Getting to Know Excel

• What are Spreadsheets, Worksheets, and Workbooks?

• Columns, Rows, Cells, and Ranges

• The Excel Interface and Ribbon

• Keyboard Navigation Options

• Creating Workbooks and File Formats

Using Formulas and Functions

• About Functions and AutoComplete

• Using the Insert Function Dialog Box

• AutoSum and Status Bar Calculations

• Automatic Workbook Calculations

• Mathematical Operators and Order of Operations

Working with Data

• Selecting Cells and Data Entry

• Cut, Copy, and Paste Operations

• Paste Options and Live Preview

• AutoFill and FlashFill Features

• Undo and Redo Functions

Working with Rows and Columns

• Inserting and Deleting Rows/Columns

• Clearing Data from Cells

• Changing Column Width and Row Height

• Hide and Unhide Functions

Managing Worksheet Structure

• Sorting and Filtering Data

• Sorting vs Filtering Concepts

• Sorting Data in Ascending/Descending Order

• Enabling and Using Filters

• Text Filters and Clearing Filters

• Data Organisation Best Practices

Formatting Text and Cells

• Fonts and Format Cells Dialog Box

• Format Painter and Mini Toolbar

• Applying Borders and Fills

• Number Formats and Custom Formatting

• Aligning Cell Content and Text Wrapping

Printing Workbook Contents

• Define Page Layout and Print Options

• Page Setup and Print Preview

• Headers, Footers, and Margins

• Page Orientation and Scaling Options

• Page Breaks and Print Titles

Managing Large Workbooks

• Format, Rename, and Colour Worksheet Tabs

• Grouped Worksheets Operations

• Repositioning, Inserting, or Deleting Worksheets

• Hiding/Unhiding Worksheets

• Worksheet References in Formulas

Customising Excel Environment

• Customise General, Language, and Formula Options

• Version Control and Save Options

• Customise Ribbon and Quick Access Toolbar

• Add-ins and Developer Tab

• Advanced and Trust Centre Options

Search and Replace Data

• Cell Names and Range Names

• Find, Replace, and Go To Functions

• Spell Check and Spelling Dialog Box

• Data Validation and Error Checking

• Accessibility and Help Options