Latest Blog Posts in excel

Apr 14, 2024

Grouping Excel Table Data

Group and sort data from an Excel table using a formula.

Aug 6, 2023

Updated: Feb 6, 2024

Learn how to use VLOOKUP function in Excel to search for and retrieve data from multiple tables or ranges with this tutorial.

May 17, 2022

Updated: Dec 21, 2022

In Office 365, Excel offers the new XLOOKUP function. We will compare it to VLOOKUP and INDEX, especially in terms of speed.

Apr 7, 2022

Learn how to combine and pivot text in Excel using PowerQuery