Certified and Advanced Degree
Computer Instructors and Consultants
Course Catalog
Microsoft Excel O365 - Level 1 / Intro
Code: EXC O365 L1
Duration: 1 Day
$295 USD

OVERVIEW

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.

DELIVERY FORMAT

This course is available in the following formats:

Virtual Classroom

Duration: 1 Day
Classroom

Duration: 1 Day

CLASS SCHEDULE
Call 800-798-3901 to enroll in this class!

GOALS

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)
OUTLINE

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 Options

  • 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

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 Options

  • 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
LABS

Will Be Updated Soon!
Will Be Updated Soon!
WHO SHOULD ATTEND

Students willing to speed with Excel quickly.

PREREQUISITES

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