Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


This course is designed to teach the fundamentals of using an Excel spreadsheet, including the basics of entering data into a sheet, to building formulas to formatting.


 
Course Outline
This course is designed to teach the fundamentals of using an Excel spreadsheet, including the basics of entering data into a sheet, to building formulas to formatting.

Course Outline

Creating a Basic Worksheet

€¢ 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

Performing Calculations
€¢ Create Basic Formulas
€¢ Calculate with Functions
€¢ Copy Formulas and Functions

Modifying a Worksheet
€¢ Manipulate Data
€¢ Insert and Delete Cells, Columns, and Rows
€¢ Search for Data in a Worksheet
€¢ Spell Check a Worksheet

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

Printing Workbook Contents
€¢ Print Workbook Contents Using Default Print Options
€¢ Set Print Options
€¢ Set Page Breaks

Managing Large Workbooks

€¢ Format Worksheet Tabs
€¢ Manage Worksheets in a Workbook
€¢ Manage the View of Large Worksheets
Prerequisites & Certificates
Pre-Requisites

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.

Certificates offered

Certificate of completion


Cancellation Policy
Students are required to give notice if they are unable to attend their class:

2 weeks (10 full business days) or longer prior to training date = full refund
1 to 2 weeks (5 - 9 full business days) prior to training date = 50% of course fee refund
Less than 1 week (4 full business days or fewer) prior to training date = 0% refund

NOTE: You may substitute classes or students at any time.

Map & Reviews
New Era Technology Training
[ View Provider's Profile ]

Reviews
 
I would have liked to go through the toolbar/ribbon a bit more and learn what each button does.
Reviewed by 2012
Alex is great!
Reviewed by 2011
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 4005 times.