How to Use Pi (π) in Excel
Even if you don’t know what Pi is, I am sure you have seen the symbol of pi (π). In this tutorial, I will cover what Pi means and how …
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 Use ‘e’ in Excel? (Euler’s Number)
If you’re an Excel user, you’re probably familiar with basic functions like SUM, AVERAGE, and COUNT. But did you know that Excel has a built-in function to calculate Euler’s number? …
How to Print Gridlines in Excel?
Gridlines in Excel are the light-colored lines that surround every cell of your spreadsheet. These lines help to demarcate the area occupied by a cell and thus improve the readability …
How to Calculate Antilog in Excel (Formula)
Logarithmic functions are often used when dealing with exponential values in your data. So when you have a log function, you might probably need to find the antilog at some …
How to Save an Excel Table as Image?
While Excel is the primary choice when it comes to analyzing data, a lot of reporting is still done with other tools such as Microsoft PowerPoint or Word. This also …
How to Remove Panes in Excel Worksheet (Shortcut)
Excel has a feature where it allows you to divide a worksheet into two or four panes. This helps as you can treat each of these panes separately and can …
Excel Logical Test Using Multiple If Statements in Excel [AND/OR]
![Excel Logical Test Using Multiple If Statements in Excel [AND/OR]](https://spreadsheetplanet.com/wp-content/uploads/2023/02/Excel-Logical-Test-Using-Multiple-If-Statements-in-Excel-ANDOR.png)
To test certain conditions, people use If statement. The If() function is used to perform logical tests and to evaluate conditions that will show two outcomes. This Excel IF statement …
How To Set Column Width in Inches (or Centimeters) in Excel?
I was recently asked if there is a way to set column width in inches in Excel. This was for a template this person was creating where they wanted the …
How to Find Duplicates in Excel (Conditional Formatting/ Count If/ Filter)
When you are working on a large number of data then you will encounter a few duplicate entries. Sometimes these duplicate values are very useful but many times you want …
How to Lock Cells in Excel [Mac, Windows]
![How to Lock Cells in Excel [Mac, Windows]](https://spreadsheetplanet.com/wp-content/uploads/2023/02/How-to-Lock-Cells-in-Excel-Mac-Windows.png)
If you are protecting a worksheet, then that means you are locking all the cells. You cannot perform any editing on those cells. To perform the editing of the cells, …
How to Open Excel File [xls, xlsx] Online (for FREE)
![How to Open Excel File [xls, xlsx] Online (for FREE)](https://spreadsheetplanet.com/wp-content/uploads/2023/02/How-to-Open-Excel-File-xls-xlsx-Online-for-FREE.png)
When you open an Excel file online, you will find a new workbook automatically displayed. The workbook contains various worksheets that hold actual data and information. Initially, the workbook opens …
How to Fill Blank Cells with Value above in Excel?
Sometimes, you may have a dataset where there are empty/blank cells in a dataset that should have been filled with the same value. Below is a common example where the …