Online Class: Excel 2013

$70.00
no certificate

- OR -

$95.00
with CEU Certificate*

Start Right Now!

$95.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

20

Lessons
40

Exams &
Assignments
8,693

Students
have taken this course
11

Hours
average time
1.1

CEUs

Course Description

Microsoft Excel 2013 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 address books, mailing lists, grocery lists, tracking expenses, creating invoices and bills, doing financial accounting, balancing checkbooks, as well as any other purpose that requires a spreadsheet or table.

This course will teach you the skills you'll need to successfully use Excel 2013. Each lesson contains step-by-step instructions and explanations to show you how to use all the features, and also provides video tutorials on how everything is done. You don't need previous experience with Excel to be able to complete this course. This course will start with basic skills, then move forward to more advanced features and techniques.

In our Excel 2013 course, you'll learn how to:

· Create a spreadsheet

· Format cells, rows, columns, and entire worksheets so they fit and match your data

· Enter data into a spreadsheet

· Use formulas and functions for math, accounting, and totaling

· Create formulas and functions

· Create charts and diagrams for your data

· Create data lists and forms

· Create and use pivot tables and pivot charts

· Work with Excel templates

· Share and protect your worksheets and workbooks

· Use What-If Analysis to determine possible outcomes

· And much, much more

This course breaks up the most complex features of Excel into easy-to-understand blocks of information. Each lesson is a building block that moves you one step closer to using Excel like a pro – which you will be by the end of this course. Even if you're new to Excel, you're just 20 lessons away from having the advanced skills you need to use this amazing program.

Courses Frequently Bought Together:

QuickBooks 101

Microsoft Office 2021: Word, Excel, PowerPoint and Outlook

Excel 2021

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

Average Lesson Rating:

"Extraordinarily Helpful"

(6,143 votes)

Lesson 1: Introduction to MS Excel 2013

This course will cover the many features of Excel and how to use them, starting with the simple and working to the most complicated. Additional lesson topics: What's new in Excel 10 Total Points

Lesson 1 Video
Lesson discussions: Reasons for Taking this Course
Assessment: Lesson 1 Exam

Lesson 2: Navigating Excel 2013

In this lesson, we're going to focus on the major elements of Excel 2013 and take a few minutes to become familiar with their purpose. 10 Total Points

Lesson 2 Video
Complete: Lesson 2 Assignment
Assessment: Lesson 2 Exam

Lesson 3: Worksheets and Workbooks

In this lesson, we'll learn all about worksheets and workbooks. Additional lesson topics: How to Move a Worksheet to Another Excel Workbook; Linking your sheets and workbooks together in Excel , Excel , and Excel 11 Total Points

Lesson 3 Video
Complete: Lesson 3 Assignment
Assessment: Lesson 3 Exam

Lesson 4: Entering Information into MS Excel 2013

The first thing you want to do before you type anything, is to spend a little time planning the spreadsheet. Additional lesson topics: Entering Data in Excel 11 Total Points

Lesson 4 Video
Complete: Lesson 4 Assignment
Assessment: Lesson 4 Exam

Lesson 5: Introduction to Working With Cells, Rows, and Columns

Selecting data in Excel is different from selecting text in a word processing program, because you must select cells. Additional lesson topics: Insert or delete cells, rows, and columns 11 Total Points

Lesson 5 Video
Complete: Lesson 5 Assignment
Assessment: Lesson 5 Exam

Lesson 6: Formatting Data and Cells

Formatting a worksheet can change the look and feel of it. You can add color, change fonts, put in headings, apply styles, and much more. Additional lesson topics: Format your chart; Excel Tutorial 11 Total Points

Lesson 6 Video
Complete: Lesson 6 Assignment
Assessment: Lesson 6 Exam

Lesson 7: Formatting Rows and Columns

In MS Excel 2013, the width of a column is determined by how many characters can be displayed within a cell. Additional lesson topics: Change the column width and row height; Show or hide columns and rows 10 Total Points

Lesson 7 Video
Complete: Lesson 7 Assignment
Assessment: Lesson 7 Exam

Lesson 8: Editing Cells, Rows, Columns, and Worksheets

MS Excel 2013 makes creating - and editing - spreadsheets a lot easier because correcting errors is clean and uncomplicated. Additional lesson topics: Freeze rows and columns; Excel : Modifying Columns, Cells, and Rows Video 9 Total Points

Lesson 8 Video
Complete: Lesson 8 Assignment
Assessment: Lesson 8 Exam

Lesson 9: Introduction to Formulas and Calculations

If you use spreadsheets to do accounting for a business, track totals, invoice customers, or anything that requires mathematics, Excel's ability to calculate formulas is going to save you errors and headaches. Additional lesson topics: How to quickly apply formula to an entire column or row in Excel?; Excel Tutorial; Microsoft Excel Training -- Formulas and Functions Intermediate Level Video 11 Total Points

Lesson 9 Video
Complete: Lesson 9 Assignment
Assessment: Lesson 9 Exam

Lesson 10: Working With Formulas and Functions

A function, by definition in Excel, is a pre-designed formula that performs a certain calculation. Additional lesson topics: New functions in Excel ; How to Work With Text Functions in Excel 10 Total Points

Lesson 10 Video
Complete: Lesson 10 Assignment
Assessment: Lesson 10 Exam

Lesson 11: Maintaining Worksheets

Any Excel worksheet that you create can easily become overwhelming because there's so much information contained in it. For that reason, it's important to learn how to maintain your worksheets to help you keep on top of all the information. Additional lesson topics: Transfer data from one Excel worksheet to another automatically; Managing Data in Excel 11 Total Points

Lesson 11 Video
Complete: Lesson 11 Assignment
Assessment: Lesson 11 Exam

Lesson 12: The What-If Analysis

There are all types of what-if analyses that Excel can do. However, in this course, we're going to cover three. Additional lesson topics: Introduction to what-if analysis; How to Use an Excel Data Table for What-if Analysis 11 Total Points

Lesson 12 Video
Complete: Lesson 12 Assignment
Assessment: Lesson 12 Exam

Lesson 13: Adding Images and Graphics

You've already learned how to format a worksheet and enter information into Excel; now we're going to show you how to add elements such as graphics and images. Additional lesson topics: Insert picture in Excel cell automatically 11 Total Points

Lesson 13 Video
Complete: Lesson 13 Assignment
Assessment: Lesson 13 Exam

Lesson 14: Charts and Diagrams

Charts and diagrams are tools you can use to visually represent the data in a worksheet. Additional lesson topics: Excel Tutorials; Add a chart title 11 Total Points

Lesson 14 Video
Complete: Lesson 14 Assignment
Assessment: Lesson 14 Exam

Lesson 15: Creating Data Lists

There is another kind of worksheet that you can create. This is called a data list or a database table. Additional lesson topics: How to Create an Excel Table From a Data List; How to Add Data to Data Lists Using the Excel Form Button 11 Total Points

Lesson 15 Video
Complete: Lesson 15 Assignment
Assessment: Lesson 15 Exam

Lesson 16: Managing Data

A form is simply a dialog box that lets you display or enter information, one record (or row) at a time. Additional lesson topics: How to Find Records with the Data Form in Excel ; How to Use Data Forms and Customize the Excel Quick Access Toolbar 11 Total Points

Lesson 16 Video
Complete: Lesson 16 Assignment
Assessment: Lesson 16 Exam

Lesson 17: Pivot Tables and Charts

A pivot table is a data summarization tool used in Excel. You can use a pivot table to summarize data that you've added to a table. 11 Total Points

Lesson 17 Video
Complete: Lesson 17 Assignment
Assessment: Lesson 17 Exam

Lesson 18: Printing Worksheets and Workbooks

Headers appear at the top of a worksheet. Footers appear at the bottom. Both can contain page numbers, and headers often contain the title of the worksheet, and perhaps the date. Additional lesson topics: Print a worksheet or workbook; Print multiple Worksheets and Workbooks in Excel 11 Total Points

Lesson 18 Video
Complete: Lesson 18 Assignment
Assessment: Lesson 18 Exam

Lesson 19: Templates

Templates are worksheets that are already designed for you. Additional lesson topics: Excel templates for budgets, invoices, calendars, and more 11 Total Points

Lesson 19 Video
Complete: Lesson 19 Assignment
Assessment: Lesson 19 Exam

Lesson 20: Protecting, Saving, and Sharing Workbooks

Add protection to worksheets, so they can't be edited by other people. You can lock cells or an entire worksheet. 55 Total Points

Lesson 20 Video
Lesson discussions: How would you rate this course?; Program Evaluation Follow-up Survey (End of Course); Course Comments
Complete: Lesson 20 Assignment
Assessment: Lesson 20 Exam
Assessment: The Final Exam

258

Total Course Points

Learning Outcomes

By successfully completing this course, students will be able to:

Describe what a spreadsheet is and what Excel 2013 can do.
Demonstrate navigation, creating workbooks and worksheets, and entering information into Excel 2013
Demonstrate working with cells, rows, and columns in Excel.
Demonstrate formatting data in cells and how to format rows and columns.
Demonstrate editing cells, rows, columns, and worksheets.
Demonstrate creating and using formulas and calculations.
Demonstrate using the What-If Analysis.
Demonstrate adding images, graphics, charts and diagrams.
Demonstrate creating data lists and managing data.
Demonstrate Pivot Table and chart usage.
Summarize creating and using templates in Excel 2013.
Demonstrate printing, protecting, saving, and sharing workbooks in Excel.
Demonstrate mastery of lesson content at levels of 70% or higher.

Additional Course Information

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

Course Title: Excel 2013

Course Number: 8900203

Lessons Rating: 4.3 / 5 Stars (6,143 votes)

Languages: English - United States, Canada and other English speaking countries

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Courses

Availability: This course is online and available in all 50 states including: California, Florida, Georgia, Illinois, New York, Pennsylvania, Ohio, and Texas.

Last Updated: June 2022

Course Type: Self-Paced, Online Class

CEU Value: 1.1 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: UniversalClass Instructional Team

Syllabus: View Syllabus

Course Fee: $95.00 U.S. dollars

Choose Your Subscription Plan

Course Only

One Course
No Certificate / No CEUs

$70

for 6 months

Add to Cart

Billed once
This course only

Includes certificate	X
Includes CEUs	X
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Certificate Course

One Course
Certificate & CEUs

$95

for 6 months

Add to Cart

Billed once
This course only

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Platinum Yearly

ALL COURSES
Certificates & CEUs

$189

per year

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	12 Months
No. of courses	600+

Platinum 2 Years

ALL COURSES
Certificates & CEUs

$299

for 2 years

You save $79.00!

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	24 Months
No. of courses	600+

Student Testimonials

"This course was very helpful to improve English grammar." -- Ahmadzia F.
"I like how the chapters are broken down...allowed me to learn about different aspects in a step-by-step format." -- Margaret M.
"Wonderful!" -- Candace H.
"Excellent course, Excellent instructor, Excellent experience!!! I thought I already knew Excel but I learned a great deal...Thank you UniversalClass for offering this course!" -- Becky A.
"Instructor was quick to mark my work which encourages progress!" -- CAROLE C.
"The best part was watching the videos. I was able to watch the videos and do what the instructor was doing at the same time. I learn better by actually doing it." -- Ashley S.
"Loved the instructor; overall just perfect with his instruction and pace of each class. Instructor was easy to follow and understand; making this a great class. I really enjoyed it!" -- Cynthia G.
"The instructor was very good...he made learning the class easier than I expected it to be." -- Cynthia G.
"The instructor's Lesson Plans were Great!" -- Diane B.