# Excel Advanced Course Online Canonical URL: ## Overview In this advanced self-paced Excel course, you’ll learn how to unlock the full potential of Microsoft Excel by moving beyond basic spreadsheet organization into advanced data manipulation and visualization techniques. The course focuses on improving workflow efficiency, generating deeper insights from data, and using Excel’s powerful analytics tools, including macros, to manage complex spreadsheets more effectively. As you progress, you’ll work with advanced functions such as MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH to handle large and complex datasets across a wide range of professional scenarios. You’ll also manage cells using locking, auditing, and keyboard shortcuts, apply special formatting for date calculations, build nested IF statements, leverage analytical tools for consolidation, filtering, and pivot charts, record and create relative reference macros for ad-hoc reporting, and complete a final project to apply the key concepts learned throughout the course. ## Prerequisites Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements. ## Curriculum ### Advanced Navigation #### Advanced Navigation - Advanced navigation techniques #### Fill Review - Review of Autofill conventions and techniques ### Cell Management #### Advanced Cell Locking - Create powerful formulas by locking either the column or the row #### Hot Keys - Transform the ribbon into a visual listing of pre-assigned shortcuts #### Cell Auditing - Observe the relationship between formulas and cells #### Go To Special - Quickly select cells that meet certain criteria ### Special Formatting #### Conditional Formatting-Formulas - Create custom rules for Conditional Formatting with formulas #### Date Functions - Calculate dates with a variety of functions #### Custom Number Formats - Customize number formats to meet specific requirements ### Advanced Functions #### Nested IF statements - Nested "IF" statements allow for more than just two possibilities in a single cell #### IF statements with AND/OR - Expand the functionality of the IF function by adding an AND / OR criteria ### What If Analysis #### Goal Seek - Find the desired result by adjusting an input value #### Data Tables - Data Tables show the range of effects of one or two different variables on a formula ### Advanced Analytical Tools #### Calculation Options - Minimize volatility by changing calculation options #### Conditional SumProduct - Use SumProduct with conditions to exclude data that does not meet certain criteria #### Pivot Table-Base Fields & Sets - Analyze data in a Pivot Table with increased granularity by defining base fields and sets #### Pivot Table-Calculations - Create calculated rows or columns in a Pivot Table that go beyond the source data #### Pivot Charts - Create dynamic, graphical representations of Pivot Table data ### Advanced Database Functions #### XMATCH function - Return the relative position (column or row number) of a lookup value #### INDEX-MATCH - Efficiently return a value or reference from a cell at the intersection of the row and column #### INDEX-Double MATCH - Use a second Match function to create a powerful, two-way lookup tool ### Introduction to Macros #### Recording Macros - Record macros that involve formatting and calculations ### Dynamic Arrays #### Dynamic Arrays - Use formulas that can return arrays of variable size ### End of Class Projects #### Projects - 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 intermediate Excel experience who want to master advanced functions, macros, and analytics for professional data workflows, including: - Those working in or seeking roles in business, analytics, finance, operations, or data-driven industries that require proficiency in advanced functions like INDEX/MATCH, nested IFs, pivot chart calculations, and dynamic arrays, as well as automation via macros. - College or graduate students in business, STEM, economics, or related fields who want hands-on practice applying complex Excel techniques such as What‑If analysis (Goal Seek, Data Tables) and constructing sophisticated spreadsheet tools. - Excel users, analysts, or professionals aiming to streamline workflows and generate deeper insights by leveraging advanced features, including cell auditing, conditional formatting, pivot table base fields & sets, and macro recording. ### 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