Equation Tools
You can insert equations in Excel (also in other MS Office applications such as Word and PowerPoint) as symbols using Equation Tools. In this article,...
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....
