Industry Professional Instructors
Our Excel instructors are industry professionals who draw on their experience to teach real-world applications and time-saving techniques. You’ll learn tips, tricks, and techniques to become an Excel guru.
Master Excel with hands-on classes from the experts. Learn VLOOKUP, Pivot Tables, macros, and more. Become proficient in the most in-demand business application.
Take your Excel skills to the next level with hands-on Excel training in NYC or live online. Get started in Excel with our beginner class, master advanced techniques with our advanced class, or learn it all with our Excel Bootcamp.
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.
Leverage Excel knowledge in more advanced financial training or take your analytics skills to the next level with our data analytics courses.
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.
Learn the essential skills needed to become a Data Analyst or Business Analyst, including data analysis, data visualization, and statistical analysis. Gain practical experience through real-world projects and prepare for a successful career in the field of data analytics.
Master the industry-standard tools and programming languages used by Data Analysts, including Excel, SQL, and Tableau, in this comprehensive classroom training program. Gain hands-on experience working on real-world projects and learn to organize, analyze, summarize, and visualize data to present actionable insights.
Learn how to extract information from databases and turn it into actionable insights by writing SQL queries, filtering data, and joining tables. This comprehensive SQL Server Bootcamp will teach you the fundamentals of SQL and how to apply them to various database systems.
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.
Join our financial modeling class to learn essential finance and accounting concepts, build a discounted cash flow (DCF) model in Excel, acquire advanced Excel skills, explore corporate finance and valuation, and create a financial model on a real company. This hands-on course will teach you practical financial skills.
Learn how to use Tableau, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. This course will teach you how to connect to datasets, analyze and structure data, customize visualizations, and publish your work.
Prepare for the Microsoft Excel exam and become an Excel expert with our certification program. Learn formulas, functions, Pivot Tables, charts, and more through group classes, private training, and an exam with a free retake.
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.
Learn the concepts and skills covered in these courses or your tuition is on us. See details and terms & conditions.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
The teaching method at Noble Desktop is perfect and the classes provide you with infinite knowledge that makes you eager to take everything they offer. I love Noble!
—Ivonne Ackerman
Experienced educators who are driven to help you succeed
Refresh the materials for free within one year
Request more info: corporate@nobledesktop.com
We’ve trained thousands of companies!
Let us create the perfect program for your team.
The Excel classes offered through NYIM are all designed to teach you the fundamentals of using the application, while simultaneously teaching you time-saving techniques and essential keyboard shortcuts. You’ll learn from industry professional instructors in small classes. And you even have the option of a free retake!
Our Excel instructors are industry professionals who draw on their experience to teach real-world applications and time-saving techniques. You’ll learn tips, tricks, and techniques to become an Excel guru.
Throughout the Excel classes you’ll learn essential concepts that you’ll be able to immediately apply to the workplace. Learn the material through hands-on exercises, then actually create a final project by the end of the class.
Each course includes the Excel workbook file that you use during the course and an accompanying manual that describes each exercise in detail. In addition to free retakes, the Excel classes also come with lifetime access to an online video suite of the course content.
From our hands-on training style to world-class instructors and proprietary curriculum, we deliver a learning experience our alumni can be proud of.
Our Excel Courses are rated 4.7 stars by 2,221 students
in the past 24 months
This class was great and I learned a lot about Excel basics and shortcuts. The instructor explained everything really specifically so it was easy to follow along.
Soyun Kim
Very impressive instructor who clearly communicates the material in an easy to understand style. Outstanding experience. I learned a lot, and feel well-prepared to effectively use Excel.
Marc Bernstein
As an Assistant Program Director, my job requires a lot of spreadsheets and data documentation. Being able to take a class that pinpoints all the ways to utilize a program that can make my life easier is something I wish I'd done earlier!
Danielle Justiniano
Great class, learned so many Excel features that I can't wait to use!
James Farrell
I really feel the Excel Bootcamp added a lot of value to my professional career.
Nietzsche Moura Mascarenhas
This course exceeded my expectations. Saba is a great instructor! She answered all my questions and went beyond to link it to real life examples.
Laura H.
Had a one on one training with Garfield - he was patient, professional, and incredibly knowledgeable. Would highly recommend for anyone looking to expand their Excel capabilities in business.
Alexandria A.
Great class! The content was well organized and the instructor was excellent. He was engaging, knew the material very well and was able to adjust to the various levels of ability of the students! Would definitely recommend!
Rebecca H.
It was a full day from 10am-5, fast-moving and packed with information on all the Excel basics, including on-the-spot exercises. Really useful for skills in managing all kinds of information and projects. I'd highly recommend this course, and would like to take the L2 when I'm ready!
Kathleen H.
Just came out of my Excel for Business training. Garfield, the instructor, is really nice And very helpful. They are very professional and they provide all the necessary tools for the students to acquire all the info they need, and, in case you want to refresh your memory you can always retake the course for free within 6 months. Cool, huh? :-)
Dana D.
Fast-paced class, a lot of information in a short amount of time—condensed to most useful tips and tricks. Very glad I was able to participate as I learned a lot more than I already knew. Michael was a great instructor with a very easygoing vibe.
Roksana B.
I can honestly say I learned more useful modeling and Excel skills from the Financial Modeling Bootcamp than I have through one and a half years of business school. The course effectively conveys key finance, corporate finance, and financial accounting concepts while also offering students the opportunity to build real financial models with real-time data. The 7:1 student to teacher ratio along with the experience and modeling expertise of Mourad offers a unique opportunity for a personalized learning experience. Whether you are a student looking to pursue a career in finance or a current professional simply looking to brush up on your Excel skills, I would highly recommend this course.
Noam Lipschutz
This was a great refresher course for some of the deeper financial concepts I have not used since undergrad. I think this course is phenomenal for recent college grads starting off their careers in finance or budget. It's a great intro for learning to navigate Excel shortcuts. I am 5 years in my career now and have never had the investment banking background but still have been a financial analyst and been involved in raising capital so the concepts covered were a great refresher for me.
Alexandria
The way NYIM understood our business model was unmatched. They catered a full three-day bootcamp directly to our specific business needs for a class of 30 analysts. All of the new hires were engaged and walked away with a better understanding of the way that we work in the Microsoft Office suite and the way we evaluate our business. I've been to plenty of Excel bootcamps throughout my career and this was by far the best; engaging, bespoke, and immediately applicable!
Kurt
WeWork
Released in 1987, Microsoft Excel is the world’s most commonly used spreadsheet program, with high estimates suggesting that the program has nearly three-quarters of a billion users globally. The application is one of the most popular computer applications in the professional world, and virtually everyone who works in an office building can benefit from knowing Excel. However, the program isn’t just for white-collar professionals like CPAs. Employees in virtually any career field where data organization is essential or productive can benefit from learning Excel. The program rewards new learners and advanced students alike, so no matter how much Excel training you have or plan to acquire, there are practical benefits to learning the application.
Students interested in learning Excel can opt to learn the basics of the program for everyday use, or they can receive more advanced training in the more complex aspects of the program. One of the reasons that Excel is so popular is that it has a robust collection of functionalities for new and experienced users, and students who only learn the basics of the program can still regularly use it to streamline their own workflow and optimize their data organization processes. Whether you are a Data Scientist looking to build complex, ten thousand-cell databases or a teacher looking for the best way to organize a grade book and an attendance calendar, Microsoft Excel is an ideal program to learn.
Since it is part of the Microsoft Office 365 suite, Excel is closely integrated with other important workplace software applications, like Microsoft Word and Microsoft Outlook. Anyone learning one of these programs will be able to take advantage of their access to Excel to build a tool kit of simple but versatile computer applications that they can apply in almost any professional setting.
The most basic function of Microsoft Excel is as a data organization tool. At its core, a spreadsheet is just a way to help users ensure that information is organized and easy to locate when needed. Learning Excel can help users of all skill levels organize their data, regardless of how much data they happen to be working with. Whether you are working in the financial department of a corporation and dealing with thousands of rows of accounting data or keeping productivity records for your company’s two dozen employees, Excel is one of the best programs available for tracking and organizing this data. This is true even for data organization that takes place outside of the workplace. Learning Excel can be useful for people looking to track their finances better or work on projects like cataloging health and exercise logs.
One reason Excel has become so popular is that it is incredibly easy to learn the basic functionalities of the program. As a tool used solely for organizing data, users are unlikely to need any training since the program has a Microsoft Word level of beginner accessibility. Beyond this, the program’s basic features are easy to pick up. Students looking to learn how Excel can calculate functions, build simple databases, and relate data points to one another can find a wide range of introductory materials to help them understand these features. Noble Desktop, for example, offers an Excel Level I: Fundamentals course that teaches students the basics of using Excel to create graphs, format tables, print pages, and utilize multi-page spreadsheets. Noble also offers a collection of free Excel resources and a free introductory seminar for students looking to learn the basics of the program.
Excel wouldn’t be as popular if it were just a simple spreadsheet program. Excel has a number of advanced data analysis, processing, and visualization features. Excel users can automate significant calculations and tasks by building complex functions and macros within their spreadsheets, they can turn their spreadsheets into elaborate and functional databases, and they can use data visualization tools to transform raw data into charts, graphs, and maps that Data Analysts can use to communicate information with stakeholders and other invested parties. Students interested in learning the more advanced functions of Excel can enroll in Noble’s Excel Bootcamp, in which students will learn these skills and more, including how to use Pivot tables and macros to streamline workflow.
Another advantage of learning Excel is that it is applicable in a wide range of different fields, and the databases that it is used to create can be used in many different contexts. The program has applications in data science, computer programming, financial analytics, and many other fields. Learning Excel can complement your existing skills and make a wide range of data-related work responsibilities much easier. Combined with the robust functions system and the deep customization offered by users' ability to write Macros, Excel is one of the most versatile programs you can learn.
Excel is a vital tool in many advanced computer science fields, including data science, machine learning and financial technology. Each of these fields uses Excel to organize and query large datasets that can provide astute programmers and analysts with actionable insights about trends and patterns. Learning Excel is only the first step in the process of learning data science, but it is one of the most important tools in the field, so if you are aspiring to work as Data Scientists, Machine Learning Engineer, or Investment Analysts (among a lot of other data related jobs), you’ll want to start by becoming familiar with the advanced functionalities of Excel.
As a data organization spreadsheet tool, there are a few obvious uses for Excel, but the program has a deep enough suite of tools that once you look beyond the surface, you’ll see that the program has something to offer virtually everyone. This versatility is one of the reasons that the program is so popular to learn and use since it doesn’t matter whether you are using Excel to manage hundreds of millions of dollars in a company’s financial department or managing your own extra spending money. You’ll find that Excel makes the process all that much easier.
A single MS Excel spreadsheet can be grouped with other Excel spreadsheets to form a workbook. Excel workbooks often track data over time with a worksheet to represent each month of the year, day of the week, or task. Excel spreadsheets can hold numbers, dates, times, and formulas, which can be used to calculate new data in adjacent columns.
Excel functions allow users to combine text and data into one string. For example, a row with name, date, and academic major could be combined in one column, with each characteristic separated by a comma. For this reason, Excel is also an excellent tool for formatting or cleaning data before analysis. Formulas, functions, and conditional statements (ex., if this, then that) can transform raw data into a standard format.
Excel can perform basic mathematical functions like adding, subtracting, multiplying and dividing numbers. Mathematical functions can be programmed to use specific cells or numeric values. These features are often useful for budget management or calculating a final total. These calculations can help Excel users optimize their work and create spreadsheets that automatically perform necessary calculations without rebuilding the spreadsheet each time.
Users can enter data or connect MS Excel to an external database such as Bloomberg and Reuters to retrieve data automatically. Despite the intensive process required to program such features, information is often exchanged this way using Microsoft’s Dynamic Data Exchange. At an advanced level, Excel can be programmed to retrieve data from an external source, analyze this data, and update a spreadsheet automatically as changes occur.
Excel performs basic statistics on data, including mean, average, mode, permutations, and quartiles. For research studies, Excel can also analyze variance (ANOVA), regression, and factor analysis. The program can also make forecasts and predictions based on trends and predict these changes in graphs.
Excel users can generate basic visuals to support data analysis in Microsoft Excel. The most common data visualizations created in MS Excel are bar and pie charts, histograms, and line graphs. The program can generate a standalone graph for insertion in another document or be inserted within the actual spreadsheet. If cell values are changed, the chart or graph will also update the data labels and the figure automatically.
Microsoft Excel can create the following types of charts:
Ready to master Microsoft Excel? Uncover data insights with Pivot Tables, advanced formulas, and charts. Expedite tasks with macros and database functions. Learn time-saving techniques, earn certification, and advance your career. Become an Excel expert today in our hands-on courses.
Start with the basics, including formulas, functions, graphs, formatting, and printing in our fundamentals class. In our intermediate course, you’ll learn more advanced functions for manipulating text and extracting information from databases, summarizing data with Pivot Tables, and managing large databases. In our advanced training, expand on various LOOKUP functions, learn Data Tables and Goal Seek, and create basic macros to automate work.
Data Scientists and Data Analysts use Excel to create the databases they use to store, organize, and query data. Excel ensures that their databases are clean, organized, and easy-to-use, since, without a good dataset to draw from, an analyst's conclusion can’t be trusted. Excel’s tools for organizing and collating data are an important part of building a working database since data needs to be easy to find and stored alongside other similar data points. Data Scientists will also use programming languages like Python and SQL to create applications that query this data and give it more practical functionalities. Excel is even utilized in machine learning contexts for organizing and cataloging some of the data sets used to ‘teach’ machine learning programs how to read and interpret data. If you aim for a career in data science, learning how to use Excel will be an important first step because if you don’t have clean and functional datasets, you won’t be able to build programs that can use your data.
Like Data Analysts, Financial Analysts need to understand Excel to organize and construct the data sets from which they will draw insights using FinTech tools. In addition, they will need to understand how Excel can be used to automate and calculate complex financial data automatically, using function tools or macros to build dedicated Excel sheets that perform these calculations in real time. Excel is commonly used for financial record keeping and accounting, making it understandable that the tool is commonly used in financial analysis projects. An important tool used in FinTech projects programs that automatically read webpages and financial reports to input that data into an Excel spreadsheet without a human interloper so that databases can be updated fast enough to use the information. Excel is also used to create visualizations of trends in financial data and to track shifts in markets using some of the advanced analytic tools either built into Excel or built using Excel and programming languages like Python and SQL.
Excel is useful for more than just organizing financial and numerical data. It is also a powerful tool for tracking large projects involving significant amounts of tasks delegated to different employees or departments. Project Managers may want to learn Excel to keep detailed records of who is working on what, which aspects of a project are currently being worked on, what aspects of the project have top priority and what aspects of the project have been completed (and by whom). It is also a useful tool for tracking individual, and team performance and productivity, and Excel can be used for functions as simple as recording contact information in a single place. The versatility of the program makes it an ideal tool for anyone who needs to organize and manage multiple aspects of a project and wants to keep a functional, easy-to-read record of the progress that they are making. Excel’s function tools and macros can also help serve a predictive function to gauge whether or not a project is on schedule and under budget or if issues should be addressed before they become significant problems.
Excel is commonly associated with office work environments, and there is a reason for this. Despite its many uses in data science, financial technology, and project management contexts, it is still a powerful tool for making office bureaucracy run more efficiently and effectively. Microsoft estimates that about 66% of office workers will use Excel regularly, making it the most commonly used office application in the world. What you will use Excel for will vary from job to job, but many office workers utilize Excel to track their tasks and productivity, input important financial or business data, keep records of everything from sales and accounts receivable to taxes and clientele information. Learning even the most basic functionalities of Excel can greatly improve your productivity and make you a more valuable employee of your organization. Learning more advanced features may open up new career opportunities as you use that training to complement your existing skills.
Using spreadsheets isn’t only applicable in a professional office environment. Most people regularly track some amount of data, and it can be useful to learn the basics of Excel to organize and access that data. This can be anything from using Excel to track your household budget to save money to documenting how much running you’ve done every day in preparation for a 10K you want to participate in. This kind of data organization can be useful for helping you visualize the data you are collecting, and it can make setting and achieving goals all that much easier. Learning the basics of Excel can also help you utilize the function and formatting features to create slightly more complicated spreadsheets. For example, if your goal is to write a certain amount of words in a month for a writing project, you can build a spreadsheet that automatically calculates your pace and the pace you’ll need to stay on to reach your goal. These Excel functions make the program useful for virtually anyone who thinks that they will benefit from the organization tools offered by the application.
Excel is a unique program in that it is utilized in many professional fields and work environments, but very few professionals are Excel specialists. Almost every career path that regularly utilizes Excel will require candidates to know a range of more field-specific skills. This means that career-focused students looking to learn Excel will need to learn other skills but will also have a wider range of options available for building on their Excel training.
Data Scientists and Data Analysts regularly use Excel when engaging with databases and other large data sets. Excel is used to build the collections of data that they interpret and analyze, and without Excel, there would be no databases for querying. Scientists and analysts must learn how to use Excel to ensure that their data sets are well-organized and easy to query. Alongside learning Excel, they will need to know programming languages like Python and SQL to build the programs that utilize, query, and interpret the data that they have collected. Data Analysts tend to focus more on interpreting and visualizing data for their clients, while Data Scientists are tasked with building the infrastructure that allows analysts to work more effectively. In the US, Data Scientists' average salary is about $125,000 a year. The average salary for a Data Analyst is about $70,000.
Similar to Data Analysts, Financial Analysts and Investment Analysts will need to learn how to use Excel for basic financial record keeping and for building the databases that they use to interpret financial data. Plus, they will need to know how to read the Excel spreadsheets many companies and organizations use to track their financial data. Beyond this, they will either need to learn Python programming skills, or they will need to learn programs built using Python. Financial Analysts may want to receive training in machine learning algorithms, since financial data is produced so quickly, they may need to train machines to read the Excel spreadsheets they produce. Finally, aspiring financial professionals will need to learn how to use Excel’s data visualization tools to present their findings to investors and stakeholders. Financial Analysts tend to work for companies to identify trends in the economic environment to help businesses make informed decisions about how to use their assets. In the US, they make about $72,000 annually. Investment Analysts focus on market data and trends to help businesses and individuals identify assets and futures that make for good investment opportunities. Their average salaries are about $78,000 a year.
Project Managers utilize Excel for various tasks, including organizing delegated tasks, managing costs and resources, and keeping records of what elements of the project have been completed. Excel is not a necessary tool for Project Managers, but it can be very useful for workflow optimization if you have experience or training with the program. To optimize these processes, Project Managers will need to understand project management techniques for managing human and financial resources during a project and building long and short-term plans for accomplishing goals. They will also need to practice the soft skills necessary to lead teams and see projects through to completion. In the US, Project Managers make around $82,000 annually, but these salaries can vary greatly depending on the industry in which you are learning projects (software engineering pays more than construction, for example).
Since none of these professions rely strictly on Excel, you’ll need further training to hold these jobs. To learn more about the course offerings available, please visit the Noble course pages for Data Science, where you can learn Python and SQL, Finance, where you can learn FinTech, and Project Management.
Attend courses in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
Unlike other providers, these are not mass open-enrollment classes. At Noble Desktop, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
All times are listed in Eastern Time unless otherwise specified.
December 2024 | |||
---|---|---|---|
December 9
Monday
10–5pm
|
|
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. |
|
December 10 & 12
Tuesday & Thursday
6–9pm
|
|
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. |
|
December 11
Wednesday
10–5pm
|
|
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. |
|
December 11–13
Weekdays
10–5pm
|
|
Prepare for the Microsoft Excel exam and become an Excel expert with our certification program. Learn formulas, functions, Pivot Tables, charts, and more through group classes, private training, and an exam with a free retake. |
|
December 11–13
Weekdays
10–5pm
|
|
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. |
|
showing 5 of 143 courses