The Journal

Google Apps: Applying Conditional Formatting Across Sheets

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...
Hosted on MSN

Prove Your Real-World Microsoft Excel Skills With the How-To Geek Test (Advanced)

Whether you've recently taken a Microsoft Excel course or you want to check that you're up-to-date with the program's latest capabilities, take the How-To Geek Advanced Excel Test and see how you fare ...
TechRepublic

How to use conditional formatting to highlight rank in Microsoft Excel

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight the top ...
Geeky Gadgets

Build an Excel calendar interactive dashboard that updates itself automatically

Creating a dynamic and interactive Excel calendar that updates automatically can significantly enhance your productivity and streamline your scheduling process. This excellent tutorial by My Online ...