BEST ADVANCED EXCEL COURSE

Microsoft Advanced Excel Accelerated Course

4.8 Stars of 445 Reviews


Our Microsoft Advanced Excel Accelerated Course includes 7 lessons and over 25 spreadsheets to practice your advanced Excel skills. Our online advanced Excel course will help you learn advanced Excel formulas and practice using techniques with Pivot Tables & Pivot Charts. Our advanced course in Excel will allow you to:

Practice using formulas with dates to make accurate calculations
Learn to connect spreadsheets for easier navigation
Create rules by using IF formulas and other logical statements
Master the use of lookup formulas to become more efficient in Excel
Practice creating and using Pivot Tables
Format your Pivot tables to make them look presentable
Learn to create Pivot Charts and Slicers
Learn Excel shortcuts 
Much, much more...

 Lifetime Access 

Microsoft Advanced
Excel
Accelerated Course

Only $19.98

Regular price: $44.99

7 Self-Paced Lessons
2+ Hrs of Video Instruction
Access Anywhere & Anytime
Lifetime Access to course
25+ Demonstrations
25+ Spreadsheets For Practice
Instant Access upon purchase
Certificate of Completion
Excel support from our experts
[FREE BONUS] Excel for Advanced users E-book
mastercard
discover

Offer only valid until:

Monday

January

01

1999

Certificate upon Completion

Over 25 Downloadable Practice Spreadsheets 

Contact Excel Experts When You Feel Stuck

Lifetime & Instant Access to Course Content

ADVANCED MICROSOFT EXCEL COURSES

Master Advanced Excel Skills


What is included in the Microsoft Advanced Excel Accelerated Course?
[FREE] Excel E-book
7 On-Demand Lessons
2+ Hrs of Video Instruction
Lifetime Access to course
Over 25 Demonstrations
Over 25 Practice Spreadsheets
Perfect for Office 2016, Office 2019 & Office 365

RELEVANT ADVANCED EXCEL CLASS CONTENT

Master VLOOKUPs & Pivot Tables


Leadership Build is Microsoft Certified and has built the Advanced Excel Accelerated Class to help advanced Excel users become confident in their Microsoft Excel advanced skills. Our on-demand Excel class for advanced users is intended for those users in need of more advanced Excel techniques.

Microsoft Advanced Excel Accelerated Class Content

1m 25s

Warm-Up Exercise

The first task to complete in your on-demand course are two exercises that will help you determine your current skill level and will help you see how prepared you are for the advanced course.

10m 17s

Lesson 1: How to use Hyperlinks & Work with Dates

During the first lesson of your advanced excel course, you'll learn how to use hyperlinks to link URLs, pages and files to your spreadsheet and you'll also practice using formulas with dates.

19m 19s

Lesson 2: Logic Formulas

In the second lesson of your Microsoft excel advanced course,  you'll work with the infamous IF formula, combining other logical formulas to automate your calculations and tables.

17m 50s

Lesson 3: LOOKUP Formulas

During the third lesson of the advanced excel course, you'll learn how to use popular formulas to transfer data, such as the VLOOKUP formula and other LOOKUP formulas.

9m 26s

Lesson 4: Introduction to Pivot Tables

The fourth lesson of our advanced excel training includes an introduction to Pivot Tables. You'll learn how to quickly create a pivot table from large data sets.

11m 42s

Lesson 5: How to Customize Your Pivot Tables

Lesson 5 is a continuation of the previous Pivot Table lesson, where you'll learn how to customize Pivot Tables, when to use them, how to manipulate them and keep them updated.

9m 46s

Lesson 6: Pivot Charts

Learn how to create Pivot Charts and graphs easily and quickly with Lesson 6 of your Advanced Excel training course. You'll learn how to use your data in pivot tables to create charts and how to customize the chart to your needs.

5m 29s

Lesson 7: Additional Tasks for Pivot Tables

To complete your course, you'll learn how to use additional tasks with Pivot Tables and tables in general. Here, you'll learn how to use Slicers with Pivot Tables and other Excel features to help you master your advanced Excel skills.

Final Exam

Complete your Advanced Excel training class by passing our final exam and earn your certificate quickly.

ADVANCED EXCEL CERTIFICATION

Certificate of Completion


Earn your Certificate after completing your Microsoft Advanced Excel Accelerated Course and passing the Final Exam. The certificate is available for download in PDF format.

TESTIMONIALS

What some of our proud users say about us


4.8 out of 5 stars

Sergio Felix, Warehouse Manager

"Best Excel course out there to finally master lookup formulas and pivot tables at a great price. Happy with my purchase."

Carlos Perez, Business Owner

"Just what I needed - an Excel course that teaches topics beyond basic stuff. The logical formulas and pivot chart lessons are the best!"

Matthew Grundy, CEO Habitat for Humanity

"I recommend Leadership Build's Excel courses for any employer looking to train their staff on Microsoft Excel."

Debra Sosa, Entreprenuer

"The practice spreadsheets are worth the price themselves. I enjoyed working through the exercises on my own and applying what I learned."

Petar Bašić, E-Commerce

"I originally thought the course would be a set of videos but I actually learned useful formulas by doing the exercise spreadsheets and not just by watching."

Jade Eastwood, Social Media Manager

"I can finally say that I am an Advanced Excel user. Investing in the course is way better than relying on YouTube."

GET SUPPORT ALONG THE WAY

Contact Our Excel Experts When You Feel Stuck


As you work through your Excel course, you'll have a piece of mind knowing that help is always near. Whenever you feel stuck you can post questions to get help from an expert, email us or chat with us live. You can expect responses within 24 hours.

PRACTICE BEYOND THE COURSE

FREE E-Book: Microsoft Excel Course: Advanced Module


To help you with your journey, our Advanced Excel Accelerated Course includes a FREE E-book. This E-book is a great resource that you can use during your course and after you complete the course. The E-book includes:

160+ pages all accessible as a PDF file
Step-by-step instructions on how to perform advanced-level Excel functions
Screenshots and images to help you follow along easily

What's Included With Your Purchase

7 Video Lessons to learn Advanced Excel skills quickly and efficiently
Access On-Demand Course any where and anytime
Get Instant Access to your course immediately after your purchase
Lifetime Access to the Advanced Excel course
Self-Paced content to learn your way
More than 25 Excel spreadsheets to follow along the video demonstrations
More than 25 additional spreadsheets to help you practice on your own and apply the skills taught in each lesson
Earn your Certificate upon completion of the course
[FREE BONUS]Immediate Access to Our Microsoft Excel Advanced Module E-Book (PDF Only)

 70% OFF Course 

Microsoft Advanced
Excel
Accelerated Class

Only $19.98

Regular price: $44.99

Receive a FREE

Microsoft Excel Advanced E-Book with purchase

mastercard
discover

GREAT LEADERS ARE BUILT

About Leadership Build


Leadership Build was established in 2013 in sunny, Southern California. Our goal is to provide resources, training and coaching to employees across all industries in order to develop strong leaders. We strive to help people in organizations by providing professional development and the proper support for long-term success. To learn more about our mission, vision and our values, visit our About Us Page.

Our services include online courses, online workshops via webinars, in-person company trainings and consulting. To contact us about your training needs, please email us at info@leadershipbuild.com

WE HAVE ANSWERS

Frequently Asked Questions


Is the Advanced Excel Accelerated course an on-demand courses?

Yes. The course is a self-paced on-demand course with practice spreadsheets that you can download to follow along and complete the assigned exercises.

Why is the courses considered an "Accelerated" course?

Our "Accelerated" courses are meant to focus on the important Excel concepts that you will most likely use and leaves out concepts that are hardly used. The goal of our accelerated courses is to help you master essential Excel skills quickly and easily.

Is the Advanced Excel Accelerated course taught with a live instructor?

No. The course is an on-demand course.

How long will I have access to the Excel course?

When you purchase one of our Excel courses, you will have lifetime access to the course. This means that you'll always be able to log in to your account and access your course content.

Do these courses include a certificate?

Yes, all of our online Excel courses include a certificate that you earn upon completing the course and passing the final exam.

Do you offer Excel workshops for companies/employees?

Yes, Leadership Build conducts 2-hour, 4-hour and 6-hour workshops with companies on various computer skills and soft skills. To learn more, feel free to complete our Questionnaire.

How do I purchase multiple Excel courses for employees?

To purchase our Excel courses in bulk, please contact us at support@leadershipbuild.com or chat with us live to provide us with your needs.

Copyright © Leadership Build 2020 | All Rights Reserved.

For Avid Excel Users

Lifetime Access to Course
7 Detailed Lessons
25+ Practice Exercises to help you apply what you learn
25+ Instructor-led demonstrations
Taught by Certified MS Office Specialist
Access to Instructors for help

Advanced Excel Accelerated Course

4.8 Stars of 68 Reviews

The Advanced Excel Accelerated Course is specifically designed to help any excel user who uses the Excel program consistently and wants to learn some of the advanced features Excel has to offer. This online Excel training course bridges the gap between intermediate skills and advanced concepts by covering the essential Excel functions any advanced Excel user really needs to know. The course is divided into 7 individual lessons and includes more than 25 practice exercises, allowing users to earn their Excel certificate quickly.  

Course Details

Number of Lessons: 7

Instruction Type: Video tutorials

Instructor-Led Exercises: 26

Practice Exercises: 26

Access to Instructor: Yes

Certificate Included: Yes

Total Instructional Time: 1 hour & 28 minutes

Length of Subscription: Lifetime

Listed Price of Course: $45.99

Course Syllabus

WARM UP LESSON

Instruction Length: 1m 25s

The Advanced Excel Accelerated Course begins with two warm-up exercises to help you assess your skills in a few intermediate-level Excel concepts. The warm-up exercises are designed to help you smoothly transition from an intermediate Excel user to an advanced Excel user.

 

LESSON 1: HOW TO USE HYPERLINKS & WORK WITH DATES

Instruction Length: 10m 17s

Lesson 1 helps you quickly learn Excel skills that intermediate users should know and helps our newer Excel students get well acquainted with the structure of our course.  During this lesson you'll learn different techniques to link sheets together, work with hyperlinks and learn a few formulas that will help you become more efficient when working with dates in Excel.

 

LESSON 2: LOGICAL FORMULAS

Instruction Length: 19m 19s

In Lesson 2 of our Advanced Excel Accelerated Course, you'll begin to learn how to automate your formulas by using the infamous IF formula. Through numerous exercises, you'll learn how to apply the IF formula to automate a process, how to use multiple IF formulas when you encounter different conditions and how to combine IF formulas with other logical formulas to facilitate the automation process.

 

LESSON 3: LOOKUPS, VLOOKUPS AND HLOOKUPS

Instruction Length: 17m 50s

In Lesson 3, users will spend a significant portion of their time learning three different types of lookup formulas by learning about how they are structured, how they are used, and when to use each type of formula depending on your spreadsheet and your desired outcome.

 

LESSON 4: INTRODUCTION TO PIVOT TABLES

Instruction Length: 9m 26s

In Lesson 4 of our Advanced Excel Accelerated Course, you'll learn how to build pivot tables in a few easy steps.

 

LESSON 5: HOW TO CUSTOMIZE YOUR PIVOT TABLES

Instruction Length: 11m 42s

Lesson 5 is a continuation of Lesson 4. Now that you have some basic understanding of Pivot Tables, it's time to learn how to to customize them, manipulate them and organize them depending on the data you want to produce.

 

LESSON 6: PIVOT CHARTS

Instruction Length: 9m 46s

Learn how to create pie graphs, bar charts, line graphs and more by using Pivot Charts in Excel.

 

LESSON 7: ADDITIONAL TASKS FOR PIVOT TABLES

Instruction Length: 5m 29s

Become a pro with Pivot tables by learning how to do additional tasks, such as inserting Slicers into your pivot tables and creating a custom field with a calculation.

Customer Reviews

Our happy customers continue to rate us with 5 stars

[RICH_REVIEWS_SNIPPET category="Advanced Excel Accelerated Course"] [RICH_REVIEWS_SHOW category="Advanced Excel Accelerated Course" num=10]
Close

Learn the Excel Basics

Lifetime Access to Course
7 Detailed Lessons
20+ Practice Exercises to help you apply what you learn
30+ Instructor-led demonstrations
Taught by Certified MS Office Specialist
Access to Instructors for help

Excel for Beginners Accelerated Course

4.9 Stars of 102 Reviews

The Excel for Beginners Accelerated Course is designed to help any beginning excel user learn the foundational concepts of Microsoft Excel quickly and easily. This Excel training course for beginners covers the basics new users need to learn how to use the software without the need of learning Excel functions that may go unused. The course is divided into 7 separate lessons and includes more than 20 practice exercises and a way to earn the Excel for beginners certificate quickly.  

Course Details

Number of Lessons: 7

Instruction Type: Video tutorials

Instructor-Led Exercises: 25

Practice Exercises: 32

Access to Instructor: Yes

Certificate Included: Yes

Total Instructional Time: 1 hour & 50 minutes

Length of Subscription: Lifetime

Listed Price of Course: $45.99

Course Syllabus

 LESSON 1: BASIC NAVIGATION & TERMINOLOGY

Instruction Length: 17m 4 s

Build your foundational skill by learning how to navigate a workbook, a ribbon and work with a basic spreadsheet. During this lesson you'll learn where to find things in Excel, how to properly name sections in Excel, how to navigate a ribbon, a workbook and a spreadsheet. You'll end the lesson working with some data and doing simple tasks to get you acclimated with tables.

 

LESSON 2: UPDATING, CHANGING & DUPLICATING THE FORMAT & CONTENT OF TABLES

Instruction Length: 21m 51 s

Learn how to use the Home tab commands to change the formatting of the content in your tables. During this lesson you'll be able to cut, copy and paste content, cells, rows and columns and learn how to use the Format Painter. Additionally, you'll learn how to change the background colors of cells, font colors and work with the Alignment group and working with Number formats.

 

LESSON 3: EDITING, SORTING AND FILTERING YOUR TABLES

Instruction Length: 22m 35 s

Learn basic Excel concepts such as inserting, deleting and moving rows and columns and how to sort and filter your table. During this lesson you'll use more common techniques to manipulate and organize your data.

 

LESSON 4: MORE EXCEL FUNCTIONS EVERY BEGINNER SHOULD KNOW

Instruction Length: 11m 47 s

In Lesson 4 of our Excel for Beginners Accelerated Course learn additional Excel functions such as grouping, removing duplicate entries and inserting Headers and Footers to sheets.

 

LESSON 5: INTRODUCTION TO EXCEL FORMULAS

Instruction Length: 11m 41 s

Learn how to build a formula and how to read basic Excel functions by learning the foundational concepts of formula calculations and the structure of the syntax. In this lesson you will also learn shortcuts to use basic formulas.

 

LESSON 6: AUTOSUM & SUM FUNCTIONS

Instruction Length: 9m 14 s

Learn and practice using AutoSUM and the SUM formula in your tables. These two basic formula functions will become the stepping stone to learn more advanced formulas.

 

LESSON 7: MORE EXCEL FORMULAS

Instruction Length: 12m 19 s

In this lesson, learn additional formulas to use with your tables and make automatic computations such as the AVERAGE formula the COUNT formula and the MAX and MIN formulas.

Customer Reviews

Our happy customers continue to rate us with 5 stars

[RICH_REVIEWS_SNIPPET category="Excel for Beginners Accelerated Course"] [RICH_REVIEWS_SHOW category="Excel for Beginners Accelerated Course" num=10]
Close

Go Beyond the Basics

Lifetime Access to Course
7 Detailed Lessons
25+ Practice Exercises to help you apply what you learn
20+ Instructor-led demonstrations
Taught by Certified MS Office Specialist
Access to Instructors for help

Intermediate Excel Accelerated Course

4.9 Stars of 81 Reviews

The Intermediate Excel Accelerated Course is specifically designed to help any frequent excel user quickly move beyond the basics. This Excel training course for intermediate-skilled users bridges the gap between beginner and intermediate concepts, and covers the only the essential Excel functions that intermediate Excel users really need to know. The course is divided into 7 separate lessons and includes more than 25 practice exercises and a way to earn your certificate quickly.  

Course Details

Number of Lessons: 7

Instruction Type: Video tutorials

Instructor-Led Exercises: 21

Practice Exercises: 26

Access to Instructor: Yes

Certificate Included: Yes

Total Instructional Time: 1 hour & 45 minutes

Length of Subscription: Lifetime

Listed Price of Course: $45.99

Course Syllabus

WARM-UP LESSON  

Instruction Length: 1m 31 s

The Intermediate Excel Accelerated Course begins with two warm-up exercises that will help you test your skills in basic Excel concepts. The warm-up exercises are designed to help you bridge the gap between beginner-level skills and intermediate skills.

 

LESSON 1: USING ANCHORS TO USE THE AUTOFILL HANDLE

Instruction Length: 8m 18 s

Lesson 1 helps you quickly get up to speed with some preliminary concepts you may have never learned to use as a beginner. During this lesson you’ll learn a few shortcuts to quickly apply formulas to tables and how to properly implement the use of the Autofill Handle and anchors.

 

LESSON 2: CREATING RULES WITH CONDITIONAL FORMATTING

Instruction Length: 8m 48 s

Improve your efficiency when using tables by creating specific rules to highlight or make parts of your data stand out. In Lesson 2 of the Intermediate Excel Accelerated Course you will learn how to make your tables look a lot more professional and even automate the process of highlighting cells. Lear how to use create various rules and effectively use Conditional Formatting.

 

LESSON 3: USING DATA VALIDATION TO CONTROL DATA ENTRY ERRORS

Instruction Length: 10m 12 s

In Lesson 3, learn how to control data entry errors in your spreadsheets, which is a very helpful technique if you have multiple people working on data sets. Use Data Validation to reject data imputed into specific cells.

 

LESSON 4: USING TEXT TO COLUMNS TO SPLIT YOUR CELL CONTENT

Instruction Length: 9m 52 s

In Lesson 4 of our Intermediate Excel Accelerated Course learn a special technique that will allow you to split the content of cells into one or more columns.

 

LESSON 5: HOW TO USE TEXT FORMULAS AND PASTE SPECIAL VALUES

Instruction Length: 19m 59 s

Improve your use of formulas by learning how to manipulate, extract and combine your data. In Lesson 5, learn how to use specific Text formulas to accomplish a desired outcome.

 

LESSON 6: SHORTCUTS TO USE WHEN WORKING WITH TABLES

Instruction Length: 10m 24 s

Learn and practice the use of Table formatting which will help you become more efficient when working with large data sets.

 

LESSON 7: INTRODUCTION TO LOGICAL FORMULAS

Instruction Length: 20m 29 s

Become more efficient by learning the structure, use and importance of Logical formulas. In the final lesson of our Intermediate Excel Accelerated Course you will be introduced to more complex formulas that will help you quickly analyze your data and prepare you for more advanced techniques.

Customer Reviews

Our happy customers continue to rate us with 5 stars

[RICH_REVIEWS_SNIPPET category="Intermediate Excel Accelerated Course"] [RICH_REVIEWS_SHOW category="Intermediate Excel Accelerated Course" num=10]
Close