Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft Excel Essentials: Level 2 – For Intermediate/Advanced Students – From User To Superuser

THIS course will take your Excel skills to the next level! So, you have an understanding of the basics, but would you like to use Excel like theprofessional...
4.6
4.6/5
(94 reviews)
8,066 students
Created by

9.4

Classbaze Grade®

9.7

Freshness

8.5

Popularity

9.5

Material

Platform: Skillshare
Video: 9h 8m
Language: English
Next start: On Demand

Best Excel Advanced classes:

Classbaze Rating

Classbaze Grade®

9.4 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

9.7 / 10
This course was last updated on 7/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

8.5 / 10
We analyzed factors such as the rating (4.6/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.5 / 10
Video Score: 9.0 / 10
The course includes 9h 8m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 9 hours 08 minutes of 1 Excel Advanced courses on Skillshare.
Detail Score: 9.6 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 10.0 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
0 resource.
0 exercise.
0 tests or quizzes.

In this page

About the course

THIS course will take your Excel skills to the next level!

So, you have an understanding of the basics, but would you like to use Excel like the professionals? If so, read on…

For students who have already completed Level 1 in this series, or already have a good basic understanding of Excel, what you will learn in this course will supercharge your skills… and your career.

So, What’s inside?

  • Over 70 bite-sized lectures
  • 6 hours of quality content
  • All the source files for each project
  • Access to me (in case you have any questions)!

You will learn powerful and little known techniques to enable you to build your own powerful spreadsheet solutions. We will do this by creating multiple projects together, step-by-step, and in depth to guarantee your understanding. Each projects builds on the last, so your skills develop cumulatively.

You will learn how to combine multiple functions in a simple way to create powerful solutions that most users believe can’t be done in Excel!

Each project in the course is designed to introduce a range of concepts that showcase the true power of Excel, and show you what is really possible.

In project one:

  • The fastest way to create powerful dynamic templates (by cheating!)
  • Custom formatting
  • Manipulating calculations with time and dates
  • Conditional formatting
  • Simple and nested logical testing
  • Building complex and dynamic text strings
  • ActiveX controls (and how to customize them)

In project two:

  • Building a fully functional complex relational database
  • Masterclass in Vlookups (WAY beyond the basics here!)
  • Importing data from multiple sources
  • Controlling user entry

In project three:

  • Creating named ranges (and why you would want to)
  • Building dynamic named ranges
  • Getting Excel to create them for you!
  • powerful trick very few users know about!

In project four:

  • Hyperlinking (so it ALWAYS works!)
  • Creating Macros, and using them to automate your work!
  • Executing Macros from buttons
  • Dropdown lists
  • Building dynamic formulas using Excel’s Indirect function

Projects 5 and 6 coming soon!

This isn’t just a course with a bunch of formulas, it’s hands on guide through real life projects. You will learn how to build complex solutions using the very same methods I use. 

Become the Excel guru I know you can be, with the help of this course!

Enrol now, and I’ll see you in the course!

Alan

What can you learn from this course?

Together we will cover 5 specify projects in depth, each designed to build on the last, and showcase the full potential of Excel.

Here you will find all the files associated with the course. Download, and follow along!

What you need to start the course?

Basic knowledge of Excel is required to start this course, as this is an intermediate level course.

Who is this course is made for?

This course was made for intermediate-level students.

Are there coupons or discounts for Microsoft Excel Essentials: Level 2 - For Intermediate/Advanced Students - From User To Superuser ? What is the current price?

You can enrol in this course with a Skillshare subscription that costs $8/month, but you start with a FREE 7-day trial. You can also enrol in thousands of courses on a variety of topics with your subscription, including several Excel Advanced courses.

Will I be refunded if I'm not satisfied with the Microsoft Excel Essentials: Level 2 - For Intermediate/Advanced Students - From User To Superuser course?

There is no money-back guarantee with Skillshare, but you can start with a free one-week trial to learn without risk. With the subscription, you can download classes to your tablet or phone using the Skillshare app.

Are there any financial aid for this course?

At the moment we couldn't find any available scholarship forMicrosoft Excel Essentials: Level 2 - For Intermediate/Advanced Students - From User To Superuser, but you can access more than 30 thousand classes for $8/month on Skillshare, including this one!

Who will teach this course? Can I trust Alan Jarvis?

Alan Jarvis has created 9 courses that got 20,992 reviews which are generally positive. Alan Jarvis has taught 128,021 students and received a 4.5 average review out of 20,992 reviews. Depending on the information available, we think that Alan Jarvis is an instructor that you can trust.
Everything Is Easy, Once You Know How
Everything Is Easy, Once You Know How
Browse all courses by on Classbaze.

9.4

Classbaze Grade®

9.7

Freshness

8.5

Popularity

9.5

Material

Platform: Skillshare
Video: 9h 8m
Language: English
Next start: On Demand

Classbaze recommendations for you