Excel Level 1
CTU-EXCEL10L1-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

Excel Level 1


jump to schedules and register button

Excel is the software program most requested by today's employers. In this course, you will gain a foundational understanding of the basic functionality in Excel. You will begin by navigating the Excel environment. From there, you will perform the basic tasks associated with creating and saving Excel worksheets and exploring the Help system. You will use formulas and functions to perform calculations in your worksheets, and you will modify worksheets by manipulating cells and data, by searching for and replacing data, and by checking for spelling errors. You will format worksheets and prepare them for printing. You will also begin working with larger workbooks that contain multiple worksheets. Finally, you will customize how Excel behaves to more closely meet your needs.

Who Should Attend

This course is intended for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.

Prerequisites

To be successful in this course, you should be familiar with using the personal computer. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.

Attend and You Will Learn

Getting Started with Excel

  • Identifying the elements of the Excel interface
  • Creating a basic worksheet
  • Using the help system

Performing Calculations

  • Creating formulas in a worksheet
  • Inserting functions in a worksheet
  • Reusing formulas

Modifying a Worksheet

  • Manipulating data
  • Inserting, manipulating, and deleting cells, columns, and rows
  • Searching for and replacing data
  • Spell checking a worksheet

Formatting a Worksheet

  • Modifying fonts
  • Adding borders and color to cells
  • Applying number formats
  • Aligning cell contents
  • Applying cell styles

Printing Workbook Contents

  • Defining the basic page layout for a workbook
  • Refining the Page Layout and Apply Print Options

Managing Large Workbooks

  • Formatting worksheet tabs
  • Managing worksheets
  • Managing the view of worksheets and workbooks

Customizing the Excel Environment

  • Customizing general and language options
  • Customizing formula options
  • Customizing  the proofing and saving options
  • Customizing the ribbon and quick access toolbar
  • Customizing the functionality of Excel by enabling add-ins
  • Customizing advanced and trust center options




Sections

  Excel Level 1
CTU-EXCEL10L1-C - 042
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Wed 9:00AM - 4:30PM
8 Jul 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
 
  Excel Level 1
CTU-EXCEL10L1-C - 043
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Tue 9:00AM - 4:30PM
4 Aug 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
 
  Excel Level 1
CTU-EXCEL10L1-C - 044
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Fri 9:00AM - 4:30PM
21 Aug 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
 
  Excel Level 1
CTU-EXCEL10L1-C - 045
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Fri 9:00AM - 4:30PM
4 Sep 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
 
  Excel Level 1
CTU-EXCEL10L1-C - 046
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Tue 9:00AM - 4:30PM
6 Oct 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
 
  Excel Level 1
CTU-EXCEL10L1-C - 047
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Wed 9:00AM - 4:30PM
4 Nov 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
 
  Excel Level 1
CTU-EXCEL10L1-C - 048
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Mon 9:00AM - 4:30PM
30 Nov 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus