Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Launching a PowerShell Script from Excel, Revisited We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell.

Learn how to make a flowchart in Microsoft Excel without using any external add-on - but with SmartArt Graphics or Shapes Tool.

Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.

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.

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

How to Create a MS Excel Script. Whether your company uses Excel for payroll and accounting purposes, project management or data collection, being able to automate common processes is hugely ...