Microsoft Tutorials

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.

Sunburst Chart in Microsoft Excel

The sunburst chart or multi-level pie chart is ideal for displaying hierarchical data. This short tutorial shows you how to create one.

Group Numbers in Excel and IFS and FormulaText functions

Need to group numbers in Excel? Shown are three methods for grouping numbers.

Webinar of Insights in Excel – Recording of live webinar

Insights in Excel: Insights will analyze your data and return interesting visuals about it in a task pane.

Insights in Excel - Get automated, fast, accurate analysis of your data

Insights in Excel is a new feature of Excel 2016 with an Office 365 subscription that give you fast, automated, insightful analysis of your data.

Excel – lose subtotal within subtotals in a PivotTable

Excel’s PivotTables are great, but sometimes we get subtotals within subtotals and you want to lose only the 2nd subtotal.

Extract email addresses from a text string in Excel

Extracting email address from a text string in Excel can be tricky. I made a video demonstrating three methods of extracting the email addresses.