Discover Classes. Earn Rewards.

Excel 2016 Intermediate is unfortunately unavailable

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

Excel Level III: Advanced

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Take your Excel skills to the next level with advanced techniques and tools in this comprehensive course. Learn to manipulate and analyze complex data, utilize advanced functions, and write macros for improved efficiency. Master Excel and enhance your productivity in any professional setting.

(372) Advanced 18 and older

Excel Level II: Intermediate

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Take your Excel skills to the next level with an intermediate course that covers VLOOKUP, Pivot Tables, and more. With Noble Desktop, you'll gain the expertise needed to manipulate and analyze data effectively. Enhance your Excel abilities today.

(372) Intermediate 18 and older

Excel Level I: Fundamentals

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Master the essentials of Microsoft Excel in this practical hands-on workshop. Learn calculations, functions, graphs, formatting, and printing, and gain the skills you need to excel in data management. Expand your proficiency with Noble Desktop.

(372) Beginner 18 and older

Excel Specialist Certification Program

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Enhance your Excel skills and gain a competitive edge in the job market with the Excel Specialist Certification Program. Master essential Excel functions, advanced formulas, and data management techniques while preparing for the Microsoft Excel certification exam. Elevate your career prospects with the top-rated Excel certification program in NYC.

(680) All levels 18 and older
$899

3 sessions

Gift it!
$549

3 sessions

Gift it!
See all Excel classes NYC

Excel 2016 Intermediate

  • Intermediate
  • 18 and older
  • $295
  • 120 S Wood Ave, Iselin, NJ
  • 7 hours

Start Dates (0)

  • $295
  • CTG Iselin @ 120 S Wood Ave 4th Fl, Ste 405, Iselin, NJ 08830
  • 7 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this excel class:

This course builds upon the foundational knowledge presented in the Excel Fundamentals course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

Upon successful completion of this course, you will be able to:
 

Leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Description:


Module 1: Organizing Workbooks
  • Overview Of Workbooks And Worksheets
  • Working With Sheets In Groups
Module 2: Linking & Consolidating Data
  • Working With Hyperlinks
  • Working With Formulas That Link Worksheets And Files
  • Consolidating Data From Various Worksheets
Module 3: Enhancing Workbook Navigation
  • Adjusting Window Layout
  • Organizing Data In An Outline
Module 4: Working With Lists of Data
  • Overview Of Excel Lists
  • Rules For Designing A List
  • Flash Fill
  • Remove Duplicate Values
Module 5: Sorting and Subtotaling
  • Sorting a Worksheet List
  • Sorting By Columns
  • Creating Custom Sort Orders
  • Producing Subtotals On A Sorted List
Module 6: Creating Tables, Using Filters and Criteria
  • Automating Your List For Day-To-Day Activity
  • Setting A Custom Autofilter
  • Working With Criteria Ranges
Module 7: Working With Charts
  • Creating A Chart
  • Excel’s Assumptions About Your Data
  • Modifying The Chart
  • Enhancing The Chart
  • Changing Series Orientation From Rows To Columns
  • Working With Data Tables
  • Updating A Chart’s Data Series
  • Changing The Data Series Order
  • Working With Series-Related Options
  • User-Defined Custom Types
  • Printing Charts
  • Creating Sparklines
  • Deleting Sparklines

Refund Policy

Cancellation acceptable prior to 10 days before class date.

Reviews of Classes at Corporate Training Group (4)

(3.5-star rating across 4 reviews)
  • Excel 2016 Intermediate

    Reviewed by Emily G. on 4/30/2019
See reviews for other classes at Corporate Training Group
loading...
Hide Reviews

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 & Answers (0)

Get quick answers from CourseHorse and past students.

Corporate Training Group

Corporate Training Group, Inc. is a Microsoft Gold Certified Partner for Learning Solutions and Information Worker Solutions. CTG provides authorized training delivered by Microsoft Certified Instructors (MCT) using Microsoft Certified Courseware. CTG provides technical training and consulting services....

Read more about Corporate Training Group

CourseHorse Approved

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

Corporate Training Group

Corporate Training Group

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...