Microsoft Excel Level 2

at Training Connection - Downtown

Course Details
$350 5 seats left
Start Date:

Tue, Oct 22, 9:00am - 4:30pm

Next start dates (8)

Downtown, Downtown/Northeast
915 Wilshire Blvd Ste 1800
Btwn Harbor Fwy & S Figueroa St
Los Angeles, California 90017
Purchase Options
No Booking Fees Book Now Save to WishList

25 people saved this class

Give as a Gift
Class Level: Intermediate
Age Requirements: 14 and older
Average Class Size: 5

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
Cancellations made more than 5 days before the commencement of the training, qualify for a refund less a $100 administration fee. 
Cancellations made 5 days or less before the commencement of the training, will not be eligible for a refund 
We are not able to offer refunds for no-shows or uncompleted courses.

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

If your student wants to confirm her seat on the future class now, then there is a $100 transfer fee payable. Alternatively, as she may not have been aware of our terms, if she is willing to check back with us 2-3 days before a future class, and provided the class is confirmed to run, we will slot her in and waive the cancellation fee.

Money Back Guarantee
We offer a money back guarantee on our public classes.

If the training does not meet expectations, students can leave the class at the end of Day 1 (or by lunchtime in the case of single day courses) and request a refund. Students have to notify the training center manager before they leave and return all the training materials to qualify for a refund.

We are unable to offer a money back guarantee to students who leave a class later than the times noted above. Students can however still repeat the training (often with a different trainer).


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 (9)
    Start Date Time Teacher # Sessions Price
    9:00am - 4:30pm TBD 1 $350
    9:00am - 4:30pm TBD 1 $350
    9:00am - 4:30pm TBD 1 $350
    9:00am - 4:30pm TBD 1 $350
    9:00am - 4:30pm TBD 1 $350
    Start Date Time Teacher # Sessions Price
    9:00am - 4:30pm TBD 1 $350
    9:00am - 4:30pm TBD 1 $350
    9:00am - 4:30pm TBD 1 $350
    9:00am - 4:30pm 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 (103)

    (103 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?
    Taking this class for work? Get exclusive perks & discounts for free.