Excel Find Position of a Value in a Range and Return that Value’s Cell Address
Microsoft Excel Tips and Tricks I demonstrate how to return the position of a value within a range of values[…]
Read more
Category: Excel
Compare Values in Excel (5 Ways) – Beginner to Advanced
Microsoft Excel Tips and Tricks How to compare text, numbers, and dates in Excel – including case sensitive text comparisons[…]
Read more
Formula to Identify Outliers in Excel Data Set | Highlight Outliers
Microsoft Excel Tips I demonstrate how to identify outliers in an Excel data set. Credit Chester Tugwell
Read more
Can you Filter Horizontally in Excel? | Can You Filter Rows Instead of Columns in Excel? | 3 Methods
Microsoft Excel Tips Are you able to filter horizontally in Excel? The answer to this question is: not really! However,[…]
Read more
How to Put Excel Formulas in a Word Document
Microsoft Excel Tips I demonstrate how to use Excel formulas in a Microsoft Word document. Credit Chester Tugwell
Read more
Excel Automatically Sort When Data Changes or Added | Auto Sort Excel Formula | Auto Sort Macro
Microsoft Excel Tips I demonstrate how to automatically sort data when it is changed or when new data is added.[…]
Read more
Why is Excel Selecting Multiple Cells When I Click on One? | Excel is Selecting Too Many Cells
Microsoft Excel Tips You can tell if Excel is in either of these modes by looking on your status bar.[…]
Read more
Why Does Excel Have Dotted Lines? How to Remove Dotted Page Break Lines in Excel
Microsoft Excel Tips I demonstrate how to remove dotted page break preview lines in Excel. Page break preview lines appear[…]
Read more
How to use VLOOKUP in Excel – Complete Tutorial
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel.[…]
Read more
How to Show Excel Formulas in Cells with FORMULATEXT Function #shorts
Microsoft Excel Tips and Tricks In this Excel #shorts tutorial you’ll learn how to use the Excel FORMULATEXT function to[…]
Read more