Category: Basics

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

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