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
