Category: Basics

On this page you can find basic Excel Tips and Tutorials.

Top Excel Tips

This will be an ever improving Top Excel Tips post. I’ll be adding new tips every couple of days until total count reaches 100 tips....

Save Prompt Without Any Changes

Sometimes when you open an Excel file and then close it without making any changes on it. But to your surprise, Excel pops a dialog...

Updating Single Column Formulas

While working in manual calculation mode, you may need to test your formulas occasionally. When this happens, updating single column formulas instead of whole worksheet...

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

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