We already work with business spreadsheets to Excel a few years ago. During all this time, we have had the opportunity to see thousands of spreadsheets developed by professionals who had a lot of Excel, amateurs who had some notion and people who had no intimacy with the program.
Invariably, even those who know how to do Excel end up being sloppy with the visual part of the spreadsheet, making the interaction and use of it much more complicated than it should be. See a testimonial (help request) found on the internet:
If you also want to make your spreadsheets look good, check out our new Free Ebook:
(Make worksheets much more beautiful and easy to use with it, just click on the image and download
Stop making spreadsheets like this:
or like this:
To make spreadsheets like this:
This is not a catch, this is a spreadsheet (our SWOT Analysis worksheet), done in Excel. But we apply all the techniques of Ebook to make her super beautiful and practical to use! See our other worksheet where we apply these tips:
See how you can improve (and much) the look of your spreadsheet? Just follow these
See the detailed tips that you will find in the Ebook:
- How to freeze panels (and avoid losing sight of your headers)
- Remove gridlines (to make your worksheet cleaner)
- Stir in columns and rows (avoid spending space on unnecessary things)
- Working edges (to have a well organized and presentable worksheet)
- Conditional Formatting (to highlight more important values, show variations between months)
- Lock up important cells (just let it be possible to tinker with what has to be filled)
- Adjust cell formatting (to have the right values in the right boxes: currency,%, etc)
- Data Validation (to work with drop-down lists and filters)
- Navigability / Usability (using hyperlinked menu for other tabs)
- Use of totals, subtotals (after all, doing calculations on the hand is not very smart)
Download the Ebook right now:
Be sure to share the Ebook, it's free!
If you find the ebook useful, take the opportunity to share it with friends and prospective ones, I bet you have friends who use Excel :).
I would also love to hear your opinion on the ebook, just comment here below!