# Excel for Data Analytics Course Online (Self-Paced)

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

## Overview

#### Apply Excel to Data Analytics

If You Want to Learn Excel and 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

- 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