Description:

THIS WORKSHOP IS ONLY AVAILABLE TO NORTHWESTERN UNIVERSITY STUDENTS.

Advanced Excel for Business Institutions

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

In the Advanced Excel course you will learn:

Working with List (flat database of data in Excel)
o What is a structured list
o Format as a Table - new list capabilities
o Sort a list using several techniques
o Add subtotals to worksheets without writing any formulas
o Use the AutoFilter to display only the records that meet one's criteria
o Examine the new filtering options for Dates and Numbers
o Create Pivot tables and Pivot Charts to summarize a data list
Large Spreadsheet
o Hide/unhide columns, rows & sheets
o Freeze panes & print titles (review)
Multiple worksheets
o Grouping worksheets for moving, copying or printing
o Use 3-D formulas to add up through sheets to a summary sheet
o Links to perform calculations on data from multiple worksheets and/or workbooks
Additional Functions to have in your “bag of skills” for the workplace
o Naming ranges for functions
o IF statements
o VLOOKUP function
o DATE360 function
o PMT & FV functions
o CONCATENATE, LEFT, RIGHT, & MIDDLE functions