Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
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
Microsoft Excel
To find the difference in years, months, and days between two dates in Excel use the Datedif function. This function will allow you put in the start date, end date, and decide the difference in years, months, or days. It is very handy for HR people. YouTube video on Dated
Why redact or remove sensitive content? Before you distribute a PDF, you should examine the document for the sensitive content or private information. Examples would include social security numbers, telephone numbers, addresses, etc…In Adobe Acrobat, use the Redact tools to remove or redact sensitive images and text that are
Microsoft
I find it aggravating when I click on a folder and there is nothing in it. If you have a lot of empty folders and want to delete them all at one time, here is an easy way. [Download this zip file](https://chrismenardtraining.com/Files/DownloadFile.aspx?FUID=7aa2840f-
Microsoft Excel
If you deal with sensitive information or Protected Health Information, you need to be very cautious with your data. Microsoft Office has a solution for those dealing with sensitive data. If you have an Excel file, PowerPoint presentation, or Word Document with sensitive information, you should encrypt the file with
Redacting tools allow you to remove or redact sensitive images and text that are visible in a PDF. Examples are phone numbers, social security numbers, Protected Health Information (PHI), and images. Redaction is the process of permanently removing visible text and graphics from a document. To redact information with Foxit