If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

This Excel 2013 Cheat Sheet from CustomGuide covers program fundamentals, as well as essential keyboard shortcuts for navigation, editing and formatting that can make your work go even faster. Excel ...

Excel isn’t the sexiest application in the world—it has an unfortunate association with the type of Milton-esque office drones we all wish we weren’t. All the same, you’re going to have to use at some ...

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...

Conditional Formatting in Excel can be considered a valuable utility that can help visually enhance the data analysis and presentation in the spreadsheet by applying particular formatting based on pre ...

The Today() function represents the current date in Microsoft Excel. If you type the =Today() function in any cell and press Enter, Excel will show you the current date. Therefore, this method is used ...

Formatting every other row is easily accomplished using conditional formatting. Fortunately, conditional formatting can handle something more specific, formatting every even or odd row. Many users ...

Later, we'll add an IF() function that returns a subtotal for each day. How to calculate conditional subtotals in an Excel revenue sheet Your email has been sent Adding a condition to a simple revenue ...