Excel 2010 Intermediate

Learn to navigate workbooks, rename and color-code sheets, insert and delete tabs, move, copy, and group worksheets, and link across workbooks while tracking results with the watch window.

Learn how to insert and delete worksheets in Excel 2010 using the insert tab or a right-click menu, with new sheets placed to the left of the current tab.

Group worksheets to print April and May together and format them simultaneously. Use Shift for contiguous sheets or Ctrl for nonadjacent ones, then ungroup by selecting another sheet.

Master the watch window to monitor running totals and formulas as you edit cells. Learn to link workbooks dynamically, tile windows, and watch multiple cells in real time.

Create three-dimensional range names across multiple sheets in Excel 2010, using define name, workbook scope, and name manager to support sums and hyperlinks.

Learn to insert hyperlinks to defined range names in Excel 2010, enabling navigation to team 1, team 2, or team 3, and even to other files.

Apply auto outline in Excel 2010 to quickly create multi-level outlines for rows and columns, revealing subtotals and grand totals with collapsible views.

Create subtotals in your spreadsheet using the data ribbon to sum quarterly values for each region and reveal a grand total with outline view.

Learn how to clear subtotals in Excel 2010, remove all subtotals, and revert to a data view without manually typed formulas, while the subtotal tool preserves the last settings.

Learn to use and customize Excel templates, accessing built-in and online options, saving your own templates, and working with loan amortization and event budget examples.

Learn how to share an Excel workbook for collaboration, enable multi-user edits, and monitor who has the file open. Manage change history, automatic updates, and conflict resolution prompts.

Enable track changes in Excel 2010, decide what to highlight, who edits, and which area to track. Review edits via the history tab or markers and accept or reject changes.

Learn to use the document inspector to reveal hidden properties, personal information, comments, and metadata in a workbook, and check compatibility with older Excel versions before sharing.

Learn to create embedded charts in Excel 2010, move and resize them, switch data ranges and chart types, and format and print charts on the worksheet.

Move a chart to a separate sheet using move chart, or press F11 to create a chart on its own sheet, while preserving any embedded chart on the original sheet.

Switch row and column data by selecting the chart, opening the design tab, and clicking switch row column to flip how data is read, placing months in the legend.

Select the chart, open the Design tab, use Change chart type, and switch to styles like bar, stacked bars, or a three dimensional area chart, then click OK.

Choose to print a chart by selecting the chart or the active sheet, print selected charts, understand embedded versus standalone charts, and compare readability on a sheet versus full-page prints.

Explore customizing 3d charts in Excel 2010 by adjusting the chart wall and floor fills, applying 3d rotation and perspective, and using right-angle axes to create picture charts.

Create 2D picture charts in Excel 2010 intermediate by replacing column fills with images of corn, tomatoes, and onions to visualize sales data.

Learn to add annotations in Excel 2010 intermediate by drawing lines and arrows with shapes, connecting an arrow from a text box to January, and keeping them linked when moved.

Learn to work with workbooks, create formulas across worksheets, use range names, apply outlines, subtotals, and build charts in Excel 2010. Collaborate by sharing workbooks and tracking changes.