Excel Course NYC
IDCME

Hands-on Training from Experts NYC or Live Online

Book self-paced course Request group training
Loading...

This course includes

  • 24 hours of live, project-based training from experts
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution

Courses in this Package

This is the recommended order, but some courses may be taken in a different order.

Download Syllabus PDF

Unit 1 6 Hours

Excel Level I: Fundamentals

In this beginner Excel course, you will learn the essentials of Microsoft Excel, including calculators, basic functions, graphs, formatting, and printing.

  • Become familiar with the interface and data entry
  • Learn essential formulas and functions
  • Format and print your work
  • Create charts, including line, column, and pie charts
  • Learn tips and tricks for easy workbook management
  • Review key concepts in a final project

Unit 2 6 Hours

Excel Level II: Intermediate

Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort and Filter databases, and split and join text.

  • Learn to split and join text, add data validation, and use named ranges
  • Use database functions such as VLOOKUP and HLOOKUP
  • Add logical statements, including AND, OR, and IF statements
  • Create PivotTables to quickly summarize large databases
  • Use statistical functions such as RANK, COUNTIFS, and SUMIFS
  • Create advanced combo charts from multiple charts
  • Review key concepts by creating a final project

Unit 3 6 Hours

Excel Level III: Advanced

Learn all of the most complex features of Microsoft Excel in this advanced training course.

  • Understand cell management, including cell locking, auditing, and hotkeys
  • Learn special formatting for calculating dates
  • Use advanced functions, such as nested IF statements
  • Learn advanced analytical tools for data consolidation, conditions to exclude data, and PivotCharts
  • Use advanced database functions, such as MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
  • Record macros and relative reference macros for ad-hoc reporting
  • Create a project that applies key concepts from the class

Schedule & Enrollment: Excel Course NYC

  • 24 Hours
  • Price before discounts: $747 Full tuition: $549
  • NYC or Live Online
  • Expert instructors
  • Small classes

  • Self-Paced More details
    Start anytime Online only

  • Custom Schedule
    Enroll

A group of adult learners sits in a classroom, smiling and engaged in a government training session.
A government training instructor in a suit gestures while teaching in front of a whiteboard covered with notes and diagrams.
A person in professional attire holds a Graduate School USA folder, symbolizing participation in government training programs.

Group Training

Since 1921, Graduate School USA has partnered with over 125 federal agencies and trained more than one million federal employees. Led by instructors with deep, real-world knowledge of federal regulations, policies, and practices, our private group programs are practical, mission-driven, and tailored to your agency’s objectives. We offer expertise across key federal domains—including human resources, financial management, acquisition and contracting, leadership, and more—to deliver training where and how your team needs it.

Complete this form and we’ll get back to you within 1 business hour.

The Fact Is – We’ve Been Government’s Training Partner Since 1921

400+ Courses & Certificates 125+ Federal Agencies Served 200+ Subject-Matter Experts