Intermediate Microsoft Excel tutorials

Excel - Get and Transform Data | Unpivot Columns with Two Header Rows

Excel's Unpivot Columns, part of Power Query, is an awesome feature. It is the easier way to fix data that isn't in a tabular format.

Excel Conditional Formatting with the TODAY function | Duplicate Rule

The TODAY function is one of my favorite Date & Time functions in Excel. It returns the current date and will automatically update. We will use the TODAY function with Conditional Formatting and create three rules on a date field.

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

Accountants use Excel all the time. In this video, which is great for Accounting students, we look at the Accounts Receivable (AR) or Accounts Payable (AP) exercise.

Excel Recommend PivotTables - Improved Experience

Recommended PivotTables in Excel is getting a great update. To use Recommended PivotTables, click the Insert Tab, and click Recommended PivotTables.

Excel PivotTable - Calculate the number of days of each week for every month of the year

If you want to calculate how many days are in each month for a year, it is easy to do with a PivotTable in Excel. I want to know how Sundays through Saturdays there are for each month of the year.

Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work

I recently spoke at the Administrative Professional Day Conference hosted by the University of Georgia. After reviewing my survey results in Microsoft Forms, I realized I needed to analyze the survey data. Forms results are immediately available in Excel.

Excel AVERAGE excluding the highest and lowest values | TRIMMEAN Function

When you have a range of numbers in Excel and want to figure out the AVERAGE but you have some extreme values that can skew your averages, there is a function that helps solve that problem.

Auto-Refresh STOCKS in Excel | Pull Live Stock Data in Excel | New Feature

The STOCKS data type in Microsoft Excel required manual refresh until now. A new feature released for Microsoft Excel on Desktop for Windows, Mac as well as Excel on the Web, fixes that problem, by allowing you pull almost live stock data into Excel.

Excel Charts vs PivotCharts | Comparison | Which is Best?

Which is best in Excel? Classic CHARTS or PIVOTCHARTS? In today's Excel video, I show you both ways of creating charts in Excel, show you step by step what's involved in each method and which one is the most flexible, powerful and which one I prefer.

Excel Distinct Count with a PivotTable

PivotTables in Excel can create a Distinct Count. An example of a distinct count is we had five orders in one day, but three orders were placed by the same customer. I want to know we have five orders from three customers.

Excel Conditional Formatting - Getting started with five examples

Conditional Formatting is one of Excel's best features. I use it daily. In this short video, I'll get you started using Conditional Formatting.

Excel Five Great Tips for Filtering Data

Five great filtering tips for Excel. Filter by selected cells value, copy and paste filtered data, delete filtered data, auto-calculate works with filtered data, and search for filtered data.