Description:
Excel can be customized to suit the user's preferences and work habits. Discover how to adjust the input options, document view settings, interface, ribbon, and Quick Access toolbar.
Target Audience:
Duration: 00:19
Description:
Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.
Target Audience:
Duration: 01:01
Description:
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, translate data, and keep tables up-to-date in Excel.
Target Audience:
Duration: 00:44
Description:
A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.
Target Audience:
Duration: 00:59
Description: Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
Target Audience:
Duration: 01:03
Description:
Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, solve problems, and prevent duplicate values.
Target Audience:
Duration: 00:39
Description:
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.
Target Audience:
Duration: 00:44
Description:
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
Target Audience:
Duration: 00:33
Description: In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
Target Audience:
Duration: 00:28