# Excel for Data Analytics Course Online Canonical URL: ## 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 PivotTables 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 Community 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. ### Is this course open to beginners? Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required. ### Do you offer payment plans or student financing for this course? This course does not qualify for payment plans or student financing. See our Payment Options FAQ to find related programs that qualify. ### How long do I have access to the course materials? This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable. ### What is the cancellation and refund policy for this single course? For this course, you are entitled to a 90% refund (your payment less the nonrefundable 10% registration fee) within 30 days of purchase if you have not accessed the course materials. ### What’s included with my tuition? A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed Access to Microsoft Office (1 month) during your training Expert support with answers to your questions from real instructors throughout your learning journey Top-notch curricula that have been tried and tested over many years and are consistently improved for an optimal learning experience A certificate of completion to verify your accomplishment The confidence of learning at an accredited institution ### 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. ### Do you offer any discounts for this course? Take this course as part of a certificate program and save: Data Analytics Certificate Online Price: $4,995 | Hours: 156 Hours Data Analytics & AI Certificate Online Price: $6,995 | Hours: 210 Hours ## Pricing **Tuition:** $595