Excel Challenge #1: Conditional Formatting
Level: Essential Skills, Estimated Completion Time: Under 5 minutes
Sample File
To save you time typing in the data you can download this sample file that has the starting-point for the challenge:
Watch the Challenge Video
If you'd rather read than watch...
If you are a teacher with a class to test you’ll want to download the challenge description as a printable PDF file and print out a copy for each student.
Attempt the challenge before watching the solution video
If you have difficulties completing the challenge (or if you want to use our challenges as a learning resource in themselves) we’ve create a professional narrated 26-minute challenge solution video tutorial that fully explains each step needed to complete this challenge. You should only watch the solution video if you have difficulty completing the challenge.
If you do need to work through the challenge solution video tutorial try the challenge again afterwards and keep trying until you can complete it without referring to the video.
Watch the Challenge Solution Video
Free Solution Video Preview
Get the full Video Solution for $2.99
For the price of a cup of coffee you can view the entire 26-minute video tutorial (as many times as you want to) and download the solution workbook used in the solution video.
seemingly I am failing to visualize the budget to make the budget charts
The Data Bar Visualization used in the solution is fully explained in our Essential Skills course, or you see how the whole challenge is solved in the challenge solution video.