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
Microsoft Excel
If you want to become a master of Excel, you need to learn how to use array formulas. Array formulas will perform calculations that other formulas in Excel can’t do. Here is example 1 – multi-cell calculation to return multi results 1. Select D2 to D8. 2. Type **=B2:B8\
Microsoft Excel
Vlookup is a great function. Most Excel users would have it in their top 10 function list. VLOOKUP is a lookup and reference function. If you are trying to find things in a table or a range by row Vlookup is a great function to use. Two other functions when
Microsoft Excel
To calculate weekly revenue or weekly orders in MS Excel, you can use either PivotTables or Vlookup. I prefer the PivotTable method but I will show both methods. One of your data fields needs to be a date field such as invoice date, purchase order date, order date, etc… Excel’