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
Why use sparklines? Excel 2010 brought us a new feature called Sparklines. Data presented in a row or column is useful, but patterns can be hard to spot at a glance. The context for these numbers can be provided by inserting sparklines next to the data. Taking up a small
Microsoft Excel
Why use a treemap in Excel? A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store’s best sellers. The tree branches are represented by rectangles and each sub-branch is shown as a smaller rectangle.
Microsoft Excel
Microsoft Excel has the number group on the Home tab that is frequently used. The number group has five commands on the bottom row. Going from left to right the commands are Accounting Number format, Percent Style, Comma Style, Increase decimal, and decrease decimal. 1. Accounting Number format 2. Percent
Microsoft Word
To perform a mail merge with Microsoft Word, you need a **data source** or a **mailing list**. The mailing list can be an Excel spreadsheet, a directory of Outlook contacts, an Access database, or an Office address list. It contains the records Word pulls information from to build the addresses
Microsoft Word
Microsoft Word - add the filename and path in the footer by Chris Menard - YouTube You should add the filename and path to a Word Document, so the next time you have to update it, you know exactly where you saved it from looking at the printed copy. I usually put
Microsoft Outlook
You can send an email message out to a contact group (distribution list), or just manually put everyone on the TO or BCC line, but if you want to personalize each recipient’s email message, you need to do a mail merge. Why would you want to do this? If
Microsoft Outlook
Outlook - turn off desktop alerts and notifications by Chris Menard - YouTube An Outlook Desktop Alert is a notification that appears on your desktop when you receive a new email message, a meeting request, or a task request. By default, Desktop Alerts are turned on. If you are doing a presentation
I love Gmail and I’ve been using if for over 10 years. One feature that Outlook has that I frequently use is called “Delayed Delivery”. Instead of sending an email at 3:45 pm, when it may not get read today and end up way down in the recipient’
Microsoft Excel
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. Array functions keep your Excel file smaller in size. In general, array formulas use standard formula syntax. They
Microsoft Excel
The **Countif** function in Microsoft Excel is one of the most popular functions in Excel you can easily master. I use Countif to figure out how many employees are in a certain state or how many customers placed an order for $100 or over. You can even use wildcards in
Microsoft Excel
Let’s say that you want to find out how long it takes for an employee to complete an assembly line operation or a nurse to give insulin after a blood glucose test, or a fast food order to be processed at peak hours. There are several ways to calculate
Microsoft Excel
Entering Military Time into Excel without having to enter the colon for each entry If you want to enter military time in Excel, such as 1300 for 1:00 pm or 1730 for 5:30 pm, Excel won’t do by default, but there are several ways to do make