Microsoft Office Blog by Chris Menard

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.

Gmail: Multiple signatures in Gmail using canned responses

Gmail's canned responses will allow you to use use multiple signatures. You can use multiple signatures for new emails or replies.

Import Excel into a Google Calendar

Need to take events and appointments from Excel and add them to a Google Calendar? It is very easy.

PowerPoint: 3D models - New Feature for Office 365 Subscribers

PowerPoint: latest feature for Office 365 subscribers. Insert animated 3D graphics to see hearts beat, planet orbit, and T-Rex rampage across slides.

Merge and Center

Merge & Center in Excel is evil. I recommend you never use it. Merge & Center causes issues with sorting, removing duplicates, and selecting.

How to get and transform data in Microsoft Excel

One of Excel 2016's best features is Get and Transform data using the Power Query Editor on the Data tab. It changes crosstab data to flat data.

Microsoft Word – Mail Merge with If…Then… Else statement

You can use Word's If...Then...Else to make a mail merge field have a condition. If one thing occurs, do this. If it doesn't occur, do something else.