The Excel Blog
Excel Blog
CHAR(10)
Column Headings
The CHAR(10) function together with CONCATENATION will allow you to manage the presentation of your column headings
- Justified Column Titles
- Stop fiddling with column widths
Excel Blog
No more MERGE!
Avoid the MERGE
Merged Cells can cause irritation when the user is transposing large amounts of data from source to destination.
- Use Excel Formatting
- Avoid the Paste issues
Excel Blog
Print Preview
Toolbar Tip
Print Preview was such a useful feature for showing how data would be displayed across multiple pages, and then it disappeared??
- Restore to the toolbar
- Step-by-Step Guide
Excel Blog
Using Excel Tables and how to create one.
Excel Tables
Excel tables are very dynamic allowing you to save time editing new information as your data requirements grows bigger, therefore giving you time to focus on what is important!
- Creating excel table from a range
- Some benefits of using excel tables
Excel Blog
How to Create Corporate Colours in a Dashboard
Tips & Tricks
This blog will help you incorporate the colours your company uses in it's marketing style guides in to your dashboards, so the output of your analysis can be more readily published in both internally and externally corporate branded publications.
- A step by step guide