Excel Shortcuts Presentation
Here is an Excel Shortcuts Presentation that I prepared for a training session I conducted. You can grab some useful shortcuts from these slides.
Author: melih
Positive Negative Bar Chart
Here is a nice bar chart that clearly shows how multiple units does compared to each other based on same criteria. Since this chart can...
Excel Timeline
Excel Timeline is a new pivot table filter introduced in Excel 2013. It automatically evaluates date data and provides year, quarter, month and day filters...
Quick Cumulative Sum
A lot of times you need to take a cumulative sum of some values during your work. Here is an easy way of taking a...
Win Loss Chart
Win Loss Chart provides a quick way of seeing overall situation of a series of data at one glance. It shows positive and negative situation...
Sum a Range of Cells that Contains Errors
Every now and then you will need to calculate sum (or average, min, max, etc.) of a range of cells that contains errors. Normal functions...
