Excel

Sales executives are always pushing their sales teams.  They typically do this by setting sales quota’s for their salespeople.  Quotas are thresholds or minimum...

For this week’s challenge, we are going to modify a previous post for a user request. If you are not familiar with it, you should...

Yesterday, I posted the a demonstration on how to make a Step Chart in Excel. You can check out that post here: How-to Easily Create a...

A while back, I published an article on how to make an Area Cliff Chart. Now this isn’t a standard chart type. If you use the Standard...

A reader, Matt, after reading this post:   How-to Format Chart Axis for Thousands or Millions   And had the following question:   “How do you use this formula without...

In a recent Wall Street Journal article I saw the following chart regarding Dropbox, YouSendIt and Box.com.  The graph describes how many people use...

Thanks for the submissions for the Friday Challenge. You can get the sample data and chart request here:  friday-challenge-help-new-to-excel-yoy-comparisons   Here are some other submissions: A) In the...

In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart...

Here is Pete's answer to the recent Music Festival Schedule Challenge. In this video, see how he used Index/Match functions as well as a helper...

Selecting Ranges in Excel Have you ever had an issue using your mouse to select a large set of data in your Excel spreadsheet?  Have...