Pricing
SearchOnline Class: Advanced Excel 2013
$50.00
no certificate
no certificate
- OR -
$75.00
with CEU Certificate*
with CEU Certificate*
-
19Lessons
-
39Exams &
Assignments -
17Hours
average time -
1.7CEUs
-
1,361Students
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
- Instructor Feedback
- 6 Months to Complete
- 24/7 Availability
- Start Anytime
- PC & Mac Compatible
- Android & iOS Friendly
- Accredited CEUs
Course Lessons
Average Lesson Rating: (529 votes)
"Extraordinarily Helpful"
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
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:
Course Type:
Computer Skill
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 Instructor
Syllabus:
View Syllabus
Duration:
Continuous: Enroll anytime!
Course Fee:
$50.00 (no CEU Certification) || with CEU Certification: $75.00
Choose Your Subscription Plan
Course Only
One Course
No Certificate / No CEUs
No Certificate / No CEUs
$50
for 6 months
Billed once
This course only
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
Certificate & CEUs
$75
for 6 months
Billed once
This course only
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
Certificates & CEUs
$189
per year
You save 50%!
Billed once
Includes all 500+ courses
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
Certificates & CEUs
$59 first month
$29.00 / each consecutive month thereafter
Billed monthly
Includes all 500+ courses
Includes all 500+ courses
| Includes certificate |
|
| Includes CEUs |
|
| Self-paced |
|
| Instructor support |
|
| Time to complete | Monthly |
| No. of courses | 500+ |
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.
Related Courses
Introduction to SQL$75.001.7 CEUs
Microsoft Access 2013$95.001.0 CEUs
Google Analytics 101$75.001.0 CEUs
Introduction to CSS$75.001.1 CEUs
MySQL$80.001.0 CEUs
OneNote 2016$75.000.5 CEUs
Typing and Keyboarding 101$75.002.0 CEUs
Excel 2013$75.001.5 CEUs
OneNote 2013$75.000.5 CEUs
QuickBooks 101$80.001.4 CEUs
Windows 7$75.000.7 CEUs
Final Cut Pro X$75.001.0 CEUs
Adobe Photoshop 101$75.001.0 CEUs
Product Management 101$75.000.9 CEUs
Adobe After Effects$90.001.0 CEUs
Dreamweaver 101$85.001.0 CEUs
Microsoft Visio 2013$75.001.0 CEUs
Effective Presentations$75.000.5 CEUs
PowerPoint 2016$75.000.7 CEUs
Advanced Excel 2013$75.001.7 CEUs
Excel 2010$75.001.4 CEUs
Microsoft Word 2016$75.000.8 CEUs
Office 2013: Word, Excel, PowerPoint and Outlook$110.004.0 CEUs
Visual Basic for Excel$115.001.7 CEUs
Microsoft Visio 2016$75.000.7 CEUs
Outlook 2016$75.000.5 CEUs
Adobe Premiere 101$95.001.0 CEUs
Adobe Lightroom 101$75.001.0 CEUs
Creating WordPress Websites$75.000.5 CEUs
Word 2010$75.000.8 CEUs
Photoshop Elements 101$75.001.0 CEUs
Ultimate Excel Bundle$125.004.6 CEUs
Crystal Reports$95.001.0 CEUs
OS X Yosemite$75.000.7 CEUs
Introduction to JavaScript$75.001.0 CEUs
Microsoft Publisher 2016$75.000.7 CEUs
Windows 8$75.000.7 CEUs
Excel 2016$75.001.2 CEUs
Microsoft Outlook 2013$75.000.8 CEUs
Windows 10$75.000.5 CEUs
How to Run an Effective Helpdesk$75.000.8 CEUs
Outlook 2010$75.000.6 CEUs
