How to Highlight Expiry Dates in Excel (Step-by-Step)

Expiry dates are not best before dates and carry a higher element of urgency. Expiry dates guide the course of action for saving the articles from expiring. Perishable goods, subscriptions, registrations; some things will need to be renewed, the others disposed of. And keeping a track of things has never been a bad idea.Working on that good idea, … [Read more...]

Excel VALUE Function – How To Use

The VALUE function is a text function that converts a number from text format to numerical format where data is in an Excel-recognized format such as date, currency, time, etc. Mostly, if Excel recognizes a number, it automatically converts the data into numerical format. However, in other cases, we can do so using the VALUE function.The VALUE … [Read more...]

How to Turn on AutoSave in Excel (3 Easy Ways)

Excel can be your savior when it comes to data but can Excel be your savior when it comes to saving? The answer is yes, and it can do it automatically. Automatically.Isn't that a word that gives you computeresque joy?Today's tutorial is about automatic saving in Excel, shortened to AutoSave and we suppose you're here to find out how it works. … [Read more...]

Excel TEXTBEFORE Function – How To Use

The TEXTBEFORE function returns the text that occurs before the given character or string. That character or string is known as a delimiter. We can also decide to extract the content before a specific delimiter occurrence if the delimiter is used more than once.The TEXTBEFORE function is a new addition to the Excel family and is only available … [Read more...]

Find Cells With Conditional Formatting in Excel (Easy Steps)

There is no doubt in the Excel mines that Conditional Formatting is an unparalleled gem used to distinguish cells meeting defined characteristics. Sometimes, however, you may find your mind boggled on what rules belongs where with so much color fill, borders, and various font colors being a general part of worksheets.It also doesn’t help if … [Read more...]

How to Rename a Table in Excel (3 Easy Ways + Shortcut)

By default, the first Table in the workbook is automatically named Table1 by Excel and it goes onto Table2, Table3, and so on. While that's helpful on Excel's part, we bet everyone is like us and can't remember what Table was for which dataset.Say, you want to jump to the Table of overdue orders but can't remember where it is in the workbook … [Read more...]

How to Change Conditional Formatting in Excel (Step-by-Step)

The world is ever-changing and the Excel universe can say the same. With changes in data, requirements, users (and even moods?), there may need to be a change in what bits of the dataset are made prominent or how.Changing from top 10 to top 5, from Data Bars to simple highlighting, from top 3 to the 90% percentile, highlighting cells with an … [Read more...]

Excel TEXTAFTER Function – How To Use

The TEXTAFTER function returns the text that appears after a given character, substring, or delimiter. If the delimiter is used more than once, we can also choose to extract the text after a particular occurrence of the delimiter.The TEXTAFTER function is one of the latest additions and currently only works with Microsoft Excel 365.SyntaxThe … [Read more...]