CAPL 1025 - Microsoft Excel

1. Workbooks/Worksheets
2. Functions: AVERAGE, MIN, and MAX functions
3. Charts
4. Financial functionsPMT, PV, IPMT
5. Logical functions IF, TODAY, WORKDAY
6. AutoFilters and Custom AutoFilters
7. Data form
8. Excel Lists including subtotals, AVG, MAX, MIN, Grand Total
9. Hyperlinks
10. Look-up tables VLOOKUP, HLOOKUP
11. Multiple workbooks¿linked
12. Pivot Charts
13. Pivot tables
14. Query wizard
15. Range names
16. Summary Page
17. Text file

1. create simple spreadsheets.
2. format data using fonts, sizes, borders and backgrounds.
3. create a header and footer.
4. create column and 2-D and 3-D pie charts; resize and move embedded charts.
5. modify the properties of the chart.
6. format chart; insert drawing objects.
7. sort, filter data and insert subtotals in a list.
8. use a data form to enter, search for, edit, and delete records.
9. summarize a list using a PivotTable and a PivotChart.
10. format and edit worksheets.
11. modify the worksheet.
12. use charting features.
13. use functions, macros, and a customized toolbar.
14. Insert text, values, and formulas.
15. Insert, delete, resize, and freeze worksheet rows and columns.
16. Insert, move, rename, spell check, and print worksheets.
17. copy and paste formulas and functions.
18. work with absolute and relative references.
19. use logical and date functions.
20. create and apply styles and AutoFormat to a table.
21. audit, trace, and fix formulas.
22. consolidate information from multiple worksheets and workbooks.
23. create a lookup table.
24. create a workbook template.
25. create validation rules.
26. merge workbooks.
27. create, assign, edit, and print macros.

Courses and Registration