Excel Essentials

Dependent dropdowns or lists, return values for a range using VLOOKUP, automated Gantt charts

What will you learn in this course?

In this course, you will learn three advanced concepts. These will help you save considerable time each time you work in these areas.

An icon showing the number 1

Dependent lists 

If you work in a collaborative environment, there is a possibility that your colleagues add data in shared Excel sheets basis their preference (e.g. full name vs. initials), leading to huge data inconsistency.

Learn how to resolve that using dependent dropdown or lists.

An icon showing the number 2

VLOOKUP for ranges

If you need to evaluate multiple conditions and end up writing long and confusing nested IF formulas.

It becomes an even bigger challenge if you are required to update those formulas. You can make it easier using VLOOKUP with approximate match.

An icon showing the number 3

Gantt charts

If you create project plans in Excel, you could be spending significant time coloring cells to indicate the duration of each activity.

Automated Gantt charts can avoid this including the effort required for each time the project timelines are revised.

How will this course help you?

In 15 minutes, you will learn how to addresses three key challenges that we face in the three phases of data flow

One of the most robust ways to improve data consistency is by using drop-downs or lists for data input.

Creating a dropdown in Excel is very simple. However, creating a dependent drop-down list, where the content of the dependent list is based on the value of the parent list can be confusing.

You will learn a simple method on how to create a dependent dropdown list and reduce your data consistency woes.

VLOOKUP formula is used extensively for finding data from large tables based on a known value.

One of the most under-utilized uses of VLOOKUP is to return values for data ranges. Example: Offer 5% discount if the sale is between 10 to 50 units, or 7% discount if the sale is between 51 to 100 units, etc.

You will learn how to return values based on such data ranges. This not only makes it easy to write formulas where you need to evaluate multiple conditions but also very easy to modify them if required.

Creating detailed project plans can be very time-consuming. And updating them at the end of every review or meeting can be even more frustrating.

You will learn a simple technique to create project plans or Gantt charts using conditional formatting. It will update the cell colours indicating the timeline information automatically as you update the start and end date for an activity.

A young man wearing headphones and looking at a laptop with focus

What all does this course include?

You'll have access to all these benefits once you enroll in this free course, Excel Essentials

An icon of a laptop

Short lessons for a quick understanding

An icon of a clipboard

Personalized feedback on assignment

An icon of a certificate

Course Certificate on approval of assignment

An icon of a badge

Earn a Skill Badge on approval of assignment

An icon of LinkedIn

Link to add certificate to your LinkedIn profile

An icon of a calendar

Invitations to upcoming webinars

An icon of chat sign

Discussion forum for clarifying doubts

An icon of downloading a file

Downloadable worksheets for practice

Course Curriculum

Reviews

5

Top Rated
  • 5 100%
  • 4
  • 3
  • 2
  • 1
SUPRIYA SINGH

thank you

very helpful

10 months ago
Shakya Bhowmik

Very nice course

Very useful

11 months ago
BATTU NAGA JYOTHI

Genuine Course

Very Useful

1 year ago
Niccole Angelika Santos

Thank you!

I still got a long way to go to become an Excel expert but this is a start! Thank you so much, this was definitely useful in my reporting.

1 year ago
Subashini selvaraj

very useful for learning excel

excellent

1 year ago
Shanmukha Sai Charan kotte

very helpful website for learning

nice website

1 year ago
See more reviews

Take the course on our complements

We are offering this course for free. You can learn these three advanced methods and save considerable time each time you work on these areas.

Thumbnail for Excel Essentials with a girl holding a laptop in one hand

Excel Essentials

Dependent dropdowns or lists, return values for a range using VLOOKUP, automated Gantt charts


  • Get immediate access
  • No credit card required
  • Assignment included
  • Certificate & badge

Take the course on our complements

We are offering this course for free. You can learn these three advanced methods and save considerable time each time you work on these areas.

Thumbnail for Excel Essentials with a girl holding a laptop in one hand

Excel Essentials

Dependent dropdowns or lists, return values for a range using VLOOKUP, automated Gantt charts


  • Get immediate access
  • No credit card required
  • Assignment included
  • Certificate & badge

Music Credit: bensound.com