Monday, July 13, 2020

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...

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...

Formula-free super quick maths

Normally in Excel, if you want to do some calculations on values in a cell or range of cells, then it's fairly easy to...

Use Advanced Filter to Remove Duplicates from your Database in Excel

I love databases. It's true. I'm a secret geek and I love finding new ways of working with Excel and making it do things...

Why is my CSV file saving as a SLYK file and...

This is a problem that we have recently encountered in our work and it took us a good while to find the solution. Now...

Part II: What is Page Layout View and How do I...

If you're using an Excel spreadsheet that contains a large amount of data or many columns, it can sometimes be difficult to adjust the...

Understand Numeric and Special Formatting in Excel 2013

Excel 2013 has a wealth of numeric formatting options which gives users the ability to perform number-crunching easily. In fact, Excel is designed to...

Use Format Painter to Quickly Copy Conditional Formatting in Microsoft Excel

Conditional formatting is a handy tool in Excel that can help you to add visual highlights to data to identify trends, highlight errors or...

Painlessly extracting the data you need from a database – Part...

In our previous article, we looked at using the Advanced Filter function of Excel to copy certain records from one database to another using...

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