Description:
Excel can be customized to suit the user's preferences and work habits. Discover how you can adjust the input options, document view settings, interface, ribbon, and Quick Access Toolbar.
Target Audience:
Duration: 00:28
Description:
You can use formulas to extract and analyze data in your spreadsheet. Discover how to use the MAX, MIN, LARGE, and SMALL formulas, and work with VLOOKUP to cross-reference the contents of two lists.
Target Audience:
Duration: 01:09
Description:
Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.
Target Audience:
Duration: 00:52
Description:
Analyze data efficiently using Excel 2013. Discover how to work with PivotTables, including formatting, sorting, filtering, grouping, and using slicers. In addition, explore how to insert, modify, and analyze using PivotCharts.
Target Audience:
Duration: 01:19
Description:
Display your data visually using Excel's built-in charting features. Learn how to insert, label, and format a chart; create various types of charts; combine types of charts; create comparative charts; and insert and customize trendlines.
Target Audience:
Duration: 01:15
Description:
Learn how to use Excel 2013 for common tasks like calculating the interest on a loan, reaching a target value, solving problems, creating automatic reports, as well as finding, visualizing, and preventing duplicate values.
Target Audience:
Duration: 00:46
Description:
Increase your Excel 2013 mastery by learning about referencing cells, using data across worksheets, absolute and relative references, and named ranges. In addition, explore automatic updates, formula auditing, and formula errors.
Target Audience:
Duration: 01:09
Description: You can easily find specific data and format how data displays in Excel 2013. Learn how to use the Find and Replace tools, sort and filter data, and hide duplicate values. Explore freezing panes, grouping items, and creating an outline.
Target Audience:
Duration: 00:42
Description:
Excel 2013 is highly customizable when it comes to formats. Learn how to customize number, text, and date and time formats; create conditional formats; use conditional formatting tools; and apply color to the first new entry in a list.
Target Audience:
Duration: 00:39