Advanced Excel Classes Online With Software

This course includes

6 hours of project-based training from experts
22 training videos
Access to Microsoft Office (1 month)
Learn from a Microsoft Certified Trainer
Access to class recordings (30 days)
Verified digital certificate of completion

This course is self-paced. For live online or in-person instruction, take Excel Level III: Advanced.

Learn all of the most complex features of Microsoft Excel in this advanced training course. Once you’ve mastered the basics of building and organizing spreadsheets using Excel, you can learn to manipulate and visualize that data to improve your workflow and draw deeper insights.

In this class, you will find out how to manage spreadsheets, utilize advanced analytics tools, and write macros to improve efficiency. You will also become familiar with complex Excel functions, including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH. The tools you’ll learn in this class will apply to virtually any job setting where you must organize large amounts of complex data.

Why Learn Excel?

Excel is one of the most commonly used business applications on the planet, so no matter what field you work in, learning Excel has the potential to help optimize your workflow and improve your productivity. Whether you're working as a professional Data Analyst or just working at a company with a lot of information to catalog and organize, learning Excel can pay long-term dividends.

Very few jobs strictly use Excel, so anyone looking to start a new career will need supplemental training. However, learning Excel is foundational for anyone hoping to work in a data analytics or financial career.

This course has a prerequisite

Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.

Video Training Preview

Lesson 1: Cell Management

Lesson 2: Special Formatting

Lesson 3: Advanced Functions

Lesson 4: What If Analysis

Lesson 5: Advanced Analytical Tools

Lesson 6: Advanced Database Functions

Lesson 7: Introduction to Macros

Lesson 8: Dynamic Arrays

Tuition

Full Tuition

$249
Due before the class starts

This course includes

6 hours of project-based training from experts
22 training videos
Access to Microsoft Office (1 month)
Learn from a Microsoft Certified Trainer
Access to class recordings (30 days)
Verified digital certificate of completion

Learn the Skills Guarantee™

Hands-on training in small groups

Build practical skills by working through guided projects designed to reinforce learning

Several students, sitting at computers, looking at the front of the classroom

Time-tested curriculum and supporting materials

Course resources are shaped through repeated instruction to support outcomes

Amazing experience. The professor really broke down the material and made sure I understood it. I would definitely recommend this class or school to anyone. Truly loved it!
— David G.

A student reading a workbook in class

Learn from industry experts with teaching experience

Classes are led by professionals who combine real-world expertise with proven teaching abilities

Retake the course for free within one year

Return to the course at no cost to review concepts and strengthen your skills

100% Online. Start Anytime

24/7 access to our premium course videos and projects.
Access to Microsoft Office (1 month)
Industry experts are assigned as your course instructor. Message your instructor with any questions.
Participate in CreativeLive online discussion forums — share ideas and receive additional support.
Hands-on quizzes and mini projects to test and reinforce concepts.

Earn a Certificate of Completion

Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!

Shareable on

Sample credential for completion of Excel Level III: Advanced Course Online (Self-Paced)

Excel Level III: Advanced Course Online (Self-Paced) Curriculum

What You'll Learn at a Glance

Cell management, including cell locking, auditing, and hot keys
Special formatting for calculating dates
Use advanced functions such as nested IF statements
Learn advanced analytical tools for data consolidation, conditions to exclude data, and pivot charts
Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
Record macros and relative reference macros for ad hoc reporting
Create a project that applies key concepts from the class

Course Syllabus

Download Syllabus PDF

Advanced Navigation

Advanced Navigation

Advanced navigation techniques

Fill Review

Review of Autofill conventions and techniques

Cell Management

Advanced Cell Locking

Create powerful formulas by locking either the column or the row

Hot Keys

Transform the ribbon into a visual listing of pre-assigned shortcuts

Cell Auditing

Observe the relationship between formulas and cells

Go To Special

Quickly select cells that meet certain criteria

Special Formatting

Conditional Formatting-Formulas

Create custom rules for Conditional Formatting with formulas

Date Functions

Calculate dates with a variety of functions

Custom Number Formats

Customize number formats to meet specific requirements

Advanced Functions

Nested IF statements

Nested "IF" statements allow for more than just two possibilities in a single cell

IF statements with AND/OR

Expand the functionality of the IF function by adding an AND / OR criteria

What If Analysis

Goal Seek

Find the desired result by adjusting an input value

Data Tables

Data Tables show the range of effects of one or two different variables on a formula

Advanced Analytical Tools

Calculation Options

Minimize volatility by changing calculation options

Conditional SumProduct

Use SumProduct with conditions to exclude data that does not meet certain criteria

Pivot Table-Base Fields & Sets

Analyze data in a Pivot Table with increased granularity by defining base fields and sets

Pivot Table-Calculations

Create calculated rows or columns in a Pivot Table that go beyond the source data

Pivot Charts

Create dynamic, graphical representations of Pivot Table data

Advanced Database Functions

XMATCH function

Return the relative position (column or row number) of a lookup value

INDEX-MATCH

Efficiently return a value or reference from a cell at the intersection of the row and column

INDEX-Double MATCH

Use a second Match function to create a powerful, two-way lookup tool

Introduction to Macros

Recording Macros

Record macros that involve formatting and calculations

Dynamic Arrays

Dynamic Arrays

Use formulas that can return arrays of variable size

End of Class Projects

Projects

End of class project to review key concepts from the class

Corporate & Onsite FinTech Classes Online Training

Purchase group class vouchers at a discount for our regularly-scheduled group classes, or create a custom training program at your offices.

Private Training

Available onsite at your location
Modern computer labs available at our offices
Customize or choose from our existing courses
Free instructor consultations to finalize content

Or

Group Class Vouchers

Send employees to our group classes
Extensive offerings and flexible scheduling
Simple billing and logistics
Computers and training resources provided

Installment Plan Breakdown for Excel Level III: Advanced Course Online (Self-Paced)

The first installment is due one week before the first class. Subsequent installments are spread out evenly across the duration of the course.

Installments
	10% non-refundable deposit
$249.00	Total You Pay