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:

Certificate upon Completion

Over 25 Downloadable Practice Spreadsheets 

Contact Excel Experts When You Feel Stuck

Lifetime & Instant Access to Course Content

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:

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 [email protected]

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 [email protected] or chat with us live to provide us with your needs.

Copyright © Leadership Build 2020 | All Rights Reserved.

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

Advanced Excel Accelerated Course Overall rating: ★★★★★ 4.9 based on 68 reviews.
5 1

Best course to learn pivot tables

Advanced Excel Accelerated Course
★★★★★
I purchased the course to learn pivot tables and this course did more than that. I never knew how to work with pivot charts and lookups so my mind is definitely blown away with everything that I learned in such a short period of time.
- Mara Kent

Great course for those looking to learn VLOOKUPS and Pivot Tables

Advanced Excel Accelerated Course
★★★★★
The Advanced Excel course cuts straight through what I needed which is some advanced formulas like VLOOKUPS and it has a few lessons specific to Pivot Tables. The course fit my needs perfectly!
- DJ Patel

Best course for employees to learn quickly

Advanced Excel Accelerated Course
★★★★★
I needed my staff to learn about vlookups and pivot tables quickly and this course helped my staff get up-to-speed in just a week. They are now on fire! I highly recommend this course to any company that needs their staff to learn these advanced concepts.
- Walker Byrd

The most practical course I've taken

Advanced Excel Accelerated Course
★★★★★
I was originally looking for a live workshop online and decided to give this advanced class a shot and was very pleased with my purchase. The examples the videos give are aligned to workplace examples and I liked that. Also, the files proivded by the course is worth buying the course because I haven't yet seen a company provide so many great resources. Highly recommend this course!
- Wylie Franks

Great for employees

Advanced Excel Accelerated Course
★★★★★
Our company was looking for Excel training for advanced users but really needed staff to learn formulas and Pivot stuff as quickly as possible. The accelerating course helped our staff learn advanced skills in a matter of days and help us prepare better spreadsheet to keep track of staff information. Highly recommend!
- Gene Simmons

great course for avid excel users

Advanced Excel Accelerated Course
★★★★★
Good course for people like me that needed to learn advanced excel fast
- Morgan Gilliam

Easy to follow and practice

Advanced Excel Accelerated Course
★★★★★
The video tutorials in advanced course were easy to follow along. The practice files were great to really showcase what I learned. I also like the fact that we can email or contact the instructor and he responds quickly to our questions and problems.
- Star Johansson

good class

Advanced Excel Accelerated Course
★★★★★
I enjoyed the excel class. thank you
- Brooke Mcgowan

5 stars to advanced excel class

Advanced Excel Accelerated Course
★★★★★
the advanced excel course is just what I needed - highly recommend
- Alan Brown

great excel lessons

Advanced Excel Accelerated Course
★★★★★
The 7 lessons go by quickly but they are filled with step by sptep tutorials that i needed for my job
- Vielka Roberson
Close

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

Excel for Beginners Accelerated Course Overall rating: ★★★★★ 4.9 based on 102 reviews.
5 1

Perfect course for employees

Excel for Beginners Accelerated Course
★★★★★
I learned about Leadership Build through an employee of mine who learned Excel quickly to do specific tasks for our dental practice. I decided to purchase the course to provide professional development for our small staff and the course was exactly what we needed. Pros: very well designed, instructor is great and responsive, you can access the tutorials at any time, lifetime access to the course... Cons: wish there was more content (but understand that it's an accelerated version of Excel).
- Maribel F. Escamilla

Great course for employees

Excel for Beginners Accelerated Course
★★★★★
I purchased a few licenses so that multiple employees can take the excel course and it's the best course out there since I researched quite a few courses. The accelerated course isn't as extensive as the other ones I saw online (I purchased a licenses for myself just to take a look at the content) but my employees learned the basics SUPER FAST and were able to work on the common spreadsheets we use in our industry. Highly recommend this course.
- Haley Sampson

Perfect course to learn Excel quickly

Excel for Beginners Accelerated Course
★★★★★
The Excel Accelerating course is great for beginners like me. I am not a computer person and we use Excel at work all the time but I never got around to learning excel. My supervisor purchased the course for me about a month ago and she was really impressed with my excel spreadsheets after completing the class. Thank you for the great course!
- Catalina Rose

I finally learned Excel!

Excel for Beginners Accelerated Course
★★★★★
Like many others, I was hesitant in purchasing a course on excel when I can easily just learn and look at tutorials on youtube but I've literally been watching youtube videos to learn excel for the last 3 years and nothing. My job asked me to take an excel class and I found Leadership Build online. The course is short and sweet and very detailed. I had a chance to practice what the instructor taught with the spreadsheets the instructor provided and was able to get my certificate super quick. Highly recommend to anyone serious about learning excel
- Teddy Williams

good training

Excel for Beginners Accelerated Course
★★★★★
The videos seem a little fast at times so I had to go back and replay the video. The teacher is good and the spreadsheets to practice are good.
- Perez P

A proper review for a good course

Excel for Beginners Accelerated Course
★★★★★
I wanted to give a good review to this course for those who are interested in learning the basics of excel. This course is inexpensive and although other courses say they have more lessons and more hours, the Leadership build excel course is great. The course starts off with just navigating excel and where to find things and then moves on to using spreadsheets and tables. In a short period of time I learned how to do basic formulas!!! That was my favorite lesson! I've taken other courses with Leadership Build and they do make great courses. Highly recommend.
- Judy

it's a good course - very beginner friendly

Excel for Beginners Accelerated Course
★★★★★
A good course for beginners to Excel
- A

Great content for the price

Excel for Beginners Accelerated Course
★★★★★
Overall the course is great. If you're looking to learn EVERYTHING about excel then this course is not for you since this course sticks to the excel basics
- Carla R.

got my certificate

Excel for Beginners Accelerated Course
★★★★★
my company made me do it but i got my certificate in 4 days
- Zak

Just what I needed

Excel for Beginners Accelerated Course
★★★★★
The course is shorter than other courses that I was looking for but this one is very organized and the practice exercises help me learn the content quickly and apply what I learned
- Jennifer
Close

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

Intermediate Excel Accelerated Course Overall rating: ★★★★★ 4.9 based on 81 reviews.
5 1

Best course for office employees

Intermediate Excel Accelerated Course
★★★★★
This course was recommended to me by my peer who took the Beginners course. I decided to buy the beginner and intermediate course and was very impressed by the videos, the practice sample exercises and how well the pacing is. I did have to look back at some videos but that's the beaty of online courses, you can always go back. I highly recommend the course
- Alex Cienfuegos

Ready for the advanced course

Intermediate Excel Accelerated Course
★★★★★
This course is not lengthy but covers so much in detail that I felt so blessed to have learned so much. This is exactly what I was looking for. I feel confident and prepared to take the advanced course
- Gemma Baxter

This is the only course our employees use

Intermediate Excel Accelerated Course
★★★★★
I came across Leadership Build courses by my counterpart in another state who used the course with his staff. We use the beginners course for new employees who need to get up to speed in Excel quickly. This course does the job. It's great that we can offer PD to employees at a good price and have them work on skills they'll need in the office anyways
- Kirestin Lopez

Great course to buy

Intermediate Excel Accelerated Course
★★★★★
This is a good course to learn more advanced excel stuff than just the basics.
- Edward Castro

The practice exercises and booklet are worth the cost

Intermediate Excel Accelerated Course
★★★★★
The practice exercises is something I really haven't seen in other online courses I have taken but they are SOOOO good because they allow me to practice the topics the instructor covers in the videos. The booklet came with the course and it's phenomenal - we use it at work all the time!
- Victoria Bishop

This course is better than it sounds

Intermediate Excel Accelerated Course
★★★★★
I honestly thought I was purchasing a condense version of an intermediate excel class but I was wrong! The course itself is organized in a great way and has tons of practice work that we can do. Not only do you get to watch videos and practice on your own but you also have access to the instructor. I actually emailed Allen (the instructor in the videos) to help me with a spreadsheet we keep screwing up at work. Overall,I 100% recommend this course
- Lael Bond

A+ Rating

Intermediate Excel Accelerated Course
★★★★★
Great course for the price
- Elliott Ballard

Loved the courses

Intermediate Excel Accelerated Course
★★★★★
I give the beginners excel course and the advanced excel course a 5 star rating - two thumbs up!
- Yuri Battle

Was hoping for more

Intermediate Excel Accelerated Course
★★★★☆
The course itself is great - learned a lot. I was hoping the course would cover vlookups and pivot tables but I was told that those topics are covered in the advanced class.
- Brandon Avery

Just the course I was looking for. Thanks Leadership Build

Intermediate Excel Accelerated Course
★★★★★
I was recently hired for a job that required Excel skills beyond the basics so I purchased this course to learn more things on Excel. I completed the course in a few days and got my certificate. This course saved my career lol
- Courtney Pace
Close