HomeHome SearchSearch MenuMenu Our productsOur products

Do you use Excel spreadsheets? Use these seven tips to make your spreadsheets more professional and pleasing to the eye

by , 24 March 2014
Excel spreadsheets have totally changed the 'accounting game'. Not only do they allow you to analyse data, but they also make reporting data easier. But that's not all to Excel spreadsheets. Continue reading to find out seven tips you can use to make your spreadsheets more professional and pleasing to the eye.

Why you need to create 'stylish' Excel spreadsheets

Style applies to Excel spreadsheets as well.

Tech Republic says that most Excel users would probably agree that the programme is a Godsend when it comes to creating spreadsheets, yet the results can often be boring to look at.

The site says that 'thankfully, Excel also provides the tools to make your spreadsheets look polished, professional, and pleasing to the eye.'

This is important because if your spreadsheet is presentable this helps you communicate results effectively and also reduces errors.

So how do you do this?


*************

Do you know why Gail doesn't spend R10 000 a month on bookkeeping fees?

Gail is a GP who's just opened her own private practice. Because she's trying to save money on admin costs, she is doing her books herself. She thinks: 'How hard can it be?' The answer: 'It's very hard unless you've got the right tools at your fingertips!' Well, I found just such a tool. It has everything from checklists about how to prepare for an audit, to detailed explanations about financial statements. Find out more about my newly-discovered one-stop accountancy resource!

*************

Apply these seven tips to make your spreadsheets more professional and pleasing to the eye

Tech Republic outlines seven tips you can use to make your spreadsheets more professional and pleasing to the eye:

#1:  Choose the right font

Choosing a clear, readable font such as Arial or Calibri is a simple first step towards creating an attractive, business-like spreadsheet.

#2: Limit use of different fonts

Two different font styles can help to differentiate between headers and main text. More than two, however, can be distracting.

#3: Center your title

Use the 'Merge Cells' or 'Center Across Selection' options to create a professional, centered title for your spreadsheet.

#4: Start in b2

Leaving row 1 and column A blank is an easy way to create some space in your document.

#5: Bold your headers

Headers that stand out from the main text can help to make your spreadsheet easier to read. Bolding them is a quick and easy way to do this.

#6: Vary your font sizes

Using a larger font size for headings and sub-headings makes for a more readable spreadsheet. It's also a good idea to keep your basic font size large enough to read clearly.

#7: Play with grid lines

All those lines separating all those numbers can look very confusing. By opting to show only the lines around your results column, for example, you can make a big difference to the readability of your Excel spreadsheet.

Well there you have it. Don't overlook formatting when it comes to Excel spreadsheets. Using these tips will go a long way in ensuring that your Excel spreadsheets are more professional and pleasing to the eye. This will in turn help you communicate results effectively and reduce errors.



Related articles




Related articles



Related Products



Comments
0 comments


Recommended for You 

  Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance



Here are all the most interesting, thought-provoking and common tax questions
asked by our subscribers over the last tax year – everything from A to Z!

To download Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance click here now >>>
  Employees always sick? How to stop it today



Make sure you develop a leave policy to regulate sick leave in your company.

BONUS! You'll find an example of the leave policy and procedure in this report.

To download Employees always sick? How to stop it today click here now >>>
  Absenteeism: Little known ways to reduce absenteeism



This FREE e-report will tell you how you can reduce absenteeism in your workplace while avoiding the CCMA and without infringing your employees' labour rights.

To download Absenteeism: Little known ways to reduce absenteeism click here now >>>
  7 Health & safety strategies to save you thousands



Don't let a health and safety incident cost you one more cent. Implement these seven
strategies in your company today.

To download 7 Health & safety strategies to save you thousands click here now >>>