1. Working with Excel : Getting to know Excel ; Start Excel ; Tour the Excel window ; Work with Excel's ribbon ; Work with Excel's galleries ; Customize the quick access toolbar ; Customize the ribbon ; Work with smart tags ; Change the view ; Configure Excel options ; Add Excel to the Windows 7 taskbar ; Quit Excel
2. Entering and editing Excel data : Learning the layout of a worksheet ; Understanding the types of data you can use ; Enter text into a cell ; Enter a number into a cell ; Enter a date or time into a cell ; Insert a symbol ; Edit cell data ; Delete data from a cell
3. Working with Excel ranges : Select a range ; Fill a range with the same data ; Fill a range with a series of values ; Move or copy a range ; Insert a row or column ; Insert a cell or range ; Delete data from a range ; Delete a range ; Hide a row or column ; Freeze rows or columns ; Merge two or more cells ; Transpose rows and columns
4. Working with range names : Understanding the benefits of using range names ; Define a range name ; Use worksheet text to define a range name ; Navigate a workbook using range names ; Change a range name ; Delete a range name ; Paste a list of range names
5. Formatting Excel ranges : Change the font and font size ; Apply font effects ; Change the font color ; Align text within a cell ; Center text across multiple columns ; Rotate text within a cell ; Add a background color to a range ; Apply a number format ; Change the number of decimal places displayed ; Apply an AutoFormat to a range ; Apply a conditional format to a range ; Apply a style to a range ; Change the column width ; Change the row height ; Wrap text within a cell ; Add borders to a range ; Copy formatting from one cell to another.
6. Building formulas and functions : Understanding Excel formulas ; Build a formula ; Understanding Excel functions ; Add a function to a formula ; Add a row or column of numbers ; Build an AutoSum formula ; Add a range name to a formula ; Reference another worksheet range in a formula ; Move or copy a formula ; Switch to absolute cell references ; Toggle the formula bar on and off ; Troubleshoot formula errors
7. Manipulating Excel worksheets : Navigate a worksheet ; Rename a worksheet ; Create a new worksheet ; Move a worksheet ; Copy a worksheet ; Delete a worksheet ; Change the gridline color ; Toggle worksheet gridlines on or off ; Toggle worksheet headings on and off ; Set the worksheet tab color ; Set the worksheet background ; Zoom in on or out of a worksheet ; Split a worksheet into two panes ; Hide and unhide a worksheet
8. Dealing with Excel workbooks : Create a new blank workbook ; Create a new workbook from a template ; Save a workbook ; Open a workbook ; Arrange workbook windows ; Find text in a workbook ; Replace text in a workbook ; Check spelling and grammar ; Close a workbook
9. Formatting Excel workbooks : Modify the workbook colors ; Set the workbook fonts ; Choose workbook effects ; Apply a workbook theme ; Add a workbook header ; Add a workbook footer
10. Printing Excel workbooks : Adjust the workbook margins ; Change the page orientation ; Insert a page break ; Choose a paper size ; Set the print area ; Configure titles to print on each page ; Preview the printout ; Print a workbook.
11. Analyzing Excel data : Sort a range ; Filter a range ; Set data validation rules ; Convert a range to a table ; Create a data table ; Summarize data with subtotals ; Group related data ; Analyze data with Goal Seek ; Analyze data with scenarios ; Create a PivotTable ; Load Excel's analysis ToolPak
12. Visualizing data with Excel charts : Examining chart elements ; Understanding chart types ; Create a chart ; Add chart titles ; Add data labels ; Position the chart legend ; Display chart gridlines ; Display a data table ; Change the chart layout and style ; Select a different chart type ; Change the chart source data ; Move or resize a chart ; Add a sparkline to a cell
13. Formatting Excel charts : Format chart elements ; Customize a chart element background ; Set a chart element's outline ; Add effects to a chart element ; Apply a style to a chart element ; Apply a WordArt style to chart text
14. Adding and editing worksheet graphics : Draw a shape ; Insert a clip art image ; Insert a photo ; Insert a WordArt image ; Insert a SmartArt graphic ; Move or resize a graphic ; Crop a picture ; Format a picture ; Add a shadow or glow to a picture ; Add a reflection or 3-D effect to a picture ; Add an artistic effect to a photo ; Recolor an image
15. Collaborating with other people : Add a comment to a cell ; Protect a worksheet's data ; Protect a workbook's structure and windows ; Share a workbook with other users ; Track workbook changes ; Accept or reject workbook changes ; Send a workbook as an e-mail attachment ; Save Excel data as a web page ; Make a workbook compatible with earlier versions of Excel ; Collaborate on a workbook online.
