Advanced Excel: Beyond The Basics is unfortunately unavailable

Thankfully we have 33 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Advanced Excel: Beyond The Basics

at General Assembly - Santa Monica

(2205)
Course Details
Price:
$55
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

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
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 20
Teacher: Caroline Groth

What you'll learn in this excel class:

In this class we will move beyond the basics of spreadsheet creation. Topics will include data manipulation/troubleshooting and advanced functions to summarize and analyze data having multiple attributes. We will also introduce Pivot Tables, advanced graphs, and macros. Class exercises will be utilized to facilitate understanding.

Takeaways

Students will learn how to effectively streamline and analyze data using some of the more advanced features of Excel.

Preparation

  • A basic understanding of the Excel spreadsheet layout and Pivot Tables
  • Common uses such as entering data into a blank spreadsheet and copying/pasting
  • An understanding of common functions such as SUM, IF, and VLOOKUP
  • Ability to create a graph from two or more sets of data points
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 (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

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 550 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,190)

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.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

33 Top Choices

Excel Intro

at AcademyX - Downtown 915 Wilshire Blvd Ste #1800, Los Angeles, California 90017

Our Intro to Excel class will familiarize you with modifying, creating, printing and formatting worksheets. You will learn formulas for calculations and functions to help automate tasks.  This training will cover: Spreadsheet basic concepts Navigating the Excel interface Creating new files and opening existing ones Entering and editing data Modifying...

Tuesday Oct 1st, 9am - 4:30pm

Excel Beginning 1: Your First Worksheets

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

This three-hour session for Windows and Mac users introduces you to Excel’s interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel’s Ribbon-based interface, able to enter and edit labels, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and...

Thursday Sep 26th, 9am - 12pm

Excel One-Day Bootcamp

at General Assembly - Santa Monica 1520 2nd St, Santa Monica, California 90401

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

Saturday Sep 28th, 10am - 3pm

Microsoft Excel Level 1

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users. You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course...

Tuesday Oct 1st, 9am - 4:30pm

Excel at Excel: Getting Down to the Basics

at General Assembly - Santa Monica 1520 2nd St, Santa Monica, California 90401

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Wednesday Sep 25th, 6:30pm - 9pm

Microsoft Excel Level 2

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  Live face-to-face instructor. No minimum...

Wednesday Oct 2nd, 9am - 4:30pm

Excel Beginning 2: Cell Formatting and Charting

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

In this three-hour session, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart elements, and how to create...

Thursday Sep 26th, 1pm - 4pm

Microsoft Excel Level 3

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on class is suitable for Excel 2010, 2013 and 2016 users.  On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

Thursday Oct 3rd, 9am - 4:30pm

Excel Lookups, Functions, & Macros

at AcademyX - Downtown 915 Wilshire Blvd Ste #1800, Los Angeles, California 90017

Macros, collaboration, security are the foundations of this advanced Excel class. You will learn about different scenarios and how to use what if analysis.  Advanced functions and much more are also covered: Using IF, SUMIF, and COUNTIF to process data based on rules Using the VLOOKUP, INDEX and MATCH functions to find data in related worksheets...

Thursday Oct 3rd, 9am - 4:30pm

Excel Intermediate 2: Queries, Subtotals & Tables

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

In this three-hour session, you will import external data, create simple queries to bring in data from SQL sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting and totals and use AutoFilter to show only...

Friday Oct 4th, 1pm - 4pm

Excel VBA Macros: Write Custom Excel Macros in VBA

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Learn to create automated custom Excel applications using VBA. This is the first day of our two-day VBA Programming course, which helps advanced Excel users develop new skills to write and debug powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is...

Thursday Oct 10th, 9am - 4pm

  (2 sessions)
$895

2 sessions

Excel PivotTables: Data Analysis with PivotTables

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for...

Friday Oct 18th, 9am - 12pm

Word & Excel: Level 2 Advancing through Word and Excel

at El Camino College - Torrance 16007 Crenshaw Blvd, Torrance, California 90506

Once you are able to navigate your way through the basics of Word and Excel, you’re probably ready to explore what more these two powerful Microsoft Office programs can offer: After a short review, we’ll guide you through:  Word:  We’ll take a closer look at formatting pages; working with styles and themes, creating bullets and...

Saturday Oct 19th, 9am - 12pm

  (3 sessions)
$89

3 sessions

Basics of MS Excel - Navigate and Simple Formula

at Santa Monica College - Santa Monica SMC Bundy Campus 3171 S Bundy Dr, Santa Monica, California 90066

In a truly introductory class, learn how to use Excel. Start with an overview of the menus and the "ribbon,” and find out how to navigate around a spreadsheet, enter simple data, write simple formulas, and work with lists.  Then, learn how to format spreadsheets to make your data stand out and look great, and how to work with text, sort and...

Saturday Nov 9th, 9am - 4pm

Excel Level 3

at Certstaffix Training - Downtown 355 S Grand Ave Ste 2450, Los Angeles, California 90071

This course will teach students advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn about:  Alternative Data Sets Dynamic Worksheets with PivotTables Automating Repetitive Tasks with Macros Working with Other Microsoft Office Apps Business Intelligence Analysis and Forecasts and Visualizations Excel Versions...

Thursday Oct 17th, 7am - 2pm

Intermediate MS Excel: Formatting Data like a Pro

at Santa Monica College - Santa Monica SMC Bundy Campus 3171 S Bundy Dr, Santa Monica, California 90066

In a follow-up class to Basics of MS Excel, get a quick review of basic formatting, and find out about conditional (if/then) and two-color formatting. Also, learn how to write a selection of advanced formulas, and how to work with named ranges and using names in formulas.  You will have an individual computer to work on during class.

Saturday Nov 16th, 9am - 2pm

Excel VBA

at AcademyX - Downtown 915 Wilshire Blvd Ste #1800, Los Angeles, California 90017

Using VBA within Excel will allow you to automate many of the frequent tasks that you perform using Excel as well as create applications that interact with your users.  In this class Excel VBA class, you will learn to: Record and edit macros that contain VBA code Adhere to the syntax rules of the language Comment your code appropriately so that...

Friday Oct 4th, 9am - 4:30pm

Excel Intermediate 1: Simple Formulas

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

This three-hour session teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, PMT and PV, write arithmetic formulas by hand, perform calculations on dates, and parse text strings with the LEFT, MID, RIGHT and SEARCH functions. You will also learn when and why to use absolute referencing (like $A$4)...

Friday Oct 4th, 9am - 12pm

Microsoft Excel Level 4 - Macros & VBA

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This instructor-led course covers automation and customation of Excel using macros and screen items (such as buttons and menus). Trainees learn how to write macros using VB code and assign macros to screen items. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! Prerequisite Students are expected to have completed Excel...

Friday Oct 4th, 9am - 4:30pm

Excel Advanced 2: Advanced Formulas

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

In this half-day session, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple calculations in a single result....

Saturday Oct 5th, 1pm - 4pm