Discover Classes. Earn 10% Rewards.

Excel Level II: Intermediate

Noble Desktop
4.6 452 reviews

Push your Excel skills past the basics with this intermediate course covering VLOOKUP, PivotTables, and more. At Noble Desktop, you'll build the working ability to manipulate and analyze data effectively for real reporting and analysis tasks.

  • Intermediate
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 185 Madison Ave, New York, NY & Virtually Online
Excel Level II: Intermediate
Excel Level II: Intermediate
Book at School

Express Checkout – $299

Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (74) $299/person

Tue. Oct 20th, 10am–5pm ET
20 left
Book
Wed. Oct 28th, 10am–5pm ET
20 left
Book
Thu. Nov 5th, 10am–5pm ET
20 left
Book
Mon. Nov 9th, 6–9pm ET
Show all 2 sessions
  • Mon, Nov 09 at 6:00pm - 9:00pm
  • Wed, Nov 11 at 6:00pm - 9:00pm
20 left
Book
Tue. Nov 10th, 10am–5pm ET
20 left
Book
Showing 1 – 5 of 74

Book a Private 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.

Class Description

Description Syllabus Cancellation Policy

Description

Advance your Excel expertise by mastering sophisticated functions such as VLOOKUP and SUMIFS, summarizing data with PivotTables, and applying powerful sort and filter capabilities to databases. Learn efficient text manipulation techniques to split and join data.

This course includes access to our comprehensive Excel video library, allowing you to review all materials at your own pace after class completion. Enroll in the Excel Bootcamp to receive a 15 percent discount on this intermediate course. The complete package includes our Fundamentals, Intermediate, and Advanced Excel courses.

This Course Has a Prerequisite:

  • Participants must have beginner-level Excel proficiency equivalent to our Excel Fundamentals course, including mastery of basic functions and formulas, printing, formatting, basic charts, and tables.

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

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

  • Using Concat and the & (ampersand) to combine 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

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]

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Noble Desktop (452)

(4.6-star rating across 452 reviews)

This class: 5.0 out of 5 from 1 review

  • Excel Level II: Intermediate

    This workshop was perfectly paced, informative, and exactly what I needed.
See reviews for other classes at Noble Desktop
loading...
Hide Reviews

Similar Classes

People who viewed this class also viewed the following classes

CourseHorse Gift Card
Pick your value!
Excel Level I: Fundamentals $299 for 1 session
Excel Level III: Advanced $299 for 1 session
Excel Specialist Certification Program $959 for 3 sessions
View all excel classes

Noble Desktop

Noble Desktop is a reputable New York-based training institute known for offering a wide range of creative and technical courses, including web development, design, coding, and digital marketing. With a strong emphasis on hands-on learning and industry-relevant skills, Noble Desktop equips individuals with the knowledge and expertise needed to excel in today's competitive job market.

View school profile
Noble Desktop
Vetted by CourseHorse

A verified Brooklyn educator.

CourseHorse’s Choice 4.6 out of 5 · 452 reviews

Give an experience worth remembering

One CourseHorse gift card. Thousands of classes to choose from.

  • Instant or scheduled delivery
  • No expiration date
  • Earn 15% reward points
Buy a Gift Card
gift card with the CourseHorse logo
Loading...