Excel Genius 4: Tables and Data Validation

at The New York Public Library (Tech) - Manhattan

(62)
Course Details
Price:
Free 4 seats left
Start Date:

Sat, Oct 19, 10:30am - 12:30pm

Location:
Manhattan
188 Madison Ave
Btwn E 34th & 35th Streets
New York, New York 10016
(Map)
Share:
Important:
Venue: Training Room 2
Purchase Options
Description
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 8

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

Still have questions? Ask the community.

Map

Google Map

The New York Public Library (Tech)

All classes at this location

Start Dates (1)
Start Date Time Teacher # Sessions Price
10:30am - 12:30pm TBD 1 Free

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 about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

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

(62 Reviews)
Excel Genius 4: Tables and Data Validation
Reviewed by Anonymous 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
loading...
Similar Classes

School: The New York Public Library (Tech)

The New York Public Library (Tech)
CourseHorse Approved

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

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here