Microsoft Excel O365/2019 - Level 1 / Intro

Module 1: Getting Started with Microsoft Excel

Excel Interface

• What are Spreadsheets, Worksheets, and Workbooks?
• What are Columns, Rows, Cells, and Ranges?
• The Excel Interface
• Navigation Options
• Creating a New Blank Workbook
• Creating a New Workbook from a Template

Create a Basic Worksheet

• The Ribbon
• Data Types
• Excel 2016 File Formats
• The Save and Save As Commands
• Save as a PDF or XPS

Module 2: Modifying a Worksheet

Manipulate Data

• The Undo and Redo Commands
• The AutoFill Feature
• AutoFill Options
• The Transpose Option
• Live Preview
• The Clear Button
• Work with Comments

Insert, Manipulate, and Delete Cells, Columns, and Rows

• The Insert and Delete Options
• Column Width and Row Height Alternation Methods
• The Hide and Unhide Options

Search For and Replace Data

• Cell Names and Range Names
• The Find Command
• The Replace Command
• The Go To Command

Module 3: Formatting a Worksheet

Modify Fonts

• Fonts
• The Font Group
• The Format Cells Dialog Box
• The Format Painter
• Galleries
• Live Preview and Formatting
• The Mini Toolbar

Add Borders and Colors to Cells

• Border Options
• Fill Options
• Sheet Backgrounds
• Paste Options

Apply Number Formats

• Number Formats
• Number Formats in Excel
• Custom Number Formats

Align Cell Contents

• Alignment Options
• The Indent Commands
• The Wrap Text Command
• Orientation Options
• The Merge & Center Options

Apply Cell Styles

• Cell Styles
• The Style Dialog Box

Module 4: Performing Calculations

Create Formulas in a Worksheet

• Excel Formulas
• The Formula Bar
• Elements of an Excel Formula
• Common Mathematical Operators
• The Order of Operations

Insert Functions in a Worksheet

• Functions
• The Function Library
• Common Functions in Excel
• The Formula AutoComplete Feature

Reuse Formulas

• The Cut, Copy, and Paste Commands
• Paste Special Options
• Relative References
• Absolute References
• Mixed References

Module 5: Basic Charts

Create a Basic Chart (Charting is covered in depth in Level 2)

• Select Data
• Chart Data
• Change the Chart Type
• Work with chart Labels

Module 6: Printing Workbook Contents

Define the Basic Page Layout for a Workbook

• The Print Options in Backstage View
• The Page Setup Dialog Box
• The Print Preview Option
• Workbook Views
• Headers and Footers
• Header and Footer Settings
• Page Margins
• Margins Tab Options
• Page Orientation

Refine the Page Layout and Apply Print Options

• Zoom Options
• Page Breaks
• Page Break Options
• The Print Area
• Print Title
• Scaling Options

Module 7: Refine the Page Layout and Apply Print Option

Format Worksheet Tabs

• Format Worksheet Tabs
• Changing Tab Color

Manage Worksheets

• Grouped Worksheets
• Repositioning Worksheets
• Inserting or Deleting Worksheets
• Hiding and Unhiding Worksheets
• Worksheet References in Formulas

Manage the View of Worksheets and Workbooks

• The Split Command
• The Freeze Panes Options
• The Arrange All Command
• The Arrange Windows Dialog Box
• The View Side by Side Command
• The Switch Windows Command
• The New Window Command

Module 8: Customizing the Excel Environment (if time allows)

• Excel Options dialog Box
• Customize Formulas Options
• Customize Proofing and Save Options
• Customize Ribbon and Quick Access Toolbar

Students will learn,

• Getting Started with Microsoft Excel
• Modifying a Worksheet
• Formatting a Worksheet
• Performing Calculations
• Basic Charts
• Printing Workbook Contents
• Refine the Page Layout and Apply Print Options
• Customizing the Excel Environment (if time allows)

The prerequisites for this course are an introductory course to Windows or a solid working knowledge of Windows.

Students willing to speed with Excel quickly.