Excel

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 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...

Here is a late entry :) Thanks Leonid.  This is an Awesome response! Leonid was responding to this recent challenge:  Friday Challenge – Pipeline Usage...

In a follow-up to my recent Terrible Chart Tuesday, I wanted to show you 2 different techniques that you can use to create a...