# Excel Level II: Intermediate Canonical URL: ## Overview This intermediate Excel course focuses on working more efficiently with larger datasets and more capable formulas. Students learn how to split and join text, use named ranges and Paste Special, apply data validation, sort and filter lists, remove duplicates, and use lookup and logic functions such as VLOOKUP, XLOOKUP, IF, AND, OR, SUMIFS, and COUNTIFS. Students also learn how to summarize and analyze data with PivotTables, grouping tools, and multiple PivotTables on a single worksheet. This course is ideal for those ready to clean up data, build smarter spreadsheets, and take on more detailed reporting tasks. Take this class as part of the Excel Bootcamp and get a 15% discount. The package includes our Fundamentals, Intermediate, and Advanced Excel classes. ## What you'll learn - Navigate worksheets more efficiently using keyboard shortcuts and Excel tools that speed up movement within and between cells. - Work with formulas and text by reviewing calculation methods, splitting text with Text to Columns, and joining text with CONCAT and the ampersand. - Manage cell ranges with Paste Special, Paste Special Values, and named ranges to format data, hardcode results, and simplify references in calculations. - Use database tools such as VLOOKUP, XLOOKUP, Sort & Filter, and Remove Duplicates to find, organize, and clean large sets of data. - Build PivotTables to summarize large databases, group data within PivotTables, and create multiple PivotTables on a single worksheet. - Apply logical, math, and statistical functions including IF, AND, OR, SUBTOTAL, SUMIFS, and COUNTIFS to analyze data based on conditions and filtered results. - Improve data quality with Data Validation and reinforce key course concepts by completing an end-of-class project. ## Prerequisites Attendees must have beginner Excel skills equivalent to our [Excel Fundamentals course](/classes/basic-excel-classes), 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 - Using Concat and the & (ampersand) to combine 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 ### End of Class Project #### Project - End of class project to review key concepts from the class ## Schedule - May 20, 2026 10:00am–5:00pm — NYC - May 28, 2026 10:00am–5:00pm — NYC - Jun 2, 2026 10:00am–5:00pm — NYC - Jun 2, 2026 – Jun 4, 2026 — NYC - Jun 10, 2026 10:00am–5:00pm — NYC - Jun 17, 2026 10:00am–5:00pm — NYC - Jun 23, 2026 10:00am–5:00pm — NYC - Jun 30, 2026 10:00am–5:00pm — NYC - Jul 8, 2026 10:00am–5:00pm — NYC - Jul 14, 2026 10:00am–5:00pm — NYC - Jul 21, 2026 10:00am–5:00pm — NYC - Jul 30, 2026 10:00am–5:00pm — NYC - Aug 12, 2026 10:00am–5:00pm — NYC - Aug 12, 2026 10:00am–5:00pm — NYC - Aug 25, 2026 10:00am–5:00pm — NYC - Sep 2, 2026 10:00am–5:00pm — NYC - Sep 9, 2026 10:00am–5:00pm — NYC - Sep 15, 2026 – Sep 17, 2026 — NYC - Oct 4, 2026 10:00am–5:00pm — NYC - Oct 4, 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