Microsoft Excel
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. **Excel PivotTable - Show days per month for the
Microsoft Excel
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. **Microsoft Forms - Analyze data in Excel** After opening in Excel,
Microsoft Excel
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. **Average using Sum with Max, Min, and Count** You can calculate the AVERAGE in
Microsoft Excel
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. **Stock data type Refresh every 5
Microsoft Excel
Which is best in Excel? Classic CHARTS or PIVOTCHARTS? I will show you both ways of creating charts in Excel. I demonstrate step by step what's involved in each method, which one is the most flexible and powerful, and which one I prefer. **Charts vs. PivotCharts** We take
Microsoft Excel
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. **PivotTable with a Distinct Count** To create a
Microsoft Excel
Excel PivotTables have calculated fields and calculated items. In this video, I will take a field called Year, which has 2022 and 2021 in it and create a calculated item. In case you are wondering, what is the difference between a calculated field and a calculated item? That is easy
Microsoft Excel
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. We will look at using five easy Conditional Formatting features. We will use Conditional Formatting with text, numbers, above average, top 10 and
Microsoft Excel
Filtering data is one of the most popular Excel features. Here are five great filtering tips for Excel. 1. Filter by selected cells value 2. Copy and paste filtered data 3. Delete filtered data 4. Auto-calculate filtered data 5. Search for filtered data **Excel - Filter data tips** Tip #1
Microsoft Excel
Excel makes it easy to sort using built-in custom lists, you can sort data—either by days of the week or months of the year. I'll demonstrate how to create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically—such as
Microsoft Excel
Use Excel to calculate your tax liability using VLOOKUP. The Excel file is in the blog post. Tax brackets show you the tax rate you will pay on each portion of your income. For example, if you are single in 2021 and make $86,375, you are in the 22%
Microsoft Excel
With a stacked column chart in Excel, you can view partial numbers, but what do you do when you want to show percentages? Excel's pie charts show percentages, but stacked column charts do not. We are going to use a mixed reference to create a column chart with