Discover Classes. Earn Rewards.

Excel Level II: Intermediate

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.

  • Level Intermediate
  • Age 18 and older
  • Price $249
  • Location Interactive Online Classroom

Start Dates (26)

  • $249
  • Interactive Online Classroom
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Tue, Mar 19 at 6:00pm - 9:00pm
  • Thu, Mar 21 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Thu, Apr 25 at 6:00pm - 9:00pm
  • Tue, Apr 30 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Tue, Jun 11 at 6:00pm - 9:00pm
  • Thu, Jun 13 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Save to WishList Purchase a Gift Card

Class Description

Description

What you'll learn in this excel class:

In this intermediate Excel class, you’ll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text.

The course comes with our revolutionary Excel video suite, so you can review the materials anytime after the class.

Take this class as part of the Excel Bootcamp and get a 15% discount. The package includes our Fundamentals, Intermediate, and Advanced Excel classes.

This course has a Prerequisite:

  • Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.

Learn more about Excel Level II: Intermediate at Noble Desktop.


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Also available in-person in NYC

Syllabus

Worksheet Management

Navigation

  • Keyboard shortcuts that facilitate quick and easy navigation within cells

Formula Review

  • Review various methods for completing calculations

Working with Text

Splitting Text

  • Use Text to Columns to split text into multiple cells

Joining Text

  • Join text from separate cells

Cell Ranges

Paste Special

  • Apply formats and perform calculations on selected cells

Paste Special Values

  • Hardcode the answer to a formula or function

Named Ranges

  • Assign a name to a range of cells to make it easier to reference those ranges in calculations

Database Functions

VLOOKUP & XLOOKUP

  • Use VLOOKUP and XLOOKUP to find information in cell range and return information from another cell range

Sort & Filter

  • Use Sort & Filter to find and organize data in large databases

Pivot Tables

Pivot Tables

  • Create Pivot Tables to quickly summarize large databases

Pivot Tables & Grouping

  • Group within Pivot Tables

Multiple Pivot Tables

  • Create multiple Pivot Tables on a single worksheet

Logical Functions

IF statements

  • Use IF statements to return output based on the contents of another cell

AND, OR

  • Tests to see whether multiple conditions are true

Math Functions

SUBTOTAL

  • Use SUBTOTAL function to sum/average/count values based on what is not filtered

Statistical Functions

SUMIFS

  • Use SUMIFS function to sum cells based on one or more conditions

COUNTIFS

  • Use COUNTIFS function to count cells based on one or more conditions

Improve Data Quality

Data Validation

  • Restrict the type of data that can be allowed in a cell

Remove Duplicates

  • Eliminate duplicate row data

Advanced Charts

Combo Charts

  • Combine two or more charts into a single chart, with the option of adding a secondary axis

End of Class Project

Project

  • End of class project to review key concepts from the class

Refund Policy

  • Students may cancel up to 14 days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price). 
  • Cancellations within 14 days are not permitted, but students may reschedule up to three business days before the class start date.
  • For cancellations and reschedules, please email us at [email protected]"

Reviews of Classes at Noble Desktop (371)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Noble Desktop

Noble Desktop is a renowned educational institution that specializes in providing comprehensive training in various creative and technology-related fields. Established in 1990 and headquartered in New York City, Noble Desktop has earned a stellar reputation for its high-quality courses and innovative...

Read more about Noble Desktop

CourseHorse Approved

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

Noble Desktop

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

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
  • Choose from thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...