Excel Topics

Where to find tutorials on popular Excel topics, here on the Contextures site

Excel Charts

Add visual impact to your Excel workbooks, by adding simple or complex charts. See how to get started, by building simple Excel charts, such as a pie chart or line chart. Then, after you know the basics, work on fancier charts, like a Cluster Stack Column chart, or a line chart with a target range.

To learn more, go to the Excel Charts topic page.

Excel Data Validation

Use the Excel data validation feature to create drop down lists on a worksheet. Or, use data validation rules to control what can be entered into worksheet cells.

To learn more, go to the Excel Data Validation topic page.

Excel Filters

Use AutoFilters and Advanced Filters to show specific data from a named Excel table, or a worksheet list.

• AutoFilters are built into the heading row for named Excel tables, and they are easy to use.
• Advanced Filters are applied through a command on the Ribbon's Data tab. It's harder to set up an Advanced Filter, but the benefit is that you can use complex criteria, above the limits of an AutoFilter.

To learn more, go to the Excel Filters topic page.

Excel Formatting

Format worksheet cells manually, to identify data entry or formula cells. Or, use conditional formatting, to automatically highlight key values on a worksheet.

To learn more, go to the Excel Formatting topic page.

Excel Formulas

Use Excel formulas and functions to summarize data, return values from a lookup table, do mathematical calculations, and much more!

To learn more, go to the Excel Formulas topic page.

Excel Macros

Use Excel macros to automate routine tasks, so you can save time while you work. Record and edit your own macros, or use code that you find here on my Contextures site.

To learn more, go to the Excel Macros topic page.

Excel Pivot Tables

Use Excel Pivot Tables to quickly summarize data from a list or Excel table. See how to get started, then learn more about the power of pivot tables!

To learn more, go to the Excel Pivot Table topic page.