Change Sheet Shortcut
Here is a valuable shortcut for you. It is called Change Sheet. If you are already using Excel mostly without mouse, this shortcut will come...
Category: Basics
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,...
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...
