How to Find Range in Excel (2 Easy Formulas)
We usually require certain metrics to understand the data that we are working with. There are a number of such representative metrics, like the average, the median, etc. Among these …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Add a Total Row in Excel Table (Easy Step-by-Step)
Excel provides some really great features in the form of Tables. Excel tables provide an organized way of viewing and reporting data in a tabular format. Besides other advantages, Excel …
How to Select Multiple Rows in Excel (3 Easy Ways)
One of the advantages of using spreadsheet software like Excel is that you get to perform operations in bulk. Instead of working on one cell or one row at a …
How to Apply Accounting Number Format in Excel
Excel spreadsheets are used for a number of applications, but its most common application is in areas of business and accounting. It only makes sense then for Excel to have …
How to Start Excel in Safe Mode (3 Easy Ways)
If you’re facing problems running an Excel file or if you find your Excel application repeatedly crashing, it might help to open Excel in Safe mode. Microsoft Excel has an …
How to Find out What Version of Excel You Have (Easy Way)
Every version of Excel brings with it new features while making some older features obsolete. As such, we often need to know exactly which version of Excel we are using, …
How to Square a Number in Excel (2 Simple Methods)
Thanks to spreadsheet software like Excel, it has become easier than ever to find squares of thousands of numbers at a time, even if some of them are quite large. …
How to Hide Rows based on Cell Value in Excel (2 Easy Methods)
Working with large datasets that contain rows after rows of data can be quite painful. In such cases, looking for data that match particular criteria can be like looking for …
How to Remove Read-Only From Excel (6 Easy Fix)
When trying to save changes to an Excel sheet you might find that you are unable to do so, because the file is ‘read-only’. At other times you might see …
3 Easy Ways to Duplicate Sheet in Excel (Shortcuts + VBA)
Working with spreadsheets often involves a lot of repetitive tasks. A common way that spreadsheet users save time and energy is by making copies of spreadsheets already created and using …
How to Undo in Excel (2 Easy Ways)
To err is human. Every Excel spreadsheet user at some point makes a mistake and needs to undo a change made. Now, life does not give you a second chance, …
How to Use Pi (π) in Excel
Even if you don’t know what Pi is, I am sure you have seen the symbol π. In this tutorial, I will cover what Pi means and how to use …