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.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Unlike traditional static reports, interactive dashboards leverage Excel’s features to create an engaging user experience where data can be filtered, sorted, and analyzed in real-time.

How to Create an Employee Calendar in Excel. When you own or manage a small business, you may need to track employees' vacation times, hours worked or shifts scheduled.

Microsoft Excel lets you swiftly create a variety of useful records to log sales calls, service calls and other kinds of call information you need to run your business. In just a few minutes, you ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

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

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.