All about Excel Comments (Notes): Shortcut Keys, Customize Background & More This post will demonstrate how we can work with comments in a better, faster way than is typically executed. We will also see how to customize our comments to have eye-catching
Excel's Find and Replace (surprising features) One of the first features a Microsoft Word user discovers is the ability to search through a document, looking for a word, and replace the word with a different word. This is useful when you want
VLOOKUP Not Working? Convert Text to Date? (Excel Text to Columns) When working with imported data in Excel, it is not uncommon to encounter issues with numbers and dates not being recognized properly. Importing data via Power Query provides us with a
Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) “Does Excel have a feature to allow a Data Validation list to be searchable?” This is a common question asked on this site and most any Excel training venue. What do
3 Methods to Unhide All Sheets in Excel (& how to hide) How can you unhide all Excel sheets at once? Hiding many worksheets at once is easy in Excel. Click on a sheet, hold down the control or the shift key,
This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this) In this tutorial you'll learn a lot about combo box drop-down lists in Excel: 1. How to create a combo box drop-down list 2. How to create a dependent
Change the Number Format of a Cell Based on a Condition Quickly learn how to change the number format of a cell based on the value of another cell. In this example, I show you how you can format a cell so
Excel Sort (by Value, Color, Icon, Own List) & How to Unsort Sorting is super easy in Excel! You'll learn how to sort by values (ascending, descending), how to sort alphabetically & much more.
FIFA world Cup 2018 is approaching fast and I thought to share an Excel template that adds to the fun and excitement of the World Cup month. Use it to keep track of the dates & times of the games, input your predictions, make
Check for text, numbers & length Excel Custom Data Validation Custom data validation is especially useful when the normal data validation criteria options are insufficient, this way, formulas can be used to define the restrictions. TIP: Since the formula text box in the