Templates Courses Blog Why Sheets?
Categories
Accounting + Finance Human Resources Project Management Real Estate Sales & Marketing Small Business Strategy & Management Supply Chain & Operations
Hire Us
Hire an Excel Expert Hire A Google Sheets Expert Hire A Power BI Expert
Buy Now
first-non-blank-cell-excel
Mastering Excel: Finding the First Non-Blank Cell in 4 Easy Steps excel index function excel match function index match match and index Jun 22, 2023

Are you looking for a way to find the first non-blank cell in a column of data in Excel?Ā 

In this blog post, you'll learn about Excel's native functi...

Continue Reading...
excel-index-match-functions
Excel's INDEX MATCH: The Dynamic Duo for Advanced Lookups excel index function excel match function index match match and index Jun 19, 2023

Are you tired of using the VLOOKUP function for Excel lookups?

Consider switching to the INDEX MATCH function, which can overcome some of VLOOKUP's l...

Continue Reading...
merge-tables-in-excel
How to Merge Tables in Excel in 3 Easy Methods excel index function match and index vlookup Jun 12, 2023

Do you want to learn how to merge tables in Excel?Ā 

Merging tables can be tricky and time-consuming if done incorrectly. Whether you need to merge da...

Continue Reading...
First Excel Live Training Video and Notes! excel tips match and index xlookup May 24, 2021

Weā€™re excited to share our first-ever Live Excel Training! You can watch the full 1-hour and 6-minute training above. While we offer a world-class Exc...

Continue Reading...

Categories

All Categories array functions benefit of excel templates cell format cells changing currency conditional formatting data analysis data management data visualization errors excel excel formulas excel functions excel index function excel is fun excel match function excel tips excel tutorial exceltools functions google sheets graph index match macros match and index merge microsoft excel performance measurement spill error spill functions spreadsheet tutorials vlookup xlookup