Microsoft Office Blog by Chris Menard

Snagit: capture cursor, use callouts, and shapes by Chris Menard

Snagit allows you to capture the cursor and apply callouts and shapes to screenshots.

Snagit: Combine multiple images into one screenshot

Snagit 2019 allows you to combine multiple screen shots into one image. You can make the images either portrait or landscape.

Covert date to fiscal quarter in Excel

In Excel, to calculate the fiscal quarter that starts with a month other than January, use the CHOOSE function. We will look at fiscal years starting in July, October, and then April in this exercise.

Snagit 2019 Webinar on January 29, 2019

Snagit 2019 webinar with Chris Menard on Tuesday, January 29, 2019, at 7:00 PM ET. Learn how to capture regions, windows, and scrolling windows. In the Editor, use callouts, blur effects, and other features.

Be careful when averaging percentages

When averaging percentages, use caution. It is a common mistake to in data analysis.

Snagit: Grab Text from a screenshot

The Grab Text feature in Snagit allows you to copy text from images and screenshots.

Use What-If Analysis with Data Tables in Excel

Calculate multiple results by using a data table in Excel.

COUNTIF Function in Excel

One of the most powerful functions in Excel is the COUNTIF function. It counts the cells that meet a certain criteria.

Excel Loan Amortization for new car, new house, or refinance

Use Excel to create a loan amortization schedule. This is table to that shows each periodic payment on an amortizing loan (typically a mortgage or car loan).

Webinar on Excel Functions on 12/04/2018

Webinar on Excel function on Tuesday, December 4, 2018. Functions covered will include trim, count, average, median, large, countblank, and many other functions.

Outlook: Add buffer time between appointments / meeting

A new feature in Outlook 2016 with an Office 365 subscription allows you to add buffer time between appointments and meetings. This is an awesome new feature. You can use that time to check in with your team, get coffee, and answer critical emails.

Crop a picture to a specific size with Paint.Net

You can easily resize an image and keep the fixed ratio. This is handy for profile pictures on LinkedIn, Google, Microsoft or for an employer.