As you may or may not know, there’s a yearly competition to determine which teenager is the best in the world at using Microsoft Office. That’s not a joke. It’s put on by a company that offers Office certifications. In any case, Lifehacker got in touch with some of the recent winners to learn some of their best Office tricks. Maybe you can learn a thing or two from them.
From the article:
MS Excel: Conditional Formatting
Excel 2016 champion John Dumoulin and Excel 2013 champion Anirudh Narayanan both recommend Conditional Formatting, which visualizes data characteristics through fill colors, text color, and mini-graphs. According to Dumoulin, “It can make your data look very enhanced and eye-catching.
“For example, if you had a table that displayed the sales for a company each month, you could apply conditional formatting to display the months with the highest sales in green, the months with the lowest in red, and the average sales months in yellow.”