# Excel for Data Analytics

Canonical URL: <https://training-nyc.com/courses/excel-data-analytics>

## Overview

#### Apply Excel to Data Analytics

If you’re a basic Excel user who wants to dive into data analytics, this is the class for you.

#### Build Skills with Hands-On Projects

To learn efficient data analysis, you'll complete projects under the guidance of an experienced instructor.

#### Learn Core Functions & Formulas

Learn advanced techniques to sort, filter, group, and visualize data in Excel.

## What you'll learn

- Common database and statistical functions
- Summarize data with Pivot Tables
- VLOOKUP and other lookup functions
- How to sort & filter data
- Tips & tricks to speed up workflow
- Basic macro creation for data analytics work

## Curriculum

#### Excel Level I: Fundamentals

- Learn how to use functions to speed up your workflow
- Add formatting and other visual effects
- Turn data into visual charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management

#### Excel Level II: Intermediate

- Learn to split and join text, add data validation, and named ranges
- Use database functions and logical statements
- Create Pivot Tables to quickly summarize large databases
- Create advanced combo charts from multiple charts

#### Excel Level III: Advanced

- Cell management, including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions and advanced analytical tools
- Record macros and relative reference macros for ad hoc reporting

## Schedule
- May 26, 2026 – Jun 11, 2026 — NYC
- Jul 7, 2026 – Jul 9, 2026 — NYC
- Aug 24, 2026 – Aug 26, 2026 — NYC
- Sep 8, 2026 – Sep 24, 2026 — NYC
- Sep 27, 2026 – Oct 11, 2026 — NYC
- Oct 13, 2026 – Oct 15, 2026 — NYC
- Nov 9, 2026 – Nov 11, 2026 — NYC

## Pricing

**Tuition:** $595