$100 – $150

Excel Intermediate/Advanced Class

Event Information

Share this event

Date and Time

Location

Location

Bay Park Hotel

1425 Munras Avenue

Monterey, CA 93940

View Map

Friends Who Are Going
Event description

Description

MS Excel Intermediate/Advance class:

Microsoft Excel is the most used spreadsheet application worldwide. PMI mBay chapter is offering an intermediate / advance Excel class on 2/17/2018. This hands-on class will prepare learners to link workbooks to manage larger data sets, work with table data, create custom filters and use PivotTables.

Prerequisites:

· Familiarity with the Microsoft Office Excel.

· Understanding of cell references and formulas .

This class has a particular audience: people who want to manipulate data. Pre-requisites are a basic working knowledge of Excel 2010, 2013, or 2016. These basics include mastery of the grid system (cell addressing), the manipulation of how worksheets look, and simple formulas. You will need to bring a laptop with one of these versions. Feel free to bring problem spreadsheets; if they fit one of the topics we will try to address them.

Topics will include Excel tables and pivot tables in depth, using multiple tables together, graphing of tables, and how to fix a variety of Excel quirks.

Instructor :

William Wiltschko:

Harvard Business SchoolMBA, Marketing and technology

Yale UniversityBS with honors, Engineering - control theory

The instructor began using Excel in late 1990, taught Excel at CSUMB, and has been an Excel power user for twenty years. He has written hundreds of macros and managed hundreds of tables. He is an engineer, MBA, and software designer, a certified PMI-ACP, and past president of the PMI Monterey Bay Chapter.

Share with friends

Date and Time

Location

Bay Park Hotel

1425 Munras Avenue

Monterey, CA 93940

View Map

Save This Event

Event Saved