Go To Source Cell of XLOOKUP Formula Result
Microsoft Excel you’ll discover how to go directly to the source data of an XLOOKUP formula using a macro button[…]
Read more
Category: Excel
Quick Tip for Navigating Formula References with the Go To Window
Microsoft Excel learn a quick tip for jumping straight to the data used for a particular reference point (argument) in[…]
Read more
Seating Chart Planner – Excel Hash 2021
Microsoft Excel This seating chart planner is packed with features to plan events or classrooms. It optimizes for small groups[…]
Read more
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
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
SURPRISING Advanced Filter TRICK in Excel (You’ve Never Heard Of!)
Microsoft Excel With Excel’s Advanced Filter feature you can filter for multiple criteria and copy the filtered results to another[…]
Read more
Excel Automatically Replaces Names | Excel Prank Part 3 #shorts
Microsoft Excel In today’s Excel prank you’ll learn how to use autocorrect in Excel (Autocorrect applies to Word, PowerPoint and[…]
Read more