Home Tags Excel

Tag: Excel

How to create a drop down menu in Excel using data...

In a previous article we showed you how to create useful data sets with data validation, however in this walkthrough we are going to show you...

Use mail merge to create personalised invitations in Publisher

This is a nifty trick that I have learnt recently when helping a friend with their invitations to their parents Ruby wedding anniversary.It was...

Your quick and easy template for bulk uploading to Hootsuite

Hootsuite is a popular choice for managing small business social media accounts. It's an excellent time saving option, especially if we are posting on...

How to create a double axis graph in Excel

Microsoft Excel’s chart functions help readers quickly visualise information and see insights buried within sheets of endless data. They can include bar charts, line...

How to analyse sales performance using conditional formatting in Microsoft Excel...

 Conditional formatting is a useful tool that formats your Excel data based upon certain criteria or conditions that you have set in Excel 2013....

Using the ‘SUM’ Function in Excel

The formulas available to you in Excel are the reasons why most most of us love it, or are incredibly scared of it! But if...

A Fast and Easy Way to Separate Data

If you're an Excel user, chances are that at some point in your life, you have come across a spreadsheet stacked full of data...

Mail Merging Made Easy – with Microsoft Word and Excel

The mail merge function of Microsoft Word is arguably one of its most useful features. It is a simple way of personalising a template...

Software Review – ASAP Utilities

Whether you are an Excel power user or not you will find this addin a huge time saver and provide functionality to your spread...

Excel – Create Useful Datasets with Data Validation

If you have had experience in using Excel to create databases of information, it’s quite possible that at one time or another you have...

DON'T MISS