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.
Category: Basics
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...
Calculate Quarter from Date
Using quarters of a year for reporting is a very common concept in all kinds of businesses. Unfortunately (and curiously) Excel doesn’t have a function...
Excel Shortcut: Paste as Value
For me, this is the best Excel shortcut ever. I came across this one late in 2013 and been using it almost daily at work....
Top 10 Excel Tips – 2013 Edition
With 2013 is recently ended, I can see a lot of very good Excel tips and tutorials are posted on the site. If you missed...
PDF to Excel
If you ever tried to copy data from PDF to Excel you sure have noticed that copied data are not quite usable when pasted into...
