# Excel Level III: Advanced Canonical URL: ## Overview This advanced Excel course is designed for experienced users who want to take on more complex calculations, analysis tools, and workflow improvements. Students learn advanced navigation techniques, mixed references, auditing tools, custom conditional formatting with formulas, date functions, and custom number formats, along with more sophisticated logic using nested IF statements and IF formulas with AND/OR criteria. The course also introduces What-If Analysis with Goal Seek and Data Tables, advanced PivotTable calculations, Pivot Charts, XMATCH, INDEX-MATCH, INDEX with Double MATCH, macros, and dynamic arrays. It prepares students to build more flexible models, automate repetitive tasks, and approach spreadsheet analysis with greater precision. ## What you'll learn - Use advanced navigation tools, Autofill techniques, Hot Keys, and Go To Special to move through worksheets and work more efficiently. - Build stronger formulas with mixed references, cell auditing tools, date functions, and custom number formats. - Create advanced logic with nested IF statements and IF formulas that incorporate AND/OR criteria for more flexible results. - Perform What-If Analysis with Goal Seek and Data Tables to test variables and evaluate possible outcomes. - Analyze data with advanced PivotTable tools, including base fields and sets, calculated fields, and Pivot Charts. - Use XMATCH, INDEX-MATCH, macros, and dynamic arrays to create powerful lookups, automate tasks, and complete an end-of-class project reviewing key concepts. ## Prerequisites Attendees must have Excel proficiency equivalent to our [Intermediate Excel course](/classes/intermediate-excel-classes), 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 #### Mixed Reference Formulas - 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 #### 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 ## Schedule - Jun 3, 2026 10:00am–5:00pm — NYC - Jun 9, 2026 – Jun 11, 2026 — NYC - Jun 18, 2026 10:00am–5:00pm — NYC - Jul 1, 2026 10:00am–5:00pm — NYC - Jul 9, 2026 10:00am–5:00pm — NYC - Jul 22, 2026 10:00am–5:00pm — NYC - Jul 31, 2026 10:00am–5:00pm — NYC - Aug 13, 2026 10:00am–5:00pm — NYC - Aug 26, 2026 10:00am–5:00pm — NYC - Sep 3, 2026 10:00am–5:00pm — NYC - Sep 10, 2026 10:00am–5:00pm — NYC - Sep 22, 2026 – Sep 24, 2026 — NYC - Oct 11, 2026 10:00am–5:00pm — NYC - Oct 15, 2026 10:00am–5:00pm — NYC ## Instructors ### Brian McClain — Program Director & Senior Instructor Brian McClain is an experienced instructor, curriculum developer, and web developer. Brian served as Director for a coding bootcamp before joining Noble Desktop in 2022, 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. Prior to Noble, 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, provides appraisals of art and antiques from user-uploaded images. ### Mourad Kattan — Program Director & Instructor Mourad Kattan is an instructor and Program Director of Business, Finance, & Excel at Noble Desktop, teaching classes and designing courses in Excel, finance, accounting, and financial modeling. Before Noble Desktop, Mourad worked as a financial analyst at Credit Suisse and H/2 Capital Partners. In those positions, he used advanced analytical and financial skills to evaluate a variety of investments. Mourad graduated from the University of Pennsylvania summa cum laude and is part of the Beta Gamma Sigma honor society. Learn more about [Mourad Kattan's](/mourad-kattan) background and expertise. ### Adebayo Norman — Instructor Adebayo "Ade" Norman is a Senior Software Trainer with over 14 years of experience in the classroom. He is a training professional with vast troubleshooting/help desk experience and thousands of hours of software training & delivery experience. His specialty is in the In-person/Online Hybrid training environment needed in these new & changing times. ### Garfield Stinvil — Senior 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 before working at Noble. 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. ## FAQ ### What version of Excel does this course cover? The instructors typically present using Excel 2019 or Office 365. However, you can also use Excel 2013 or 2016; the exercises and interface are compatible with what we teach (with some minor differences that the instructor will explain). ## Pricing **Tuition:** $249