Microsoft Excel
Create a Sunburst Chart in Excel by Chris Menard - YouTube The sunburst chart or multi-level pie chart is ideal for displaying hierarchical data. Each level of the hierarchy is represented by one ring or circle with the innermost circle as the top of the hierarchy. A sunburst chart without
Microsoft Excel
Excel group numbers and IFS and FormulaText functions Two new Excel 2016 Functions **IFS** - The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements and is much
Microsoft Excel
Excel - use the Median function in a PivotTable by Chris Menard - YouTube PivotTables do not allow median function. We will create a helper column and use an array function to calculate the median in a PivotTable. Also shown are average, median, averageif, if statement with the median function.
Microsoft Excel
Bill in Smyrna, GA wants to show percentage in a PivotTable and filter the PT. That is easy. The issue is Bill wants to show the unfiltered percentages, not the filtered percentages. I had to add a helper column to do this. PivotTable Percentages - Show unfiltered percentage when filtering
Microsoft Excel
What if I told you in Excel 2016 for Office 365, you can click on one cell and with two more clicks, have data analysis you would never dream of having? It’s here! Microsoft has updated Excel 2016 for Office 365 with Insights for Excel. Insight is discussed in
Microsoft Excel
Extracting email address from a text string in Excel can be tricky. I made a video demonstrating three methods of extracting the email addresses. I also showed how to take the email addresses and add a comma between them. This is handy when you need to import the email addresses
Microsoft Excel
You can use Microsoft’s **Map Chart** to compare values and show categories across geographical regions. The map chart works with geographical regions. This means your data should have 1. Countries 2. Regions 3. States 4. Counties 5. Postal codes Note: This feature is only available if you have an
Microsoft Excel
If you see data on a webpage and need to pull it into Microsoft Excel, don’t copy/paste. Excel 2016 has a feature called Get Data / From Other Sources / From Web. In the example below I’m pulling population data for the 50 states from Wikipedia into Excel. If
Microsoft Excel
Microsoft Excel can be used to analyze vast amounts of data, and one of the best features in Excel for this purpose is changing your data range to a table. With tables, you can quickly sort and filter your data, add new records, and see your charts and PivotTables update
Microsoft Excel
Excel - new feature added. You can now deselect with the CTRL key by Chris Menard - YouTube You can now deselect with the CTRL key in Excel. Version 1801 of Office 365 Excel allows you to deselect/unselect with the CTRL key. This was one of the most requested
Microsoft Excel
Human Resource Professionals have a hectic schedule. They deal with benefits, training, staffing, retention, reviews, hiring, firing, personnel manuals, and many other HR aspects of their jobs. I’ve put together a list of Excel functions every HR Professional should know. This list is not all inclusive but comes from
Microsoft Excel
Break-even overview Calculating the break-even on a company with only one product is relatively easy. Just take the total fixed expenses and divide by the contribution margin per unit. The contribution margin per unit is the unit sales price minus the unit variable cost. Here is an example. If a