How to Create Custom Lists in Excel?
Excel has a fantastic feature called Custom Lists that lets you create your own lists and quickly apply them in various ways. When you create a custom list in Excel, …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
#REF! Error in Excel
An error in Excel called “#REF!” (with REF standing for reference) happens when a formula refers to an invalid cell. This usually occurs when cells referenced by formulas are deleted …
How to Write Scientific Notation in Excel?
Scientific notation is commonly used by mathematicians, engineers, and statisticians when they are writing very large numbers or very small numbers. MS Excel offers some built-in features to work with …
Extract Last Word in Excel
As you work with data in Excel, you might need to extract the last word in a cell, for example: This tutorial shows five techniques for extracting the last word …
Convert Number to Percentage in Excel
In Excel, we frequently calculate and enter growth rates, efficiency rates, success rates, discount rates, tax rates, interest rates, etc. In general, we have to give those as percentages. Then, …
How to Find the Largest Value in Excel
Finding the largest value from the given values is important when making decisions about things like what is the highest score in the class or what is the highest gross …
Standard Deviation in Pivot Tables in Excel
When dealing with numerical data in Excel, you might need to calculate the standard deviation within a Pivot Table. The standard deviation is a statistical calculation that measures the degree …
How to Separate Excel Tabs Into Separate Files
Sometimes, you might need to divide the Excel sheets in your workbook into separate Excel or PDF files for various reasons. This tutorial shows five techniques for separating Excel sheets …
Find the Position of a Character in a String in Excel
When working with Excel, you may want to determine the position of a character within a string for various reasons. For example, if you need to split a string into …
Can’t Push Objects Off the Sheet in Excel – How to Fix!
At times, when trying to insert rows or columns in a worksheet, it may fail, and Excel will display an error message stating, “Can’t push objects off the sheet,” as …
Find Last Occurrence of a Value in a Column in Excel
Sometimes, you may want to find the last occurrence of a value in a column in Excel. For example, If you intend to highlight or format the cell containing the …
How to Lock a Pivot Table in Excel
When working with Excel, you may find yourself using pivot tables to organize and analyze your data more efficiently. However, there might be instances where you want to lock and …