Discover Classes. Earn Rewards.

Excel Genius 4: Tables and Data Validation is unfortunately unavailable

Thankfully we have 41 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 Genius 4: Tables and Data Validation

  • All levels
  • 18 and older
  • Free
  • NYPL Online Classroom
  • 2 hours
Excel Genius 4: Tables and Data Validation
Sold Out

Start Dates (0)

  • Free
  • NYPL Online Classroom
  • 2 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this excel class:

This Class will cover how to build and edit Tables, and how to write structured references that make function writing easier and more flexible. We will also cover data validation and build drop down lists in your spreadsheets.

Skills required:

  • Be able to Write functions
  • Understand Absolute vs Relative Cell References
  • Know how to navigate menu options in Excel

Skill prerequisites: Intermediate Excel

Note:

Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the world’s most popular spreadsheet application. Each class will cover a topic in depth and then give students exercises that apply that knowledge to real world situations.

While we recommend that students take the classes in order, there are no attendance requirements, and students are welcome to repeat or skip classes as they choose.

  • Class 1: Logic Functions
  • Class 2: Conditional Stat Functions
  • Class 3: Charts and Sparklines
  • Class 4: Tables, Structured References, and Data Validation
  • Class 5: Pivot Tables
  • Class 6: Lookup Functions
  • Class 7: Importing Data, String Functions, and Goal Seek

Class Requirements

Each Class will have its own set of specific requirements, but all classes will use the following skills:

  • Data Entry
  • Selecting Cells
  • Copy and Paste
  • Formatting Cells

Must register with a valid email address. The instructor will send out an email two (2) hours before the class starts.

These are registration based classes and spots may fill up quickly. If for any reason we're unable to accommodate your registration, we will let you know as soon as possible.


Reviews of Classes at The New York Public Library (Tech) (160)

(4.1-star rating across 160 reviews)
  • Excel Genius 4: Tables and Data Validation

    Anonymous review on 10/16/2018
    The class and subject was great but the teacher could have been better
  • Excel Genius 4: Tables and Data Validation

    Reviewed by Janice D. on 9/29/2019
See reviews for other classes at The New York Public Library (Tech)
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 0 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

The New York Public Library (Tech)

CourseHorse Approved

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

The New York Public Library (Tech)

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