Excel tutorials, functions and advanced formula examples, page 32

Meet the new Ultimate Suite release

Change of the seasons is my favourite time for letting you know about the improvements we bring to Ultimate Suite. Here at AbleBits we’ve been testing and enhancing the tools you use daily. Today, we’re making the updates available to you! Continue reading

How to remove all blank rows in Excel

In this quick tip I will explain why deleting Excel rows via select blank cells -> delete row is not a good idea and show you 3 quick and correct ways to remove blank rows without destroying your data. All solutions work in Excel 2016, 2013 and lower. Continue reading

How to export Outlook contacts to Excel

In this article I will show how you can quickly export contacts from Outlook 2013, 2010, 2007 and 2003 to an Excel spreadsheet. First I will explain how to use the build-in Outlook Import / Export function, and after that we will create a custom contacts view and copy / paste it to an Excel file. Continue reading

How to merge two Excel Worksheets by partial cell match

This article will show you how to quickly merge data from two Excel tables when there are no exact matches in your key columns, e.g. your unique ID in the first table may make up the first five characters of the ID column in your second table. I have tested all the solutions I present in this article, they work in Excel 2016-2007. Continue reading

How to create / update a table of contents in Microsoft Word

If you are a document writer, this article will be very useful for you. You will learn how to insert a table of contents into your document, modify and update it just in a few clicks. Also, I’ll show you how to make your document look good using Word’s built-in heading styles and the multilevel list option. Continue reading