Use Descriptive Statistics Functions in Excel

Curious about statistics like mean, median or standard deviation? Want a feature that gives you some basic descriptive statistics in a couple clicks? This video will cover a basic overview of how to get those type of descriptive statistics with the Data Analysis command and the different functions you can use to get to the same for each individual statistic.

Power Query Append Queries Not Working - Mismatch Columns Order & Name

Combining or appending files should be a straightforward process and using Power Query makes it easier. If the files that have the same header names and are in the same column order it’s really easy. However if the header names of different between files and the column orders are also different (i.e., mismatched column names and mismatched column orders) it’s a bit harder. If you only have a few files or tables to combine or append it’s just a copy and paste. But if you do this on a recurring basis or if there’s a LOT of files, it’s much harder. But still Power Query will make it easier, so check out the video to see how.

Find Largest or Smallest Value based on Criteria

If you wanted to find out the biggest or smallest values in a table there’s a couple ways that can be done. Also if you wanted to find the next largest or smallest value, there’ also a function for that. AND...if you had multiple criteria to find big or small values there's recently added functions (Excel 2019 or Office 365) that let you do that. See how all this can be done in the video and there's also a bonus tip on how to create dropdown list.