# Excel Intermediate Course Online Canonical URL: ## Overview In this self-paced intermediate Excel course, you’ll build on your foundational skills by working with more powerful tools and functions. You’ll learn how to use VLOOKUP and SUMIFs, summarize data with Pivot Tables, sort and filter databases, and manipulate text using split and join functions. The course includes access to an Excel video suite, allowing you to revisit lessons anytime and reinforce concepts at your own pace. You’ll also have the option to enroll in this course as part of the Excel Bootcamp, which includes the Fundamentals, Intermediate, and Advanced Excel courses at a 15% discount. Throughout the course, you’ll practice splitting and joining text, adding data validation, using named ranges, applying database and logical functions such as VLOOKUP, HLOOKUP, AND, OR, and IF, analyzing large datasets with Pivot Tables, creating advanced combo charts, and reinforcing key concepts through a final project. ## Prerequisites Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables. ## Curriculum ### Worksheet Management #### Navigation - Keyboard shortcuts that facilitate quick and easy navigation within cells #### Formula Review - Review various methods for completing calculations ### Working with Text #### Splitting Text - Use Text to Columns to split text into multiple cells #### Joining Text - Join text from separate cells ### Cell Ranges #### Paste Special - Apply formats and perform calculations on selected cells #### Paste Special Values - Hardcode the answer to a formula or function #### Named Ranges - Assign a name to a range of cells to make it easier to reference those ranges in calculations ### Database Functions #### VLOOKUP & XLOOKUP - Use VLOOKUP and XLOOKUP to find information in cell range and return information from another cell range #### Sort & Filter - Use Sort & Filter to find and organize data in large databases ### Pivot Tables #### Pivot Tables - Create Pivot Tables to quickly summarize large databases #### Pivot Tables & Grouping - Group within Pivot Tables #### Multiple Pivot Tables - Create multiple Pivot Tables on a single worksheet ### Logical Functions #### IF statements - Use IF statements to return output based on the contents of another cell #### AND, OR - Tests to see whether multiple conditions are true ### Math Functions #### SUBTOTAL - Use SUBTOTAL function to sum/average/count values based on what is not filtered ### Statistical Functions #### SUMIFS - Use SUMIFS function to sum cells based on one or more conditions #### COUNTIFS - Use COUNTIFS function to count cells based on one or more conditions ### Improve Data Quality #### Data Validation - Restrict the type of data that can be allowed in a cell #### Remove Duplicates - Eliminate duplicate row data ### Advanced Charts #### Combo Charts - Combine two or more charts into a single chart, with the option of adding a secondary axis ### End of Class Project #### Project - End of class project to review key concepts from the class ## 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 ### Who is the target audience for this course? Participants with basic Excel proficiency who want to expand their skills with intermediate-level functions and data tools, including: - Those working in or seeking roles in business, finance, operations, or analytics that require proficiency in VLOOKUP/XLOOKUP, SUMIFS, data summarization via PivotTables, text manipulation, and data validation. - College or graduate students in business, economics, STEM, or data-related fields who want hands‑on experience using intermediate Excel features like sorting/filtering, logical functions, PivotTable grouping, and combo charts. - Analysts, administrative professionals, or spreadsheet users aiming to improve efficiency by mastering database functions, named ranges, advanced charting, and managing diverse datasets with Split and Join text techniques. ### 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:** $249