Customizing Toolbars and Menus

• Displaying more buttons
• Hiding or displaying toolbars
• Personalized menus and toolbars
• Creating a new toolbar

Working with Dates

• Interpreting two-digit years
• Date functions
• Date formatting

Outlining

• Creating outline levels manually
• Creating outline levels automatically

Naming Cells

• Using the Name box to create a range name
• Naming cells by using existing row and column labels

Worksheet Functions

• Use SUM to add nonadjacent ranges
• Using the insert function command
• Nesting functions
• Simple vs. complex functions
• Using the PMT() function
• Using the IF() logical function
• Using the AND() Operator within an IF() statement
• Nested IF() statements
• Using the VLOOKUP() function

Linking

• Linking cells on the same worksheet
• Linking values between worksheets
• Linking cells in different workbooks
• Changing the link source
• Changing from a link to a value
• Breaking links

Working with Excel Lists

• Creating a list
• Sorting a list
• Using a data form
• Filtering a list
• Using advanced filtering

Using Database Functions with Lists

• Using the DSUM() function
• Using the DCOUNT() function
• Using the SUM() function