Excel - Level 2 Course

Course Details:

Length: 1 day

Price: $275/person (USD)

Bundle & Save: View Bundle

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.


Course Overview

This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to: Perform Calculations on Data, Manage Worksheet Data, Reorder and Summarize Data, Combine Data from Multiple Sources, Analyze Alternative Data Sets, and Collaboration.

Register Early: Registration Deadline is 2 Weeks Prior to Class Start.

Course Notes

Versions That Can Attend: Desktop Version of Office 2021, 365, 2019, 2016 (Microsoft Windows PC or Macintosh)
Course Taught With: Desktop Version of Office version 365/2019 (Microsoft Windows PC) Software and Courseware

Knowledge Prerequisites

Excel - Level 1

Suggested Follow-Ons

Excel - Level 3

Related Certifications

MOS: Microsoft Excel Expert Certification
MOS: Microsoft Excel Associate Certification

Certification Notes: Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact the corresponding testing provider to take a certification exam.

Course Topics

Chapter 3: Perform calculations on data - 71
Summarize data that meets specific conditions
Copy and move formulas
Create array formulas
Find and correct errors in calculations
Configure automatic and iterative calculation options
Skills review
Practice tasks

Chapter 5: Manage worksheet data - 137
Filter data ranges and tables
Summarize filtered data
• Sidebar: Randomly select list rows
Enforce data entry criteria
Skills review
Practice tasks

Chapter 6: Reorder and summarize data - 159
Sort worksheet data
Sort data by using custom lists
Outline and subtotal data
Skills review
Practice tasks

Chapter 7: Combine data from multiple sources - 175
Look up data from other locations
• Locate information in the same row (VLOOKUP)
• Locate information in the same column (HLOOKUP)
• Locate information anywhere (XLOOKUP)
Link to data in other locations
Consolidate multiple sets of data
Skills review
Practice tasks

Chapter 8: Analyze alternative data sets - 193
Define and display alternative datasets
Forecast data by using data tables
Identify the input necessary to achieve a specific result
Skills review
Practice tasks

Chapter 14: Collaborate with colleagues - 351
Manage comments
Protect workbooks and worksheets
Finalize workbooks
Save workbook content as a PDF file
Create and distribute workbook templates
Skills review
Practice tasks

Course FAQs

What Are the Available Class Formats?

This course is taught by a live instructor and is available in two class formats:

  1. Live Online for Individuals
  2. Onsite/Online for Private Groups

What Are Excel Calculations on Data?

Excel offers a wide range of powerful tools to help users make calculations on data. From simple addition and subtraction to more complex statistical functions, Excel can provide you with the detailed insights you need. With an intuitive user interface, it makes calculating data easy and efficient. You can quickly enter formulas that will automatically calculate your desired result or set up more advanced calculations such as regression and exponential smoothing. Excel also offers a range of charting options to help you visualize your data in an easy-to-understand format. By using the powerful tools available in Excel, you can quickly turn raw data into meaningful insights that can be used to inform decision-making. With the right calculations, Excel can help you analyze trends and uncover valuable information to support your business.

As with all data analysis tools, you must understand how to use Excel correctly to get accurate results. It is also essential that you check your results thoroughly before relying on them in any way. Having a firm grasp of formulas, functions, and charting techniques is essential for ensuring the accuracy of your calculations and analysis. With a comprehensive understanding of Excel calculations on data, you can make informed decisions that are based on reliable information.

Overall, Excel provides an array of tools to help you quickly and easily calculate data to gain insights into trends or patterns. With the help of Excel, you can make better decisions based on reliable and accurate data.

What Are Management Options for Excel Worksheet Data?

Excel worksheets provide a powerful platform for collecting, organizing, and analyzing data. Managing the worksheet data effectively is key to unlocking its full potential. Common management options include sorting, filtering, formatting, pivoting, linking sheets/workbooks together, and more. By taking advantage of these tools you can quickly manipulate and analyze your data in efficient and meaningful ways. Additionally, a wide range of pre-built functions can be used to analyze data in various ways such as summing, averaging, or finding the maximum and minimum values. All these options allow you to get the most out of your data and make decisions with confidence. With an understanding of Excel worksheet management tools, you will have more control over your data and be able to use it more effectively.

Excel offers a wide range of tools for you to manage worksheet data. By taking advantage of these tools you can quickly and easily manipulate and analyze your data in efficient and meaningful ways. This will allow you to get the most out of your data, make better decisions and get more value out of your data.

What Are Excel Reordering and Summarizing Options?

Excel offers a range of options when it comes to reordering and summarizing data. With features such as sorting, filtering, grouping, subtotaling, and pivot tables, users can quickly make sense of large amounts of data.

Sorting allows you to arrange your data alphabetically or numerically in either ascending or descending order.

Filtering allows you to isolate specific data and hide other values that are not relevant. Grouping enables users to combine related data, making it easier to draw meaningful conclusions from the information.

Subtotaling and pivot tables help summarize large amounts of data into more manageable chunks. With these features, Excel makes it easy for users to organize and analyze their data. With a few clicks, users can quickly gain insight into the data and make informed decisions.

Excel's reordering and summarizing options are invaluable for anyone who needs to understand large sets of data. These features allow users to quickly get the information they need, helping them save time and be more productive. Excel's reordering and summarizing options make it easy for users to gain insight into their data and make more informed decisions. By leveraging the power of these features, users can take control of their data and unlock its full potential.

What Are Options to Combine Data From Multiple Sources in Excel?

When dealing with data from multiple sources, Excel can provide a range of options to combine the data into one sheet. Common methods include using formulas such as VLOOKUP, INDEX, and MATCH or combining the sheets using the Consolidate function.

Using formulas is a powerful way of combining data from two or more files in Excel. VLOOKUP is a type of formula used to look up specific information from one sheet and display it on another. INDEX and MATCH are formulas that work together to match values from different sheets, columns, or rows.

The Consolidate function enables users to combine data into a single sheet by selecting the ranges they want to consolidate and specifying the function to use, such as sum or average. Consolidating data in this way allows users to quickly summarize and analyze larger sets of information from multiple sources.

Excel also provides external data query options that allow users to connect to data stored in other formats, including databases and web pages. This enables users to keep their workbooks up to date with the latest data.

Overall, Excel offers various methods to combine data from multiple sources into one sheet, enabling users to quickly and efficiently summarise large amounts of information.

What Are Ways to Analyze Alternative Data Sets in Excel?

One of the most popular tools for analyzing alternative data sets in Excel is Pivot Tables. A Pivot Table allows users to quickly summarize, analyze, explore and present large amounts of data. It can group and sort information, calculate subtotals and create charts that make it easy to identify patterns or trends. Another useful tool in Excel is the Solver Add-in, which helps users optimize various types of models. It can provide a solution to the challenge of determining how best to allocate resources, minimize costs and maximize profits. Lastly, the Conditional Formatting feature allows users to format data based on specific criteria so they can identify trends or patterns in their data set. These features, among others, make Excel an ideal tool for analyzing alternative data sets.

By taking advantage of the powerful tools in Excel, users can quickly and easily analyze alternative data sets to gain valuable insights and make better decisions. As the world of alternative data continues to grow, Excel is an invaluable resource for exploring and understanding this valuable asset.

What Collaboration Features Are in Excel?

Microsoft Excel offers a range of collaboration features that make it easier for users to work together on spreadsheets. These include the ability to share workbooks, which allows multiple people to view and edit documents at the same time; co-authoring which allows files to be edited by two or more people simultaneously; chat feature which allows users to communicate with each other; and alert notifications which will let users know when changes have been made to the workbook or when comments have been added. Excel also allows users to track changes, so they can better understand why certain edits were made or identify who is responsible for any mistakes. With these tools, Excel makes it easier than ever for teams to collaborate on spreadsheets and work together on projects more efficiently.

Excel also offers another great way to collaborate: version control. Version control allows users to maintain a history of all changes made to the spreadsheet, providing an extra layer of security and accountability when making edits or deleting data. The feature is especially useful for teams as it allows them to monitor major changes and easily revert to earlier versions should an issue arise. This tool also allows users to quickly identify the source of a problem or mistake, further enhancing collaboration and productivity. Excel's version control feature is yet another way that Microsoft has made it easier for teams to collaborate on spreadsheets.

Overall, Microsoft Excel offers a wide variety of collaboration features that make it easier for users to work together on spreadsheets. These tools allow teams to share workbooks, co-author documents, chat with each other, receive notifications when changes are made, and track changes so they can better understand the reasoning behind edits. Version control is also available to maintain a history of all changes made and easily revert to earlier versions should an issue arise. With these tools, Excel makes it easier than ever for users to collaborate and work together on projects more efficiently.

Related Microsoft Excel Information:

How Much Do Your Online Excel Classes Cost?

Our live online Excel class prices start at $275 per student. Group training discounts are available.

Excel eLearning courses cost $125 at the starting point per student. Group purchase discounts are available.

What Microsoft Excel Skills Should I Learn?

A: If you are wondering what Microsoft Excel skills are important to learn, we've written a Microsoft Excel Skills and Learning Guide that maps out Excel skills that are key to master and which of our courses teaches each skill.

Read Our Microsoft Excel Skills and Learning Guide

What is Microsoft Excel and Why is it Important to Learn?

A: Excel is an industry standard spreadsheet program created by Microsoft that can be used to enter, edit, and compute numerical data analysis for professional business use. It increases productivity and the accuracy of important data. Those involved in financial calculations (financial analysts), accounting (bookkeepers), and other positions that use spreadsheets to organize data may benefit most from an Excel course to learn Excel. Excel can be used to develop budgets, track sales, create reports, graph data, and streamline accounting tasks. Enrolling employees in an online Excel class is a great way to ensure they have the skills needed to succeed in their role at your company.

More Information on What is Excel and Why is it Important to Learn

What's the Best Way to Learn Excel for Beginners?

A: Learning the fundamentals of Excel can give employees the capability that they need to enter data into digital spreadsheets and process it quickly. The best online Excel classes teach the basics of the Excel spreadsheet program to analyze data and define what workbooks are and train employees on how to correctly use formulas and program features such as pivot tables. Investing in a live instructor online Excel class that can guide students through lessons is almost always the best way to learn Excel. At the end of a basic Excel course, students should be able to track numbers, input data and formulas (data calculations), sort through data, and create charts (data visualization).

More Information on the Best Way to Learn Basic Excel

Is Excel Training and Certification Worth the Cost?

A: Business owners and employees who work with data and spreadsheets may find that attending an Excel course can sharpen skills, ensure data accuracy, and increase productivity in the workplace. Formal training can pay dividends, especially if a certification test, such as the Microsoft Office Specialist (MOS) exam, is taken. Investing in training can help employees prepare for the test as well as reduce or eliminate the need for exam retakes. Moreover, employees may consider training and certification a worthwhile investment in their careers, as the skill can be applicable to future jobs and even different industries.

More Information on Excel Certification Cost and Benefits

Are Intermediate and Advanced Excel Skills in Demand?

A: While basic knowledge of Excel can improve employees’ productivity and help them contribute to the overall health of a business, intermediate and advanced Excel skills can transform employees into indispensable assets to employers. Higher-level Excel skills are applicable across several different industries, and hiring managers are increasingly seeking applicants with in-depth knowledge of the software. Employees with even basic Excel proficiency enjoy significant pay bumps and rosier long-term career prospects. Business owners who hire employees with great Excel skills can find themselves relying on their quick analysis of business-related data to make important decisions.

More Information on the Benefits of Advanced Excel Training

Which Excel Formula Should I Use When?

A: Determining which Excel formulas and functions you should use in your office can depend on the specific business tasks that you want to perform. Whether you’re attempting to juggle human resource duties, like schedules or benefit planning, or keep operations running smoothly by checking inventory or running balances, there’s a perfect Excel formula or function for you. Using just a few of the many available Excel formulas and functions can save you time, keep your records accurate, and ensure that you’re maximizing your productivity, among other advantages.

More Information on Excel Formulas and Functions

What Are Advanced Excel Skills, and How Can I Learn Them Online?

A: When hiring managers talk about “advanced Excel,” they’re usually referring to Excel’s most complex features and functions and the higher-level skills that are required to use them. Employees with advanced Excel skills often occupy positions that require expert data analysis and organization, such as accountants and bookkeepers. To learn Excel advanced skills, you can enroll in online courses that offer training on how to work with common complex Excel features like VBA programming or PivotTables. Obtaining advanced Excel skills can often put you on the path to a promotion or help you stand out from a crowd of job applicants, and companies benefit from the greater efficiency that comes with having highly skilled workers.

More Information on Advanced Excel Skills and How to Learn Them Online

Why Is Microsoft Excel Important, and What’s the Best Way to Learn It?

A: Learning Excel is one of the best ways to increase your value as an employee. Aside from helping you to learn the skills necessary to successfully manage data, taking an Excel Microsoft Office Specialist certification course and earning this credential can result in a pay raise or a promotion. While many employees choose to learn Excel in an on-site classroom, others are increasingly turning to online Excel courses for instruction. The best online excel classes are structured, specialized, and built upon preexisting knowledge. High-quality training courses can cost hundreds of dollars, regardless of whether the classes are taken in person or online.

More Information on Why Microsoft Excel Is Important and How to Learn Excel

What Excel Skills Do Employers Value, and How Can I Improve on Mine?

A: While many employers value advanced Excel skills, basic Excel knowledge can also be in demand, as long as those skills are relevant to the job that you’re performing. At a minimum, employers expect that employees understand the fundamentals of the software, including basic navigation, formulas, find and replace, and sorting and filtering. To improve your Excel skills and stand out as a candidate, brush up on the fundamentals by reviewing basic features and functions and practicing them within the program. For top-notch, quick instruction, enroll in professional Excel courses designed to improve your skills within only a few days.

More Information on the Excel Skills Employers Value and How to Improve Them

What Are the Benefits of Learning Excel, and How Can I Learn it Fast?

A: Professionals who rely on Excel to manage data may find that sharpening their Excel skills helps them to be more productive and efficient at organizing and analyzing data, performing complex calculations, and creating graphs and charts. Job-seekers with demonstrable Excel skills increase their attractiveness to employers, find it easier to make career transitions, and may even enjoy significant pay increases. To simplify and speed up your ability to learn Excel, determine which particular skills you need to effectively perform your job and sign up for an Excel course that builds upon your knowledge and covers these concepts.

More Information on the Benefits of Learning Excel and How to Learn it Fast

How Can I Learn Excel Quickly?

A: Learning Microsoft Office programs like Excel quickly will depend on your ability to identify which features and functions of the program you will need to use regularly to perform your job and focus on learning each while using good time-management skills. To further speed up the process of learning, you can take advantage of the software’s built-in shortcuts and workflow streamlining features. If you sign up for a reputable, instructor-led online Excel class, you can learn Excel skills in as little as one day.

More Information on How to Learn Microsoft Excel Quickly

What Levels of Online Excel Classes Are Available?

A: [Instructor-led] - There are three levels of online Excel classes available: basic, intermediate, and advanced. Basic level 1 is for those who are new to Excel or need a refresher on the basics. Intermediate level 2 is for those who want to learn more about intermediate-level features and functions. Advanced level 3 is for those who want to take more advanced Excel training to learn more advanced formulas and functions. [eLearning] - There are three to five levels for online excel classes delivered by eLearning video tutorials. Both learning methods allow students to learn one of the most important Microsoft Office Suite programs.

What Topics Are Covered in Your Excel Training?

A: Popular topics covered in both our onsite and online Excel courses to learn Excel include, but are not limited to:

  • Advanced Formulas
  • Built in Functions
  • Conditional Formatting
  • Creating Charts
  • Data Analysis
  • Data Entry
  • Data Visualization
  • Data Calculations
  • Data Validation
  • Data Modeling
  • Excel Tables
  • External Databases
  • Pivot Tables
  • And many more important skills to learn the Excel program...

Who Uses Microsoft Excel?

A: Microsoft Excel is a versatile spreadsheet program used by professionals in a variety of industries. The program is widely used in business and finance to manage data, create charts & graphs for data visualization, analyze data with pivot tables and perform complex calculations. Additionally, Excel is used by financial analysts, business intelligence analysts, scientists, researchers, and students to organize and analyze data for tasks such as data modeling. With its many features and functions, Excel is a powerful tool used by professionals across many industries.

How To Learn Excel For Data Analysis?

A: Excel is a spreadsheet program used by professionals in a variety of industries for data management, analysis, and visualization. If you want to learn how to use Excel for data analysis, you can attend online Excel classes or take eLearning video tutorials that will teach you the basics and more complex tasks of the program (like pivot tables). As with any software, it's important to have a good foundation in the basics before moving on to more advanced concepts. Once you have a good understanding of the program, you can begin to learn how to use Excel for data analysis.

What Are Excel Pivot Tables?

A: Excel pivot tables are one of the most powerful features of Excel. They allow you to quickly and easily summarize data in a variety of ways. You can use pivot tables to create reports, analyze data, and make decisions.

Excel pivot tables are created by placing fields of data into specific areas called buckets. The data in each bucket is then summarized and displayed in a table. You can use the pivot table to see how the data changes based on the values in each bucket.

There are four main areas of a pivot table:

  1. The Filters area allows you to filter the data in the pivot table.
  2. The Columns area allows you to choose which columns of data to include in the pivot table.
  3. The Rows area allows you to choose which rows of data to include in the pivot table.
  4. The Values area allows you to choose how the data in the pivot table should be displayed.
How many hours does it take to learn Excel?

A: It depends on your level of expertise and how much time you are willing to dedicate to learning the program. If you are starting from scratch, it will take longer than if you already have some experience with spreadsheets and data entry. Generally speaking, you can expect to spend at least 10-20 hours learning the basics of Excel. However, becoming an expert can take much longer, sometimes hundreds of hours of practice.

What is basic Excel training?

A: Basic Excel training covers the fundamental skills and concepts needed to use this popular spreadsheet software effectively. Topics typically covered in a basic Excel training course include entering and editing data, creating formulas and functions, working with charts and graphs, and using various excel features such as pivot tables. Whether you're just getting started with Excel or looking to brush up on your skills, a basic Excel training course can help you get the most out of this powerful software.

How many days will it take to learn Excel?

A: Assuming you have a basic understanding of computers and how to use them, it should take you about 3-5 days to learn the basics of Excel. However, if you want to become an expert at using Excel, it will take much longer – months or even years of practice. Our Excel classes can fully train you on all of Excel's features. There are also plenty of resources available online and offline to help you learn Excel at your own pace. And once you get the hang of it, Excel can be an incredibly powerful tool for managing data and analyzing information.

What is the best way to learn Excel?

A: If you want to learn Excel, there are a few different ways you can go about it. You can attend an excel training course, either in person or online. You can also watch video tutorials or read books and articles on the subject. Whichever method you choose, make sure you start with the basics and work your way up to more advanced concepts. With a little patience and practice, you'll be an excel expert in no time!

What are the top Excel skills?

A: When it comes to Excel, there are a few key skills that can really help you get the most out of the program. Here are four of the top Excel skills that you should focus on developing:

Top Microsoft Excel Skills

1. Navigating the interface – One of the most important things you can do in Excel is to learn how to navigate the interface effectively. This means knowing how to find the right tools and features quickly and easily, without getting lost in the process.

2. Working with data – Another key skill is knowing how to work with data in Excel. This includes everything from inputting data correctly to performing calculations and analysis.

3. Creating charts and graphs – Visualizing data is a key part of working with Excel, and being able to create charts and graphs can be a huge help.

4. Automating tasks – Finally, learning how to automate tasks in Excel can save you a lot of time and effort in the long run. This could involve creating macros or using built-in features like pivot tables.

Developing these key skills will help you get the most out of Excel and make your work with the program much more efficient. Invest some time in learning and practicing these skills and you’ll be surprised at how much easier Excel can become.

Where Can I Learn More About Excel?

Excel Blogs

Excel User Groups

Excel Online Forums

Explore Microsoft Excel Training Classes Near Me:



Have a Group?
Request Private Training

6/20/2023 10:00:00 AM
Online Class

Registration Deadline - 06/05/2023


6/30/2023 10:00:00 AM
Online Class

Registration Deadline - 06/13/2023


7/6/2023 10:00:00 AM
Online Class

Registration Deadline - 06/20/2023


7/12/2023 10:00:00 AM
Online Class

Registration Deadline - 06/27/2023


7/21/2023 10:00:00 AM
Online Class

Registration Deadline - 07/04/2023


7/26/2023 10:00:00 AM
Online Class

Registration Deadline - 07/11/2023


8/2/2023 10:00:00 AM
Online Class

Registration Deadline - 07/18/2023


8/8/2023 10:00:00 AM
Online Class

Registration Deadline - 07/24/2023


8/15/2023 10:00:00 AM
Online Class

Registration Deadline - 07/31/2023


8/23/2023 10:00:00 AM
Online Class

Registration Deadline - 08/08/2023


8/30/2023 10:00:00 AM
Online Class

Registration Deadline - 08/15/2023


9/7/2023 10:00:00 AM
Online Class

Registration Deadline - 08/22/2023


9/14/2023 10:00:00 AM
Online Class

Registration Deadline - 08/29/2023


9/21/2023 10:00:00 AM
Online Class

Registration Deadline - 09/05/2023


9/26/2023 10:00:00 AM
Online Class

Registration Deadline - 09/11/2023


10/3/2023 10:00:00 AM
Online Class

Registration Deadline - 09/18/2023


10/10/2023 10:00:00 AM
Online Class

Registration Deadline - 09/25/2023


10/19/2023 10:00:00 AM
Online Class

Registration Deadline - 10/03/2023


10/26/2023 10:00:00 AM
Online Class

Registration Deadline - 10/10/2023


11/2/2023 10:00:00 AM
Online Class

Registration Deadline - 10/17/2023


11/7/2023 10:00:00 AM
Online Class

Registration Deadline - 10/23/2023


11/14/2023 10:00:00 AM
Online Class

Registration Deadline - 10/30/2023


11/21/2023 10:00:00 AM
Online Class

Registration Deadline - 11/06/2023


11/29/2023 10:00:00 AM
Online Class

Registration Deadline - 11/14/2023


12/6/2023 10:00:00 AM
Online Class

Registration Deadline - 11/21/2023


12/13/2023 10:00:00 AM
Online Class

Registration Deadline - 11/28/2023


12/21/2023 10:00:00 AM
Online Class

Registration Deadline - 12/05/2023

Start your training today!