Become proficient in Microsoft Excel and go from beginner to pro with our hands-on Excel Bootcamp. Learn functions, formulas, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
In this hands-on course, learn how to automate repetitive tasks in Microsoft Excel using VBA programming. Develop macros, custom commands, and new worksheet functions to streamline your Excel workflow and increase productivity.
Boost your resume with a Microsoft Excel Certification. Our program offers three courses, private training, the Specialist Exam fee with free retake, lifetime access to Excel video courses, and free exam proctoring.
Excel is a spreadsheet tool offered by Microsoft and is among the most popular spreadsheet tools available. As part of the ubiquitous Microsoft Office Suite, Excel is a powerful tool for converting raw data into valuable information that can drive intelligent business decisions.
By learning Excel, you give yourself the ability to organize and present data in tables, create charts and graphs, and, with additional training, create visualizations that bring your data to life. With Excel, you can perform mathematical functions, create strings of data, conduct statistical analysis, and summarize data with PivotTables.
Although proficiency in Excel is generally not enough on its own to begin a high-profile career, many jobs do require the use of this tool. For example, business, digital, data, financial, and investment analysts all use Excel spreadsheets to organize and share their data. Experience with Excel is a valuable asset when looking for a job or promotion, particularly in business and finance. Understanding how to read data is one thing, but employers also want to know that you know how to organize the data and present it in a format that is easy to understand.
If you’re looking for an office job or a finance career in Chicago, knowing Excel can definitely benefit you. Chicago is one of the nation’s leading financial hubs, home to major banks, investment firms, and trading institutions such as BMO Harris, Chase, Northern Trust, DRW, and Jump Trading. The city hosts globally recognized organizations like the Chicago Mercantile Exchange (CME Group) and the Chicago Board Options Exchange (CBOE). Its strong banking, insurance, and fintech sectors contribute significantly to the city’s economy, attracting professionals in finance, analytics, and technology. Financial Analysts in this city earn about $81,000 yearly, and Business Analysts $86,000.
Excel Fundamentals Level 1
Noble Desktop’s Excel Fundamentals Level 1 is an all-encompassing starter course for those new to Microsoft Excel. It is tailored for beginners and methodically covers fundamental aspects like performing calculations, utilizing basic functions, and managing data entry. The interactive teaching approach allows students to grasp a concept, see it in action, and then apply it through guided exercises. The course further explores the art of formatting and teaches the creation of diverse chart types such as line, column, and pie charts, to visualize data effectively. It includes additional insights for efficient workbook management. Students will culminate their learning with a comprehensive final project that encapsulates the essential elements taught throughout the course and will be equipped with a detailed training manual for continued learning and application of Excel beyond the classroom.
Excel Bootcamp
Noble Desktop’s Excel Bootcamp equips participants with the skills to become adept at Microsoft Excel, transitioning from beginner to advanced users over a series of three distinct classes, all within a hands-on, three-day learning experience.
The bootcamp begins with Excel for Business Fundamentals, where students are introduced to essential concepts like calculations, functions, chart creation, formatting, and the nuances of printing within Excel. Progressing to Intermediate Excel for Business, attendees build upon their knowledge with more complex functions, including VLOOKUP and SUMIFS, as well as data summarization using PivotTables and the intricacies of sorting, filtering, and text manipulation.
In the final leg of the Advanced Excel for Business course, students tackle advanced database functions such as INDEX and MATCH, dip into the automation of tasks using basic macros, and explore What-If Analysis tools like Goal Seek and Data Tables. This comprehensive bootcamp is structured to provide a robust learning curve, ensuring that participants are well-versed in the powerful features of Excel by the end.
Advanced Excel & Financial Modeling Intensive
Noble Desktop’s Advanced Excel & Financial Modeling Intensive is a targeted program that delivers expert-level training in advanced Excel features and comprehensive financial modeling. This immersive experience is designed to refine core Excel abilities and extend into specialized financial skills necessary for roles such as Financial Analyst.
The intensive begins with Core Excel Skills on the first day, where participants enhance their knowledge of formulas, functions, PivotTables, and VLOOKUP, advanced analytical tools, and essential shortcuts. Day two transitions to Advanced Excel for Finance, focusing on financial functions and modeling, sensitivity analysis, and key Excel techniques required in financial analysis.
The third day is dedicated to foundational financial accounting and corporate finance knowledge, which are critical for understanding and building financial models. The course culminates on the fourth day with a Financial Modeling Intensive, where attendees apply what they’ve learned by constructing a Discounted Cash Flow model for an actual public company. This program is meticulously designed for those aiming to deepen their mastery of Excel in the context of finance and modeling.
Excel, Finance, & Investing Summer Program
The Excel, Finance, & Investing Summer Program by NextGen Bootcamp in NYC is an immersive one-week course designed for high school and college students interested in mastering Microsoft Excel and understanding the fundamentals of finance and stock market investing. Aimed at beginners, the program introduces participants to the critical business application of Excel and covers essential finance and investment principles.
Throughout the course, students will evolve from learning basic data entry and chart creation to mastering advanced functions like Pivot Tables, VLOOKUP, and macro recording in Excel, setting the stage to become proficient Excel users. The finance and investing component demystifies how stock prices fluctuate and the factors influencing investor valuations, incorporating real-world analysis of financial giants like Google and Apple.
In addition to technical skills, the course prepares students to meet the expectations of future employers, giving them an edge in college and internship opportunities. Instructors with substantial experience and credentials from top business schools lead the program, ensuring high-quality, practical education. The course is offered in-person in NYC and online, accommodating different learning preferences.
Noble Desktop also offers corporate Excel training in-person and live online. It’s common for Excel to go underutilized in workplaces. If you’re in an industry that benefits from experienced Excel users, seeking corporate onsite or virtual training can be a great investment in your company’s future.
Custom courses can be designed to teach employees a specific set of skills if a course to meet the need doesn’t already exist. To arrange for private or group training at your place of business, contact us today at corporate@nobledesktop.com.
In the heart of the Midwest’s finance capital, there’s opportunity everywhere. From tech startups in Fulton Market to powerhouse Fortune 500 firms in the Loop, Chicago offers a virtually endless array of ways to level up your skills in tech, business, data, and design. The city thrives on bold ideas, making it the perfect place to grow a career that is not only lucrative but also makes a real impact. With expert instructors with decades of experience, you’ll learn more about the subjects you’re interested in, all while receiving hands-on training. These instructors live and breathe to explore and work within their field, meaning they don’t just teach; they mentor, guide, and connect you to the heart of Chicago’s many successful industries and direct you to the most meaningful path to help you achieve your goals.
Noble Desktop’s partner school, Practical Programming, has state-of-the-art facilities conveniently located in downtown Chicago’s iconic Hayworth Building at 29 E. Madison Street, Chicago, IL, 60602. It’s an easy-to-find location for students from across the city to attend. The campus is modern, equipped with the necessary tech and tools you may need, and provides resources like Wi-Fi, comfortable workstations, and expert instructors and staff ready to help you learn. Getting there is simple, whether you’re commuting from the Loop, River North, or surrounding areas. The school is easily accessible from the CTA trains and buses, with nearby stops for major lines like the Red, Blue, and Brown. If you’re driving, you can park nearby at various parking decks and metered spots within walking distance. The central location means you won’t have to stress about making it to class, and that your training sessions can fit into any schedule with ease.
Excel remains one of the most prominent tools for analysis, reporting, and decision-making in Chicago’s business and government environments. Students taking classes with Noble Desktop will get to learn from instructors who demonstrate the formulas, tools, and workflows that professionals rely on every day.
Henry Gonzalez is a certified Project Management Professional (PMP) with over 30 years of experience in the federal government, leading engineering, program management, and acquisition initiatives in naval warfare, air traffic management, and homeland security. A retired senior executive, Henry now serves as a part-time instructor in Chicago, where he teaches project and program management, leadership, and strategic planning to professionals of all kinds. He holds the highest level of federal certification one can hold for acquisition program management and systems engineering. In addition, Henry was part of the core team that updated the Project Management Institute’s Standard for Program Management. Henry is also a certified Balanced Scorecard Professional and holds a Bachelor of Science in Ocean Engineering from Florida Atlantic University, along with a dual Master of Science in Ocean Engineering and Ocean Systems Management from MIT.
Robert Simon is a highly accomplished financial management professional and educator with more than four decades of federal and private sector experience. As a Financial and Management Curricula Instructor at Graduate School USA since 2007, he teaches courses in financial management, federal travel regulations, and organizational leadership, both virtually and in person. Prior to his teaching career, he held senior roles at the General Services Administration, overseeing a six-state regional budget of approximately $100 million, and at the U.S. Treasury’s Financial Management Service, where he led national training initiatives on electronic banking. Robert’s background spans accounting, budgeting, and program analysis, holding certifications as a Certified Public Accountant and Certified Government Financial Manager.
Edward (Scott) Dillion is a seasoned financial expert with over three decades of experience in the Department of Defense, where he specialized in a range of financial management areas like budgeting and auditing, as well as performance-based management and cost analysis. He holds an MBA from Southern Illinois University and a B.A. in Business Administration from Grove City College. After retiring in 2014, Scott pivoted to a second career in education and consulting. He teaches project management and marketing at Graduate School USA and has also taught courses in federal budgeting. Additionally, Scott serves as a Subject Matter Expert (SME) for Management Concepts Inc., where he helps develop financial management course materials. He also has a lifetime membership with the American Society of Military Comptrollers, holds a Top Secret security clearance with the Department of Defense, and is a recognized Tier 2 instructor at Graduate School USA for his wealth of experience.