Excel 2016 Fundamentals - Half Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Create and modify a worksheet
  • Perform calculations
  • Format a worksheet
  • Work with workbooks and worksheets
  • Print a workbook

Class Content

Lesson 1: Exploring the Excel 2016 Environment

  1. Navigating in Microsoft Excel 
  2. Customizing the Quick Access Toolbar and the Ribbon
  3. Using the Backstage View and Saving a File
  4. Exploring "Tell Me" and "Smart Lookup" Features

Lesson 2: Creating and Modifying a Worksheet

  1. Entering and Editing Data
  2. Selecting, Cutting, Copying, and Pasting
  3. Inserting and Deleting Cells, Columns, and Rows 

Lesson 3: Performing Calculations

  1. Understanding Cell References 
  2. Doing Simple Calculations 
  3. Inserting Frequently Used Functions 
  4. Copying Formulas across Adjacent Cells using AutoFill
  5. Adding Absolute Cell References to Formulas 

Lesson 4: Formatting a Worksheet

  1. Formatting the Font, Border, Shading and Alignment
  2. Merging Cells 
  3. Applying Number Formats 
  4. Copying Formatting 
  5. Understanding and Using Themes 

Lesson 5: Workbooks and Worksheets

  1. Viewing Workbooks 
  2. Viewing, Adding and Deleting Worksheets 

Lesson 6: Printing Workbooks

  1. Creating Headers and Footers 
  2. Configuring the Margins and Page Orientation
  3. Viewing and Using Page Breaks

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!