# Excel for Data Analytics Course

Canonical URL: <https://www.graduateschool.edu/courses/excel-data-analytics>

## Overview

Enhance your spreadsheet expertise with this three-part Excel Bootcamp, starting with core skills like formulas, functions, and charts, then advancing to data management with PivotTables, validation tools, and logical statements.

You’ll finish by mastering advanced features and automation techniques, including macros, auditing, and custom reporting—equipping you with the full range of Excel tools to streamline workflows, manage large datasets, and create dynamic, professional reports.

## 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 — Live Online
- Jul 7, 2026 – Jul 9, 2026 — Live Online
- Aug 24, 2026 – Aug 26, 2026 — Live Online
- Sep 8, 2026 – Sep 24, 2026 — Live Online
- Sep 27, 2026 – Oct 11, 2026 — Live Online
- Oct 13, 2026 – Oct 15, 2026 — Live Online

## Pricing

**Tuition:** $595