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
|