Excel Bootcamp: Working with Functions & PivotTables
14

Saturday, 14 December

10 am – 5 pm CST

GA Chicago @ Rent 24

444 N Wabash Avenue, 5th Floor
Chicago, IL 60611
$195 USD
Regular Ticket
$195 USD
Total

Questions? Read our FAQs

Excel Bootcamp: Working with Functions & PivotTables | December 14

Alex Blyakhman Photo


Director of Analytics, iCrossing (a Hearst Media company)

14

Saturday, 14 December

10 am – 5 pm CST

GA Chicago @ Rent 24

444 N Wabash Avenue, 5th Floor
Chicago, IL 60611
$195 USD
Regular Ticket
$195 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 PivotTables, 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)
  • PivotTables and PivotCharts (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

Alex Blyakhman Photo

Director of Analytics,
iCrossing (a Hearst Media company)

Alex Blyakhman, CMA, CIA, CBIP is Analytics Director with iCrossing, a digital advertising agency. His professional experience spans various information technology and finance roles across manufacturing, telecommunications, and retail verticals. His own consulting practice, Excel Strategies, LLC serves the needs of small business owners since 2009, and his work involves helping companies ranging in size from mom and pop operations to Fortune 50 multi-nationals. His teaching experience includes continuing education classes at Henry Ford Community College, Macomb Community College, Illinois District 214 and other institutions. Alex aims to help students master various software tools and features to boost their productivity and quality of work. As a lifelong student himself, who pursues various professional certifications as a hobby, Alex enjoys sharing his knowledge and exchanging ideas with his students. He instills creativity into his problem-solving approach, enabling students answer questions they never knew they had.

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.