Questions? Read our FAQs
Questions? Read our FAQs
In this class, we will move beyond the basics of spreadsheet creation and manipulation. This fast-paced workshop covers a fair amount of material and will be most beneficial to those who already have intermediate understanding and use of Excel. The expectation is for participants to be able to leave and begin immediately using the new skills and concepts learned in their professional roles.
Topics will include data “cleaning”/troubleshooting and showing attendees how to use some of the more advanced features of Excel to assimilate, analyze and summarize data having multiple attributes. We will also develop Pivot Tables, advanced graphs, and create basic macros. Ideally, participants will learn how to effectively manipulate and streamline data to ultimately use in conveying “data stories” upon which business decisions will be based—participants will learn to present data in a way that allows leadership a clear understanding of their organization to begin having the right conversations. Class exercises will be utilized to facilitate understanding.
A basic understanding of the Excel spreadsheet layout and Pivot Tables
Common uses such as entering data into a blank spreadsheet and copying/pasting
An understanding of common functions such as SUM, IF, and VLOOKUP
Ability to create a graph from two or more sets of data points
Please bring a laptop with Microsoft Office 7 or 10 installed. It is also highly recommended that you bring a mouse.
Please download the macro feature prior to class and ensure that it functions properly (Note that the instructor uses a PC so Mac macro knowledge and troubleshooting will be limited).
Instructions for setting up the Developer tab for Macros:
This is an interactive class, and your participation and questions are encouraged.
Instructional Associate ,
Music performer, collaborator and educator. Data investigator and analytical thinker. Lover of art, music and the sea!
With the goal of equipping colleagues with new tools and techniques, Connor leads Excel workshops and bootcamp (on campus and online) for beginner through advanced concepts. As a data investigator, he has served on Instructional teams for Data Analytics PT classes and SQL Bootcamps. He brings experience from a variety of programming environments, from R to Python. He is always in pursuit of the "why behind the what" and in search of effective ways to communicate insights!
Connor has deep appreciation and respect for orchestral, chamber and jazz music. Having studied saxophone, woodwind studies and piano for 15 years, he has a strong and diverse music background. He began his professional life training middle school and high school students with woodwind pursuits. Three time performer at Chicago's Annual Midwest Clinic, twice at the prestigious TMEA conference and grand champion of the 2015 Houston Underground, Connor has stories to share about life as a music performer.
We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.
Enter your email to start following
You’re following Advanced Excel: Beyond the Basics.
Start following any program. No need to enter your email again.