Tips and Tricks

In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products.  You can check out...

When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers.  Excel gives you...

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...

Select and Align Charts for an Excel Dashboard Creating dashboards can take a lot of time.  With this simple technique that I just learned, you...

In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...

We have learned how to Stop Excel Overlapping Columns in a few posts on the site.  A reader had a follow-up question that I...

I have been traveling very frequently for business as a Salesforce.com Software Consultant, so I spend a lot of time in hotel’s and airports. ...

Excel Formula Formatting Quick Tip Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use...

Have you ever tried to draw a straight line in Excel only to get frustrated? It can be so Frustrating :) to be off by...

Sum Excel Worksheets Technique Why haven't I known about this simple Excel technique before now? Maybe you were aware how you can easily Sum Excel Worksheets...