Questions? Read our FAQs
Questions? Read our FAQs
In this workshop, we will move beyond the basics of spreadsheet creation. Topics will include data manipulation and advanced functions to summarize and analyze data having multiple attributes. We will also introduce using slicers with PivotTables, creating interactive charts and dashboards, and using advanced formulas. In-class exercises will be utilized to facilitate understanding. The workshop is designed for participants with familiarity of basic features/ functions in Excel (i.e. navigation, layout, basic formulas like SUM/COUNT, etc). Beginner level participants should attend GA’s Excel at Excel: Getting Down the Basics workshop prior to this workshop.
The best place to park is in the structure off of Colorado and 2nd St. The first 90 minutes are free (269 Colorado Ave, Santa Monica, CA 90401).
The end of the Expo Line is the Downtown Santa Monica station, which is a 5-minute walk to campus.
The 733 bus also ends in Santa Monica directly in front of our building.
Participants will learn how to effectively streamline and analyze data using some of the more advanced features of Excel including:
• Advanced Functions such as INDEX, MATCH, and SUMIFS
• Pivot Tables and Pivot Charts
• Interactive Dashboards
Agenda (not necessarily taught in this order)
• Review of Filtering, Sorting, and Conditional Formatting
• Review of Intermediate Functions (VLOOKUP, SUMIF, COUNTIF)
• Relative and Absolute Cell References within Formulas
• Date and Time Functions
• Logical Functions (IF/NESTED IF statements)
• Data Validation (notably drop-down lists)
• Advanced Functions (INDEX/MATCH, SUMIFS, COUNTIES)
• Charts and Graphs
• PivotTables and PivotCharts (including Slicers)
• Tables and Named Ranges
• Creating Interactive Dashboards
This is an intermediate/advanced class. Please make sure you have attended GA's Excel at Excel: Getting Down the Basics Class or have a strong familiarity with intermediate Excel functions (VLOOKUP, SUMIF, and COUNTIF)
My experience stems from college, with my degree in Finance, as well as current and past experiences at work. I used to work at One West Bank as a Valuation Analyst, where I would use Excel every day doing financial analysis of mortgages. In programming, I have used Excel both producing workbooks and using them as inputs, so I have a few different perspectives of Excel.
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 Excel Bootcamp (Santa Monica).
Start following any program. No need to enter your email again.