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.
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.
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.
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
Data input
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.
Data processing
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.
Data presentation
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.
What all does this course include?
You'll have access to all these benefits once you enroll in this free course, Excel Essentials
Short lessons for a quick understanding
Personalized feedback on assignment
Course Certificate on approval of assignment
Earn a Skill Badge on approval of assignment
Link to add certificate to your LinkedIn profile
Invitations to upcoming webinars
Discussion forum for clarifying doubts
Downloadable worksheets for practice
Course Curriculum
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.
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.
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
Reviews
5
Top Rated
Ankita Bansal
Thank you!
Very helpful course.
Atiqa Azan
Good
Thank you for providing this lesson!
Jazelle Jade Lama
New knowledge
Helpful
SUPRIYA SINGH
thank you
very helpful
Shakya Bhowmik
Very nice course
Very useful
BATTU NAGA JYOTHI
Genuine Course
Very Useful
Rate this course