Advanced Excel Classes Online With Software

This course includes

6 hours of project-based training from experts
22 training videos
Learn from a Microsoft Certified Trainer
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
Learn from a Microsoft Certified Trainer
Verified digital certificate of completion

Learning Experience Highlights

Learn from world-class creators

Classes taught by leading photographers, designers, and artists who share real workflows and insights

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

Watch anywhere, on your schedule

Stream on-demand video lessons at your own pace. Rewatch anytime, on any device, whenever inspiration strikes

Shabang! I'm really enjoying the class. This course feels like a workshop with step by step demo on every piece of theory and with tons of details."
— Gerald B.

A student reading a workbook in class

Comprehensive course materials

Downloadable guides & practice files crafted to support your creative journey

Join a global creative community

Connect with thousands of fellow learners and get inspired by creators from around the world

100% Online. Start Anytime

24/7 access to our premium course videos and projects.
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 Training

Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, 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