Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
Sometimes we may need to hide formulas in our Excel worksheet without necessarily protecting the sheet or protecting the cells that have the formulas. In this tutorial, I will cover …
Documents such as bank statements may be sent to us in PDF format. We may need to convert these documents into Excel. This enables us to use the powerful Excel …
As we work with Excel, we may sometimes need to combine two columns and separate them with characters such as a space or a comma. Below is an example where …
Excel’s Greater Than or Equal To (>=) operator is a comparison operator. It compares two values of the same data type. It returns TRUE if the greater than or equal …
To perform some operations in Excel requires that we first select cells. Selecting adjacent cells is easy. While selecting non-adjacent cells is not as straightforward, with a bit of practice, you …
Many Excel users often work with large datasets in Excel. And large datasets are often split into different categories row-wise. In such cases, it would become difficult to get an …
We often work with very large datasets in Excel. One issue many users face is that when you scroll too far down or too far to the right, the first …
Time tracking is useful when trying to improve efficiency in your projects (or even your personal life). If you work with time datasets in Excel, it would be useful to …
Excel is an excellent choice for storing and managing small databases efficiently. However, sometimes in order to clean Excel raw data and extract some meaningful information from a data set, …
You’ve got text in Excel that you need in another language, but you’ve been copying every translation by hand. This used to be a pain, especially when you had a …
Microsoft Excel is an excellent choice for creating a small database for storing information such as employee records, test scores, or even small inventory items. In some scenarios, we want …
A Pivot Table is an interactive table that can summarize vast amounts of numeric data enabling us to analyze data in finer detail. Therefore it can be frustrating when you …