Excel Power Query Tutorial: Get and Transform Data
Learn what Excel Power Query is, how to use this powerful tool to get data from various sources into Excel, and apply basic data transformations.
Category: Excel Tutorials
Tutorials and guides related to the use of Excel functions and features.
Time-Tracking Spreadsheet in Excel – Do It Yourself or Use Our Template
Learn how to build a time tracking spreadsheet in Excel or connect Excel to a time-tracking app. Ready-to-use templates are included.
IMPORTRANGE Excel – How to Implement the IMPORTRANGE Functionality in Excel
Learn the options for how to implement the IMPORTRANGE equivalent for Excel in a native way or with a third-party solution.
Link Excel Files – How to Do It Right
Wondering how to link files in Excel? Look no further. We answer various questions and compare approaches to linking your Excel data.
Excel SUMIF with Text Criteria: Formula Examples
Find out how to use the Excel SUMIF function with text criteria. This tutorial covers various formulas, from basic to advanced examples.
Excel VLOOKUP SUM: Formula Examples
Learn how the combination of Excel VLOOKUP & SUM functions can be useful to sum values across multiple columns.
Excel XLOOKUP Function Explained – Syntax and Examples
Excel XLOOKUP is a function that makes a look up to the left or to the right, top to bottom or bottom to top, and allows for wildcards.
Excel SUMIF with VLOOKUP: Formula Examples
Looking for how to use Excel SUMIF + VLOOKUP together? In this article, you’ll learn how these two useful functions can be combined in a single formula!
Excel SUMIF with Date Criteria: Formula Examples
Learn how to use the Excel SUMIF and SUMIFS functions with date criteria. Examples and common uses for are included.
Excel Vlookup Multiple Columns: Explanation + Examples
VLOOKUP formula example and explanation of how to vlookup multiple columns in Excel.