Excel_256x256.png

Choose your timezone

Register Below or Call (888) 804-1132
and Talk to a Training Specialist Today

$50 off each course when you book more than one course or more than one person per course. Discount will be applied at checkout.
Class sizes are kept small for a better learning experience. Limited to 15 people per class.
  • October 20
    1 day, 8:00 AM PDT - 3:30 PM PDT
    Presented by Chris Murphy
    Online via Zoom
    $350.00 per person
None of these dates work for you? Suggest another date & time

Want to run this as a private class for your team? Enquire about running this event as a private class

Description

This course provides the basic concepts and skills to start being productive with Microsoft Excel: How to create, save, share, and print worksheets that contain various kinds of calculations and formatting.

Excel Essentials

  • Identifying Parts of the Screen
  • The Ribbon
  • Opening/Creating a Workbook
  • Selection Techniques
  • Entering Data
  • Quickly Adjusting Column Width
  • Finishing a Workbook

Performing Basic Calculations

  • Creating Simple Formulas
  • Using Functions - SUM, AVERAGE, MIN, MAX, COUNT
  • Learning Function Syntax with PMT
  • Using the AutoSum Button
  • Editing Data on the Worksheet
  • Clearing the Contents from a Cell or Range
  • Defining Relative, Mixed, and Absolute References
  • Copying Formulas

Managing the Worksheet

  • Navigating in a Worksheet
  • Changing the Worksheet Structure
  • Deleting Cells, Rows, and Columns

Formatting a Worksheet

  • Moving and Copying Data
  • Using AutoFill
  • Changing the Appearance of Data
  • Changing Row Height
  • Formatting Numbers, Text, and Dates

Adding Enhancements

  • Aligning Data in Cells
  • Merging and Centering Cells
  • Rotating and Indenting Text
  • Adding Borders and Shading
  • Adding Graphic Elements

Printing a Worksheet/Workbook

  • Printing the Worksheet
  • Working with Headers and Footers
  • Using Advanced Printing Techniques
  • Aligning the Printout
  • Fitting a Document onto a Desired Number of Pages
  • Working with Page Breaks
  • Repeat Title Rows on Each Page
 

Prerequisites

The course assumes you know how to use a computer and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Excel or another spreadsheet program before. 

Who should attend?

Those who want to accomplish basic workplace tasks in Excel, or if you want to have a solid foundation for continuing on to become an Excel expert.