Excel Training - Advanced - 2014 Spring
Date and time
Location
University Library, B234 & B238 (Project Cafe PC Labs)
1970 Campus Dr Evanston, IL 60201Refund Policy
Description
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
*Note: the instructor Cynthia will stay after class to answer your specific questions-bring your files or examples if desired.
Thank you to the support from CME GROUP FOUNDATION.
Organized by
The Minor in Business Institutions offered by the Harvey Kapnick Center for Business Institutions is designed to provide Northwestern undergraduates with a rigorous introduction to business and management fundamentals. The minor is open to all Northwestern undergraduates regardless of major or home school. The minor allows them to build on the set of skills and knowledge they have acquired through other Northwestern coursework to prepare for employment in the business world. It also allows students to connect their study of business and management fundamentals to broader areas of academic inquiry both by linking the study of principles of business and management to the social science scholarship that these principles are based on and by introducing students to social science and humanities scholarship on the cultural, political, philosophical, literary and social aspects of business institutions. Therefore, the minor is not meant to serve as narrowly conceived pre-professional training. Instead the minor offers a broad multi-disciplinary perspective on a significant area of inquiry in 21st century society. Students without extensive quantitative training are particularly encouraged to apply. The minor is designed so that such students can acquire the necessary quantitative background by completing four basic prerequisite courses in mathematics, statistics and economics.