Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
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. The median
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 a
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 features of
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
Posted on: 10/10/2017 Google Wallet - Send and Request money for free by Chris Menard **Google Wallet** is free! It is one of the fastest ways to send money, You can send money through either the app, in Gmail, or use the web. The website is wallet.google.com.
Google Sheets
Do you ever have Wikipedia data you need in a spreadsheet? Using Google Sheets you don't have to copy and paste. Instead, use the ImportHTML function in Google Sheets and get the data from Wikipedia. Scrape data from wikipedia and put into Google Sheets by Chris Menard Scraping
The Google calendar is great. Not many people utilize the Labs feature in Google calendar. Here are three features you probably didn’t know about, but should use from Google labs. Hide Morning and Night Do you have meetings at 2 am? Likely not. There is no reason to see