Find the nearest zip code using Microsoft Excel

Microsoft Excel's “user defined functions” can perform many specialized tasks related to address and location information, such ...

How to calculate the most improved sales area with an array formula in Excel

This article will show you how to find the most perfect sales in four areas, very quickly, using the array formula in Excel. ...

Excel Macro Tips - Launch Excel Macro from Instant Access Window

In this article we will explain how to use the immediate access window in a VBA debugging environment. This environment can be used ...

Excel Tips - quickly find and hide all formulas on an Excel sheet

In this article today, I will show you an amazing way to quickly find all your formulas on an Excel sheet and hide them. The article...

How to calculate nutrition data using Excel or Open Office Calc

EU Directive 1169/2011 enters into full force on 13 December 2016. The first stage of this directive came into force in 2014 on Dece...

MS Excel Tips - Adding a Background Image to an Excel Worksheet

Most MS Office users will be familiar with using background images in MS Word and MS PowerPoint. Have you ever thought about using b...

Excel Macro Tip - Limit Scroll Area or Range Motion in Excel Sheet

In this article, we will look at how to limit the movement of a range or area that a user can scroll through in an Excel sheet. This...