How to make your spreadsheets more visually appealing

Excel tips to make your work look even greater

  • 30 November 2017
  • Author: Liam Phelan
  • Number of views: 4313

On the topics below you will find tips to make your Excel spreadsheets more visually appealing and easy to understand. Which come in handy if you are making a presentation or just sharing spreadsheets with your colleagues.  The tips are quite easy and simple to apply so take a sneak peek and master your next spreadsheet.  

Data Bars

If you need to communicate your number visually, graphs are always helpful. But why not try Data Bars which allow you display the numbers over visual representations of them.
To use Data Bars, select your data range, go to Home > Conditional Formatting > Data Bars, then select a colour scheme as per below.

Slice Data

Slicers are buttons that let you filter data easily. To use it you need to select any range in a table or PivotTable, and go to Insert > Slicer. Select the column you want to filter by. When you're done, you've got handy buttons that let you filter.

Easy way to create a chart

Just select any cell in your data range and press Alt+F1. The magic will happen, and you will have a graph to show your data.

Accessible templates

If design isn’t your strong point or you think it will just take too long to make your spreadsheet more presentable, you can always use the ready made templates.
In the excel Click File > New, and search for "accessible." Choose Accessible Template Sampler to see all the templates available for the Excel.
Once you have downloaded the spreadsheet you will see all the templates available and can choose one that suits your work. As you can see in the example below.

Instant PivotTables

Are you the kind of person that freaks out when hear the word PivotTable? If yes, this tool is for you, no pivot table knowledge required. By selecting the recommended PivotTable, the Excel will recommend the best option for your data range.
Go to Insert > Recommended PivotTables, select your data range, and choose the one that looks best.

Excel training at New Horizons Ireland

If you want to master your spreadsheets and save time in your work routine, check out our Excel courses. They were designed to help you in your daily work and make your life much easier.

Popular Excel courses

View all Excel courses

Complimentary Office Skills Assessment

Looking to find out what level of Excel, Word or PowerPoint you need to enrol in or simply looking to find out your level of expertise in Office? Well click the link below and take the test no, completely obligation free.

Free skills assessments for:

Subscribe for more!

Like our tips and tricks? Like to get your hands our latest keyboard shortcut cheat sheets? Or want to make sure you never miss our webinars and resources? Well subscribe to our Newsletter now!

Subscribe now

Please login or register to post comments.

Theme picker



Subscribe to our Newsletter

cheat sheet resources

Subscribe to our Newsletter for all the latest cheat sheets and resources.