« Back to Class Listing

Excelling at Excel: The FUNdamentals

Description

In this half-day course, students will discover important shortcuts and tips and tricks in navigating and selecting data in Excel. We’ll customize Excel through our Quick Access Toolbar and important options. The course teaches formatting, using Autofill, and how to create formulas and functions the right way the first time. Finally, we will print and view Excel worksheets using Freeze and Split panes, Page Layout View, and Page Break Preview.

Audience: This course is designed for those who are new to Excel and want to learn to create and work with electronic spreadsheets.

Software: This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, you will be able to:

  1. Increase productivity through shortcuts and the Quick Access Toolbar
  2. Create attractive worksheets with formatting
  3. Use AutoFill to save time and input for text, numbers, dates, and formulas/functions
  4. Develop formulas and functions in Excel
  5. Understand syntax of Excel’s formulas and functions
  6. Print and view Excel worksheets the right way

Section: MS-EXCEL-FUND (12MAY17)
Dates: May 12, 2017 - May 12, 2017 Time: 9:00 AM
Tuition: $185.00 Instructor: Greg Creech Register

Lesson 1: The Excel Environment, Shortcuts and Customization
  • Excel terminology: “Ribbon,” “tabs,” “columns,” “rows,” “cells,” and “worksheets”
  • Keyboard shortcuts and menus for navigating and selecting data in Excel
  • Customize the Quick Access Toolbar and the Ribbon

Lesson 2: Formatting
  • Merge and Center
  • Text Orientation
  • Fills and Borders
  • Format Painter
  • Number and Date formatting

Lesson 3: AutoFill
  • Text
  • Dates
  • Numbers
  • Formulas and Functions

Lesson 4: Formulas and Functions
  • Difference formulas
  • SUM
  • AVERAGE
  • COUNT
  • COUNTA
  • TODAY

Lesson 5: Printing and Viewing Worksheets
  • Page Setup
  • Freezing and splitting panes
  • Page Layout View
  • Headers and Footers
  • Page Break Preview

Class Schedule

Date Times Meeting Type Location
05/12/2017 9:00 AM - 12:00 PM Classroom Executive Park

Additional Information

Final Enrollment:
 
Clock Hours: 3.0