This is a really cool Excel trick that can potentially save you a tonne of time. You are probably already familiar with the Find And Replace function in Excel used for straight forward finding or replacing text and numbers. This article will walk you through how to use the Find and Replace function to find cells formatted in a particular style, and then replace them all at once with new formatting.

The new Icons sets that arrived with the introduction of Excel 2007 conditional formatting functionality are really useful, and can really make you data display really pop by guiding the readers’ eyes directly to the data you want then to read. This tip I am going to show you is great if you only need to show 2 icons against your data. Let’s say for positive and negative numbers you want a green tick and red cross respectively.

I love this feature in Excel. Being able to monitor numerous cell values and see them change from anywhere on your Excel work book- even different work sheets. So when cells are not visible on a worksheet that you are in you can still monitor them and their changing values making it really convenient to inspect, audit, or confirm formula changes. So by using the Watch Window, you don’t need to repeatedly scroll or go to different parts of your work book to see changes. This article will walk you through a simple example to demonstrate the power of this feature in Excel.

If you have a calculated field in your Excel Pivot Table then you may well come across the dreaded #DIV/0! error, which just means that you are attempting to divide a number by zero. There is a really simple way to avoid this error. This article will work through an example to demonstrate the formula to use to return another value in replace of this error.

There is no job too small and no customer more significant than any other when it comes to running a successful business in today’s economy. Yes, you will have your VIPs and repeatedly loyal customers, but valuing every dollar invested or spent on your company is part of outstanding customer service.

Nowadays, people choose to say it with videos rather than flowers and cards. A short 2-5 minute video presents a kaleidoscope of emotions, conveying the message effectively. However, creating a video slideshow can be a bit of a task if you are not a very tech-savvy person. Adding photos and animation effects can be more work than you expected it to be.

Have you ever wanted to fly a big airline plane or helicopter? Well, now you can using a flight simulator. Today’s improvements of computer graphics make flying simulators so very realistic that it becomes very addictive for those who play with them. There are even computer flight simulators that are so good that they are officially used for the training of real pilots. Discover how you too can have fun with flying simulators on your computer and at the same time become a skilled pilot..

In this article we will look at how to sum only positive numbers in an Excel data set. By using the SUMIF function we can calculate only the sales of goods whilst ignoring any returns that are in the data set which are represented by negative numbers.

Once your business web application or website is developed, it is time to go for a thorough testing to check whether the site works well on different devices having different screen sizes or not. This task can be time consuming if there is no access to additional tools.

I have recently been working on a spreadsheet solution based very much on Pivot Tables and a good deal of Slicers to enable an easy of drilll down into the data. If you have been using any version of Excel from Microsoft Excel 2010 onwards, then you probably have already used slicers to navigate around the data in your Pivot Tables. In this article I will show you how to reset all of the Slicers in a Work sheet using some simple VBA code and a command button.

This article will show your how to use the OFFSET formula in Excel to always return the latest 3 months sales values in your data set. Even when you add more and more data into your data, it will automatically return the last 3 months sales values without having to update your formula.

By default, Excel will update any changes you make to a work book automatically, and therefore you will see any results of updated calculations of formulas straight away. So that in theory is great as our Excel formulas will always be up to date. It may on some circumstances be better to have the choice when you want your calculations to update. This article will take you through how to turn manual calculations on or off and these options to the Quick Access toolbar.