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 the most advanced features of Microsoft Excel in this training course. Once you've mastered the basics of building and organizing spreadsheets, you'll learn how to manipulate and visualize data to improve your workflow and draw deeper insights.

In this course, you'll learn how to manage spreadsheets, use advanced analytics tools, and write macros to improve efficiency. You'll also become proficient in complex Excel functions, including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH. The skills you develop will apply to virtually any role that requires organizing and analyzing large amounts of data.

Why Learn Excel?

Excel is one of the most widely used business applications in the world. No matter what field you work in, learning Excel can help optimize your workflow and improve your productivity. Whether you're a professional data analyst or someone who needs to catalog and organize large amounts of information, Excel skills offer long-term value.

While few jobs rely exclusively on Excel, it is a foundational tool for anyone pursuing a career in data analytics or finance, and a valuable complement to other technical skills.

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