Microsoft Excel
It is tempting to use merge and center in Excel. It stands out when you open Excel. Avoid merge and center. Three reasons why merge and center is evil: 1. Data with Merge and Center can't be sorted. 2. Remove Duplicates, another great Excel feature, doesn't
Microsoft Excel
Many Excel files are not set up properly. Data that should be in a flat file is laid out in a crosstab file format, or in this example, the data is missing information and has totals manually applied. The issue with data being set up incorrectly is the following can’
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