

Category Archives for "Excel Tips"

2 How to Sort By Color in Excel (in less than 10 seconds)

Sort by multiple colors - select Green in the drop down

Excel has a lot of options when it comes to sorting data. And one of those options allows you to sort your data based on the color of the cell. For example, in the below dataset, you can sort by color to get the names of all the students who scored above 80 together at […]

1 Hyperlinks in Excel (A Complete Guide + Examples)

Excel allows having hyperlinks in cells which you can use to directly go to that URL. For example, below is a list where I have company names which are hyperlinked to the company website’s URL. When you click on the cell, it will automatically open your default browser (Chrome in my case) and go to […]

0 How to Quickly Unhide COLUMNS in Excel (A Simple Guide)

Watch Video – How to Unhide Columns in Excel If you prefer written instruction instead, below is the tutorial. Hidden rows and columns can be quite irritating at times. Especially if someone else has hidden these and you forget to unhide it (or even worse, you don’t know how to unhide these). While I can’t […]

2 Using Index & Match Functions Combo in Excel (10 Easy Examples)

Three Way Lookup - Result using INDEX MATCH

Excel has a lot of functions – about 450+ of them. And many of these are simply awesome. The amount of work you can get done with a few formulas still surprises me (even after having used Excel for 10+ years). And among all these amazing functions, the INDEX MATCH functions combo stands out. I […]

4 How to Recover Unsaved Excel Files [All Options + Precautions]

Looking to recover unsaved Excel file, click here to jump to all the possible options you have to get the file back. Let me tell you the shortest horror story ever. Excel Crashed! Imagine working on that urgent report or that extremely important dashboard where you have done such a fantastic job. You are proud […]

0 How to Insert a Check Mark (Tick ✓) Symbol in Excel [Quick Guide]

In Excel, there are two kinds of tick marks (✓) that you can insert – a check mark and a checkbox. And no… these are not the same. Let me explain. Check Mark Vs Check Box While a check mark and a checkbox may look somewhat similar, these two are very different in the way […]

9 FREE Monthly & Yearly Excel Calendar Template (2019 and Beyond)

Calendar Contemporary Digital Device Concepts

I am a big fan of using Excel templates to plan and manage work. I regularly use to-do lists and calendars to plan my days in advance. In this post, I am sharing an Excel calendar template that you can use in Excel or even take a print out and stick it at home or at […]

1 2 3 … 34 Next »