Excel Workbooks, Formulas and Functions is unfortunately unavailable

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

Microsoft Excel Level 2

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA 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 class size - all classes guaranteed to run! You should have completed our Introduction class or...

Tuesday Oct 10th, 9am–4:30pm Pacific Time

Microsoft Excel Level 1

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA 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 is ideal for people new to Excel who need to produce reports, budgets, lists and other spreadsheets....

Monday Oct 9th, 9am–4:30pm Pacific Time

Microsoft Excel Level 3

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA 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, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user...

Friday Oct 13th, 9am–4:30pm Pacific Time

Microsoft Excel Level 4 - Macros & VBA

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA 90017

This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors Live face-to-face instructor. No minimum class size - all classes guaranteed to run! Prerequisite Students...

Monday Oct 16th, 9am–4:30pm Pacific Time

See all Excel classes Los Angeles
Questions about this class?
Get help now from an expert!

Excel Workbooks, Formulas and Functions

at ONLC Training Centers - Westwood

Course Details
Price:
$295
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:
Westwood, Westside
10940 Wilshire Blvd Ste 600
Btwn Midvale Ave & S Westwood Blvd
Santa Monica, California 90024
(Map)
Purchase Options
Save to WishList

1 person saved this class

Book Private Class
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7
Teacher: ONLC Instructor

What you'll learn in this excel class:

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment, it is best to register for this class at least three weeks in advance.

Overview
Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions.

Target Student

The course is for individuals who are responsible managing and creating large worksheets and models in Excel.

Prerequisites
Excel 2013 or 2016 Introduction or equivalent skills.

Course Outline

Working with Large Workbooks
  • Viewing, Renaming, and Color-coding Worksheets
  • Working in Group Mode
  • Manipulating Worksheets
Working with Multiple Worksheets
  • Creating Linked Formulas
  • Using 3-D References
  • Consolidation by Position and Category
  • Viewing Worksheets from Different Workbooks Side by Side
  • Creating Linked Formulas Between Workbooks
Background Concepts with Functions
  • Working with Functions/Using Functions
  • Using Absolute Cell Reference
  • Creating & Using an Absolute Named Range
  • Creating a Relative Named Range
  • Creating a Custom Zoom
  • Working with Insert Function
Working with Financial and Date Functions
  • Using Financial Functions
  • Using Date Functions
  • Working with Auditing & Error Checking Tools
Working with Logical Functions
  • Using the IF Function
  • Nesting Functions
  • Using Multiple Conditions with the IF Function
  • Using Multiple If Functions
  • Using Table Lookup Functions (VLookup & HLookup)
  • Using Match and Index
Working with Data Analysis Tools
  • Creating Scenarios
  • Working with Scenarios
  • Using Goal Seek
  • Using One-Input Data Tables
  • Using Two-Input Data Tables
  • Understanding Solver
  • Defining a Problem
  • Solving a Problem
  • Generating a Report of Results and Alternate Solutions
Using Protection and Shared Workbook Features
  • Protecting Workbooks and Worksheets
  • Protecting a Workbook
  • Protecting a Worksheet
  • Allowing Users to Edit Ranges
  • Working with Shared Workbooks
  • Configuring a Workbook for Shared Use
  • Highlighting Tracked Changes
  • Creating the History Report
  • Reviewing Shared Workbook Changes
Creating a Forecast
  • Creating a Forecast Sheet
  • Setting Dates
  • Returning a Confidence Interval
  • Using Seasonality Patterns
  • Filling Missing Points
  • View outline in Word 

Still have questions? Ask the community.

Refund Policy

Cancellation / Reschedule by Student

Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.

Please note the following policies:

  • If requested 16 or more calendar days before the class
    • Cancellation requests made in this timeframe are eligible for refund less 5% cancellation fee.
    • Reschedule requests made in this timeframe will be accommodated if availability exists and will be processed at no additional charge.
  • If requested 15 calendar days or less before the class
    • Cancellation or Reschedule requests made by the student 15 calendar days or less before the class starts will be charged 100% the course fee and are not entitled to a refund.

Substitutions

  • If you are unable to attend your class, a substitute who meets the course prerequisites may attend in your place at no additional charge for the original class title, date and location. If you cannot find a substitute, you will be subject to the class cancellation policy.

Make-up Policy

Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.

  • Make-Up class registrations are subject to availability and are not entitled to refund.
  • Students may not reschedule a Make-up class registration.
  • Any no shows or cancellations forfeit their one Make-up opportunity.

Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

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.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)
Save to WishList
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 2950 points. Points give you money off your next class!
Questions about this class?
Get help now from an expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (7)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here