Excel Training with Michael Bush '11 & Emily Niehaus '12
Saturday, October 5, 2013 from 11:00 AM to 3:00 PM (EDT)
This workshop will cover introductory and advanced Excel functionality, including entering and manipulating data, performing calculations, and using functions, charts and pivot tables.
Please note that this workshop will be focused almost exclusively on Excel for PCs and that PCs in Carson 61 will be used (reference materials, including a list of functions and shortcuts, will be provided for Macs).
Schedule of topics to be covered (estimated times provided):
11:15am to 12:30pm (1hr 15mins) - Basic Excel techniques
- Microsoft Office Shortcuts
- Efficient Navigating & Viewing
12:30 to 1pm (30mins) - Lunch will be served
1pm to 3pm (2hrs) - Advanced Excel techniques*
- Filter & Sort
- Pivot Tables
* Additional topics to be covered if time allows: Formula Auditing, Goal Seek, Data Validation, Dynamic Transpose
Michael Bush '11
Michael Bush is a Senior Associate with the Parthenon Group, a strategy consulting firm based in Boston. He joined the firm in the fall of 2011 after graduating from Dartmouth and has done extensive work in the Private Equity, Education, Industrials and Healthcare practices. He is currently building a financial model in excel to test the profitability of a number of acquisitions for an industrial battery manufacturer. At Dartmouth, he was captain of the Club Tennis team, Circulation Director of The Dartmouth and a member of Alpha Delta. Mike grew up in Madison, WI and now lives in Boston’s Downtown Crossing.
Emily Niehaus '12
Emily Niehaus is an Associate with the Parthenon Group, a strategy consulting firm based in Boston. She has been at the firm for a year and focuses in the Private Equity and Healthcare practice. She is currently working on an excel model to help a healthcare wellness company improve profitability by decreasing COGS. Emily graduated Dartmouth in 2012 with a degree in Psychology and Geography. At Dartmouth, she volunteered as a ski patroller at the Dartmouth Skiway and played Club Soccer. Emily currently lives in Boston’s Beacon Hill.
When & Where
Nelson A. Rockefeller Center for Public Policy at Dartmouth College
The Rockefeller Center for Public Policy at Dartmouth College is a catalyst for teaching, research, and deliberation about public policy. Dedicated to providing an interdisciplinary perspective on policy-related topics, the center fosters a commitment to the ideals of public service and informed public debate exemplified by the man for which the Center is named, Nelson A. Rockefeller.
The Center inspires and energizes students to become effective leaders in their communities & to cherish and participate in democracy.
Connect with Rocky online!