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.
courses
1265
Views
23/02/2020 Last update