« Back to Class Listing

Microsoft Excel Level 1: Introduction

Description

This class is taught specifically for Microsoft Excel 2010 using our lab PCs. Material learned in this course may not apply to different versions of Excel (2007/2013/2016) or those for Mac.

Excel is one of the most powerful and frequently used tools in an office environment. Get the most out of Excel 2010 by learning to create, edit, and print basic Excel spreadsheets with the latest version of this application! In this course, you will learn to speed up data entry, move and copy information, and create formulas to perform calculations. You'll prepare a spreadsheet for printing by setting margins, page breaks, and more. Finally, you'll learn to manage large Excel workbooks, making your data more readable and more attractive with formatting techniques.

Section: MS-EXCEL-LVL1 (26APR17)
Dates: Apr 26, 2017 - Apr 26, 2017 Time: 9:00 AM
Tuition: $375.00 Instructor: Karen Maddox-Jones Inquire
    Lesson 1: Getting Started
  • Explore the User Interface and the Ribbon
  • Navigate and Select in Excel
  • Obtain Help
  • Enter Data and Save a Workbook
  • Customize the Quick Access Toolbar

    Lesson 2: Modifying a Worksheet
  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

    Lesson 3: Performing Calculations
  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions

    Lesson 4: Formatting a Worksheet
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Position Cell Contents
  • Apply Cell Styles

    Lesson 5: Managing Large Workbook
  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large Worksheets

    Lesson 6: Printing Workbook Contents
  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks

Class Schedule

Date Times Meeting Type Location
04/26/2017 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
 
Clock Hours: 6.5