EXF: Microsoft Excel 2021 Foundation

Module 1: Getting Started with Microsoft Excel 2021
Topic A – Identify the Elements of the Excel Interface

• Microsoft Excel 2021
• What is Spreadsheet, Worksheet and Workbook
• What are Columns, Row, Cells, and Ranges
• The Excel Interface
• Navigation Options

Topic B Creating a New Blank Workbook

• The Ribbon
• The File View
• The Save and Save As Commands

Module 2: Formatting a Data in Worksheet
Topic A: Formatting Fonts

• Font type
• Font size
• Font color
• Bold
• Italic
• Underline
• The Mini Toolbar
• The Clear Button

Topic B: Add Borders and Colors to Cells

• Select Border
• Select Fill

Topic C: Align Cell Contents

• Horizontal Alignment
• Vertical Alignment
• Increase or Decrease Indent
• Wrap Text
• Orientation Options
• Merge & Center

Topic D: Apply Formats

• Format cell
  • Number
  • Date
  • Currency
• Paste Format

Topic E: Move and Duplicate data

• Dragging and Dropping Cells
• Cut, copy, and paste cells
• Cut, copy, and Paste Multiple cells
• Using the Clipboard
• Paste Value
• Format Painter

Topic F: Apply Cell Styles

• Cell Styles
• Style Dialog Box

Topic G: Manipulate Data

• Undo and Redo Commands
• AutoFill Feature
• Auto Fill Options
• Transpose Option

Topic H: Insert, Manipulate, and Delete Cells, Columns, and Rows

• Insert and Delete cell, row, column
• Column Width and Row Height Alternation Methods
• Hide and Unhide row, column

Module 3: Performing Calculation
Topic A: Create Formulas in a Worksheet

• Common Mathematical Operators
  • Addition
  • Subtract
  • Multiply
  • Divide
• The Order of Operations

Topic B: Insert Functions in a Worksheet

• Functions in Excel
  • SUM
  • AVERAGE
  • COUNT
  • MIN
  • MAX
• Worksheet References in Formulas

Module 4: Managing Large Workbooks
Topic A: Format Worksheet Tabs

• Insert sheet
• Renaming Worksheet Tabs
• Changing sheet Tab Color

Topic B: Manage Worksheets

• Repositioning Worksheets
• Inserting or Deleting Worksheets
• Hiding and Unhiding Worksheets

Topic C: Spell Check a Worksheet

• The Spelling Dialog Box

Topic D: Search for and Replace Data

• The Find Command
• The Replace Command
• The Go to Command

Topic E: Manage the view of Worksheets and Workbooks

• Split Command
• Freeze Panes
• Arrange All Command
• View Side by Side Command
• Switch windows Command
• New Window Command
• Zoom Options

Module 5: Printing Workbook Contents
Topic A:  Define the Page Setup

• Page size
• Page orientation
• Page Margins
• Headers and Footers

Topic B: Print Options

• Scale to fit
• Page break
• Print title