In 15 minutes, you will learn how to addresses three key challenges that we face in the three phases of data flow:
How will this course benefit you?
In this course, you will learn tricks for each of these problems. These will help you save considerable time each time you work on these areas.
Data Input:
One of the most robust ways to improve data consistency is by using dropdowns 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.
And all of this, in about 15 minutes!
Short lessons for a quick understanding
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 to clarify doubts from our experts
Downloadable worksheets to practice along
Music Credit: bensound.com
Reviews
5
Top Rated
Subashini selvaraj
very useful for learning excel
excellent
Shanmukha Sai Charan kotte
very helpful website for learning
nice website
Azad Prajapati
VERY NICE COURSE
SUPER
Anjali sharma
Awesome website
Very helpful website for learning and thank you for the help
Sana Mulla
Amazing
Amazing
Tanmoy Sen
Just awesome!!
Awesome website to learn and great support from the team.
Rate this course