Ever tried to create a formula with a condition but could not? Perhaps you intend to have different answers depending on the status (true or false) of the condition? The answer to your problem is the IF function. The IF function is one of Excel’s most useful and most used functions. What it does, basically, […]

Continue reading

 If you have 90 days to settle an account, and would like to know if a given date is within 90 days of today’s date, you can use a combination of the TODAY() date function and the IF() function. This will enable you to check if a given date is within 90 days of, well, […]

Continue reading

If you have plotted a graph and want to change the scale of the vertical axis to suit your needs, MS Excel allows you to customize the vertical axis. By default, Microsoft Office Excel determines the minimum and maximum scale values of the vertical (value) axis. The y axis is usually the vertical axis and […]

Continue reading

The GETPIVOTDATA function returns data stored in a PivotTable report. You can use GETPIVOTDATA to retrieve summary data from a PivotTable report, provided the summary data is visible in the report. You can quickly enter a simple GETPIVOTDATA formula by typing = in the cell you want to return the value to and then clicking […]

Continue reading

This is a list of the top 10 Excel Tips & Tricks of 2012 based on number of views by you! This list is made up of the Excel tips you and our other readers found the most interesting & useful in 2012. Top of the list is: 1. How to create a shared workbook […]

Continue reading

If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. After you […]

Continue reading

Are you looking for an easy and yet effective method of removing hyperlinks from you worksheet? By using Visual Basic for Excel the following code will remove all hyperlinks from the worksheet. Visual Basic Coding: Sub RemoveHyperlinks() Activesheet.Hyperlinks.Delete End Sub Sometimes a copy and paste of internet based materials can also bring across embedded hyperlinks. […]

Continue reading

Ever tried to sort data based on the Month field in chronological order and not alphabetical? It can be frustrating but we have a solution for you. By sorting based on the custom sort order the data can be sorted in chronological order and not alphabetical. Below we explain how. Applies To: MS Excel 2003, […]

Continue reading

Some spread sheets can get very complicated, with many cells relying on other cell calculations to deliver information and a change of one cell can have dramatic effects. Formula Auditing will show you which cells are connected. In the example below we are going to use the screen shot below to trace cells that are […]

Continue reading

By using the DSUM function, you can specify criteria and conditions regarding which cells should be added together. The DSUM Function differs from the SUM function in that it lets you specify one or more criteria which act as data filters.  In the example below we calculate the total Filo Mix sales for the Month […]

Continue reading