Save time and improve your reporting skills with these important tips.

The problem with a list of hundreds of shortcut keys is that it is overwhelming. You cannot possibly absorb 233 new shortcut keys and start using them. The

Structured references make it much easier and more intuitive to work with table data when you are using formulas that reference a table, either portions of a table or the entire table. They are...

Bullet graphs were invented by Stephen Few to improve upon standard bar charts and gauges.  Instead of just showing the one value, you can compare that value

At times you may want to select the cells that have specified type of data in it, by which you can distinguish between cells that contain different types of data, which allows you to delete, fill or...

MS Excel is the best available software for calculations and sorting out data into rows and columns. You can use these tips and tricks to make your Excel

VLOOKUP MATCH is one of several possible lookup formulas within Microsoft Excel. This tutorial assumes you already have a decent understanding of how to use VLOOKUP. If you do not, please click here...

The main benefit of connecting to external data from Microsoft Excel is that you can periodically analyze this data in Excel without repeatedly copying the data, which is an operation that can be...

Do you need to insert the page numbers in printed workbook as well as author name, current date and file name? The Microsoft Excel's Header/Footer command can

Tables began as lists in the menu version of Excel, but they've become more powerful in the Ribbon versions. Converting a data range into a table extends

We can achieve this result using two methods...

Excel support services will receive scores of different questions each and every day. The range of the questions definitely covers a lot of ground. Among the

We are often asked by Microsoft Office power users whether, why, and when they should use Microsoft Access versus Microsoft Excel. Especially when they are very comfortable using MS Excel and don't...

Today let's learn how to generate unique usernames in Excel, even when you have duplicates in your data.

Today we will learn about Workbook Events and Procedures

Excel puts lots of great tools on your desktop, but what each one of them does isn't always obvious, especially since so many Excel features are hidden.

Excel smart tags help to recognize specific data and then the smart tags help in providing action to those data that are being recognized. There is a button

In this article, I plan to show you how powerful formulas and conditional formatting can be, with three pretty useful examples.

Microsoft Word does not have an automatic feature to count the number of rows in a table; however, you can create a simple macro to return these values

If your intent is to someday become an Excel power user, you will need a solid understanding of all the lookup formulas available to you. Below is list of the most popular Excel lookup formulas with...