Northwestern Events Calendar

Apr
17
2014

BIP Excel (Advanced) Training - Thursday

When: Thursday, April 17, 2014
5:00 PM - 9:00 PM CT

Where: University Library, B182 (MAC Lab), 1970 Campus Drive, Evanston, IL 60208 map it

Audience: Student - Graduate Students

Cost: 25

Contact: BIP   (847) 491-2706

Group: Kapnick Center for Business Institutions

Category: Academic

Description:

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

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

More Info Add to Calendar

Add Event To My Group:

Please sign-in