# Excel for Data Analytics

Canonical URL: <https://www.nobledesktop.com/classes/excel-data-analytics>

## Overview

Advance your spreadsheet skills with this three-part Excel Bootcamp, covering foundational techniques, intermediate tools, and advanced automation. Learn how to navigate Excel, use formulas and functions, format spreadsheets, and create charts to present data clearly and professionally.

Build on those skills by working with data validation, logical statements, PivotTables, and advanced combo charts to manage and analyze large datasets. Then master high-level tools including cell auditing, keyboard shortcuts, special date functions, and macro recording to boost productivity and streamline reporting.

## What you'll learn

- Learn Excel functions and formulas to organize, calculate, and summarize data efficiently
- Create and customize visual charts, such as line, column, and pie charts, to present data clearly
- Use logical statements, database functions, and data validation to manage and filter large datasets
- Build and manipulate PivotTables to quickly summarize, sort, and group information
- Explore advanced tools like named ranges, date calculations, and macro recording for custom reporting
- Apply auditing techniques, cell locking, and Excel hot keys to optimize your spreadsheet workflow

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