Northwestern Events Calendar

Jan
30
2020

Kapnick Center - Excel Training (Advanced)

Advanced Excel

When: Thursday, January 30, 2020
5:30 PM - 9:30 PM Central

Where: Technological Institute, MG51 (lower level), 2145 Sheridan Road, Evanston, IL 60208 map it

Audience: Student

Cost: $30

Contact: Kapnick Center for Business Institutions   847.491.2706

Group: Kapnick Center for Business Institutions

Category: Academic

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

Register More Info Add to Calendar

Add Event To My Group:

Please sign-in