Discover Classes. Earn Rewards.

Implement Advanced Skills And Algorithms In Excel

  • Advanced
  • 18 and older
  • $70
  • 1520 2nd St, Santa Monica, CA

Get More Information

Fill out this form and the course provider will contact you with more information about this course.

  • $70
  • GA Santa Monica @ 1520 2nd St, Santa Monica, CA 90401

By submitting this form, I consent to CourseHorse providing the information in this form with the course provider which may contact me via email, phone or text.

Class Description

Description

What you'll learn in this excel class:

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put students in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions and processes to help organize and analyze data and go through situational overviews of time-saving shortcuts to improve your efficiency dramatically. We will work through examples of advanced skills and algorithms that analysts to implement in the workplace, research, or academics.

Takeaways
  • Learn how to manipulate datasets using pivot tables and other functions.
  • Find out how to leverage the onboard statistical analysis tools to make effective conclusions on data.
  • Master the art of shortcuts to streamline the process of analysis in Excel.
  • Create seamless connections between data sources for reporting and dashboards.Practice advanced skills such as ranking/indexing, complicated text manipulation, and table joins (i.e. Vlookup).
  • Implement advanced algorithms on sample data, such as customer segmentation (clustering) and forecasting.
  • Become familiar with Excel extensions to aid your workflow and analysis and keep you leveling up!
Prereqs & Preparation

Students should have a basic understanding of Excel and rudimentary functions (IF, SUMIF statements) as well as how to organize data into functional tables (i.e. how to create a data table in Excel with a simple understanding of sort and filter functionality). Students should bring a laptop with Excel installed. Mac-based laptops are preferable, though not required (certain shortcuts may not transfer directly into Excel for PC). The instructor will use a Mac for this class. Students should try to arrive a few minutes early to class, if possible.

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.

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.


In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at General Assembly (2,637)

Similar Classes

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

General Assembly

At General Assembly you get the tech skills, career advice and networking opportunities needed to be job ready for a career in coding or data or ux design, in as little as three months, with little or no previous experience.

Since 2011 General Assembly has graduated more than 40,000 students...

Read more about General Assembly

CourseHorse Approved

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

General Assembly

General Assembly

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...