Mastering Data Visualization Techniques in Excel
Sub Category
- Microsoft
{inAds}
Objectives
- Basics of Conditional formatting
- Kinds of conditional formatting
- Custom conditional formatting with formulas
- How to highlight lines that are "too long" with conditional formatting - a great example of how to use CF for quality control.
- How to build a search box with conditional formatting.
- How to calculate and highlight expiration dates - quickly highlight dates that are within 60 days, 30 days, or any time frame you need
- How to do zebra striping with conditional formatting
Pre Requisites
- Having Excel installed, any excel version will do
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)