Category: Excel Tutorials

Learn how to create various types of timesheet templates in Excel, and pick one to start tracking working hours.

Do you need to count cells according to set values as dates, numbers, or words? COUNTIF Excel performs counting based on formulas and one criterion.

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 the COUNTIF Excel multiple criteria formula and COUNTIFS function to return counts by multiple criteria using the AND / OR logic.

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