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
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
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.
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
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 Word
After you insert an envelope in Word, you end up with page 2 of your document being a blank page to type the letter. Page 1 is the envelope. Most of the time you only want the envelope and not the blank page. Steps for removing the blank page: 01.
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’