Whenever you create a Microsoft Excel workbook, you should always take the necessary steps to make it accessible to everyone, especially if you plan to share your work with others. In this guide ...

The Box and Whisker Chart shows the distribution of data into quartiles. Learn how to create a Box and Whisker Chart in Excel properly.

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 Multiply Boxes in Excel. Microsoft Office Excel includes a wealth of function options when entering data in to your spreadsheet. For instance, if you want to multiply a pair of cells or ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Learn how you can make use of Name Box in Excel. The purpose of Excel Name Box is to help reduce the time taken while working with columns, cells, rows & ranges.

Here's a quick tip for creating a Microsoft Excel drop down list from another tab.

To create dynamic dropdown lists, you typically need to use named ranges and the INDIRECT function in Excel. The function references a range of cells that change based on what you selected in the ...

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 collection includes nearly 100 lectures and more than eight hours of training to help a complete spreadsheet novice get comfortable and innovate in the Excel environment.