Microsoft Office Tutorials and References
In Depth Information
Enhancing Reporting with Custom Number Formatting
Figure 2-9: Before and after applying table design principles.
Although it may seem like a mere matter of taste, font type has a subtle but tangible
impact on your tables. Outdated or inappropriate fonts will cause your audience to
focus on the fonts rather than the data in your table. Using fonts like Comic Sans may
seem cute, but they’re rarely appropriate for a report. Older fonts like Times New Roman
or Arial can make your reports look old. It may seem strange, but fonts with straight
edges and fancy strokes now look old compared to the rounded edges of the more
popular fonts being used. This change in font perception is primarily driven by popular
online sites, which often use fonts with rounded edges. If possible, consider using
modern-looking fonts like Calibri and Segoe UI in your reports and dashboard.
Enhancing Reporting with Custom
You can apply number formatting to cells several ways. Most people utilize the convenient Number
commands found on the Home tab. Using these commands, you can quickly apply some default
formatting (such as number, percent, and currency) and just be done with it. But a better way is to
utilize the Format Cells dialog box, where you can create your own custom number formatting.