Description:

*Prerequisite: Must have either previously taken Excel (Basic) Training course or show competency of topics taught in Excel (Basic) Training course.

Advanced Basics for BIP

In the advanced class you will learn:

1. Working with LIST (flat database of date in EXCEL)
2. What is structured list
3. Format as a Table-new list capabilities in 2007 (review)
4. Sort a list using several techniques
5. Add subtotals to worksheets without writing any formulas
6. Use the AutoFilter to display only the records that meet one’s criteria
7. Examine the new filtering options for Dates and Numbers
8. Create Pivot tables and Pivot charts to summarize a data list
9. Protect a workbook by enabling a password and locking cells to prevent unauthorized changes
10. Create Column, Bar & Pie charts (2-D/3-D)
11. Format charts with themes and styles
12. Change locations-on worksheet/on chart sheet
13. Large Spreadsheet
14. Hide/unhide columns, rows & sheets
15. Freeze panes & print titles (review)
16. Multiple worksheets
17. Grouping worksheets for moving, copying or printing
18. Use 3-D formulas to add up through sheets to a summary sheet
19. Links to perform calculations on data from multiple worksheets and /or workbooks
20. Additional functions to have in your “bag of skills” for the workplace
21. Naming ranges for functions
22. IF statements
23. VLOOKUP function
24. DATEDIFF function
25. PMT & FV functions
26. CONCATENATE, LEFT, RIGHT & MIDDLE functions