How to Count Cells with Errors in Excel. Count Specific Error eg #N/A or Count All Errors
Microsoft Excel Tips and Tricks I demonstrate how to count the number of cells that contain an error. You can[…]
Read moreTag: excel
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 moreCompare 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 moreFormula 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 moreHow 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 moreWhy 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
Windows 10 Tips & Tricks You NEED to Use in 2021!
Microsoft Excel Tips and Tricks In this tutorial I’ll share my favorite and rather hidden Windows 10 tips and tricks.[…]
Read more
How to use Goal Seek & Solver in Microsoft Excel
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how to use Goal Seek & Solver in Microsoft Excel.[…]
Read more
Excel for Accounting – 10 Excel Functions You need to Know!
Microsoft Excel If you work in accounting or you are a finance professional, make sure you learn these Excel formulas.[…]
Read more
Bookkeeping for Small Business – Excel Tutorial – Part 4 – VAT Calculations
Microsoft Excel In the fourth part of this small business bookkeeping video tutorial, I will show you how to convert[…]
Read more