Online Class: Advanced Excel 2013

$50.00
no certificate

- OR -

$75.00
with CEU Certificate*

Start Right Now!

Taking multiple courses? Save with our platinum program.

19

Lessons
39

Exams &
Assignments
17

Hours
average time
1.7

CEUs
1,568

Students
have taken this course

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.

What You Need to Know Before Beginning this Course

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 continuing with this course. This course makes the assumption that all students have at least a basic working knowledge of Excel and have mastered the basic skills required to:

Navigate Excel 2013

Create, naming, saving, and working with worksheets and workbooks

Work with, editing, and formatting cells, rows, and columns

Create and formatting tables

Enter data into Excel

Create basic formulas and calculations

Understand the role of functions in Excel, as well as mathematical operators

Understand absolute vs. relative cell references

Have basic knowledge of the What-If Analysis

Create and formatting pivot tables and pivot charts

Create, sorting, and filtering lists

Although our Excel 2013 course is not a mandatory prerequisite, it is recommended that you complete that course prior to starting advanced Excel 2013 training if you are not familiar with the topics listed above.

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"

(675 votes)

Lesson 1: Outlines and Templates

Outlining groups sections of the sheet together so you can hide them. 10 Total Points

Lesson 1 Video
Review Article: Excel Templates 2013
Complete: Assignment 1
Complete: Exam 1

Lesson 2: Working with Sparklines

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. 11 Total Points

Lesson 2 Video
Complete: Assignment 2
Complete: Exam 2

Lesson 3: Scenarios

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. 11 Total Points

Lesson 3 Video
Review Article: How to Use the Scenario Manager in Excel 2013
Complete: Assignment 3
Complete: Exam 3

Lesson 4: Goal Seek and Solver

Another way to ask Excel ?what if? is by using the Goal Seek and Solver tools. 10 Total Points

Lesson 4 Video
Review Article: Define and solve a problem by using Solver
Review Video: How to use the Goal Seek function in Excel
Complete: Assignment 4
Complete: Exam 4

Lesson 5: Pivot Tables

In this lesson, we are going to go in-depth as we learn to create and work with pivot tables. 11 Total Points

Lesson 5 Video
Complete: Assignment 5
Complete: Exam 5

Lesson 6: Continuing to Work with PivotTables

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. 11 Total Points

Lesson 6 Video
Review Article: Create a PivotChart
Complete: Assignment 6
Complete: Exam 6

Lesson 7: PivotCharts

Where a PivotTable is simply a table with data listed in it, a PivotChart is a graphical representation of the data. 11 Total Points

Lesson 7 Video
Complete: Assignment 7
Complete: Exam 7

Lesson 8: Mathematical Functions

In this lesson, we?re going to start talking about some of the more basic functions, as well as teaching you to use them. 11 Total Points

Lesson 8 Video
Complete: Assignment 8
Complete: Exam 8

Lesson 9: Continuing with Mathematical Functions

In this lesson, we are going to continue to explore mathematical functions. 11 Total Points

Lesson 9 Video
Review Article: LOOKUP function
Review Video: How to use the LOOKUP Function in Excel
Complete: Assignment 9
Complete: Exam 9

Lesson 10: Data Lookups

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. 11 Total Points

Lesson 10 Video
Review 2 Articles: Vlookup examples in Excel 2013; How to create relational databases in Excel 2013
Complete: Assignment 10
Complete: Exam 10

Lesson 11: The IF Function

The IF function helps to determine what will be displayed to those who view your worksheets in Excel. 11 Total Points

Lesson 11 Video
Review 2 Articles: IF function; Excel IF Statement: How to Use Excel IF Function
Complete: Assignment 11
Complete: Exam 11

Lesson 12: Data Functions

Data functions give you various ways to search your data. 11 Total Points

Lesson 12 Video
Review Article: Excel Tutorial: An In-Depth Guide to Working with your Data, Building Formulas, and Using Functions
Complete: Assignment 12
Complete: Exam 12

Lesson 13: Continuing with Data Functions

In this lesson, we are going to continue to explore the different data functions that Excel 2013 has to offer. 11 Total Points

Lesson 13 Video
Review 2 Articles: 10 new Excel 2013 functions that can save you time; OFFSET function
Complete: Assignment 13
Complete: Exam 13

Lesson 14: All About Data Validation

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. 11 Total Points

Lesson 14 Video
Review Article: Apply data validation to cells
Complete: Assignment 14
Complete: Exam 14

Lesson 15: Manipulating Text

Although Excel is well known for its mathematical capabilities and features, it also has some powerful tools for creating text formulas to manipulate text. 11 Total Points

Lesson 15 Video
Review Practice Worksheet: CHAR_functions.xlsx
Complete: Assignment 15
Complete: Exam 15

Lesson 16: Exploring Conditional Formatting

In this lesson, we are going to learn more about conditional formatting. 10 Total Points

Lesson 16 Video
Review Article: Excel formulas for conditional formatting based on another cell value
Review Video: Highline Excel 2013 Class Video 40: Conditional Formatting Basic To Advanced 50 Examples
Complete: Assignment 16
Complete: Exam 16

Lesson 17: Exploring Macros in Excel 2013

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. 11 Total Points

Lesson 17 Video
Review 2 Articles: Create or delete a macro; Enable or disable macros in Office files
Complete: Assignment 17
Complete: Exam 17

Lesson 18: More Fun with Macros

In this lesson we are going to continue to explore macros in this lesson and learn more about creating and working with them. 11 Total Points

Lesson 18 Video
Review Video: Highline Excel 2013 Class Video 51: Recorded Macro Basics, including Absolute and Relative References
Complete: Assignment 18
Complete: Exam 18

Lesson 19: Troubleshooting and Auditing in Excel 2013

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. 104 Total Points

Lesson 19 Video
Take Poll: How would you rate this course?
Complete: Assignment 19
Complete: Exam 19
Complete: 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, and
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: Advanced Excel 2013

Course Number: 8900326

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

Category:

UniversalClass.com > Computers & Technology > Microsoft Training

Course Type: Computer Skill (Self-Paced, Online Class)

CEU Value: 1.7 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 Staff Instructors

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

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

$75

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

You save 50%!

Start Now

Billed once
Includes all 500+ courses

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

Platinum Monthly

ALL COURSES
Certificates & CEUs

$59 first month

$29.00 / each consecutive month thereafter

Start Now

Billed monthly
Includes all 500+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	Monthly
No. of courses	500+

Related Courses

Introduction to SQL

This comprehensive course teaches and demonstrates all aspects of SQL. While you'll learn everything there is to do with SQL, this course assumes you have no prior SQL experience and is for the complete beginner. Structured Query Language (SQL) is t...

$75.00
1.7 CEUs 17h
Microsoft Access 2013

Microsoft Access 2013 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.0 CEUs 10h
Office 2013: Word, Excel, PowerPoint and Outlook

Word 2013: This course will teach both the new and experienced user alike how to use the many features of MS Word 2013. You'll learn how to create documents, publications and complete tasks that require the use of a word processor. You'll start out...

$110.00
4.0 CEUs 40h
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
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
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
JQuery Programming

JQuery is one of the most popular frameworks on the web that deals with client-side scripting for styling web pages and performing asynchronous events. It's built on the JavaScript language, so anyone familiar with the JavaScript language will pick ...

$85.00
0.9 CEUs 9h
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
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
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
Microsoft Visio 2016

Microsoft Visio 2016 is a program used to create diagrams and drawings of all types and for all purposes. Unlike the basic diagram functions found in other Office programs, such as Word or Excel, Visio offers advanced drawing and diagram functions t...

$75.00
0.7 CEUs 7h
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 Project 2016

Microsoft Project 2016 is a project management software program created for businesses and freelance professionals to help better manage individual projects that occur within companies. Although no project management software should be used to repla...

$75.00
0.8 CEUs 8h
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
MySQL

If you've decided to build a website or need a database, MySQL is an open-source option that's very cost effective and affordable. Without knowing how to install, configure, design and maintain the database, you risk having a poor performing environ...

$80.00
1.0 CEUs 10h
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
C# Programming

C# is a powerful backend coding language used for Microsoft web and desktop applications. C# is a C-style language, so you can take C# and learn other languages such as Java, C and C++. This course will get you started with C# and the language style...

$120.00
1.7 CEUs 17h
Introduction to JavaScript

JavaScript is the globally used client-side scripting language for the web. Most browsers support the language by default, so you can get started using JavaScript and HTML with a simple text editor and browser for testing. Client-side, programming l...

$75.00
1.0 CEUs 10h