Microsoft Excel: Part I
$202/Attendee
Cost
Program Length
2 Days
Course Overview
Course Outline
Getting Started with Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Navigate in Excel for the Web
Enter Cell Data
Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
Modifying a Worksheet
Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Colors, Borders, and Styles
Apply Basic Conditional Formatting
Printing Workbooks
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties
Course Objectives
Familiarize yourself with Excel's layout, its various parts, its commands, and its terminology.
Outline Excel's abilities to quickly, efficiently, and accurately calculate data.
Update worksheets without throwing away all of the valuable work you've already done.
Format a worksheet and organize your data.
Print workbooks.
Manage the overall structure of your workbooks.
For cancellation notices received more than fifteen business days prior to the class date, students may receive either a full refund or reschedule into another class date.
For cancellation notice less than fifteen business days prior to the class start date, students will receive an voucher in the amount of the paid tuition to use for the same course up to a six months’ time frame and will be automatically put onto the wait list of the course of their choice and granted final admission ten business days prior to class start day based on enrollment levels.