Online Class: Advanced Excel 2013

This advanced Excel course goes beyond the basics of Excel and explores the advanced features that make the most popular spreadsheet program available today.

$95.00
no certificate
- OR -
$120.00
with CEU Certificate*
Start Right Now!
$120.00 (with CEU Certificate)
Taking multiple courses? Save with our platinum program.
 
  • 19
    Lessons
  • 39
    Exams &
    Assignments
  • 1,728
    Students
    have taken this course
  • 14
    Hours
    average time
  • 1.4
    CEUs
 
 
 

Course Description

This advanced Excel course goes beyond the basics of Excel and explores the advanced features that make this the most popular spreadsheet program available today. Picking up where our Excel 2013 online course leaves off, this course delves into Excel's world of functions and formulas, teaching you how to use Excel to enter, manage, calculate and display any type of data.  

You will learn how to:

·     Use outlining in Excel

·     Create templates

·     Work with sparklines

·     Create and manage scenarios

·     Use Goal Seek and Solver

·     Create, manage, and format pivot tables and pivot charts

·     Use the Excel mathematical functions

·     Perform data lookups

·     Create and use IF statements

·     Use Excel's data functions

·     Create and use data validation rules

·     Apply custom and prebuilt conditional formatting

·     Work with functions to manipulate strings of text and data

·     Create and use macros

·     Troubleshoot and audit formulas

·     And more

If you're not a regular Excel user, it's important that you take the time to brush up on your basic Excel skills before signing up.   This course makes the assumption that all students have at least a basic working knowledge of Excel before beginning the first lesson.  You do not need access to Excel 2013 to successfully complete this course; however, it is highly recommended.
  • 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:
4.2 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(707 votes)

Lesson 1: Outlines and Templates

10 Points
Outlining groups sections of the sheet together so you can hide them. Additional lesson topics: Microsoft Excel 1PC/1User [Download]; Excel Templates ; Microsoft Office Home and Student 1PC/1User [Download]
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete: Assignment 1
  • Assessment: Exam 1

Lesson 2: Working with Sparklines

11 Points
In this lesson, we are going to discuss the various types of sparklines, how to alter the design of sparklines, as well as how to compare the data that's represented in multiple sparklines. Additional lesson topics:
  • Lesson 2 Video
  • Complete: Assignment 2
  • Assessment: Exam 2

Lesson 3: Scenarios

11 Points
In Excel, the Scenario Manger lets you create sets of different input values to produce different calculated results. These sets of input values are called scenarios, such as Best Case, Worst Case, and Most Likely Case. Additional lesson topics: How to Use the Scenario Manager in Excel ; Excel Tutorial Using Scenario Manager Microsoft Training Video
  • Lesson 3 Video
  • Complete: Assignment 3
  • Assessment: Exam 3

Lesson 4: Goal Seek and Solver

10 Points
Another way to ask Excel “what if” is by using the Goal Seek and Solver tools. Additional lesson topics: How to use the Goal Seek function in Excel; Define and solve a problem by using Solver
  • Lesson 4 Video
  • Complete: Assignment 4
  • Assessment: Exam 4

Lesson 5: Pivot Tables

11 Points
In this lesson, we are going to go in-depth as we learn to create and work with pivot tables. Additional lesson topics: Working with Pivot Tables in Excel ; Working with Pivot Tables in Excel
  • Lesson 5 Video
  • Complete: Assignment 5
  • Assessment: Exam 5

Lesson 6: Continuing to Work with PivotTables

11 Points
PivotTables are an invaluable tool in Excel because they give you a way to summarize data; however, they also give you a way to look at the exact data that you need. Additional lesson topics: Create a PivotChart
  • Lesson 6 Video
  • Complete: Assignment 6
  • Assessment: Exam 6

Lesson 7: PivotCharts

11 Points
Where a PivotTable is simply a table with data listed in it, a PivotChart is a graphical representation of the data. Additional lesson topics: Excel Tutorial; Excel Tutorial
  • Lesson 7 Video
  • Complete: Assignment 7
  • Assessment: Exam 7

Lesson 8: Mathematical Functions

11 Points
In this lesson, we're going to start talking about some of the more basic functions, as well as teaching you to use them.
  • Lesson 8 Video
  • Complete: Assignment 8
  • Assessment: Exam 8

Lesson 9: Continuing with Mathematical Functions

11 Points
In this lesson, we are going to continue to explore mathematical functions. Additional lesson topics: LOOKUP function; How to use the LOOKUP Function in Excel
  • Lesson 9 Video
  • Complete: Assignment 9
  • Assessment: Exam 9

Lesson 10: Data Lookups

11 Points
Data lookup is quite simply the process where values in Excel are scanned until certain results are found. In Excel 2013, there are two main formulas for looking up the data you have in a worksheet. Additional lesson topics: Vlookup examples in Excel ; How to create relational databases in Excel
  • Lesson 10 Video
  • Complete: Assignment 10
  • Assessment: Exam 10

Lesson 11: The IF Function

11 Points
The IF function helps to determine what will be displayed to those who view your worksheets in Excel. Additional lesson topics: IF function; Excel IF Statement: How to Use Excel IF Function
  • Lesson 11 Video
  • Complete: Assignment 11
  • Assessment: Exam 11

Lesson 12: Data Functions

11 Points
Data functions give you various ways to search your data. Additional lesson topics: Excel Tutorial: An In-Depth Guide to Working with your Data, Building Formulas, and Using Functions
  • Lesson 12 Video
  • Complete: Assignment 12
  • Assessment: Exam 12

Lesson 13: Continuing with Data Functions

11 Points
In this lesson, we are going to continue to explore the different data functions that Excel 2013 has to offer. Additional lesson topics: 10 new Excel functions that can save you time; OFFSET function
  • Lesson 13 Video
  • Complete: Assignment 13
  • Assessment: Exam 13

Lesson 14: All About Data Validation

11 Points
Data validation in Excel allows you to define what type of data should be entered into a cell and allows you to prevent invalid data from being entered. Additional lesson topics: Apply data validation to cells; Highline Excel Class Video 28: Excel Data Validation: List, Date, Time, Custom 22 Examples
  • Lesson 14 Video
  • Complete: Assignment 14
  • Assessment: Exam 14

Lesson 15: Manipulating Text

11 Points
Although Excel is well known for its mathematical capabilities and features, it also has some powerful tools for creating text formulas to manipulate text.
  • Lesson 15 Video
  • Review Practice Worksheet: CHAR_functions.xlsx
  • Complete: Assignment 15
  • Assessment: Exam 15

Lesson 16: Exploring Conditional Formatting

10 Points
In this lesson, we are going to learn more about conditional formatting. Additional lesson topics: Excel formulas for conditional formatting based on another cell value; Highline Excel Class Video 40: Conditional Formatting Basic to Advanced Several Examples
  • Lesson 16 Video
  • Complete: Assignment 16
  • Assessment: Exam 16

Lesson 17: Exploring Macros in Excel 2013

11 Points
A macro is a series of instructions or commands that can be triggered by a keyboard shortcut, button in the toolbar, or by an icon that you can stick in a worksheet. Additional lesson topics: Create or delete a macro; Enable or disable macros in Office files
  • Lesson 17 Video
  • Complete: Assignment 17
  • Assessment: Exam 17

Lesson 18: More Fun with Macros

11 Points
In this lesson we are going to continue to explore macros in this lesson and learn more about creating and working with them. Additional lesson topics: Highline Excel Class Video 51: Recorded Macro Basics, including Absolute and Relative References
  • Lesson 18 Video
  • Complete: Assignment 18
  • Assessment: Exam 18

Lesson 19: Troubleshooting and Auditing in Excel 2013

104 Points
Finding and fixing errors could wind up being just as time consuming as entering and calculating the data. At least, it would be if Excel 2013 didn't offer you the tools you need to help you efficiently audit and troubleshoot your workbooks and data.
  • Lesson 19 Video
  • Lesson discussions: How would you rate this course?; Course Comments; Program Evaluation Follow-up Survey (End of Course)
  • Complete: Assignment 19
  • Assessment: Exam 19
  • Assessment: Final Exam
299
Total Course Points
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Identify outlines and templates.
  • Demonstrate working with sparklines.
  • Create scenarios.
  • Use goal seek and solver.
  • Demonstrate pivot table usage.
  • Demonstrate PivotCharts usage.
  • Demonstrate usage of mathematical functions.
  • Demonstrate data lookups.
  • Demonstrate the IF function usage.
  • Demonstrate data functions usage
  • Demonstrate data validation.
  • Demonstrate manipulating text.
  • Demonstrate conditional formatting usage
  • Demonstrate creating and using Macros
  • More Fun with Macros
  • Demonstrate troubleshooting and auditing techniques for Excel 2013.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 

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: Advanced Excel 2013
Course Number: 8900326
Lessons Rating: 4.2 / 5 Stars (707 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: This course is accessible online throughout all states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. It's also available in top English-speaking countries like the United Kingdom, Canada, Australia, and New Zealand.
Last Updated: March 2023
Course Type: Self-Paced, Online Class
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
Syllabus: View Syllabus
Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$95
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
$120
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
ALL COURSES
Certificates & CEUs
$189
per year
 
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 600+