Microsoft Excel

Create a treemap in Excel to spot patterns

Chris Menard

03 Feb 2017 — 1 min read

Why use a treemap in Excel?

A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store’s best sellers. The tree branches are represented by rectangles and each sub-branch is shown as a smaller rectangle. The treemap chart displays categories by color and proximity and can easily show lots of data which would be difficult with other chart types. The treemap chart displays categories by color and proximity and can easily show lots of data which would be difficult with other chart types.

Video of creating a treemap

Create a treemap in Excel 2016 by Chris Menard - YouTube

Read more

Microsoft Teams: Save Chat and Channel Messages is Back!

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.

Master Microsoft Teams Follow Threads to Boost Your Productivity

Master Microsoft Teams Follow Threads to Boost Your Productivity

As a Microsoft MVP and certified trainer, I’m always excited to share the latest productivity tools that help you work smarter. If you’re a frequent Microsoft Teams user, you’ll be thrilled to hear about the new Teams Follow Threads feature rolling out in public preview as of

Summarize Outlook Attachments with Copilot

Summarize Outlook Attachments with Copilot

Managing emails efficiently is crucial, especially when it comes to handling attachments. I demonstrate an exciting new feature that has rolled out in Microsoft Outlook’s Copilot — the ability to summarize Outlook attachments with Copilot. While Copilot has long been capable of summarizing email bodies, this new enhancement now extends