Events.com apps

Excel Bootcamp: Working with Functions and Pivot Tables

Excel Bootcamp: Working with Functions and Pivot Tables
Image from coursehorse.com
Event ended

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.

Views - 23/02/2020 Last update
courses
General Assembly
444 N Wabash Ave 5th Fl, Chicago, 60611, Illinois, US
Create an event
Create events for free. They will be immediately recommended to interested users.
Nearby hotels and apartments
444 N Wabash Ave 5th Fl, Chicago, 60611, Illinois, US
Discover more events in Chicago
Discover now
Discover more events in Chicago
Discover now
General Assembly
444 N Wabash Ave 5th Fl, Chicago, 60611, Illinois, US
Create an event
Create events for free. They will be immediately recommended to interested users.
  1. Chicago
  2. Excel Bootcamp: Working with Functions and Pivot Tables
 
 
 
 
Your changes have been saved.