bookmate game
Michael Alexander

Excel Dashboards and Reports For Dummies

Notify me when the book’s added
To read this book, upload an EPUB or FB2 file to Bookmate. How do I upload a book?
  • herawan19has quoted8 years ago
    the concept of lines is used to indicate time — consider timelines, family lines, bloodlines, and so on
  • herawan19has quoted8 years ago
    Line charts are the kings of trending
  • herawan19has quoted8 years ago
    Icons and shapes do a much better job at conveying your
  • herawan19has quoted8 years ago
    possible, consider using modern-looking fonts such as Calibri and Segoe UI in your reports and dashboards
  • herawan19has quoted8 years ago
    Figure 3-7: Use number formatting to eliminate clutter in your table and draw attention to key metrics
  • herawan19has quoted8 years ago
    Try to use the natural white space between the columns to partition sections. If borders are necessary, format them to lighter hues than your data; light grays are typically ideal
  • herawan19has quoted8 years ago
    Figure 3-4: Minimize the use of borders and use the single accounting underlines to accent the column headers
  • herawan19has quoted8 years ago
    You should always endeavor to de-emphasize borders and gridlines wherever you can
  • herawan19has quoted8 years ago
    borders get in the way of quickly reading the data in a table. Because borders help separate data in nicely partitioned sections, this may seem counterintuitive, but the reality is that a table’s borders are the first thing your eyes see when you look at a table
  • herawan19has quoted8 years ago
    Use effective number formatting to avoid inundating your table with too much ink.
    Subdue your labels and headers
fb2epub
Drag & drop your files (not more than 5 at once)