Online Class: Advanced Excel 2013

Name: Advanced Excel 2013
Price: 95.00 USD

Dive deep into Excel's advanced functionalities, including data validation, custom formatting, and powerful analytics tools like Goal Seek and Solver. Tailored for those with basic Excel knowledge, this course empowers users to manipulate and visualize data effectively.

$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,730

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.

Courses Frequently Bought Together:

Microsoft Excel Level 1

Microsoft Office: Word, Excel, PowerPoint and Outlook

Introduction to SQL

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"

(707 votes)

Lesson 1. Streamlining Data with Excel Outlining

10 Points

Efficient data organization in Excel involves outlining, which can be created either automatically or manually, depending on the presence of subtotals. Custom views enhance this by allowing users to save and quickly apply various display settings, optimizing workflow. Additional lesson topics: Microsoft Excel 1PC/1User [Download]; Microsoft Office Home and Student 1PC/1User [Download]; Excel Templates

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

Lesson 2. Sparklines: A Visual Data Story within Cells

11 Points

Sparklines in Excel transform cell data into visual summaries, offering insights into patterns like employee sales. Master creating, modifying styles, addressing data omissions, grouping, comparing, and easily removing sparklines in your worksheets. Additional lesson topics:

Lesson 2 Video
Complete: Assignment 2
Assessment: Exam 2

Lesson 3. Creating, Managing, and Leveraging Scenarios in Excel

11 Points

Through Excel's Scenario Manager, create and assess multiple hypothetical scenarios—such as enlarging sales territories—without modifying original data, ensuring clarity in decision-making. This lesson teaches scenario creation, adjustments, and comparative summaries for enhanced analytical insights. 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. Mastering Goal Seek and Solver Tools

10 Points

Through Goal Seek, one can easily alter a singular cell in an Excel spreadsheet to meet a predefined target, albeit with simplicity. Conversely, Solver empowers users to handle multiple variables, employing diverse solving methods and constraints to reach more sophisticated, optimal solutions. 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. PivotTable Tactics for Efficient Data Analysis

11 Points

Pivot tables unlock the potential of large data sets in Excel by providing functions like totals, averages, and sorting. This lesson equips users with skills to manage data through hands-on creation, filtering, and organization techniques, including suggestions for efficient table setup and maintenance. 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. Mastering the Art of PivotTables: Going Beyond Basics in Excel

11 Points

PivotTables empower Excel users by offering detailed data analysis and customization options to manage large data sets efficiently. The lesson highlights techniques like cell adjustment, grouping, timeline usage, and SQL server integration to enhance data insights. Additional lesson topics: Create a PivotChart

Lesson 6 Video
Complete: Assignment 6
Assessment: Exam 6

Lesson 7. Creating and Managing PivotCharts in Excel

11 Points

The lesson demonstrates transforming worksheet data into PivotCharts, offering a visual edge over traditional PivotTables. Key skills covered include creating, customizing, filtering, and managing PivotCharts for effective data presentation. Additional lesson topics: Excel Tutorial; Excel Tutorial

Lesson 7 Video
Complete: Assignment 7
Assessment: Exam 7

Lesson 8. Navigating Excel's Mathematical Landscape

11 Points

Excel 2013 offers essential mathematical functions that help users create formulas and analyze data, demonstrating the use of SUM and COUNT functions for tallying sales data over a period. The lesson also covers finding averages and extrema in datasets using AVERAGE, MIN, and MAX functions, along with practical steps for automating these calculations in spreadsheets.

Lesson 8 Video
Complete: Assignment 8
Assessment: Exam 8

Lesson 9. Effortless Time and Loan Calculations

11 Points

This lesson teaches how to manage time data in Excel using decimals, along with optimal formatting techniques for time calculations. Further, financial computations such as loan payments, interest rates, and investments are meticulously explained using functions like PMT, RATE, and PV. Additional lesson topics: LOOKUP function; How to use the LOOKUP Function in Excel

Lesson 9 Video
Complete: Assignment 9
Assessment: Exam 9

Lesson 10. The Art of Fetching Data in Excel

11 Points

Using a dialogue box when entering formulas in Excel provides guided steps to help users—especially beginners—reduce trial and error in creating functions. 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. Using IF Functions to Manage Data Errors

11 Points

Learning to harness the power of the IF function in Excel equips users to tailor data displays by setting specific conditions, with options to nest functions for added complexity. This lesson touches on related functions like IFNA and IFERROR, and logical constructs enabling complex, criteria-based calculations. 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. Error Management and Lookup Functions in Excel

11 Points

Excel's data functions, such as MATCH and INDEX, simplify data search by allowing precise location of information in extensive lists, eliminating tedious scrolling through rows. This lesson covers MATCH, INDEX, CHOOSE functions, and handling #REF errors, showing how wildcard and combined functions enhance data retrieval. 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. Mastering IS Functions: Error Checking in Excel

11 Points

Learning IS, IFERROR, and OFFSET functions allows for error-handling and crafting adaptable spreadsheets that grow with your data. OFFSET's utility shines in dynamic ranges, while INDIRECT resolves complex cell referencing issues smoothly. 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. Mastering Data Validation in Excel: A Comprehensive Guide

11 Points

Excel's data validation feature guards against erroneous data entry by defining allowable data types and facilitating error messages. Practical guidance in this lesson includes rule creation, invalid data identification, and managing validation dropdowns and message customization in worksheets. 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. Text Functions in Excel: A Comprehensive Study

11 Points

Master Excel's capabilities beyond numbers by leveraging text functions such as LEFT, RIGHT, and TRIM to efficiently manipulate and clean your data. Harness the power of CONCATENATE and TEXT functions to seamlessly integrate and format text and numbers.

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

Lesson 16. Bringing Data to Life: Mastering Conditional Formatting in Excel

10 Points

Through conditional formatting, Excel allows for dynamic data visualization using colors and icons to better identify key insights and data patterns. This lesson provides hands-on guidance on applying top/bottom rules, leveraging formatting presets, and creating custom rules to optimize data presentation. 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. Mastering Macros: Automation in Excel 2013

11 Points

Excel macros enable users to efficiently execute multiple commands using keyboard shortcuts, saving significant time. The lesson details the steps to create, manage, and secure these macros, ensuring seamless data operations. 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. Macro Integration

11 Points

Demystify macro editing with basic Visual Basic instructions to safely modify existing macros, adding functionality like confirmation boxes to avoid accidental data loss. Empower your worksheet automation with a curated selection of personalized macros readily available across all workbooks. 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. Quick Tips for Excel 2013 Error Checking

104 Points

Excel 2013 facilitates efficient troubleshooting through features like tracer arrows to trace relationships between cells, Error Checking for inconsistency resolutions, and the Watch Window functionality for real-time monitoring of data changes across multiple sheets. These tools aim to streamline error detection and correction, optimizing workflow productivity.

Lesson 19 Video
Lesson discussions: How would you rate this course?; Course Comments; Program Evaluation Follow-up Survey (End of Course); Reasons for Taking this 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

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

Lessons Rating: 4.18 / 5 Stars (707 votes)

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

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Certification Courses

Availability: You can take this course online in every U.S. state including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. International availability includes English-speaking countries like Canada, Australia, the UK, and South Africa.

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