Videos uploaded by user “Chris Menard”
Import Calendar Events from Excel into Google Calendar by Chris Menard
Here is how you import events into a Google Calendar. Simply save the excel file as a CSV fiile, which is also shown in the video.
Views: 32425 Chris Menard
MS Word - Odd and Even Page numbers using Headers and Footers by Chris Menard
Chris Menard shows you how easy it is to duplex or print two-sided in Microsoft Word. The odd page numbers should be aligned to the right, and the even page numbers should be aligned to the left. Start with a Word Document that has at least two pages. ****************************************************** Chris Menard provides onsite Microsoft office training in metro Atlanta.
Views: 41673 Chris Menard
Create a PivotTable in Excel using multiple worksheets by Chris Menard
You can create a PivotTable in Excel using multiple worksheets. The key is to turn the ranges into Tables. Chris Menard is a Microsoft Office Master Instructor. He is also a public speaker on technology products. His clients include: * The University of Georiga Executive MBA students. * Mizuno USA * Gwinnett Medical Center * The Georgia Society of CPAs.
Views: 24421 Chris Menard
Table of Contents in two columns in MS Word - Chris Menard
How do you create a table on contents in Microsoft Word in two columns? Chris Menard, Microsoft Office Master Instructor, demonstrates how to do 2 column TOC
Views: 12614 Chris Menard
Sum up hours and minutes in Excel by Chris Menard
If you need to total hours and minutes in Excel, you need to add an open and closed bracket around the h for hours. Here is a sample Excel file if you get stuck. https://1drv.ms/x/s!AlMvSeFCSQ84iIpQlvenBhahDXGDZQ www.chrismenardtraining.com
Views: 30819 Chris Menard
Using Excel's Subtotal Function with Filters in Excel
When using filters in Excel, the functions average, max, min, and sum will give you the wrong answer since they include the hidden rows. Use the Subtotal function to get the correct answer. =Subtotal(1,range) will give you the Average for what is visible. 1 is average 4 is max 5 is min 9 is total Chris Menard - Microsoft Office Master Instructor. Contact Chris for training for your organization.
Views: 14577 Chris Menard
Excel how to use a 3D reference to add worksheets by Chris Menard
Chris Menard shows you the correct way to add multiple worksheets using a 3D Reference in Excel. This works in any version of Microsoft Excel. Chris provides on-site instructor led training.
Views: 23195 Chris Menard
Create Labels in Microsoft Word that autonumber
You need labels for Student 1, Student 2, or Runner 1, Runner 2, etc....Do you mail merge in MS Word but make your data source in Excel. All mailmerges are done in MS Word.
Views: 11795 Chris Menard
Excel Vlookup showing false and true arguments
Short 2:18 video showing excel's Vlookup and when to use false for an exact match and true for a range. Chris Menard does Microsoft Office training in Atlanta, Georgia Related videos: Index and Match function for advanced lookup by Chris Menard. https://www.youtube.com/watch?v=T3FPvFX8tN8
Views: 19124 Chris Menard
Mail Merge Envelopes with Microsoft Word by Chris Menard
1)In Word, choose File / New / Blank Document. 2) On the Mailings tab, in the Start Mail Merge group, choose Start Mail Merge / Envelopes. 3)Size 10 envelope should appear on your screen. If not, change to size 10. Click OK. 4) In the top left corner of the envelope, type in a return address if necessary. If using pre-printed you can still add your department or name in case it is returned. 5) Choose Select Recipients then Use an Existing List. Locate your saved Excel file. Pick Open and pick the correct worksheet. 6) Place your cursor were you want the address block to go. If you have show paragraph marks turned on, click immediately after the paragraph mark (¶) that Word has placed in the middle of the envelope. 7) On the Mailings tab, in the Write & Insert Fields group, choose Address Block. In the Insert Address Block dialog box, choose a format for the recipient's name as it will appear on the envelope. If necessary, On the Mailings tab, in the Write & Insert Fields group, choose Match Fields. 8) Choose Preview Results, and then choose the Next or Previous record button to make sure the names and addresses on all the envelopes look right. 9) Choose Finish & Merge / Edit Individual Documents, make sure All is selected and click OK.
Views: 6439 Chris Menard
Convert decimals to time in Excel by Chris Menard
To make 7.5, which is a decimal to 7:30 as hours and minutes, you simple divide 7.5 by 24 and format the cells as h:mm. www.chrismenardtraining.com Providing Excel training in Atlanta, Cobb County, Gwinnett County, Roswell, Smyrna, and other locations.
Views: 4672 Chris Menard
Microsoft Word - add the filename and path in the footer by Chris Menard
Use Microsoft Word Quick Parts to put in the filename and path in the footer of a Word 2007, Word 2010 or Word 2013 document.
Views: 21754 Chris Menard
Excel data validation list based on another data validation list
Here is how you create one data validation list in Excel based on another data validation list. Example: if you select one state, you only want to see the counties for that state not all 50 states.
Views: 6235 Chris Menard
Mail Merge with Outlook, Word, and Excel by Chris Menard
Mail Merge with Outlook is a great way to personalize your email messages. This is great for vendors, customers, contractors, and employees. A personalized email has a greater chance of being read than an email to 500 people with them on the TO or BCC line.
Views: 4220 Chris Menard
Mail Merge with Grouping in MS Word by Chris Menard
Need to group records in MS Word wth a Mail Merge? It can be done using a Directory and typing in the fields with CTRL + F9. This is the longest video I have made. Most of my videos are under 2 minutes. It is so long because I had to type the fields. Feel free to use the bookmarks below. Hope it helps. 00:12- Excel file 00:57 - Word - blank doc Mailing - Directory 01:30 - Excel sort by what you want to group by
Views: 35311 Chris Menard
Cost-Volume Profit Analysis / Breakeven analysis in Excel with multiple products by Chris Menard
If you need to find the breakeven point in Excel with one product, it is fairly easy. It gets tricky with multiple products. This is how to get the weighted average contribution margin and calculate the break-even in units with 2 or more products. This is used for Cost-Volume-Profit Analysis. Cost-Volume-Profit Analysis with multiple products. The contribution margin is a company's sales less its variable expenses. Then, divide the company's fixed costs by the contribution margin. This will give you the company's break-even point in total dollars of sales. To create a cost-volume-profit (CVP) Chart or Breakeven-Analysis Chart, see my video https://www.youtube.com/watch?v=1BDLh1jbB7U I train the Executive MBA students from the University of Georgia in Excel. Feel free to visit my website or sign up for my free class on Excel Tables. www.chrismenardtraining.com http://chrismenardtraining.teachable.com
Views: 4003 Chris Menard
Word - lose blank page after inserting envelope by Chris Menard
Need to lose a blank page after inserting an envelope in Word? Here are the steps: 1) Press Ctrl+Home to go to the top of the envelope. 2) Click the Layout tab of the ribbon. 3) Click the page dialog arrow in the lower right corner of the Page Setup group. 4) Click OK without changing anything. If Word complains about margins, click Ignore. 5) Press Ctrl+End to go to the blank page. 6) Press F4 to "redo" the page setup. The blank page should now be in envelope format too. 7) CTRL + Home 8) Turn on Show/Hide ¶ button is "on" in the paragraph group. 9) Click the section break and press Delete. 10) Turn off Show/Hide www.chrismenardtraining.com Microsoft Office Trainer / Instructor in Atlanta, Georgia
Views: 2614 Chris Menard
Cost-Volume-Profit analysis to determine the break even point / chart in Excel by Chris Menard
Need to find your break-even point and chart it in Excel? Chris Menard walks you through finding your contribution margin and break even in units and creating a chart. The contribution margin is a company's sales less its variable expenses. Then, divide the company's fixed costs by the contribution margin. This will give you the company's break-even point in total dollars of sales. I train the Executive MBA students from the Terry College of Business at the University of Georgia. The CVP and break-even chart was a request from an MBA student during one of my training sessions in Atlanta, Georgia. Related Videos: Vertical Analysis of an Income Statement https://www.youtube.com/watch?v=BmpbEVS4cP0 http://chrismenardtraining.com
Views: 22484 Chris Menard
Create a combo chart or two-axis chart in Excel 2016 by Chris Menard
If you have data in Excel that has a huge variance that you want to chart, you need to use a combo chart in Excel. A combo chart will have two verticle axis. A primary axis and a secondary axis. www.chrismenardtraining.com
Views: 7319 Chris Menard
Excel - use the Median function in a PivotTable by Chris Menard
PivotTables do not allow median function. I 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. Chris Menard is an Excel instructor in Atlanta. http://chrismenardtraining.com Just some of Chris Menard clients: Georgia-Pacific Mizuno USA Clayton County Water Authority Clayton College & State University Georgia Society of CPAs University of Georgia
Views: 2070 Chris Menard
Create a Directory in Microsoft Word using Mail Merge by Chris Menard
This video shows you how to create a directory in Microsoft Word. Think of a directory as an interoffice phone directory for a company. To create a directory, you should have your data source in Excel. Do the Mail Merge in Microsoft Word by going to Mailings tab, click Start Mail Merge and select Directory. Select Recipients and use your Excel data source. Insert the Merge Fields and and finally finish and merge.
Views: 36786 Chris Menard
Outlook 2016 print multiple calendars at one time by Chris Menard
Outlook 2016 will allow you to view multiple calendar at one time in overlay mode, but it will not print multiple calendars. To print multiple calendars, you must download and use the Calendar Printing Assistant for Outlook 2007. Outlook 2016 needs to be open when working with the Calendar Printing Assistant. You will need to tweak your registry using Microsoft support article 2898576. Note: Method 1 on the support article did not work for me. I had to use Method 2. Steps I did on my computer after I got the message "Setup cannot complete" when I tried to install the Calendar Printing Assistant for Outlook 1. Start Registry Editor. To do this, use one of the following procedures, as appropriate for your version of Windows: Windows 10 and Windows 8: Press Windows Key + R to open a Run dialog box. Type regedit.exeand then press OK. Locate and then right-click one of the following registry subkeys: 2. For a 32-bit version of Office that is installed on a 32-bit version of Windows HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\ProductVersion For a 64-bit version of Office that is installed on a 64-bit version of Windows HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Common\ProductVersion 3. Select New, and then click String Value. 4. Type LastProduct as the value name, and then press Enter. 5.Right-click the new LastProduct string value, and then click Modify. In the Value data box, type 14.0.6029.1000, and then click OK. 6. Exit Registry Editor. 7.Install the Calendar Printing Assistant for Outlook. After you install the Calendar Printing Assistant for Outlook, remove the LastProduct value. Note The value data version does not really matter. The Calendar Printing Assistant just checks whether the key exists.
Views: 14832 Chris Menard
Mail Merge for Gmail - Different attachments for each recipients by Chris Menard
You can use Gmail to perform a mail merge. The advantage of Gmail over Outlook is you can use an Add-on that is free to send different attachments to different recipients and you can also schedule delivery. Everything you need is free. A Gmail account, chrome, and google sheets which is part of Google Docs. Microsoft Outlook 2016 and previous versions of Outlook allow you to perform a mail merge also, but if you want to send an attachment it is all of nothing. Meaning every recipient gets the same attachments or they don't get any attachments. Another feature I noticed when doing the mail merge with Gmail is I can even customize the subject line. That is impossible with Outlook. Exact steps: 1. Sign into your Gmail account using Google Chrome. 2. Click on the icon for Google apps in the top right. Go to Drive. 3. When Drive opens up, click on New in the top left and select Google Sheets. 4. Click Add-ons then select Get Add-ons. Type in "mail merge with attachments" and press Enter. 5. It should be the first one. To the right click on Free and select Allow and it will be installed. 6. Click back on Add-ons and now
Views: 18977 Chris Menard
Create a Macro in Excel for printing by Chris Menard
When used right, macros can save you hours by automating simple, repetitive tasks. In my example, I'm frequently printing landscape with gridlines and I want header and footer information. To create a Macro you have to turn on the Developer tab. 00:35 - Turn on Developer Tab 01:09 Record Macro 03:10 Stop Recording Macro About Chris Menard **************** Chris Menard provides instructor-led training classes in Atlanta and other cities in the United States.
Views: 21832 Chris Menard
Microsoft Excel create a mixed reference - F4 key to change references by Chris Menard
Chris Menard demonstrates how to use Excel's mixed reference in this short 90 second video. You can either type the dollar symbol or use the F4 function key to cycle through the references. An Absolute Reference looks like this $B$4. Both the column and row are frozen. A Mixed Reference looks like either $B4 or B$4. The first mixed will freeze column B since the dollar sign is in before the column. The latter will freeze row 4 since the dollar sign in before the row. Chris Menard does Microsoft training in metro Atlanta.
Views: 13226 Chris Menard
Create canned responses in Outlook by Chris Menard
Canned responses are a great way to quickly reply to an email. Unlike Out of Office assistance, you pick the messages you want to send a reply. www.chrismenardtraining.com
Views: 2785 Chris Menard
SyncBack Free for easy backup by Chris Menard
SyncBack is a great program for backing up files to USB or external hard drives. The free version for home users is shown in this video but the steps shown are used in all the versions of SyncBack for setting up your backup. What you need to do: 1) Create a profile (takes 15 seconds) 2) Pick source and destination (takes 45 seconds) 3) Make a schedule. (30 seconds) That's it! Your files are automatically backed up. No more worrying about losing files if your computer crashes or if you want to take a backup with you, just unplugged your external drive and off you go. One Note: a lot of people think they can only backup one folder at a time. I show in Step 2 when you pick you source and destination, pick your C drive for the source or your C drive and the user folder. After that pick Sub-directories. You can even backup OneDrive and Dropbox if installed which is cool. One more advantage of SyncBack, you can backup your harddrive folders to multiple cloud storage. Example: you can back up Documents and Desktop to OneDrive, Dropbox, and Google Drive. Instructions with screenshots I made is located here: http://www.trialityonline.com/News/Vi...
Views: 7007 Chris Menard
Create a Map chart in Excel 2016 by Chris Menard
Excel 2016 has a new Chart that rolled out in November 2016. It is a Map Chart. You can use it for countries, states, and counties to chart geographical data. www.chrismenardtraining.com Excel instructor-led training classes https://support.office.com/en-us/article/Create-a-Map-Chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b?ui=en-US&rs=en-US&ad=US
Views: 18015 Chris Menard
Backup vs. Synchronization (Sync) - Sync using Total Commander
This video shows the difference between a backup vs sycn. Windows by default can't sync. You need another program. I use Total Commander. What is the difference between a backup and sycn? Backup copies data from one location to another. Going from your laptop ro desktop to an extermal hard drive or flash drive is a backup. Synchronization makes sure that two locations, example desktop and flash drive, contain the same up-to-date files. If you add, change, or delete a file from one location, the synchronization process will add, change, or delete the same file at the other location.
Views: 4811 Chris Menard
Google Wallet - Send and Request money for free by Chris Menard
UPDATED: August 2018 - Google Wallet is now called "Google Pay". Still works the same. You can use the Google Wallet to send and request money for free. The Google Wallet works on both a computer and smartphone. www.chrismenardtraining.com Linkedin
Views: 3711 Chris Menard
How to add percentages to a PivotTable in Excel by Chris Menard
To add percentages to a PivotTable in Excel, right click the field and use Show Value As. Pick Percentage of Grand Total. www.chrismenardtraining.com http://chrismenardtraining.teachable.com
Views: 2687 Chris Menard
Conditional Formatting with Countif in Excel by Chris Menard
To use Conditional Formatting in Excel. Select your data range, on the Home tab click Conditional Formatting.
Views: 2905 Chris Menard
Excel Scenario Manager for budgeting and forecasting by Chris Menard
Use Excel's Scenario Manager to create different groups of data you can switch to quickly. Example: original budget and updated budget. Another example: new product and you want to know what happens if you sell more units, increase or decrease price or cost. I recommend naming the cells or range but it isn't requried. The changing cells are input cells and the cells with formulas or functions are dependent cells. You can even create a summary of your changes.
Views: 3991 Chris Menard
Excel Max and Large to find unique values (ignore duplicates) by Chris Menard
Excel's Max and Large and Small function are great. But if the max value has duplicate numbers, the 2nd largest will return the same answer as the max. To ignore duplicates and find the unique 2nd value you can you the Large function with an If statement as an array function. An array function is entered by CTRL + SHIFT + ENTER on the keyboard. The same would apply to the Small function.
Views: 1854 Chris Menard
Word make heading 1 always show at the top of a page by Chris Menard
In Microsoft Word, you can format your heading 1 styles to always be at the top of a page. Use paragraph dialog box / line and page breaks tab / check page break before.
Views: 943 Chris Menard
Using Mentions in Outlook by Chris Menard
There is a new feature in Outlook 2016 called Mentions. When you type an email, in the body of the email just type @name and Outlook will fill in the TO line with the name of the person. When the person receives the email, there name is in blue so they can quickly see what they need to do. www.chrismenardtraining.com
Views: 2770 Chris Menard
Remove Duplicate pictures or photos with Easy Duplicate Finder by Chris Menard
Need to remove those duplicate files or pictures all over your computer? Easy Duplicate Finder is what I have been using for a couple years. This comes in handy when your hard drive is full of duplicate pictures or videos. I'm using version 2.4 in this video. Steps: 1. Select the directory or folder you want to scan. 2.Add a File Type if you want by selecting Define Masks for Include. Example would be .jpg 3.Click Start 4.Decide which duplicates to remove. One great advantage of Easy Duplicate Finder is it can be loaded on a flash drive or external hard drive. Just copy and paste the folder after you unzip it. Now you can use at your client's computer to remove duplicate files.
Views: 3660 Chris Menard
Mail Merge in Word with Grouping records by Chris Menard
https://youtu.be/DtPApM1Fv3k Video where I type the code from start to finish. This short video demonstrates how to group records and do a Directory mail merge in MS Word. You must TYPE in the field codes. CTRL + F9 will insert the braces. I figured this out from Microsoft's support kb/294686. It works in all versions on MS Word. Here is my YouTube video where I type in the field codes. It is https://www.youtube.com/watch?v=DtPApM1Fv3k It does works. You just have to type in the field codes correctly.
Views: 39943 Chris Menard
Microsoft Dictate in Word, Outlook, and PowerPoint by Chris Menard
Microsoft has a new feature called dictate. It is available for Office 365 subscribers. It works in Microsoft Word, Microsoft Outlook, and Microsoft PowerPoint. Instead of typing just Dictate. ******* Chris Menard is a Microsoft Office Master Instructor. Client list includes Georgia-Pacific, Coca-Cola in Atlanta, Mizuno USA, The Georgia Society of CPAs, Gwinnett Medical Center, and many other clients. Chris specializes in Excel training in Atlanta. http://chrismenardtraining.com
Views: 1872 Chris Menard
MS Word - Cover page, TOC /  Roman Numerals and normal page numbering by Chris Menard
Need to write a training manual or personnel handbook? This video demonstrates how to not number the cover page, the table of contents (TOC) show with Roman Numerals, and the main pages show as normal numbering (pages 1 to 50). Microsoft Word document with: 1) Cover Page, 2) Table of Contents that has roman numerals (i, ii, etc...) 3) the main part of the document with regular numbering (1, 2, 3, etc...). The key to doing this is using "section breaks / next page" and turning off the "link to previous" in the header / footer. Remember your odd page numbers will be 1, 3, 5, etc...Even pages will be 2, 4, 6, of your main document. In the video I made, I had to put in a blank page after the Table of Contents so the 5th page of my document was page 1. I did not want page 4 to be page 1. If you aren't printing two-sided or duplex this isn't that big of a deal, but I like to create my Word documents correctly. Chris Menard is a Microsoft Office Master Instructor. www.chrismenardtraining.com
Views: 6817 Chris Menard
Vertical Analysis of an Income Statement in Excel by Chris Menard
A vertical analysis is used to show the relative sizes of the different accounts on a financial statement. www.chrismenardtraining.teachable.com www.chrismenardtraining.com Target audience: Accounting students MBA students department managers business people Finance students
Views: 5668 Chris Menard
Windows Taskbar - add or pin items to taskbar including Dropbox folders and Computer
Certain items such as Computer, Network Folders and Dropbox Folders can't be added or pinned to the Windows Taskbar by drag and drop. You can get around this limitation by making your own shortcut and icon and adding to the Taskbar.
Views: 3850 Chris Menard
Redact a word or phrase in Adobe Acrobat Pro DC by Chris Menard
In Adobe Acrobat Pro DC you can search through the entire pdf and redact a word or a phrase. www.chrismenardtraning.com
Views: 4101 Chris Menard
Excel Subtotals with Conditional Formatting by Chris Menard
When you use Excel's Subtotal feature on the data tab, you can sum, average, max, min, groups of data. The issue is the subtotal looks like the rows above it. To make it stand out, you can use fill color. In this video, I show you two ways to add the fill color. My preferred method is using ISFORMULA function with Conditional Formatting. http://chrismenardtraining.com Microsoft Office Master Instructor Chris Menard
Views: 935 Chris Menard
Build an index in Word using a concordance file by Chris Menard
If you have a long Word document, you should have a training manual at the end of the document.
Views: 487 Chris Menard
Many to One Mail Merge in Word using Graham Mayor's Add-in by Chris Menard
Note: I did not create the Add-in tested in this video. I merely tested it to see if it was easy to use and if it worked. It does. I tested Graham Mayor's Add in today. It works. Microsoft Word's mail merge is designed to do one to one. So if you have three doctors with ten patients each and you wanted to print letters for the doctors, 30 letters would be printed. What Graham's add-in does is allow one letter for each doctor with all the patients for that doctor to show. Only three letters instead of thirty letters. Link to Graham Mayor's webpage: http://www.gmayor.com/ManyToOne.htm Chris Menard provides Microsoft Office training in Atlanta, Gwinnett, and other cities in metro Atlanta. http://chrismenardtraining.com https://chrismenardtraining.teachable.com/p/excel-tables
Views: 17835 Chris Menard
Redact a PDF file / remove sensitive information by Chris Menard
It is easy to redact a PDF file with Foxit Phantom PDF. In this video, I redact Protected Health Information (PHI) and even change the color of the redacted text from black to gray. To redact: 1. Click on the Protect tab. 2. Click Mark for Redaction in the Redaction group. 3. Draw a rectangle around what you want to redact. 4. Click Apply Redactions. 5. Click OK. Chris Menard provides Microsoft Office Training to companies in Atlanta, Gwinnett, Cobb, Roswell, Alpharetta, and many other metro Atlanta counties and cities. Website: www.chrismenardtraining.com
Views: 2101 Chris Menard
Import csv file with recurring events into Google Calendar by Chris Menard
When you import a csv file into the Google calendar, there is no way by default to handle recurring events or appointments. Examples would be birthdays. To get around this, I use Excel's Date function with the year, month, and day function. www.chrismenardtraining.com
Views: 5085 Chris Menard
Filter and Sort by multiple colors in Excel by Chris Menard
Microsoft Excel - to filter by more than one color in Excel, you need VBA code into a module. This also allows you to quickly sort by color without having to go to Data Sort. This question came from an MBA student at the University of Georgia in 2016. Specific Steps: 1. Start Excel. 2. Open the file you want to apply color (fill). 01:17 in video 3. ALT F11 to open VBA editor 4. Insert Module 5. Copy and Paste this into the module window Function ColorNumber(x As Range) As Integer ColorNumber = x.Interior.ColorIndex End Function 6. Close VBA 7. Back in Excel insert a column and give it a name. Example: ColorNumber 02:14 in video 8. Type the function you created =colornumber(cell reference) 9. AutoFill. 10. Now you can filter or sort by that column. **************************** Chris Menard is a Microsoft Office Master Instructor. Feel free to contact Chris for training for your organization. ****************************
Views: 6280 Chris Menard
Enter time in Excel without a colon by Chris Menard
To put in time in Excel and not have to use a colon, you can use TimeValue with the Left and Mid function in Excel. www.chrismenardtraining.com http://chrismenardtraining.teachable.com Online Excel Training with Chris Menard
Views: 6929 Chris Menard