# Excel Level I: Fundamentals Course Online (Self-Paced) Canonical URL: ## Overview In this beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This basic Excel class is perfect for those with limited experience looking to expand their proficiency. #### Practical Hands-On Training Our Excel course includes practical exercises that walk you through the basics. Learn the concept, watch an example, and complete an activity with the new concept on your own. At the end of the course, you’ll keep your training guide for reference whenever you use Excel. #### Comprehensive Excel Video Suite After completing the Excel Level I course, you'll receive access to our companion video suite, featuring beginner-level video lessons available for viewing on desktop, mobile, and tablet. These video tutorials explain popular Excel concepts in simple steps. ## What you'll learn - Become familiar with the interface and data entry - Learn essential formulas and functions - Format and print your work - Create charts, including line, column, and pie charts - Learn tips and tricks for easy workbook management - Review key concepts in a final project ## Curriculum ### Introduction #### Interface - Provides a brief description of the user interface for Microsoft Excel #### Worksheets - Manage elements of worksheets #### Data Entry - Examines and describes multiple means of entering data #### Rows & Columns - Insert, delete, hide, and group rows and columns ### Formulas #### Autofill - Explores Excel's amazing ability to predict and extrapolate patterns #### Calculations - Perform mathematical expressions and review the Order of Operations rule #### AutoSum Functions - Review the five key functions: Sum, Average, Max, Min, and Count Numbers #### Absolute Reference - Changing a cell reference into a constant, which is necessary for certain calculations #### True or False - Tests to see whether criteria is true/false #### Text Functions - Introduces functions used to modify text in Excel #### Multi-Input Functions - More advanced functions that require more than one input ### Formatting #### Formatting - The addition of effects to an Excel document to provide visual instruction #### Cell Styles - Apply consistent formatting to specific types of cells or values #### Conditional Formatting - Apply a predetermined format based on specified rules ### Charts & Tables #### Tables - Explore the special functionality created when data is converted to a Table #### Column Chart - Create a Column chart to visually examine data #### Line Chart - Create a Line chart and Spark lines to visually examine data #### Pie Chart - Create a Pie chart to visually examine data ### Workbook Management #### Freeze Panes - Enable a portion of the screen to stay visible at all times #### Printing - Rules and strategies to make printing easy #### Windows - Change how your worksheet displays data #### Templates - Use prefabricated templates to build a spreadsheet #### Excel Tricks - Fundamental keyboard shortcuts and other Excel tricks ### End of Class Projects #### Projects - End of class projects to review key concepts from the class ## 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. ## Pricing **Tuition:** $249