Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
Excel is essentially a calculation engine. Just like a calculator, it takes questions in the form of formulas, for example, =8+4, and returns answers. Formulas are essential to manipulating data …
In Excel, we often came across a situation where we have to add a percentage to a number. This is often the case when we want to increase or decrease …
Sometimes in Excel, we want to convert the number to the nearest 100 instead of an exact value. Rounded-off numbers are often easier to read and comprehend. For instance, if …
We format data in Excel to change its appearance to make it more readable and appealing. The process of formatting can be tedious and time-consuming. In the event we need …
There may be times when you import datasets and find that date and time columns have been combined. In this tutorial, we are going to look at seven simple methods …
If the Scroll Lock is turned on in Excel, the active cell remains unchanged as you scroll through the worksheet using the arrow keys. This is convenient if you want …
In Microsoft Excel, when we apply a filter to a specific column it only filters all the columns based on that specific column. But we often came across situations where …
Countries such as the USA and the UK use a comma to separate groups of thousands and a decimal point to separate decimals. Many other countries such as Spain and …
Sometimes when you launch Excel or are in the process of working with Excel, Excel freezes and returns a message box indicating that Microsoft Excel is not responding. This tutorial …
The VLOOKUP Function allows you to retrieve information from a vertically arranged table or dataset. It’s an extremely popular Excel function that automates looking up information from large datasets. However, …
Document Properties in Excel are a set of data that describe the document. This information includes the author, title, company name, and other information about the document (such as the …
Linked cells in Excel refer to the contents of other cells. The other cells may be in the same worksheet, other worksheets in the same workbook, or worksheets in other …