« Back to Class Listing

Microsoft Excel Level 1: Introduction

Description


Excel is one of the most powerful and frequently used tools in an office environment. Get the most out of Excel 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.

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

Section: MS-EXCEL-LVL1 (05JUN18)
Dates: Jun 05, 2018 - Jun 05, 2018 Time: 9:00 AM
Tuition: $375.00 Instructor: Karen Maddox-Jones Register

    Lesson 1: Getting Started with Microsoft Office Excel 2016
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

    Lesson 2: Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

    Lesson 3: Modifying a Worksheet
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

    Lesson 4: Formatting a Worksheet
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

    Lesson 5: Printing Workbooks
  • Preview and Print a Workbook
  • Set up the Page Layout
  • Configure Headers and Footers

    Lesson 6: Managing Workbooks
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Class Schedule

Date Times Meeting Type Location
06/05/2018 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
 
Clock Hours: 6.5