Intermediate MS Excel: Formatting Data like a Pro is unfortunately unavailable

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

Intermediate MS Excel: Formatting Data like a Pro

at Santa Monica College - Online

(467)
Course Details
Price:
$129
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.

Important:
Online Class
Purchase Options
Save to WishList

13 people saved this class

Book Private Class
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 10
Teacher: Seth David

What you'll learn in this excel class:

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.

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

School Notes:

Important:

You MUST have and input a valid California address and US phone number when signing up for Santa Monica College courses, or you may be rejected from the course. If you do not have a valid US address and phone number, your enrollment will not be accepted.

Also:

Santa Monica College's Community Education Office operates from 8:30 AM to 4:30 PM Monday through Friday, excluding weekends and holidays. Please bring your CourseHorse purchase confirmation with you to class. Your Classroom information is noted in the Special Notes. If you do not have a classroom on your purchase receipt, please reach out to [email protected]


You may also check our FAQ HERE

Still have questions? Ask the community.

Refund Policy
NO CANCELLATIONS AFTER A CLASS HAS BEGUN, so choose courses carefully! Requests for withdrawal from a class must be submitted in writing via email at least seven business days before the start date of the class; receipt of requests made via other methods, such as phone messages, cannot be guaranteed.  You may receive a credit voucher applicable to future Community Education classes, which is valid for two years from the date of issue.  A minimum service charge of $10 per class cancellation will be withheld.  Refunds are granted ONLY if a class is cancelled, discontinued, or rescheduled.In the instance of cancelled classes, course fee is automatically refunded. Credit card refunds are processed with seven business days, check and cash refunds will be issued by check within 45 business days.

Transfers

To transfer to another class, request must be submitted in writing via email at least seven (7) business days before the original class meets. A minimum service charge of $10 per class transfer will be deducted. 

Important Information: Refunds are NOT issued for absences nor prorated for late registrations. Missed class meetings may not be made up in another class. There is no auditing of classes. Students are highly encouraged to register before class begins.  Returned checks will be subject to a $25 handling charge.

SOME HIGH DEMAND CLASSES, SUCH AS GLASS FUSING AND GOOD TIMES TRAVEL DAY TRIPS, HAVE SEPARATE AND DIFFERENT REFUND POLICIES STATING THAT ALL REGISTRATIONS ARE FINAL, AND NO REFUNDS, CREDITS, OR TRANSFERS WILL BE GIVEN.  PLEASE BEAR THAT IN MIND WHEN REGISTERING FOR THOSE CLASSES.

MAKE-UP POLICY

Missed class meetings may not be made up in another class

Map

Google Map

Santa Monica College

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 1290 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 Santa Monica College (467)

(467 Reviews)
Intermediate MS Excel: Formatting Data like a Pro
Reviewed by Anonymous on 7/12/2015
The instructor was terrific. I expected (and would have appreciated) more time spent on the Excel portion of the class.
Intermediate MS Excel: Formatting Data like a Pro
Reviewed by Anonymous on 11/17/2019
Intermediate MS Excel: Formatting Data like a Pro
Reviewed by Shannon Q. on 2/3/2019
loading...

School: Santa Monica College

Santa Monica College

You've come to a special place. We believe that Santa Monica College offers an outstanding and unique educational experience. We also believe that we provide the community a wealth of resources.

Santa Monica College, which was opened in 1929, has grown to a thriving campus with offerings in more than...

Read more about Santa Monica College

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
Booking this class for a group? Find great private group events here

64 Top Choices

Intermediate Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

Friday Dec 4th, 10am - 5pm Eastern Time

Excel for Business Fundamentals

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques. Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing....

Thursday Dec 3rd, 10am - 5pm Eastern Time

Advanced Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Monday Dec 7th, 10am - 5pm Eastern Time

Intermediate Microsoft Excel

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard...

Friday Dec 4th, 10am - 5pm Eastern Time

Microsoft Excel Essentials

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019. This course is great for someone...

Monday Jan 11th, 10am - 6pm Eastern Time

Microsoft Excel Expert (Level 3)

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Wednesday Jan 13th, 10am - 6pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. Registered students will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you'll need for the session. Registration for this class...

Tuesday Dec 1st, 11am - 5pm Mountain Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Tuesday Dec 1st, 1pm - 7pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

Important Note about Online Classes: Registered students will be notified 48 hours in advance of this program with information on how to log in to the Zoom webinar and Slack messaging apps. Registration for this class will close 48 hours prior to class start in order to allow all students ample opportunity to have the technology enabled. This Bootcamp...

Tuesday Dec 1st, 1pm - 7pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Tuesday Dec 1st, 1pm - 7pm Eastern Time

Excel Advanced 1: Automating Tasks

This class is temporarily being offered remotely.

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

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have taken...

Tuesday Dec 1st, 6:30pm - 9:30pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

Tuesday Dec 1st, 1pm - 7pm Eastern Time

Excel Power BI for Desktop: Data Summarization

This class is temporarily being offered remotely.

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

Full Course Name: "Excel Power BI for Desktop: Data Summarization and Visualization" In this one-day Excel for Windows session, you will learn how to use Microsoft's free Power BI for Desktop app to produce stunning interactive summarization reports full of modern charts/visuals. In class, you will connect to external data sources, create relational...

Wednesday Dec 2nd, 9am - 4pm Pacific Time

Excel Dashboards for Interactive Reporting - Online

This class is temporarily being offered remotely.

at Colorado Free University - Online 00000

A dashboard is a single screen used for reporting that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. You will: Create an interactive, dynamic information source within Excel without creating a monster workbook or submitting...

Thursday Dec 3rd, 9am - 4pm Mountain Time

Virtual Excel Beginning Class

This class is temporarily being offered remotely.

at Computers Etc Software Training Center - Online

Build formulas to add, subtract, multiply, divide, average, and figure percentages. Create different spreadsheets from scratch, learn many tips and shortcuts, as well as Charts. What you will learn: Create Formulas that add, subtract, multiply divide, etc: Learn how to create Formulas that add, subtract, multiply, and divide numbers, calculate...

Thursday Dec 3rd, 9am - 4pm Pacific Time

Microsoft Excel Level 1

This class is temporarily being offered remotely.

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

Monday Dec 7th, 9am - 4:30pm Pacific Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

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 participants 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 to help you organize...

Monday Dec 7th, 9pm - 11:55pm Eastern Time

Microsoft Excel Level 2

This class is temporarily being offered remotely.

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

Tuesday Dec 8th, 9am - 4:30pm Pacific Time

Microsoft Excel Level 3

This class is temporarily being offered remotely.

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

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 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,...

Wednesday Dec 9th, 9am - 4:30pm Pacific Time

Excel VBA Macros: Write Custom Excel Macros in VBA

This class is temporarily being offered remotely.

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 two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is ideally suited...

Thursday Dec 17th, 9am - 4pm Pacific Time

  (2 sessions)
$895

2 sessions