Course Syllabus

COURSE CLOSED

We're sorry, this course is no longer open for enrollment.
 
 

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
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

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 skills
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 
 

Assessment Guide

Assessment Points
An Introduction 1 points
Lesson 1 Assignment 20 points
Lesson 1 Exam 8 points
Lesson 2 Assignment 20 points
Lesson 2 Exam 8 points
Lesson 3 Assignment 20 points
Lesson 3 Exam 9 points
Lesson 4 Assignment 20 points
Lesson 4 Exam 8 points
Lesson 5 Assignment 20 points
Lesson 5 Exam 10 points
Lesson 6 Assignment 20 points
Lesson 6 Exam 9 points
Lesson 7 Assignment 20 points
Lesson 7 Exam 7 points
Lesson 8 Assignment 20 points
Lesson 8 Exam 8 points
Lesson 9 Assignment 20 points
Lesson 9 Exam 3 points
Lesson 10 Assignment 20 points
Lesson 10 Assignment Bonus 0 points
Lesson 10 Exam 9 points
Lesson 11 Assignment 20 points
Lesson 11 Exam 10 points
Lesson 12 Assignment 20 points
Lesson 12 Exam 10 points
Lesson 13 Exam 9 points
The Final Exam 50 points