Class Level:
Intermediate
Course Details
Price:
$350
5 seats left
Need more seats?
See group options for 8+
Start Date:
Tue, Jul 11, 9:00am - 4:00pm Pacific Time
Location:
Downtown, Downtown/Northeast
915 Wilshire Blvd Suite 1800
Btwn Harbor Fwy & S Figueroa St
Los Angeles, California 90017 (Map)
915 Wilshire Blvd Suite 1800
Btwn Harbor Fwy & S Figueroa St
Los Angeles, California 90017 (Map)
Purchase Options
No Booking Fees
Book Now
Save to WishList
33 people saved this class
Give as a Gift Book as Private Event
Description
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
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
- Using Names in Formulas
- Other ways to use Named Ranges
- Naming Shortcuts
- Managing Named Ranges
- Sorting Data
- Custom Sorts
- Filtering Tables
- Using Auto-Filter
- Removing Duplicate Rows
- Working with Structured References
- Data Validation
- Transposing Rows and Columns
- Consolidating Data
- Using Sub-totals
- About PivotTables
- Creating PivotTables
- Formatting PivotTables
- Manipulating PivotTables
- Viewing Subsets of PivotTable Data
- Adding Slicers
- Creating PivotCharts
- Conditional Formatting
- Graphical Conditional Formatting
- Custom Formats
- Adding Graphics
- Adding Smart Art
- 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
Still have questions? Ask the community.
Refund Policy
All cancellations and rescheduling requests must be made in writing and emailed to [email protected]
- Rescheduling requests made 8 business days before the commencement of the training are free.
- Rescheduling that takes place within 8 business days of the commencement of the training will incur a $100 administration fee.
- We do not charge for student substitutions at any time.
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 for no-shows or uncompleted courses.
Map
Training Connection
Downtown, Downtown/Northeast
915 Wilshire Blvd Suite 1800
Btwn Harbor Fwy & S Figueroa St
Los Angeles, California 90017 Downtown, Downtown/Northeast
915 Wilshire Blvd Suite 1800
Btwn Harbor Fwy & S Figueroa St
Los Angeles, California 90017
The easiest access is from the State 110N Freeway (Harbor Hwy)
If traveling North-bound on 110N Hwy
The entrance to our parking garage is also on the left hand side of building.
If traveling South-bound on 110S Hwy
The entrance to our parking garage is also on the left hand side of building.
Start Dates (4)
Tuesday Jul 11th,
9am–4pm PDT
Training Connection - Los Angeles
915 Wilshire Blvd, Los Angeles, CA 90017
915 Wilshire Blvd, Los Angeles, CA 90017
TBD
$350
Book
Wednesday Aug 9th,
9am–4pm PDT
Training Connection - Los Angeles
915 Wilshire Blvd, Los Angeles, CA 90017
915 Wilshire Blvd, Los Angeles, CA 90017
TBD
$350
Book
Wednesday Aug 16th,
9am–4:30pm PDT
Training Connection - Los Angeles
915 Wilshire Blvd, Los Angeles, CA 90017
915 Wilshire Blvd, Los Angeles, CA 90017
TBD
$350
Book
Tuesday Sep 12th,
9am–4pm PDT
Training Connection - Los Angeles
915 Wilshire Blvd, Los Angeles, CA 90017
915 Wilshire Blvd, Los Angeles, CA 90017
TBD
$350
Book
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.
Reviews of Classes at Training Connection (147)
Microsoft Excel Level 2
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
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
Loved the class! I would highly recommend this course to people.
Microsoft Excel Level 2
The instructor made the difference!
Microsoft Excel Level 2
Microsoft Excel Level 2
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
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
Loved the class! I would highly recommend this course to people.
Microsoft Excel Level 2
The instructor made the difference!
Microsoft Excel Level 2
Similar Classes
Ch Gift Card
School: 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 valuable...
Read more about Training Connection
This school has been carefully vetted by CourseHorse and is a verified LA educator.
Ready to take this class?
BOOK NOW
Booking this class for a group?
Find great private group events here
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?