Home > Excel Topics Excel Topics Here's a list of the main Excel topics that I cover. For each topic, there's a short description, and a link where you can find detailed tutorials and videos, for that topic, here on my Contextures site

1) Excel Charts

Add visual impact to your Excel workbooks, with simple or complex charts. To get started, build 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.

2) Excel Data

Tips for Excel data entry, sorting, tables, sample data. Fix date problems, add or remove line breaks, avoid copy paste problems, troubleshoot, and more.

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

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

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

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

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

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

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

9) Excel Structure

Tips and templates, for Excel workbooks, worksheets, names, comments, and objects. Troubleshoot errors, add comments, set up named ranges, freeze panes, and more.

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

Get Monthly Excel Tips! Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up. Next, when you get my reply, please click the Confirm button. I add this step to protect you from spam!

Excel Topics Data Validation | Pivot Tables | Formulas | Data | Macros | Format | Charts | Filters | Structure