Universal Class - Leading Provider of Continuing Education
 

Online Class: Excel 2010


Microsoft Training Picture
$50.00
no certificate
- OR -
$75.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
 
 
 
Loading...
 
 
 

Course Description

Most computer-savvy people out there today know that MS Excel 2010 is a spreadsheet program that you can use to record data, create charts, and utilize mathematical equations.  However, most people who are familiar with Excel aren't fully aware of all that MS Excel can do.  Maybe that's you.  You'd be surprised about the things that you can do using Excel that you're currently doing by hand or using other inappropriate software (such as the familiar sibling to Excel, MS Word).  But that's okay. That's why we designed this course. 

But first, let's dispel the myths that MS Excel 2010 is complicated to use, or to use its mathematical functions and capabilities that you must be good at math, or worse yet, that you must know some complicated programing in order to make it work for you.  The truth is, most people like you that use MS Excel use it for a single defined reason.  Because there are so many options and features available within the software, most people feel overwhelmed and don't take the time to explore just how many other things they can actually use it for.

With Excel 2010, you can:

  • Organize, sort, and record data.
  • Enter in text and mathematical equations.
  • Keep, track, chart, graph, and compare statistics.
  • Maintain records.
  • Create mathematical equations and functions to accurately keep records and statistics whenever data changes.

You can even use Excel to balance your checkbook, calculate the dollar amount you're spending on interest rates for credit cards and mortgages, as well as track your corporate spending accounts! You can also turn around and use Excel for something as simple as listing who is bringing what to the next family reunion.  MS Excel can be used for the most complex or simplest of tasks…and all these tasks can be done quite easily when you know how to use Excel 2010.

But telling you how convenient and easy MS Excel 2010 is to use isn't enough--we're going to show you step-by-step. So join us today!

  • Completely Online
  • Self-Paced
  • Instructor Feedback
  • IACET CEUs
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe what Excel is and why it is important for personal and business use.
  • Describe what worksheets and workbooks are.
  • Demonstrate entering information.
  • Demonstrate formatting a worksheet and adding elements to it.
  • Demonstrate chart usage in Excel.
  • Demonstrate formulas and calculations in excel.
  • Describe creating and using form and tables in Excel 2010.
  • Demonstrate developing a workbook.
  • Demonstrate sharing Worksheets and Workbooks and other advanced Excel 2010 skill, and
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 
 
 
IACET Accredited Provider
Universal Class, Inc. has been approved as an Accredited Provider by the International Association for Continuing Education and Training (IACET). In obtaining this approval, Universal Class, Inc. has demonstrated that it complies with the ANSI/IACET Standard which is widely recognized as the Standard of good practice internationally. As a result of their Accredited Provider status, Universal Class, Inc. is authorized to offer IACET CEUs for its courses that qualify under the ANSI/IACET Standard.
 
 
 

Request More Information

Request More Information
Have a question? Check out our FAQ or contact us for more information.
 
Microsoft Training Picture Microsoft Training Picture
 
 

Course Lessons

Average Lesson Rating: (3226 votes)
4.4 / 5 Stars (Average Rating) 4.4 / 5 Stars (Average Rating) 4.4 / 5 Stars (Average Rating) 4.4 / 5 Stars (Average Rating) 4.4 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
8/23/2016 11:57:44 AM

Lesson 1: Introduction to MS Excel 2010

MS Excel is a spreadsheet program that you can use to record data, mathematical charts, and equations. This first lesson will go over the new features and how to navigate of this program 29 Total Points
  • Lesson 1 Video
  • Review Article: 10 Cool Features to Look Forward to in Office 2010
  • Review Article: Buy Excel Version 2010/ or Try Trial Download
  • Review Video: Excel 2010- New Features Video
  • Complete Assignment: An Introduction
  • Complete: Lesson 1 Assignment
  • Complete: Lesson 1 Exam

Lesson 2: Worksheets and Workbooks

The basic structure and tools to efficiently use workbooks and worksheets will be discussed. 28 Total Points
  • Lesson 2 Video
  • Review Article: Hide and Unhide Worksheets and Workbooks in Excel 2007 & 2010
  • Review Article: How to Create a Custom Header or Footer in Excel 2010
  • Complete: Lesson 2 Assignment
  • Complete: Lesson 2 Exam

Lesson 3: Entering Information into MS Excel 2010

More basic information will be covered as this lesson will discuss how to enter, format and manipulate data. 29 Total Points
  • Lesson 3 Video
  • Review Video: Excel 2010 - Insert and Delete Rows and Columns
  • Review Video: How to Enter Data in Excel
  • Complete: Lesson 3 Assignment
  • Complete: Lesson 3 Exam

Lesson 4: Entering Information Part 2

Entering data more efficiently with Excels auto fill, how to search data, how to split and freeze panes, how to use to proofreading tools will be discussed in this lesson. 28 Total Points
  • Lesson 4 Video
  • Review Article: MS EXCEL 2010 Entering data automatically with Auto Fill
  • Review Video: Excel 2010 - Locking Columns and Rows
  • Review Video: Excel 2010 - Use Find and Replace
  • Complete: Lesson 4 Assignment
  • Complete: Lesson 4 Exam

Lesson 5: Formatting a Worksheet

By using a few simple formatting features in you MS Excel 2010, you can make the information in it easy to grasp and attractive. This lesson will show you how to use the features and more. 30 Total Points
  • Lesson 5 Video
  • Review Video: Excel 2010 Basics - Merging and Splitting Cells.mov
  • Review Video: Excel 2010: Conditional Formatting
  • Complete: Lesson 5 Assignment
  • Complete: Lesson 5 Exam

Lesson 6: Adding Elements to a Workbook

Now we're going to show you how to add elements such as images, art and diagrams. 29 Total Points
  • Lesson 6 Video
  • Review Video: Hyperlink That Opens Different Workbook or Goes To Different Sheet
  • Review Video: Stop Automatic Copyright symbol ©
  • Complete: Lesson 6 Assignment
  • Complete: Lesson 6 Exam

Lesson 7: Charts

Charts and diagrams are tools you can use to visually represent the data in a worksheet. You can use them to show trends, averages, high points, low points, and more. 27 Total Points
  • Lesson 7 Video
  • Review Video: Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics
  • Review Video: Inserting SmartArt in Excel 2010 Essential Training
  • Review Video: Sparklines
  • Review Video: VideoExcel - How to create graphs or charts in Excel 2010 (Charts 101)
  • Complete: Lesson 7 Assignment
  • Complete: Lesson 7 Exam

Lesson 8: Formulas and Calculations

MS Excel has many features and capabilities, but the ability to use formulas and perform calculations is the bread and butter of MS Excel. In this lesson we will begin learning how to perform some basic calculationa. 28 Total Points
  • Lesson 8 Video
  • Review Video: Basic Functions
  • Review Video: Complex Formulas
  • Complete: Lesson 8 Assignment
  • Complete: Lesson 8 Exam

Lesson 9: Excel Forms

A form is simply a dialog box that lets you display or enter information one record (or row) at a time. It can also make the information more visually appealing and easier to understand. This quick lesson will show you how to use this powerful feature. 23 Total Points
  • Lesson 9 Video
  • Review Article: Excel 2010: Data Input Forms
  • Review Video: Use the Built-in Data Form in Excel to View and Filter All Fields for a Record
  • Complete: Lesson 9 Assignment
  • Complete: Lesson 9 Exam

Lesson 10: Tables

A Table in MS Excel consists of orderly rows and columns of data, such as names, addresses, or even sales totals. This lesson will show you how to put a table together as well as how to utilize other tools to better analyze your data. 29 Total Points
  • Lesson 10 Video
  • Review Article: How to Create a Table
  • Review Article: How to use the AutoFilter in Excel 2007 or 2010
  • Review Article: Understanding Auditing Tools
  • Review Video: Auditing Worksheets
  • Review Video: Drop-Down Lists
  • Complete: Lesson 10 Assignment
  • Complete: Lesson 10 Assignment Bonus
  • Complete: Lesson 10 Exam

Lesson 11: Developing a Workbook

In an earlier lesson we showed you how to create a workbook. In this lesson, we're going to show you how to develop it further to fit your needs. 30 Total Points
  • Lesson 11 Video
  • Review Video: Copying and Moving worksheets
  • Review Video: Grouping worksheets
  • Review Video: Printing workbooks
  • Complete: Lesson 11 Assignment
  • Complete: Lesson 11 Exam

Lesson 12: Sharing Worksheets and Workbooks

In this lesson, we're going to cover the ways that you can share your MS Excel 2010 workbooks. 30 Total Points
  • Lesson 12 Video
  • Review Article: Merge Spreadsheets Using Data Consolidation In Excel 2010
  • Review Article: Merging Data from Multiple Workbooks into a Summary Workbook in Excel 2010
  • Review Video: Excel 2010 Tutorial Sharing Workbooks Microsoft Training
  • Complete: Lesson 12 Assignment
  • Complete: Lesson 12 Exam

Lesson 13: Advanced Skills

This final lesson will introduce many of the advance features that Excel can use- such as XML,a type of code that tells the computer how to display the content correctly across a wide variety of computers. 59 Total Points
  • Lesson 13 Video
  • Review Article: How to Use a Pivot Table in Excel 2010
  • Review Video: Search & Find Excel Videos, Playlists, Download Excel Workbooks and more...
  • Take Poll: What is your opinion of this course?
  • Take Survey: Course Comments
  • Take Survey: Program Evaluation Follow-up Survey (End of Course)
  • Complete: Lesson 13 Exam
  • Complete: The Final Exam
399
Total Course Points

Additional Course Information

Online CEU Certificate
  • Document Your Lifelong Learning Achievements
  • Earn an Official Certificate Documenting Course Hours and CEUs
  • Verify Your Certificate with a Unique Serial Number Online
  • View and Share Your Certificate Online or Download/Print as PDF
  • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Document Your CEUs on Your Resume
 
Course Title: Excel 2010
Course Number: 8900073
Languages: English - United States, Canada and other English speaking countries
Category:
Course Type: Computer Skill
CEU Value: 1.4 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned
Assessment Method: Lesson assignments and review exams
Instructor: Dave Scarbrough
Syllabus: View Syllabus
Duration: Continuous: Enroll anytime!
Requirements: View Technical Requirements
Course Fee: $50.00 (no CEU Certification) || with CEU Certification: $75.00

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$50
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$75
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
Best Value
ALL COURSES
Certificates & CEUs
$189
per year
You save 50%!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 500+
Platinum Monthly
ALL COURSES
Certificates & CEUs
$59 first month
$29.00 / each consecutive month thereafter
 
Billed monthly
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete Monthly
No. of courses 500+
 

Student Testimonials

  • "Videos relating to the lesson that was presented were very helpful....Videos relating to the lesson that was presented were very helpful." -- Arthur F.
  • "Before this course, the self taught use of Excel left out a great deal. This course shored up the basic knowledge I had and carried it forward to include the sections needed to produce varied and interesting spreadsheets....Before this course, the self taught use of Excel left out a great deal. This course shored up the basic knowledge I had and carried it forward to include the sections needed to produce varied and interesting spreadsheets." -- Betty T.
  • "The instructor was willing, able, and quickly responded to my issues, questions, and concerns in a timely manner. Very good!...The instructor was willing, able, and quickly responded to my issues, questions, and concerns in a timely manner. Very good!" -- James B.
  • "The images were most helpful because it gave me an idea of where to find things I was looking for. I'm a visual person so I was able to open my own document and find things with the images....The images were most helpful because it gave me an idea of where to find things I was looking for. I'm a visual person so I was able to open my own document and find things with the images." -- Sierra L.
  • "I really liked how the course was set-up over all. I really enjoyed this class and feel like I learned alot!!...I really liked how the course was set-up over all. I really enjoyed this class and feel like I learned alot!!" -- Julie W.
  • "Course was well paced based on contents of each lesson making it flow quite smoothly....Course was well paced based on contents of each lesson making it flow quite smoothly." -- James R.
  • "The videos are very helpful to me. Just seeing the work done and not just reading about it helps me to understand the information more....The videos are very helpful to me. Just seeing the work done and not just reading about it helps me to understand the information more." -- Karla M.
  • View More Testimonials...

Related Courses

Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2016 Universal Class™ All rights reserved.