Universal Class: Over 500 Online Certificate Courses
 

Online Class: Excel 2010


$50.00
no certificate
- OR -
$75.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
  • 13
    Lessons
  • 28
    Exams &
    Assignments
  • 14
    Hours
    average time
  • 1.4
    CEUs
  • 7,657
    Students
    have taken this course
 
 
 
 
 

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!

Show More
  • Completely Online
  • Self-Paced
  • Instructor Feedback
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Related Courses

  • PowerPoint 2016
    PowerPoint 2016
    PowerPoint 2016 is a presentation creator that can be used to create stunning slideshows and basic videos. It can also be used to create slide presentations, handouts, transparencies, and much more. While creating presentations using some programs c...
    $75.00
    0.7 CEUs 7h
  • Microsoft Publisher 2016
    Microsoft Publisher 2016
    Publisher 2016 is Microsoft's entry-level desktop publishing program, allowing you to quickly create publications for the web or print. You can easily create professional-looking publications by either creating them yourself from scratch or using o...
    $75.00
    0.7 CEUs 7h
  • Outlook 2016
    Outlook 2016
    Microsoft Outlook 2016 is the email client and personal information organizer that comes with the Microsoft Office Suite. In this course, we're going to teach you how to effectively use nearly every aspect of Outlook, from sending, receiving, and or...
    $75.00
    0.5 CEUs 5h
  • Microsoft Word 2016
    Microsoft Word 2016
    Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn everything you need t...
    $75.00
    0.8 CEUs 8h
  • Ultimate Excel Bundle
    Ultimate Excel Bundle
    Learn Excel 2016 Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an addr...
    $125.00
    4.6 CEUs 46h
  • Office 2016: Word, Excel, PowerPoint and Outlook
    Office 2016: Word, Excel, PowerPoint and Outlook
    Microsoft Word 2016: Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn ...
    $110.00
    3.2 CEUs 32h
  • Visual Basic for Excel
    Visual Basic for Excel
    Developer tools in Microsoft Office give you the functionality to create custom applications in Excel. These tools require Visual Basic for Applications (VBA). The developer can create custom spreadsheets, workbooks, controls, and even toolbar add-i...
    $115.00
    1.7 CEUs 17h
  • Advanced Excel 2016
    Advanced Excel 2016
    Excel 2016 Advanced Skills Course With most software programs on the market today, you can thrive with just a basic knowledge of the tools and options built into the individual program. However, that is not necessarily true when it comes to Excel 20...
    $85.00
    1.7 CEUs 17h
  • OneNote 2016
    OneNote 2016
    OneNote 2016 is a note-taking program that comes bundled with the Microsoft Office 2016 suite. Whereas MS Word is a word processing program that you can use to create documents, OneNote is simply a note taking program that you can use to take notes ...
    $75.00
    0.5 CEUs 5h
  • Microsoft Access 2016
    Microsoft Access 2016
    Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access w...
    $95.00
    1.2 CEUs 12h
  • Adobe Captivate
    Adobe Captivate
    Adobe Captivate is a responsive authoring tool that allows you to create eLearning content, such as eLearning courses, software demonstrations, branched scenarios, games, quizzes, and screencasts. The files you create in Adobe Captivate 9 can be exp...
    $75.00
    0.6 CEUs 6h
  • QuickBooks 101
    QuickBooks 101
    QuickBooks® Course Introduction QuickBooks® is an accounting software program created by Intuit® for small businesses and self-employed professionals. It can be used for almost all financial business processes. You can use it for ent...
    $80.00
    1.4 CEUs 14h
  • Digital Photography 101
    Digital Photography 101
    You just bought your first digital camera and don't know the ins and outs of all those buttons. If that isn't daunting enough, the user's manual is pages thick and intimidating. Well, you've come to the right place. Owning a great digital camera is ...
    $95.00
    1.7 CEUs 17h
  • Google Analytics 101
    Google Analytics 101
    Tracking tools are an important part of a website toolkit. Google Analytics is one of the most popular tools for tracking website user patterns, so webmasters can identify landing page strengths and weaknesses. Google offers the tool for free. All y...
    $75.00
    1.0 CEUs 10h
  • Computer Basics 101
    Computer Basics 101
    Computer Basics is a course that's designed specifically for those who are completely new to computers or who feel they need to have more instruction before they can feel confident buying a new computer for their personal use. Filled with screensho...
    $75.00
    0.6 CEUs 6h
  • Windows 10
    Windows 10
    Windows 10 is the latest version of the Windows operating system released by Microsoft on June 29, 2015. It follows Windows 8 and Windows 8.1, which introduced some of the biggest changes to the operating system since the first release in 1985. Wind...
    $75.00
    0.5 CEUs 5h
  • Adobe InDesign 101
    Adobe InDesign 101
    Adobe InDesign is a software program created by Adobe Systems, the same company that creates Photoshop, Illustrator, and a number of other programs. Whereas Photoshop is used for image editing and Illustrator is used for drawing, InDesign is used to...
    $75.00
    1.0 CEUs 10h
  • Adobe Photoshop 101
    Adobe Photoshop 101
    This course will teach you everything you need to know to make full use of the world's most popular graphics editing program -- Adobe Photoshop. Adobe Photoshop is a complex graphics and image editing software and paint program. It has become a main...
    $75.00
    1.0 CEUs 10h
  • Excel 2016
    Excel 2016
    Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery...
    $75.00
    1.2 CEUs 12h
  • Photoshop Elements 101
    Photoshop Elements 101
    Adobe Photoshop Elements is the consumer-based version of the popular Photoshop program that allows you to store, sort, and edit images and photographs. Photography enthusiasts will love Elements ability to organize images and create albums. Photosh...
    $75.00
    1.0 CEUs 10h
  • Adobe Lightroom 101
    Adobe Lightroom 101
    Adobe Photoshop Lightroom is a photo editing and management program offered by Adobe, allowing users to manage and edit multiple images at once using the Adobe Photoshop Lightroom interface. This course will teach you the features in Adobe Photosho...
    $75.00
    1.0 CEUs 10h
  • Adobe Illustrator 101
    Adobe Illustrator 101
    Course Introduction Adobe Illustrator is a powerful drawing software program offered by Adobe. Anyone, regardless of artistic or computer ability, can use Illustrator to draw shapes and lines, create text, or import graphics and pictures. You can ...
    $75.00
    1.0 CEUs 10h
  • Adobe Premiere 101
    Adobe Premiere 101
    Adobe Premiere Pro is a video editing program that is part of the Adobe Creative Cloud software collection, as well as Adobe CS6 – or Adobe Creative Suite. Premiere Pro is used to edit videos, including movies, and is quickly becoming the go-t...
    $95.00
    1.0 CEUs 10h
  • Photography 101: Beginner to Intermediate
    Photography 101: Beginner to Intermediate
    Have you ever seen those old black and white (or brown and white) pictures of pioneers? No one smiled, the women always wore gloves, and the children's faces were smudgy. In those days, the cameras required a longer period of time to capture the ima...
    $95.00
    1.7 CEUs 17h
  • Adobe After Effects
    Adobe After Effects
    Adobe After Effects allows you to create videos containing animation and special effects for graphics-related projects. You can use After Effects to animate, alter, and composite media using various tools and optional plug-ins. The program is widely...
    $90.00
    1.0 CEUs 10h
  • Google+ for Business
    Google+ for Business
    If you've been wondering about how to use Google+ for your business, this comprehensive course is the best way to get started. With simple instructions and ideas regarding social media marketing, businesses of every size soon understand why they nee...
    $75.00
    0.4 CEUs 4h
  • Final Cut Pro X
    Final Cut Pro X
    Final Cut Pro X is a video editing and movie making software application created by Apple for OS X. Unlike previously released versions of the video editing program Final Cut, Final Cut Pro X is an all-new application. It has been designed from sc...
    $75.00
    1.0 CEUs 10h
 
 

Course Lessons

Average Lesson 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) 4.4 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(3,805 votes)

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 2 Articles: 10 Cool Features to Look Forward to in Office 2010; 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 2 Articles: Hide and Unhide Worksheets and Workbooks in Excel 2007 and 2010; 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 2 Videos: Excel 2010 - Insert and Delete Rows and Columns; 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 2 Videos: Excel 2010 - Locking Columns and Rows; 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 2 Videos: Excel 2010 Basics - Merging and Splitting Cells.mov; 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 2 Videos: Hyperlink That Opens Different Workbook or Goes To Different Sheet; Stop Automatic Copyright symbol and copy;
  • 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 3 Videos: Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics; Inserting SmartArt in Excel 2010 Essential Training; Sparklines
  • 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 2 Videos: Basic Functions; 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 3 Articles: How to Create a Table; How to use the AutoFilter in Excel 2007 or 2010; Understanding Auditing Tools
  • Review 2 Videos: Auditing Worksheets; 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 3 Videos: Copying and Moving worksheets; Grouping worksheets; 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 2 Articles: Merge Spreadsheets Using Data Consolidation In Excel 2010; 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 2 Videos: How to Use a Pivot Table in Excel 2010; Search and 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
Show More
 

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.
Show More
 

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!
Course Fee: $50.00 (no CEU Certification) || with Online 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

  • "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." -- 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." -- Karla M.
  • "He was great and he replied very quickly. I liked that a lot. I know how to move around Excel now, whereas before I had no clue. I wouldn't even bother opening the program because I had no idea what to do. Now I can move around and figure out what I am doing." -- Adrianna S.
  • "I found all of the information helpful because didn't know anything about excel. Now I feel that I can do a spread sheet." -- Patricia N.
  • "For my personal use, the earlier lessons on operating in Excel were the most useful. I felt that the chapter on functions and formulas was really the heart of the course. Although much of it I will never use, it gave me more confidence." -- Marty K.
  • "Whenever I had a question, the instructor always answered it in a timely fashion. I was also quite surprised at the quickness he graded my lessons and quizzes. The charts were extremely fun. They truly enhance your workbook by turning all of your data into a pictorial creation. " -- Joyce L.
  • View More Testimonials...
Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.