Microsoft Excel O365/2019 - Level 1 / Intro Course Details:

We will cover different features of the interface, the basics of formatting and editing, the basics of building formulas and functions and show users how to print.

    No classes are currenty scheduled for this course.

    Call (919) 283-1653 to get a class scheduled online or in your area!

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

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.

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.

Ready to Jumpstart Your IT Career?