I’ve emphasized before that the key behind Visual Design is that every formatting decision you make should have a purpose behind it. In the following post, I plan to demonstrate more of the visual style I use in Excel. These formatting techniques still do have justifications behind them, but there are no hard and fast ...
Visual Design is a concept that many people don’t think about when using Excel. However, given how much Excel’s visual display capabilities have improved over the years, the concept is becoming more and more important. There are a number of great books on Visual Design and they all have very similar themes. The following post is ...
Pasting chart formats is an Excel function that’s somewhat un-intuitive to find and therefore underutilized. One of the main reasons that people don’t bother improving the formatting of their charts is because of the time it takes to make these adjustments. By using the paste format function for your charts, you can save yourself time ...
Because it’s buried deep in the cell formatting menu and has very little documentation, Excel’s custom number formatting is probably its most underutilized feature. Understanding and mastering this feature can greatly enhance the Visual Design of your Excel workbooks. The key benefit of custom number formatting is: It allows you to change the appearance of your ...