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

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

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.

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.

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.

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.

Learn how to make custom templates in Microsoft Excel to save you time and effort when creating similar reports or spreadsheet data analysis ...

The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

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 ...

In Excel, custom input or error messages explain the rules for each field to prevent data-entry errors. Here's how to set them up in a spreadsheet.