

Category Archives for "Excel Tips"

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 […]

6 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 […]

6 Excel AutoCorrect – A complete Guide with Useful Time Saving Examples

What happens when you type the word ‘Drnik’ instead of ‘Drink’ in Excel? You would notice that Excel will autocorrect that misspelled word to Drink (as shown below). Somehow, Excel knew that this is not the correct spelling and autocorrected it to the right one. Now, it won’t autocorrect all the misspelled words. Just a few! […]

0 6 Easy Ways to Insert the Delta Symbol (Δ) in Excel

When it comes to inserting symbols in Excel, things can get a bit complicated. You either need to know the keyboard shortcut, or use the methods that are not very straightforward. And there are a lot of symbols that many people need to insert regularly, such as the degree symbol, cent symbol, delta symbol, etc. […]

12 8 Ways to Reduce Excel File Size (that actually work)

Excel workbooks have been known to become painfully slow and heavy as more data/formulas/images are added to it. Sometimes, it’s easy to get rid of the extra flab and keep the excel file size in check, and sometimes, it isn’t. And since Excel is not a web-based tool, most of us work and collaborate by […]

1 How to Move Rows and Columns in Excel (The Best and Fastest Way)

Sometimes when working with data in Excel, you may have a need to move rows and columns in the dataset. For example, in the below dataset, I want to quickly move the highlighted row to the top. Now, are you thinking of copying this row, inserting the copied row where you want it, and then […]

11 Search and Highlight Data Using Conditional Formatting

Video – Search and Highlight Data Using Conditional Formatting If you work with large datasets, there can be a need to create a search functionality that allows you to quickly highlight cells/rows for the searched term. While there is no direct way to do this in Excel, you can create a search functionality using Conditional […]

1 2 3 … 33 Next »