Excel Bootcamp: Working with Functions & Pivot Tables
19

Friday, 19 June

10 am – 5 pm CDT

GA Chicago @ 150 N Wacker

150 N Wacker, Suite 2600
Chicago, IL 60606
$250 USD
Regular Ticket
$250 USD
Total

Questions? Read our FAQs

Excel Bootcamp: Working with Functions & Pivot Tables | June 19

Bianca Mounce Photo


Senior Data and Technology Strategist, The Movement Cooperative

19

Friday, 19 June

10 am – 5 pm CDT

GA Chicago @ 150 N Wacker

150 N Wacker, Suite 2600
Chicago, IL 60606
$250 USD
Regular Ticket
$250 USD
Total

Questions? Read our FAQs

About This Workshop

In this one day bootcamp, we will move beyond the basics of spreadsheet creation. We will dive into data manipulation and advanced functions to summarize and analyze data with multiple attributes. We will also introduce using slicers with Pivot Tables, creating interactive reports, and using advanced formulas. Interactive in-class exercises will be utilized to facilitate understanding.

Agenda

  • Review of Intermediate Functions (VLOOKUP, SUMIF, COUNTIF)
  • Relative and Absolute Cell References within Formulas
  • Date and Time Functions
  • Logical Functions (IF/NESTED IF statements)
  • Advanced Functions (SUMIFS, COUNTIFS)
  • Pivot Tables and Pivot Charts (including Slicers)
  • Named Ranges

Takeaways

Participants will learn how to effectively streamline and analyze data using some of the more advanced features of Excel including:

  • Advanced Functions
  • Pivot Tables and Pivot Charts

Preparation

  • This bootcamp is designed for participants with familiarity of basic features/functions in Excel (i.e. navigation, layout, basic formulas like SUM/COUNT, etc).
  • Please install Excel version 2010 or later.

About the Instructor

Bianca Mounce Photo

Senior Data and Technology Strategist,
The Movement Cooperative

Since 2013, Bianca has empowered for-profit companies, electoral campaigns and non-profit organizations to strategically use data. She is currently the Data and Analytics Strategist at Forward Together, a non-profit that works nationally to ensure that all families have the rights, recognition and resources they need to thrive.
After working on President Obama's re-election campaign as a Field Organizer in Tampa, Florida, Bianca continued immersing herself in data-driven campaigns and non-profit work. She was the National Data Manager at Organizing for Action where she oversaw reporting, training and data for Grassroots staff and volunteers. She then worked at Civis Analytics as a Client Success Analyst working with a diverse portfolio of clients on how to leverage the Civis Platform.
A native Oregonian, Bianca lived in the United Kingdom for five years, and has traveled to 21 countries. She likes to think she is equal parts coffee expert, yogi and proud Portlander.

Refund Policy

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.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.