Excel One-Day Bootcamp

at General Assembly - Santa Monica

(2199)
Course Details
Price:
$120 7 seats
Start Date:

Sat, Sep 28, 10:00am - 3:00pm

Next start dates (2)

Location:
Santa Monica, Beach Cities
1520 2nd St
Btwn Broadway & Colorado Ave
Santa Monica, California 90401
(Map)
Share:
Important:
A computer will not be provided.
Purchase Options
No Booking Fees Book Now Save to WishList

32 people saved this class

Give as a Gift
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 20
Teacher: Kyle Liu

What you'll learn in this excel class:

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 course is designed for students with familiarity of basic features/ functions in Excel (i.e. navigation, layout, basic formulas like SUM/COUNT, etc). Beginner level students should attend GA’s Excel at Excel: Getting Down the Basics course prior to this workshop.

Takeaways:
Students 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 
Prereqs & Preparation:

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).

School Notes:
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.

Still have questions? Ask the community.

Refund Policy
If you can't make it to a class/workshop, please email us at [email protected] at least 7 days before the scheduled event date. No refunds will be given after this timeframe.

Map

Google Map

General Assembly

All classes at this location

Start Dates (3)
Start Date Time Teacher # Sessions Price
10:00am - 3:00pm Kyle Liu 1 $120
10:00am - 3:00pm Kyle Liu 1 $120
10:00am - 3:00pm David Bickham 1 $120

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 1200 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at General Assembly (2,184)

(2184 Reviews)
Excel One-Day Bootcamp
Reviewed by Brennan H. on 7/1/2019
Excel One-Day Bootcamp
Reviewed by Anonymous on 4/29/2019
Excel One-Day Bootcamp
Reviewed by Heidi B. on 3/13/2018
loading...
Similar Classes

School: General Assembly

General Assembly

General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.

What began as a co-working space in...

Read more about General Assembly

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified LA educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.