Excel Advanced

Total Hours: 3

1. What are records and fields?
2. Using the Pick List to enter data
3. Defining and creating names
4. Using the Go To feature
5. Filter information using Auto Filter
6. Create a custom Auto Filter
7. Set up an Advanced Filter
8. Using labels to match criteria
9. Understanding “AND”/”OR” searches
10. Use number match/comparison criteria
11. Add records using Form
12. Finding data using the Form feature
13. Writing formulas:
    1. =DAVERAGE, =DCOUNT, =DMIN, =DMAX, and =DSUM
14. Sorting spreadsheet data
15. Creating a series
16. Create, edit and delete a Custom List
17. Using vertical/horizontal split windows
18. Arrange multiple documents on screen
19. Moving or Copying sheets
20. Insert and delete sheets
21. Copy data between Excel documents
22. Link data from one file to another
23. Understand linking between documents
24. Set or change Calculations options
25. Creating a Template
26. Adding and removing Passwords
27. Viewing and customizing toolbars
28. Recording and running macros
29. Creating a macro button
30. Adding custom menu to a toolbar
31. Assign a macro to a custom menu
32. Deleting menu items