A countdown of our top five Excel Tips & Tricks in 2013

Happy New Year! We hope that you had a fantastic festive season!

Before we get into this year’s Microsoft® Excel® tips and tricks, we’ve compiled a list of our five most popular ones in 2013. In total, these tips received over 14 000 views – thank you for taking the time to read and make use of them!

Here’s a countdown of our top five …

#5: How to Extract Text from a Text String Using the MID and FIND Functions

If you would like to separate data that is in one column into two columns, you can do this by using the MID and FIND functions …read on

#4: How to Prevent Data Duplication In a Microsoft Excel Worksheet  

Data duplication in Excel can lead to a host of irregularities. In this tip we explain how you can prevent duplicate data capturing using custom data validation…read on

#3: How to Use the Excel PMT Function to Calculate the Monthly Repayment on a Loan

The Excel PMT (payment) Function is a really simple but highly useful Financial Function for calculating the repayment amount on a loan…read on

#2: Minimize Date Entry Error by Using a Calendar Drop Down List

Ensuring data integrity by limiting date entry errors in an Excel worksheet can easily be achieved by adding a calendar drop down list…read on

Our most read tip in 2013 was…

#1: Calculating Multiple Conditions in a Formula With The Nested IF Statement

The Nested IF statement enables one to calculate multiple conditions in a formula, as a result more elaborate tests of data can be constructed…read on