Online Class: Excel 2010

This online course will tell you how to use all the features of Microsoft Excel 2010 in a step-by-step, easy-to-follow fashion.
COURSE CLOSED
We're sorry, this course is no longer open for enrollment.
 
  • 13
    Lessons
  • 28
    Exams &
    Assignments
  • 14
    Hours
    average time
  • 1.4
    CEUs
 
 
 

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!

Courses Frequently Bought Together:
  • 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
 
 

Course Lessons

Lesson 1. Excel 2010 Essentials

Mastering Excel 2010 involves becoming familiar with its workbook and worksheet dynamics, including cells, rows, columns, and sheet tabs. Knowing these basics enables accurate data entry and management, setting the foundation for more advanced Excel features. 29 Total Points
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete Assignment: An Introduction
  • Complete: Lesson 1 Assignment
  • Assessment: Lesson 1 Exam

Lesson 2. Mastering Worksheets and Workbooks in MS Excel 2010

Excel 2010 workbooks allow ease of data management through adding, deleting, and renaming worksheets, contributing to a custom workflow. Hiding and unhiding features aid in data protection while maintaining full access and use during calculations. 28 Total Points
  • Lesson 2 Video
  • Complete: Lesson 2 Assignment
  • Assessment: Lesson 2 Exam

Lesson 3. Streamlined Spreadsheet Planning and Entry in MS Excel 2010

Before entering data in Excel 2010, plan by determining your spreadsheet's purpose and required information, including column and row needs. Enter data by clicking a cell, and navigate swiftly using Enter, Tab, and arrow keys while managing labels, values, and formulas effectively. 29 Total Points
  • Lesson 3 Video
  • Complete: Lesson 3 Assignment
  • Assessment: Lesson 3 Exam

Lesson 4. Filling Cells with Data: Mastering Excel Series Entry

Efficient data entry in Excel 2010 using the AutoFill feature can quickly generate number, date, or custom series, saving time over manual input. Additionally, tools such as Find and Go To streamline navigation and data retrieval within large worksheets. Additional lesson topics: MS EXCEL Entering data automatically with Auto Fill 28 Total Points
  • Lesson 4 Video
  • Complete: Lesson 4 Assignment
  • Assessment: Lesson 4 Exam

Lesson 5. Sprucing Up Your Excel Worksheet: Making Data Appealing and Readable

Breathe life into your Excel worksheets by embracing font customization, borders, and colors, while ensuring clarity with column and row height adjustments. Unlock the full potential of spreadsheet management with advanced features like freezing panes and applying custom cell styles. 30 Total Points
  • Lesson 5 Video
  • Complete: Lesson 5 Assignment
  • Assessment: Lesson 5 Exam

Lesson 6. Transforming Workbooks with Images

Excel's Insert tab enables users to augment spreadsheets with images, shapes, and hyperlinks, transforming plain data sheets into interactive and visually engaging documents. By utilizing features like Picture Tools and Format AutoShape, learners can edit and customize visual elements to align with their project goals. 29 Total Points
  • Lesson 6 Video
  • Complete: Lesson 6 Assignment
  • Assessment: Lesson 6 Exam

Lesson 7. Customize Your Excel Charts

Excel 2010 replaces the Chart Wizard with a more accessible ribbon interface, empowering users to create a variety of chart types like column, line, and pie charts effortlessly. Selecting and adjusting data ranges is straightforward, enhancing clarity in data representation. 27 Total Points
  • Lesson 7 Video
  • Complete: Lesson 7 Assignment
  • Assessment: Lesson 7 Exam

Lesson 8. Formulas and Calculations: The Core of Excel

Lesson Summary 1: Excel's core functionality is built on its ability to use formulas and calculate data effectively, with formulas acting as equations within Excel that can range in complexity. The inclusion of various operators such as arithmetic, comparison, text, and reference operators enhances its utility for diverse calculation needs. 28 Total Points
  • Lesson 8 Video
  • Complete: Lesson 8 Assignment
  • Assessment: Lesson 8 Exam

Lesson 9. Efficient Data Handling in Excel Using Forms

Creating data forms in Excel allows users to format and enter information more efficiently, similar to Access. By customizing the Quick Access Toolbar, you can easily integrate the Form feature for streamlined data input. 23 Total Points
  • Lesson 9 Video
  • Complete: Lesson 9 Assignment
  • Assessment: Lesson 9 Exam

Lesson 10. Streamline Your Data Sorting with Excel Tables

Excel Tables, first known as 'Lists', facilitate data clarity and manipulation via mechanisms to sort, filter, and summarize information, making it an integral tool for dynamic spreadsheet management. The Table Tools/Design tab offers flexible styling and summation options, while formula auditing aids in precise identification and correction of data errors. 34 Total Points
  • Lesson 10 Video
  • Complete: Lesson 10 Assignment
  • Complete: Lesson 10 Assignment Bonus
  • Assessment: Lesson 10 Exam

Lesson 11. Enhancing Your Workbook: Tips and Tricks for Advanced Customization

Learn to enhance your workbook by adjusting worksheet tabs and securing sheets, providing better management and protection of data. Master printing techniques such as page setup and selection to ensure optimal output presentation of your workbook. 30 Total Points
  • Lesson 11 Video
  • Complete: Lesson 11 Assignment
  • Assessment: Lesson 11 Exam

Lesson 12. Effective Ways to Share Excel Workbooks

Excel 2010 extends collaboration through its web app and SkyDrive, making sharing seamless while providing tools to protect workbook information. Users can recover previous versions, manage shared workbooks with multiple contributors, and utilize comments and templates for streamlined sharing and output. 30 Total Points
  • Lesson 12 Video
  • Complete: Lesson 12 Assignment
  • Assessment: Lesson 12 Exam

Lesson 13. Mastering XML for Advanced Excel Users

XML's capability to define data in tagged structures aids Excel in converting imported data into comprehensible tables, facilitating versatile information processing. Excel 2010 introduces robust security measures that protect workbooks from unauthorized access by encrypting content and managing user permissions effectively. Additional lesson topics: How to Use a Pivot Table in Excel 59 Total Points
  • Lesson 13 Video
  • Lesson discussions: What is your opinion of this course?; Course Comments; Program Evaluation Follow-up Survey (End of Course); Reasons for Taking this Course
  • Assessment: Lesson 13 Exam
  • Assessment: The Final Exam
404
Total Course Points
 

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.
 

Student Testimonials

  • "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.
  • "I found the whole thing helpful, from what I already knew to the new information." -- Lee H.
  • "The instructor is excellent. He had assignments and exams graded very quickly. I gained more exposure to figure out why something was or wasn't working while completing the assignments." -- Linda C.
  • "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." -- Betty T.
  • "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." -- Sierra L.
  • "I really liked how the course was set-up over all. I really enjoyed this class and feel like I learned alot!!" -- Julie W.

Related Courses