Import Text Files Into Excel
Once in a while you may encounter data in a text form. If you copy this data and paste it directly to Excel, all columns...
Category: Basics
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.
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...
