Excel Training - Advanced - 2021 Fall

Excel Training - Advanced - 2021 Fall

Excel Advanced Workshop for Northwestern Undergraduates

By Kapnick Center for Business Institutions

Date and time

Thursday, October 28, 2021 · 5:30 - 9:30pm CDT

Location

Northwestern University Technological Institute

2145 Sheridan Rd TCHMG51 (Tech PC Classroom - MG51, Wing M, Ground Floor/Basement) Evanston, IL 60208

Refund Policy

Refunds up to 7 days before event
Eventbrite's fee is nonrefundable.

About this event

THIS WORKSHOP IS FOR NORTHWESTERN UNIVERSITY STUDENTS ONLY.

*All cancellations must be processed by Tuesday, October 26 @ 12:00 PM (CT) to receive a refund (Eventbrite fees are non-refundable).*

*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 Lists (a flat database of data in Excel)

  • 
What is a structured list

  • Format as a Table - new list capabilities
  • 
Sort a list using several techniques

  • Add subtotals to worksheets without writing any formulas
  • 
Use the AutoFilter to display only the records that meet one's criteria
  • 
Examine the new filtering options for Dates and Numbers

  • Create Pivot tables and Pivot Charts to summarize a data list

Large Spreadsheet


  • Hide/unhide columns, rows & sheets
  • 
Freeze panes & print titles (review)

Multiple Worksheets

  • 
Grouping worksheets for moving, copying or printing

  • Use 3-D formulas to add up through sheets to a summary sheet

  • Links to perform calculations on data from multiple worksheets and/or workbooks

Additional Functions to have in your “bag of skills” for the workplace


  • Naming ranges for functions

  • IF statements

  • VLOOKUP function

  • DATE360 function

  • PMT & FV functions

  • CONCATENATE, LEFT, RIGHT, & MIDDLE functions

Northwestern is closely monitoring developments related to the coronavirus (COVID-19) pandemic and will follow local, state, and University guidelines for this activity. All attendees are required to have been fully vaccinated or receive a weekly COVID during the time they are on campus, as well as comply with all other University safety protocols that are in place at the time of the event. Attendees unwilling or unable to abide by these requirements should not come to campus.

Organized by

Kapnick Center for Business Institutions

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.

Sales Ended