# Excel for Data Analytics

Canonical URL: <https://www.careercenters.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
- 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