Microsoft Excel Level 2

at Training Connection - Downtown

Course Details
$350 5 seats left
Start Date:

Tue, Apr 11, 9:00am - 4:30pm Pacific Time

Next start dates (3)

Downtown, Downtown/Northeast
915 Wilshire Blvd Suite 1800
Btwn Harbor Fwy & S Figueroa St
Los Angeles, California 90017
Purchase Options
Class Level: Intermediate
Age Requirements: 14 and older
Average Class Size: 5

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

What you'll learn in this excel class:

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 have the equivalent experience prior to attending this course. 

Course Outline

Managing Workbooks
  • Inserting and Deleting Worksheets
  • Rearranging Worksheets
  • Adding Hyperlinks
  • Linking to other Workbooks
  • Customizing Excel
Named Ranges
  • Using Names in Formulas
  • Other ways to use Named Ranges
  • Naming Shortcuts
  • Managing Named Ranges
Filtering and Sorting Data Tables
  • Sorting Data
  • Custom Sorts
  • Filtering Tables
  • Using Auto-Filter
  • Removing Duplicate Rows
  • Working with Structured References
  • Data Validation
  • Transposing Rows and Columns
Summarizing Data
  • Consolidating Data
  • Using Sub-totals
  • About PivotTables
  • Creating PivotTables
  • Formatting PivotTables
  • Manipulating PivotTables
  • Viewing Subsets of PivotTable Data
  • Adding Slicers
  • Creating PivotCharts
Presentation Features
  • Conditional Formatting
  • Graphical Conditional Formatting
  • Custom Formats
  • Adding Graphics
  • Adding Smart Art
Advanced Charts
  • Special Chart Types
  • Inserting Trendlines
  • Combination Charts
  • Chart Templates
  • Inserting Sparklines
  • Quick Analysis Options
  • Controlling Access with Permissions
  • Protecting and Securing Workbooks
  • Shared Workbooks
  • Adding Comments
  • Tracking Changes
  • Merging Shared Workbooks
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

Still have questions? Ask the community.

Refund Policy

Please send all requests to [email protected] .

We are unable to offer refunds for cancellations, however we can issue you a training voucher for the same value that can be used to book any class in the future.

Rescheduling requests made 7 days before the commencement of the training are free. Rescheduling that takes place within 7 days of the commencement of the training will incur a $100 administration fee. We do not charge for student substitutions at any time.

Due to the Coronavirus we are waving the transfer fee when you reschedule your training.

While we make every effort to deliver classes as scheduled, we reserve the right to reschedule previously confirmed classes for a variety of reasons including but not exclusively, the illness of the Trainer. In such cases, we will endeavor to inform the Client as soon as possible of the new training dates. We are not liable for any additional expenses incurred as a result of rescheduling training.

We are not able to offer refunds or training vouchers for no-shows or uncompleted courses.


Google Map

Training Connection

All classes at this location

The easiest access is from the State 110N Freeway (Harbor Hwy)

If traveling North-bound on 110N Hwy

  • Take the 9th St exit
  • Turn Left at Figueroa Street
  • Turn Left into Wilshire Blvd
  • 915 Wilshire is on the Right (look for the Bank of the West located in our lobby)

  • The entrance to our parking garage is also on the left hand side of building.

    If traveling South-bound on 110S Hwy
  • Take the 4th St exit towards WILSHIRE blvd / 6TH St / 3RD St
  • Turn left at Wilshire Blvd
  • 915 Wilshire is on the Left (look for the Bank of the West located in our lobby)

  • The entrance to our parking garage is also on the left hand side of building.

    Start Dates (4)
    Start Date Time Teacher # Sessions Price
    9:00am - 4:30pm Pacific Time TBD 1 $350
    9:00am - 4:30pm Pacific Time TBD 1 $350
    9:00am - 4:00pm Pacific Time TBD 1 $350
    9:00am - 4:00pm Pacific Time TBD 1 $350

    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 3500 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 Training Connection (146)

    (146 Reviews)
    Microsoft Excel Level 2
    Reviewed by Matthew G. on 10/3/2019
    Loved this class and the teacher was really patient with all the odd or off-topic questions from everyone else in the room. Highly recommend for everyone.
    Microsoft Excel Level 2
    Reviewed by Preston S. on 4/3/2019
    Chris was very helpful and made the class interesting rather than boring. Absolutely recommend keeping Chris as an instructor. I knew most the topics we covered in class. However, it helped reviewing these topics in another setting. I will be back to take the advanced course soon! Thank you. Best Preston
    Microsoft Excel Level 2
    Reviewed by Adriana O. on 7/21/2017
    Loved the class! I would highly recommend this course to people.
    Microsoft Excel Level 2
    Reviewed by Greg S. on 2/12/2016
    The instructor made the difference!
    Microsoft Excel Level 2
    Reviewed by Whitney B. on 3/28/2019
    Similar Classes

    School: Training Connection

    Training Connection

    Training Connection LLC is a computer and business skills training company.  

    Our Training Philosophy

    Our main focus is to provide exceptional computer desktop and business skills training. We strive to achieve this by following a 5 cornerstone approach:

    1. Our Instructors

    Without a doubt our most...

    Read more about Training Connection

    CourseHorse Approved

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

    Ready to take this class?
    Booking this class for a group? Find great private group events here