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.
Classes are running in-person (socially distanced) and live online. Secure your seat today
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.
Learn functions, formulas, Pivot Tables, Macros, and time-saving techniques in this hands-on Excel Bootcamp. You'll conquer all the keys skills to become proficient in Microsoft Excel.
In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.
In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text.
In this advanced Excel training, you'll learn advanced database functions such as INDEX and MATCH; create basic macros; and use What-If Analysis for Goal Seek and Data Tables.
Leverage Excel knowledge in more advanced financial training or take your analytics skills to the next level with our data analytics courses.
This Excel VBA course concentrates on practical automation of repetitious Excel tasks and reports. In this hands-on training, you will write macros to automate your Excel tasks even if the data is not consistently formatted, create custom Excel applications and environments, and create custom Excel Add-ins to increase the functionality of the program.
Learn the skills you’ll need to become a Data Analyst or Business Analyst, including data analysis, visualization, statistical analysis, and how to work with relational databases. Build a portfolio of projects and prepare for a career.
Learn the industry-standard tools for data analytics: Excel, SQL, and Tableau. Organize, analyze, summarize, and visualize your data to present actionable insights.
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results so you can turn data into actionable insights.
Learn to extract info 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
Learn essential finance & accounting concepts while building a comprehensive discounted cash flow (DCF) model in Excel. This financial modeling class blends finance, accounting and Excel concepts into an intensive 3-day course.
Tableau is a powerful tool, giving you full control of the look and feel of your visualizations, and helping compile your charts in the form of stories and dashboards.
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: hello@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 490 students
in the past 24 months
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
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.
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 perform an analysis of 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 types of 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 it can 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, learn more advanced functions for manipulating text and extracting information from databases, summarize data with Pivot Tables, and manage large databases. In our advanced training, expand on various LOOKUP functions, learn Data Tables and Goal Seek, and create basic macros to automate work.
Attend at our campus in NYC or learn remotely, live online
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.
In this video, we'll cover various tips and tricks for beginners to improve their Excel skills. Get a taste of some of the tricks and techniques we cover in our Excel classes with this video. We'll touch on various chart features, calculat...
In this article, we'll discuss two of the most popular tools for data analytics, Excel and Python. We'll walk through how each of these tools fares across a variety of dimensions to help you with your next steps in professional development and learning.
Learn advanced features of Pivot Tables like adding percent totals, creating slicers, and creating multiple Pivot Tables off the same dataset.
showing 3 of 3 entries
Excel is the foundation behind analyst jobs in finance, business, and marketing. Learning excel sets you up to head down any one of these career paths and there are even specific courses that show how each career uses Excel in their own specific ways.
Excel is the best analytical tool for roles in the finance industry. It has been the foundation of finance careers for over a decade now. It’s used financial analyses that inform investors’ decisions. Roles in finance – including Financial Analyst, Investment Banker, and Investment Analyst – will rely heavily on Excel daily.
Even if you’re still in college or a complete Excel beginner, taking an Excel course will dramatically enhance your resume and the work that you do every day. If you want to embark on a career in finance any time within the next decade, now is the time to learn how to take a Financial Modeling course.
Excel is also the first-choice tool for most Business Analysts. Business analysts often serve in a role that bridges the gap between the tech team and business stakeholders. They use Excel to analyze data to make business decisions, draw informed conclusions from those analyses, efficiently create reports, budget, and communicate their findings to both of the teams that they work with.
An Excel for Business Bootcamp will teach you how to make the most of Excel in your day-to-day including how to use VLOOKUP, create complex tables, and perform data analytics. You’ll learn how to create automations to make your work more efficient.
Excel is one of the most used tools for data analysis by marketers. Marketing teams use Excel to organize research and data for their campaigns, analyze the effectiveness of campaigns, forecast trends, and compile reports. Excel is an essential tool for jobs such as Marketing Analyst and Digital Analyst.
An individual beginner course is perfect for Marketers or to dip your toes into how Excel can make your job easier. Intermediate Excel courses are a great choice if you’ve already used Excel at work but you know you could learn more to optimize.
Excel plays a smaller role in data science jobs because it is often too small-scale to handle big data the way that professional Data Analysts require. It is, however, the best way to start understanding data, data analysis, data manipulation, functions, and cleaning data. The more advanced Excel Level 3 course is everything an Analyst would need to know about Excel.
Excel classes are the best way for marketers, finance professionals, and business professionals to optimize how they work with data. They’re also a great way to start understanding data concepts. You should learn Excel if you want to upskill, break into finance or business, become an Analyst, or optimize the way that you work with data.
You can take one-day workshops or multi-day courses in-person or online to learn Excel. You’ll learn from industry-leading instructors who provide you with a roadmap and hands-on dataset projects to make sure you’ve learned everything you need to know.
Learning in-person or live online is the best way to secure these in-demand skills. These education settings provide you with the most opportunities to get your questions answered, overcome roadblocks, and hold you accountable for learning the material in the curriculum fully.
Excel concepts can maximize your day-to-day work and help you earn a raise. Some courses even offer a certification to show your skills on your resume. Already have a job working with Excel? Consider asking your employer if they’ll pay for your Excel course so that you can optimize your work!
Excel is a powerful spreadsheet application created by Microsoft that used at companies across the world to store, analyze, and visualize data.
The workbook refers to the broad Excel file that you are using. Generally, you'll use one workbook for a specific project and within that workbook, you can use multiple sheets to break out the project.
A worksheet refers to one sheet within an Excel workbook. Within one workbook you can have many worksheets to split up the project. You can also reference data across worksheets within the same workbook.
On the top of your Excel workbook, you'll find a handful of helpful command tabs called the Ribbon. Within each tab in the ribbon, you can find various functions and features to use in your workbook.
In Excel, each little box where you can enter data is called a cell. You can input data, create calculations, or format cells in Excel.
All times are listed in Eastern Time unless otherwise specified.
February 2023 | |||
---|---|---|---|
February 9–13
Weekdays
10–5pm
|
|
Learn functions, formulas, Pivot Tables, Macros, and time-saving techniques in this hands-on Excel Bootcamp. You'll conquer all the keys skills to become proficient in Microsoft Excel. |
|
February 10
Friday
10–5pm
|
|
In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text. |
|
February 10
Friday
10–5pm
|
|
In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text. |
|
February 13
Monday
10–5pm
|
|
In this advanced Excel training, you'll learn advanced database functions such as INDEX and MATCH; create basic macros; and use What-If Analysis for Goal Seek and Data Tables. |
|
February 13 & 15
Monday & Wednesday
6–9pm
|
|
In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text. |
|
February 15
Wednesday
10–5pm
|
|
In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency. |
|
February 21
Tuesday
10–5pm
|
|
In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency. |
|
February 21–23
Weekdays
10–5pm
|
|
Learn functions, formulas, Pivot Tables, Macros, and time-saving techniques in this hands-on Excel Bootcamp. You'll conquer all the keys skills to become proficient in Microsoft Excel. |
|
February 21–23
Weekdays
10–5pm
|
|
Learn functions, formulas, Pivot Tables, Macros, and time-saving techniques in this hands-on Excel Bootcamp. You'll conquer all the keys skills to become proficient in Microsoft Excel. |
|
February 22
Wednesday
10–5pm
|
|
In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text. |
|
showing 10 of 80 courses