Category: Excel Tutorials

Learn different methods to merge Excel sheets including the native Power Query option, a third-party tool for importing data, and a code-based macro.

The SUMIF function in Excel with multiple criteria is perfect for summing up cells that meet certain conditions.

Learn how the AGGREGATE function Excel can be used to summarize data including its syntax, basic usage, examples, and more!

Learn how to link sheets in Excel between the same and different workbooks with this easy step-by-step explanation.

Learn various examples of how to write SUMIFS in VBA including its syntax and parameters, as well as how to combine it with other functions.

Check out the examples of how you can use Excel VLOOKUP IF together for solving different tasks.

Learn how to use Excel COUNTIF not blank formula to count the number of blank and not blank cells.

Explore the options of how to split cells in Excel using the native functionality or Excel functions, depending on your needs.

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.

Learn how to build a time tracking spreadsheet in Excel or connect Excel to a time-tracking app. Ready-to-use templates are included.