Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
While Excel is built to work with large numbers, when you enter a number that has more than 11 digits, you would notice that these are converted into scientific notation …
We often came across a situation where we want to copy the row height from one row and apply the same to other rows. It would be quite tedious to …
Shortcuts refer to the combination of keys used to complete repetitive tasks instead of scrolling through various ribbons to achieve the same objective. These shortcuts come in handy when you …
A lot of times, when I download data from a database or from the web, it has the time as well as the date in the same cell. And many …
Tiered commissions are quite common for people who do sales. Tiered commissions provide an incentive for salespeople to boost their sales figures in order to earn more commission. This, in …
In Excel, we often use formulas like INDEX/MATCH, VLOOKUP, and XLOOKUP to match the lookup value but in some scenarios, we came across a situation in which we lookup for …
The Conditional Formatting feature provides an excellent way to highlight or draw attention to data, that meets certain criteria or conditions. It is an effective, visual communication technique. Spreadsheet designers …
I have seen many people manually change the cell’s font color based on the cell value. While this is all right if you have to do it once in a …
By default, your Excel has some preset theme colors and fonts. These preset theme colors are applied when you open any new Excel file and create charts or Excel Tables. …
Excel has close to 500 awesome formulas across various different categories, but it does not have a BETWEEN formula. And there is probably a good reason for this – you …
Pivot tables are extremely useful in analyzing and summarizing a large amount of data with a few clicks. When you create a Pivot Table in Excel, by default it would …
Excel filters are quite useful when you’re trying to analyze a large amount of data. Excel allows you to quickly apply filter your data based on one or more than …