# Excel for Data Analytics (Self-Paced)

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

## Overview

Apply Excel to Data Analytics in this hands-on class designed to help you master core functions and formulas while building practical skills through guided projects. You’ll learn to sort, filter, group, and visualize data in Excel, developing the expertise to turn raw information into clear, actionable insights.

## What you'll learn

- Learn Excel functions and formulas for organizing, calculating, and summarizing data efficiently
- Create and customize visual charts, including 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 Pivot Tables 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

## Pricing

**Tuition:** $595