Excel Level II: Intermediate
via Noble Desktop
Affiliated with Course Report
Develop spreadsheet-analysis skills beyond basic formulas in Noble Desktop's intermediate Excel course. You work with lookups, logical functions, data cleanup, validation, and PivotTables. The course connects these tools to the task of organizing larger datasets and producing summaries that are easier to inspect and use.
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Enrollment and course access are provided by Noble Desktop.
Is this course right for you?
You should already know basic formulas, formatting, charts, and tables. Choose this course to progress from that foundation. Compare the Excel Bootcamp if you need the introductory preparation and advanced continuation alongside the intermediate material.
Compare your options
Summary
This intermediate Excel course focuses on working more efficiently with larger datasets and more capable formulas. Students learn how to split and join text, use named ranges and Paste Special, apply data validation, sort and filter lists, remove duplicates, and use lookup and logic functions such as VLOOKUP, XLOOKUP, IF, AND, OR, SUMIFS, and COUNTIFS.
Students also learn how to summarize and analyze data with PivotTables, grouping tools, and multiple PivotTables on a single worksheet. This course is ideal for those ready to clean up data, build smarter spreadsheets, and take on more detailed reporting tasks.
Take this class as part of the Excel Bootcamp and get a 15% discount. The package includes our Fundamentals, Intermediate, and Advanced Excel classes.
Who this course is for
Those with familiarity with basic Excel, including basic formulas & functions, graphs, and tables, seeking to expand their skills to intermediate-level features, including VLOOKUP and Pivot Tables. The skills taught in the course apply to a variety of industries, including technology, financial services, retail, education, professional services, healthcare, non-profit, and more.
Prerequisites
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
Topics included
Curriculum
What you'll learn
- Navigate worksheets more efficiently using keyboard shortcuts and Excel tools that speed up movement within and between cells.
- Work with formulas and text by reviewing calculation methods, splitting text with Text to Columns, and joining text with CONCAT and the ampersand.
- Manage cell ranges with Paste Special, Paste Special Values, and named ranges to format data, hardcode results, and simplify references in calculations.
- Use database tools such as VLOOKUP, XLOOKUP, Sort & Filter, and Remove Duplicates to find, organize, and clean large sets of data.
- Build PivotTables to summarize large databases, group data within PivotTables, and create multiple PivotTables on a single worksheet.
- Apply logical, math, and statistical functions including IF, AND, OR, SUBTOTAL, SUMIFS, and COUNTIFS to analyze data based on conditions and filtered results.
- Improve data quality with Data Validation and reinforce key course concepts by completing an end-of-class project.
Course syllabus
Worksheet Management
Navigation
- Keyboard shortcuts that facilitate quick and easy navigation within cells
Formula Review
- Review various methods for completing calculations
Working with Text
Splitting Text
- Use Text to Columns to split text into multiple cells
Joining Text
- Using CONCAT and the & (ampersand) to combine cells
Cell Ranges
Paste Special
- Apply formats and perform calculations on selected cells
Paste Special Values
- Hardcode the answer to a formula or function
Named Ranges
- Assign a name to a range of cells to make it easier to reference those ranges in calculations
Database Functions
VLOOKUP & XLOOKUP
- Use VLOOKUP and XLOOKUP to find information in a cell range and return information from another cell range
Sort & Filter
- Use Sort & Filter to find and organize data in large databases
PivotTables
PivotTables
- Create PivotTables to quickly summarize large databases
PivotTables & Grouping
- Group within PivotTables
Multiple PivotTables
- Create multiple PivotTables on a single worksheet
Logical Functions
IF statements
- Use IF statements to return output based on the contents of another cell
AND, OR
- Tests to see whether multiple conditions are true
Math Functions
SUBTOTAL
- Use SUBTOTAL function to sum/average/count values based on what is not filtered
Statistical Functions
SUMIFS
- Use SUMIFS function to sum cells based on one or more conditions
COUNTIFS
- Use COUNTIFS function to count cells based on one or more conditions
Improve Data Quality
Data Validation
- Restrict the type of data that can be allowed in a cell
Remove Duplicates
- Eliminate duplicate row data
End of Class Project
Project
- End of class project to review key concepts from the class
What's included
- Free course retake within one year to refresh the material and gain practice.
- Course workbook
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Schedule & enrollment
Find dates that fit your schedule, then book on Noble Desktop.
All class times are Eastern (ET).
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 6pm ET
Final session ends at 9pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 6pm ET
Final session ends at 9pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 6pm ET
Final session ends at 9pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 6pm ET
Final session ends at 9pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
Confirm current dates and availability on Noble Desktop before booking. Enrollment opens in a new tab.
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $299
- Course length
- 6 hours
- Schedule
- On your schedule
Enroll with Noble Desktop
View current tuition and secure enrollment options from the course provider.
View tuition & enrollLoading enrollment options…
Prefer to enroll directly? Open the course website.
In this intermediate Excel class, you’ll learn functions such as VLOOKUP and SUMIFS, summarize data with Pivot Tables, sort and filter databases, and split or join text.
The course includes access to our Excel video suite, allowing you to review the materials anytime after class.
Enroll in this class as part of the Excel Bootcamp to receive a 15% discount. The bundle includes our Fundamentals, Intermediate, and Advanced Excel courses.
Who the self-paced course is for
Those familiar with basic Excel, including basic formulas and functions, graphs, and tables, seek to expand their skills to intermediate-level features, including VLOOKUP and Pivot Tables. The skills taught in the course apply to a variety of industries, including technology, financial services, retail, education, professional services, healthcare, non-profit, and more.
Self-paced prerequisites
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
Self-paced curriculum
What you'll learn self-paced
- Learn to split and join text, apply data validation, and create named ranges
- Use lookup functions such as VLOOKUP and HLOOKUP
- Write logical formulas using AND, OR, and IF functions
- Create PivotTables to efficiently summarize and analyze large datasets
- Apply functions such as RANK, COUNTIFS, and SUMIFS
- Build advanced combo charts by combining multiple chart types
- Reinforce key concepts through a guided final project
Self-paced syllabus
Worksheet Management
Navigation
- Keyboard shortcuts that facilitate quick and easy navigation within cells
Formula Review
- Review various methods for completing calculations
Working with Text
Splitting Text
- Use Text to Columns to split text into multiple cells
Joining Text
- Join text from separate cells
Cell Ranges
Paste Special
- Apply formats and perform calculations on selected cells
Paste Special Values
- Hardcode the answer to a formula or function
Named Ranges
- Assign a name to a range of cells to make it easier to reference those ranges in calculations
Database Functions
VLOOKUP & XLOOKUP
- Use VLOOKUP and XLOOKUP to find information in a cell range and return information from another cell range
Sort & Filter
- Use Sort & Filter to find and organize data in large databases
PivotTables
PivotTables
- Create PivotTables to quickly summarize large databases
PivotTables & Grouping
- Group within PivotTables
Multiple PivotTables
- Create multiple PivotTables on a single worksheet
Logical Functions
IF statements
- Use IF statements to return output based on the contents of another cell
AND, OR
- Tests to see whether multiple conditions are true
Math Functions
SUBTOTAL
- Use SUBTOTAL function to sum/average/count values based on what is not filtered
Statistical Functions
SUMIFS
- Use SUMIFS function to sum cells based on one or more conditions
COUNTIFS
- Use COUNTIFS function to count cells based on one or more conditions
Improve Data Quality
Data Validation
- Restrict the type of data that can be allowed in a cell
Remove Duplicates
- Eliminate duplicate row data
Advanced Charts
Combo Charts
- Combine two or more charts into a single chart, with the option of adding a secondary axis
End of Class Project
Project
- End of class project to review key concepts from the class
What's included with self-paced
- Course workbook
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Excel Level II: Intermediate Course Online (Self-Paced)
-
Enrollment required
Tips and Fundamentals
Lesson 5: Workbook Management
10:24
Review and apply Excel's autosum functions and formula auditing tools to calculate totals, averages, and high scores, detect and fix errors, and ensure correct formula dependencies.
View enrollment options at Noble Desktop -
Navigation
Lesson 1: Worksheet Management
6:58
Navigate and select cells in a spreadsheet using keyboard shortcuts like arrow keys, control, shift, and page up/down for efficient data management.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Paste Special
Lesson 2: Working with Text
8:55
Use paste special in Excel to apply formats, perform calculations, and change data orientation.
View enrollment options at Noble Desktop -
Enrollment required
Paste Special Values
Lesson 2: Working with Text
3:14
Use "paste special values" to copy and paste only the results of formulas as text without including the formulas themselves.
View enrollment options at Noble Desktop -
Enrollment required
Splitting Text
Lesson 2: Working with Text
5:08
Use text-to-columns to split data in a spreadsheet into separate columns based on delimiters like commas or spaces.
View enrollment options at Noble Desktop -
Enrollment required
Joining Text
Lesson 2: Working with Text
5:06
Join text using either the concatenate function or the ampersand method to combine cells with specified separators like spaces or dashes.
View enrollment options at Noble Desktop -
Enrollment required
Named Ranges
Lesson 3: Cell Ranges
3:56
Create named ranges for assets, liabilities, and equity to simplify referencing them in calculations.
View enrollment options at Noble Desktop -
Data Validation
Lesson 4: Database Functions
7:35
Use data validation in Excel to create drop-down lists that restrict cell input to specified numerical or text values, with options to customize error alerts and input messages.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Remove Duplicates
Lesson 4: Database Functions
3:51
Remove duplicates by selecting a cell in the data, going to the Data tab, clicking Remove Duplicates, and confirming the selection.
View enrollment options at Noble Desktop -
Enrollment required
VLOOKUP
Lesson 4: Database Functions
10:06
Use VLOOKUP to find information in a table by specifying a lookup value, table array, column index number, and choose between exact or approximate match.
View enrollment options at Noble Desktop -
Enrollment required
HLOOKUP
Lesson 4: Database Functions
2:58
Use HLOOKUP to find a lookup value horizontally in a row by selecting the row index number instead of the column index number.
View enrollment options at Noble Desktop -
Enrollment required
Sort and Filter
Lesson 4: Database Functions
15:53
Sort and filter data using Excel's home or data tab, create subtotals for grouped data, and practice these skills through specific tasks like multi-level sorting, filtering, and applying subtotals.
View enrollment options at Noble Desktop -
Pivot Tables New
Lesson 5: Pivot Tables
10:00
Create a basic pivot table by converting your data into an Excel table, then use the pivot table options to summarize and filter the data, remembering to refresh for updates.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pivot Grouping Timelines
Lesson 5: Pivot Tables
5:16
Group and filter pivot table data by time periods using the group and insert timeline features.
View enrollment options at Noble Desktop -
Enrollment required
Multiple Pivot Tables
Lesson 5: Pivot Tables
11:40
Explore pivot tables by inserting fields multiple times, using value field settings for different calculations, employing slicers for easy filtering, and connecting slicers to multiple pivot tables for synchronized filtering.
View enrollment options at Noble Desktop -
If Statements
Lesson 6: Logical Functions
8:30
Explain how to use if statements and if error functions in Excel for logical testing and error handling.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
And Or
Lesson 6: Logical Functions
6:17
Use AND to ensure all criteria are true and OR to check if at least one criterion is true when evaluating conditions.
View enrollment options at Noble Desktop -
COUNTIFS and SUMIFS
Lesson 7: Statistical Functions
9:46
Count and sum data based on conditions using COUNTIFS and SUMIFS functions in Excel, which act as filters for specified criteria across multiple columns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Combo Charts
Lesson 8: Advanced Charts
5:01
Create a combo chart with a secondary axis for better comparison, and format it by adjusting bar colors, background, border, and adding effects.
View enrollment options at Noble Desktop