Microsoft Excel is a powerful database management tool with all sorts of in-depth problem-solving functions and dynamic formatting. To make the most of it, though, you need to know the basics. Using ...

Bar graphs are graphical representations of statistical data in the form of strips or bars. This allows viewers to understand the difference between the various parameters of the data at a glance ...

For many small business owners, Microsoft Excel is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare documents for distribution to partners or ...

Comparing two columns in Excel doesn’t have to be a difficult task, and to get the job done, we suggest using VLOOKUP. You see, not always; the columns you want to compare are in the same workbook or ...

An icon in the shape of a lightning bolt. Impact Link Excel is a great program with hundreds of helpful functions. Unfortunately, one function it's lacking is a simple way to merge two or more columns ...

We show you how to hide and unhide rows and columns in Excel using the mouse, hotkeys, the toolbar and how you can deal with hidden rows on the top of your table. The ability to hide and unhide rows ...

When you create a spreadsheet you might want to change the column width to accommodate the length of text in the column. In a previous tip I showed you two ways to do this. Using either way to change ...

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...

When you add text to a cell in your business spreadsheet, that cell will not widen automatically to accommodate your text unless you change a few settings. This behavior can be frustrating when you ...

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically. Freezing a column in Excel makes that pane visible while you scroll to other ...

If you’ve ever worked with an enormous Excel spreadsheet, you’ll know just how daunting all those rows and columns can be. Once you’re over 10 or 15 different values and labels, it can get pretty ...