(212) 684-5151

Intermediate Microsoft Excel 2016
Intermediate Microsoft Excel 2016

Price: $209.00

Course Code: 6G | Hours: 7

Excel Training Classes | Intermediate Course Overview

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.

Intermediate Excel Course Outline

Hands-on Intermediate Excel Training

Our intermediate Excel class is hands-on and uses real-world examples throughout the training. The instructor will first explain the concept along with a example, and then you'll perform an exercise on your own. Our step-by-step training manual is the perfect reference guide for during and after the class.

Revolutionary Excel Video Suite & Free Retake

You'll also receive access to our premium Intermediate Excel video suite, which has the lessons on high-quality video that can be viewed on desktop, mobile and tablet.

And just in case you need a refresher, you can retake the class anytime within 6 months of the course (provided there is an available seat in the class).

With all these revolutionary resources, you're virtually guaranteed to walk away with some advanced skills in Excel.

What You'll Learn in this Class:

  • Navigate Worksheet with Keyboard Shortcuts
  • Create Dropdown Menu
  • Analyze Data
  • Use Logical Functions
  • Use Statistical Functions
  • Analyze Data with PivotTables

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Next Classes:

Related Classes:

See Also:

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Next Classes:

Related Classes:

See Also:

Intermediate Excel Course Outline

Lesson 1: Worksheet Management

• Navigation
• Paste Special

Lesson 2: Text

• Splitting Text
• Joining Text

Lesson 3: Database Management

• Named Ranges
• Data Validation
• Sort & Filter
• Remove Duplicates

Lesson 4: Database Functions

• Vlookup
• Hlookup
• Vlookup - Closet Match

Lesson 5: Logical Functions

• True, False, Not
• And, Or
• IF statements

Lesson 6: Statistical Functions

• Rank.eq
• Countifs
• Sumifs

Lesson 7: Pivot Tables

• Table review
• Pivot Tables
• Pivot Tables & Grouping
• Multiple Pivot Tables

End of Class Project

• Project