We all use Excel Spreadsheet and Microsoft Word document every time and we use ...

An Excel Joke to Start Off… Did you hear about the database developer that ...

And we’re back… We took a brief hiatus for the holiday season here in ...

Isn’t it just frustrating to receive a copy-paste summary table that requires analysis? Yes, ...

We all know that VBA allows us to create Macros in Microsoft Excel which ...

We all know that for some problems, Protect Sheet tool under the REVIEW tab ...

Hello All! We all are aware that VLOOKUP allows us to find the intersecting ...

Troubleshooting Excel workbooks of others can be mind-numbing, if not excruciating. There are various ...

We all love Excel and looks like there is no need any introduction for ...

Excel MVP Jordan is continuing the Excel VBA Coding tips. While coding comments play ...

In many situations, particularly when it comes to inventory management, there is a need ...

Microsoft Excel allows us to show any complex data in an easy way. You ...

We all know that Excel Ribbon has tabs like Home, Data, review, Insert and ...

Excel makes it possible for simple buy / not-buy or do / not-do financial ...

As frequent Excel users, we know the importance of absolute and relative references. On ...

Analyzing and parsing data in Excel is really a tedious task. If it is ...

Did you know you can indicate whether the user of your file is putting ...

Microsoft launched PowerPivot as a separate add-in for Excel 2010. And since then it ...

Many times we are in need of random data. Suppose, if you are doing ...

Excel Tables arranges data in a structured way in rows and columns. When you ...

Sometimes we have analyze or sort through data all of which is in a ...

Have you ever faced problems while making copy of buttons in Excel? We normally ...

When dealing with a small but complex set of calculations, it is very tempting ...

In this universe of crowded excel shortcuts, let me share with you five less-known ...

People who work with PowerPivot a lot know the importance of dates to analytics. ...

Microsoft Excel allows you to create the form with radio buttons, text boxes, check ...

Have you ever thought to change text color and font in Excel? Till now, ...

Let’s say we just got handed a report in Excel and have been asked ...

In high-pressured meetings with Chief Executives, no one would want to be seen as ...

What if there is a way to define new formulas in Excel without using ...

There might be times when you need to shuffle a list of distinct items. ...

Most, if not all, pieces of analyses in Excel employ the IF function numerous ...

We all know that VLOOKUP works to the right (of the column with the ...

  Done with your analysis and now you want to move your data somewhere ...

We all are aware of the basic methods of referencing worksheets in our VBA ...

One of the benefits of being Bill Jelen (Mr Excel) is that people send ...

Using Ampersand Formula In ExcelExcel MVP Jordan Goldmeier notes that although this quick tip ...

Given a rich data set, making pivot tables and charts is amongst the first ...

There are times when there is a need to cut down on the available ...

Have you ever tried to form a band but found it difficult to figure ...

Tired of googling how to convert inches into meters or how many liters a ...

In the post-apocalyptic world, can you visualize how much time would you have before ...

This doesn’t have to be difficult. It doesn’t have to be hard. No need ...

Most of you must be familiar with Solver. It’s a built-in tool in Excel ...

After having written thousands of lines of codes over multiple sheets or modules, it ...

Have you ever wondered how to sort lists using 2nd word in each cell? ...

Not long ago, Microsoft had an update to Excel that broke a lot of ...

Oz du Soleil experiments with how to visualize music in Excel.  To do this, ...

Are you converting your measurements like a chump? This happens all the time. You ...

Can I use Exclusive OR function XOR?This is a new function is Excel 2013. ...

There are some tips on the show that seem to take on a life ...

Nick Green of http://EchoXL.com shows you how he uses conditional formatting to create a ...

So here is the problem.  You, your Momma and your sister all made separate ...