Excel 2013 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 2013 Environment

  1. Launch screen and Ribbon Overview
  2. Quick Access Toolbar Overview
  3. Using the Backstage View and OneDrive
  4. Working with Contextual Tabs

Lesson 2: Creating and Modifying a Worksheet

  1. Selecting Parts of a Worksheet
  2. Entering/Editing Data
  3. Saving a Workbook
  4. Cutting, Copying and Pasting
  5. Working with AutoFill
  6. 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
  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!