Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Tools
Always lock your computer. It is time for lunch, and the lunch crowd has gathered and is waiting on you. You missed breakfast, and you are hungry. You get up from your desk and head out the door. Did you remember to lock your computer? It is amazing to me
Microsoft Outlook
To import an Excel file that has contact information into Outlook, there are three main steps: 1. Save your Excel workbook as a .csv file. 2. Import your contacts. 00:56 in the video 3. Map the Excel spreadsheet columns with the appropriate Outlook fields. 01:35 in the video
Microsoft Excel
When you import data into Excel, occasionally a column of data will only have a key field listed one time. An example would be States only showing once at the start of each data set. See the image below. _Notice_ **column A**. It only displays the state for the first
Microsoft Word
In Microsoft Word, to print two-sided or duplex printing, your page numbers need to be aligned to the right on odd pages and to the left for even pages. To do this in Word, you turn on Different Odd and Even headers/footers. Steps to creating Odd and Even
Microsoft Word
Microsoft Word performs a One to One mail merge by default. This means if you have five sales reps and each rep has 5 new potential leads, when you do a mail merge, each rep will receive five letters. That is 25 letters when ideally, you only want to send
Microsoft Word
Microsoft Word comes with plenty of predefined text watermarks. Among them are Draft, Confidential, Do Not Copy, Sample, Urgent, and ASAP. When you create a watermark it is in the center of the page by default. You can change the font, size, and color of any watermark. If you don’
Microsoft PowerPoint
PowerPoint has a new feature called QuickStarter. I think it is awesome! PowerPoint QuickStarter solves this problem by building an outline for you with suggested sections, talking points, and properly attributed Creative Commons images to help get you started. It doesn’t create a finished product for you, but it
Microsoft Excel
When you enter zip codes in Excel, the leading zeros will get dropped. Here are some examples. Massachusetts starts with 01 and 02. Hew Hampshire is 03, Maine is 04, Vermont is 05, Connecticut 06, and New Jersey is 07 and 08. So when you type in the zip codes
Microsoft Excel
Conditional formatting is one of my favorite features in Excel. I like it because I’m a visual person. Excel has a lot of predefined rules in Conditional Formatting, but it is very easy to write a formula if the predefined rules don’t have what you need. An Executive
Microsoft Excel
You can use data validation to restrict the type of data or the values that users enter into a cell. An example would be if you have a column for Departments, and someone puts in Accounting but another person types in Acct. (abbreviating Accounting). Data validation keeps bad data from
Microsoft Excel
There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, **absolute references** do not change when copied or filled. You can use an absolute reference to keep a row and/or column **constant**. The keyboard shortcut for absolute reference is
Microsoft Excel
Excel has built-in custom lists. You can sort data by days of the week or months of the year. Or create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically, such as July to June; October to September; S, M, L, XL.