Sunday, February 28, 2021

How to: Word counts in Excel

Ever needed to know the word count of text in a certain cell in Excel? It's not something that you would need know often,...

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

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

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

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

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

How to calculate the difference between two dates in Excel

There might be a number of reasons why it would be handy to be able to calculate the difference between two dates in Excel...

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

How Do I Produce A Graph From A Table In Excel?

A frequently asked question by many of our readers, so we thought we'd tackle this little task first, and show you how to make...

Add a calculator into Microsoft Excel

Microsoft Excel has lots of little hidden tips, tricks and add-ons that many people don't know about, and it's my mission to make these...

DON'T MISS