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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

When I teach how to develop dashboards in Excel, I'm often asked if the ...

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

Imagine a situation where in you applied some border, changed font color, did something ...

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

Until the end of September, Chandoo and I will be offering a free, one-hour ...

Read More

It’s finally done! That’s right: the entire manuscript is done and in production. It’s ...

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

Splitting Names From Suffixes Data cleansing and prep can come to you in any ...

Read More

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

Read More

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

Read More

The theme colors for Excel 2013 are probably the best scheme to date. However, ...

Read More

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

Read More

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

Read More

When I first started this blog, I thought to myself: VBA is wonderful and ...

Read More

Hello everyone. I’m a little late getting out my holiday card. Unfortunately, it’s not ...

Read More

Hello everyone! I’m releasing chapter 3 from my new book, Advanced Excel Essentials, for free! ...

Read More

Take your Excel skills to the next level!     Advanced Excel Essentials can be ...

Read More

I’m not always the biggest fan of info graphics. Many of the posters-sized info ...

Read More

In case you’ve missed it, my 70-minute long free webinar is available on YouTube. ...

Read More

Watch me argue it out with the wise and venerable (but ultimately incorrect) Bill ...

Read More

There are plenty of terrific random data generators for Excel out there. But sometimes ...

Read More

As you might imagine, I often get approached to promote Excel material. As a ...

Read More

Based on the great reception Rob Collie has had in Cleveland, I am attempting ...

Read More

First of all, happy spreadsheet day! It was on this date today that VisiCalc ...

Read More

You probably noticed a “bug” while playing around with my Interactive Periodic Table of ...

Read More