# Excel for Data Analytics Course Online

Canonical URL: <https://vdci.edu/courses/excel-for-data-analytics-online>

## Overview

This course is built for anyone ready to treat Excel as a serious data analytics tool instead of just a place to keep simple spreadsheets. You'll dig into real data sets and project based work that demonstrates how Excel can sort, filter, group, and visualize information in ways that actually mean something. With the freedom to move through the material on your own schedule, you'll discover how to apply core functions and formulas that organize data efficiently and transform raw numbers into clear, usable insights.

As you move forward, you'll develop sharper skills for analyzing and presenting your findings. You'll build and customize charts, put logical statements and database functions to work on large data sets, and rely on Pivot Tables to summarize information in seconds. You'll also get introduced to tools like named ranges, date calculations, macro recording, and auditing features, all of which help you tighten your workflow and produce spreadsheets that are more dependable and polished.

## What you'll learn

- Apply Excel functions and formulas to organize, calculate, and summarize data with efficiency
- Design and tailor visual charts, including line, column, and pie charts, to present data clearly
- Work with logical statements, database functions, and data validation to manage and filter large datasets
- Construct and adjust PivotTables to quickly summarize, sort, and group information
- Discover advanced tools such as named ranges, date calculations, and macro recording for custom reporting
- Use auditing techniques, cell locking, and Excel hot keys to streamline 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

## Instructors

### Garfield Stinvil — Instructor

Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.

Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. 

Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.

### Colin Jaffe — Instructor

Colin Jaffe is a programmer, writer, and teacher with a passion for creative code, customizable computing environments, and simple puns. He loves teaching code, from the fundamentals of algorithmic thinking to the business logic and user flow of application building—he particularly enjoys teaching JavaScript, Python, API design, and front-end frameworks.

Colin has taught code to a diverse group of students since learning to code himself, including young men of color at All-Star Code, elementary school kids at The Coding Space, and marginalized groups at Pursuit.

Colin lives in Brooklyn with his wife, two kids, and many intricate board games.

### Brian McClain — Instructor

Brian McClain is an experienced instructor, curriculum developer, and web developer. Brian served as Director for a coding bootcamp, where he is now a lead instructor and course developer for both JavaScript and Python. He teaches Web Development, JavaScript, Python for Data Science, Machine Learning, and AI. He taught Python Data Science and Machine Learning as an Adjunct Professor of Computer Science at Westchester County College.

Brian is also an active industry professional in the field of generative AI app development. His website and iOS app, Artmink, provide appraisals of art and antiques from user-uploaded images.

## Pricing

**Tuition:** $595