Microsoft recently made some significant enhancements to its Visio add-in for Excel, enabling users to create Visio diagrams from within Excel. Here's how it works.

When collaborating in Excel, sometimes the collaboration can be distracting. Here's how to make a static image so you can do your own work without interruption.

A treemap chart provides a hierarchical view of data and makes it easy to spot patterns. Learn how to create a treemap chart in Excel.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

New Excel Drop-Down Lists Excel’s dynamic, dependent drop-down lists are a fantastic solution for data management. These lists automatically adapt to your data, ensuring accuracy and efficiency.

After you've assembled all your financial data and created a worksheet to contain your income in one column and your expenses in another, you can use Excel's "SUM" function to create a formula to ...

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

In the rapidly evolving world of data analysis, AI tools like Microsoft Copilot, ChatGPT, and Zebra AI are transforming the way you work with Excel. These ...

The Data Analysis for Excel Video Series is designed to supplement Lesson 3 in the AQ-IQ curriculum. Learn about units of Air Quality PollutantsAQ-IQ Mentor Elise Mesenbring explains the concentration ...