# Excel for Data Analytics Course Online

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

## Overview

This course is designed for anyone who wants to use Excel as a powerful tool for data analytics rather than just basic spreadsheets. You’ll work with real data sets and hands-on projects that show how Excel can be used to sort, filter, group, and visualize information in meaningful ways. The best part? You get to learn this at your own pace. Along the way, you’ll learn how to apply core functions and formulas to organize data efficiently and turn raw numbers into clear insights.

As the course progresses, you’ll build more advanced skills for analyzing and presenting data. You’ll create and customize charts, use logical statements and database functions to manage large data sets, and work with Pivot Tables to summarize information quickly. The course also introduces tools like named ranges, date calculations, macro recording, and auditing features, helping you streamline your workflow and produce more reliable, professional spreadsheets.

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

## FAQ

### Are there any additional fees or expenses?

There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.

## Pricing

**Tuition:** $595