Price:
$350 5 seats left
Start Date:

Tue, Jul 17, 9:00am - 4:30pm

Next start dates (4)

Location:
The Loop
230 W Monroe St Ste 610
Btwn S Franklin & Wells Streets
Chicago, Illinois 60606
(Map)
Share:
Class Level: Intermediate
Age Requirements: 14 and older
Average Class Size: 5

What you'll learn in this excel class:

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. 

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users.

Prerequisite: 
You should have completed our Introduction class or have the equivalent experience prior to attending this 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
PivotTables
  • 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
Collaboration
  • Controlling Access with Permissions
  • Protecting and Securing Workbooks
  • Shared Workbooks
  • Adding Comments
  • Tracking Changes
  • Merging Shared Workbooks

Still have questions? Ask the community.

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

Map

Google Map
Training Connection


All classes at this location
Trains CTA - Blue and Red Lines - Monroe Station Walk approximately 4 blocks west on Monroe Street to Franklin Street. CTA - Orange, Pink, Purple and Brown Lines - Quincy station Walk approximately 1.5 blocks north on Wells Street, turn left (west) on Monroe Street, and go to corner of Franklin Street. CTA - Green Line Swap at Clark for Blue line or Roosevelt for Orange line. Metra - Union Station Walk 3 blocks east on West Adams (crossing river). Turn left (North) on Franklin and walk 1 block to Monroe Street.
Start Dates (5)
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

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

Get quick answers from CourseHorse and past students.

Reviews of Classes at Training Connection

(63 Reviews)

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

Read more about Training Connection

CourseHorse Approved

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

Ready to take this class?
BOOK ONLINE
Taking this class for work? Get exclusive perks & discounts for free. Learn More