Advanced Microsoft Excel tutorials

Excel - Combine the SORT, UNIQUE, and COUNT functions

Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet.

Excel Import Data from the Web

Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command.

Excel - Turn on Multiple Filters in a PivotTable

Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on the PivotTable Option - Totals and Filters tab and check Allow multiple filters per field.

PivotTables - 3 Annoying Things FIXED!

PivotTables are one of the best features in Excel. PivotTables allow you to summarize, analyze and chart complex data. There are 3 annoying things in PivotTables that users always ask me about.

Excel - Share a PivotTable without the Source Data or Underlying Data

When you share a PivotTable in Excel, even if you delete the data source worksheet, the data source is still attached to the PivotTable.

Calculated Items in an Excel PivotTable

Excel PivotTables have calculated fields and calculated items. In this video, I'm going to take a field called Year, which has 2022 and 2021 in it and create a calculated item.

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

How to calculate progressive tax with 2021 tax brackets and VLOOKUP in Excel, with examples. Tax brackets show you the tax rate you will pay on each portion of your income.

How to use the Subtotal Function with Filters in Excel

We love to use Filters in Excel. When filtering data, the filtered rows turn blue. To get the SUM, AVERAGE, MAX, MIN, or COUNT of the filtered data, use the SUBTOTAL function.

Excel compare two or more text strings

To compare two text strings in Excel, you can use the EXACT Function or you can use =A1=B1. The EXACT function checks for case sensitivity. Example "Chris" is not the same as "CHRIS" if you use the EXACT function. With =A1=B1, Chris would appear as the same.

Year-Over-Year Growth - Excel PivotTable

Year-Over-Year (YOY) growth compares one period, usually a quarter or a month, against the same period twelve months before. You can compare Q3 of 2021 against Q3 of 2020. Another example is comparing the month of September 2021 to September 2020.

Excel PivotTable - Summarize data by Month or Day of the week

I need to know what day of the week is my most profitable. PivotTables and the TEXT function in Excel can easily determine this for me.

Excel DateDif function - difference between two dates

In Excel if you need to calculate the difference between two dates in years, month, or days, the DATEDIF function will handle it. DATEDIF is "Date & Dif".