Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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 …
If you try to add a leading zero in front of a number in Excel, Excel removes it immediately after you press Enter. This is because a zero before a …
The Interquartile Range is commonly used in statistics as it helps us identify the natural seasonality and monthly trends in a dataset. It gives you insight into the spread of …
Sometimes you may have a dataset in Excel that has date and time values in separate columns. You may want to combine those values in one column. In this tutorial, …
Sometimes, you may want to get the first day of the month when you already have a date. For example, if you have 15 Jan 2023, you can use a …
Threaded comments are like conversations within the Excel worksheet. They allow team members to have a discussion about the data they are working on. Below is an example of comment …
Year Over Year (YOY) growth is a common comparison metric that is considered when analyzing the growth of our business It compares the growth in a certain period of time …
Pivot Table is a very handy feature in Excel to calculate, analyze and summarize data. Using Pivot Table, we can see comparisons, patterns, and trends in our data. However, when …
Excel by default displays negative numbers with a minus sign. In some instances, for example, when dealing with financial data, you may want to display negative numbers in parentheses or …
Excel Table is an amazing built-in feature that allows us to easily work with the data. When you convert a data set into an Excel Table, you’re able to use …