Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
Performing operations on names like search, sort, filter, etc. is usually easier when full names are separated into separate columns. In fact, separating names is such a frequently performed data …
Often when you inherit Excel files from other people, they can have links to other external Excel files and ranges. Many times, you don’t need to keep these links to …
Compound interest is a concept heavily used by the banking and finance industry. If you’re investing or saving money in a bank, Compound Interest is the magical formula that is …
The term ‘percentage difference’ is often misunderstood. A lot of people get mixed up between the terms ‘percentage difference’ and ‘percentage change’. Both are completely different concepts and have completely …
One of the most important applications of Pivot tables is summarizing your data. You can use Pivot tables to summarize data by a number of factors, including by month, day, …
If you’re using Excel 365 or newer versions, you might have come across the SPILL error. This is a new error code that you will find in addition to the …
We often need to work with names in Excel. A lot of times we might need to work with a certain part of names in a list. For example, we …
There are enough functions in Excel to help you if you need to find an exact match for a value from a list. However, if you’re looking to find the …
Excel is quite commonly used in processing survey data and results. In many cases, these surveys are used to collect user responses as Yes or No. and then as part …
In Excel, you might come across situations where you need to combine strings into a single cell, but you want to display them in separate lines. For example, you might …
This is going to be a trouble-shooting tutorial where we are going to focus on what to do if you can’t type into a cell in Excel (i.e., you type …
The parentheses are a pair of symbols that have different meanings in different contexts. In general, parentheses are used to group elements together into an entity. In the English language, …