Excel Unplugged

Monthly Archives: December 2014

Holiday chart in Excel
December 28, 2014

This is what happens when someone has too much time and Excel 🙂 Happy holidays and all the best in 2015 to all Excel lovers!

Difference between two times formula in Excel

In short, times in Excel are decimal numbers between 0 and 1 that show you the percentage of the day that has past. Now with that in mind let’s calculate two ...

Case sensitive/insensitive Sort in Excel (bug or a feature)

This post will talk about the way that Excel sorts data and the Case Sensitive sorting it offers. If we look at this data And sort it in ascending order (A-Z), we ...

Create a Date Series of all weekdays in Excel (omits Saturdays and Sundays)
December 9, 2014

  Let’s say we want to create a series of dates from 1/1/2013 to 12/31/2013 but with a catch. We want to leave out all dates that occur on weekends. So all ...

Making your Min Max chart in Excel truly shine

Just so we know where this is heading, this is the end result And here is the file with the end result, you can download it and play around with pressing F9. ...