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
Lesson 1: Creating a Basic Excel Worksheet
  • Topic 1A: Identify the Elements of the User Interface
  • Topic 1B: Customize the Excel Interface
  • Topic 1C: Work with Cells
  • Topic 1D: Enter Data in an Excel Workbook
  • Topic 1E: Obtain Help in Excel

Lesson 2: Performing Calculations in an Excel Worksheet
  • Topic 2A: Create Basic Formulas
  • Topic 2B: Calculate the Cell Values by Using Functions
  • Topic 2C: Copy Formulas and Functions

Lesson 3: Modifying an Excel Worksheet
  • Topic 3A: Manipulate Data
  • Topic 3B: Modify the Worksheet Elements
  • Topic 3C: Search for Data in a Worksheet
  • Topic 3D: Modify Rows and Columns

Lesson 4: Formatting an Excel Worksheet
  • Topic 4A: Modify Fonts
  • Topic 4B: Check a Worksheet for Spelling Errors
  • Topic 4C: Apply Number Formatting
  • Topic 4D: Add Borders and Colors to Cells
  • Topic 4E: Align the Content in a Cell
  • Topic 4F: Apply Cell Styles

Lesson 5: Printing Excel Workbooks
  • Topic 5A: Set the Page Layout Options
  • Topic 5B: Set Page Breaks
  • Topic 5C: Print a Workbook

Lesson 6: Managing an Excel Workbook
  • Topic 6A: Format Worksheet Tabs
  • Topic 6B: Manage Worksheets
  • Topic 6C: View Worksheets and Workbooks

Prerequisites & Certificates
Pre-Requisites

Previous knowledge of this application is not required. 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
 
Great seminar. Instructor was vey helpful and seemed to satisfy everyone's needs. Looking forward to taking the next level.
Reviewed by 2016
The course was informative but fast flowing. I love the idea of being able to re-attend at no cost.
Reviewed by 2016
The course was very informative and useful, but the time could have been used better. I could have learned everything taught in an hour and a half, and the rest of the time would have been better used doing exercises to really ingrain the information into my brain.
Reviewed by 2015
The instructor was excellent - I would highly recommend him and hope to get him again as my instructor.
Reviewed by 2013
Instructor was very soft spoken did not have all the answres but did get answers later in the class.
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 4062 times.