Conditional Formatting for a List of Partial Matches in Excel
Microsoft Excel Conditional Formatting for a List of Partial Matches in Excel Credit Excel Campus – Jon
Read more
Category: Excel
UNIQUE Formula for Non-Adjacent Columns in Excel
Microsoft Excel we learn how to use a formula to return unique combinations of values from columns that are non-adjacent.[…]
Read more
10 Essential Shortcuts for Excel Tables
Microsoft Excel we explore 10 Windows and Mac shortcuts to use when working with Excel Tables. These include selecting, moving,[…]
Read more
How to Merge Excel Files with Different Headers in Power Query
Microsoft Excel Consolidating data from multiple Excel files requires you to have identical table headers otherwise you can run into[…]
Read more
When Should you Use the Hash Sign (#) in Excel Formulas?
Microsoft Excel The Hash sign or the pound sign (#) in an Excel formula allows you to easily reference an[…]
Read more