Category: Excel

Microsoft Excel Tips and Tricks The new Excel “SHOW CHANGES” feature lets you collaborate confidently with others! With this feature[…]

Microsoft Excel Tips and Tricks Great News for us Excel people! You can now unhide multiple sheets in one go[…]

Microsoft Excel Tips and Tricks In this video, I show you how to use Excel’s Text to Columns feature to[…]

Microsoft Excel Tips and Tricks I demonstrate how to add up times in Excel. Times are stored as numbers in[…]

Microsoft Excel Tips and Tricks I explore a problem with dates and times, where Excel will not allow you to[…]

Microsoft Excel Tips and Tricks I demonstrate how to get a count of unique text or numeric values in Excel.[…]

Microsoft Excel Tips and Tricks I demonstrate how to count the number of cells that contain an error. You can[…]

Microsoft Excel Tips and Tricks I demonstrate how to return the position of a value within a range of values[…]

Microsoft Excel Tips and Tricks How to compare text, numbers, and dates in Excel – including case sensitive text comparisons[…]

Microsoft Excel Tips I demonstrate how to identify outliers in an Excel data set. Credit Chester Tugwell

Microsoft Excel Tips Are you able to filter horizontally in Excel? The answer to this question is: not really! However,[…]

Microsoft Excel Tips I demonstrate how to use Excel formulas in a Microsoft Word document. Credit Chester Tugwell

Microsoft Excel Tips I demonstrate how to automatically sort data when it is changed or when new data is added.[…]

Microsoft Excel Tips You can tell if Excel is in either of these modes by looking on your status bar.[…]

Microsoft Excel Tips I demonstrate how to remove dotted page break preview lines in Excel. Page break preview lines appear[…]