Excel Level III: Advanced
Hands-on Training from Experts
NYC or Live Online
Advanced Excel Class in NYC
Learn all of the most complex features of Microsoft Excel in this advanced training course. Once you’ve gotten the hang of the basics of building and organizing spreadsheets using Excel, you can learn to manipulate and visualize that data to improve your workflow and draw deeper insights.
In this class, you will find out how to manage spreadsheets, utilize advanced analytics tools, and write macros to improve efficiency. You will also become familiar with complex Excel functions, including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH. The tools you’ll learn in this class will apply to virtually any job setting where you must organize large amounts of complex data.
Why Learn Excel?
Excel is one of the most commonly used business applications on the planet, so no matter what field you work in, learning Excel has the potential to help optimize your workflow and improve your productivity. Whether working as a professional Data Analyst or just working at a company with a lot of information to catalog and organize, learning Excel can pay long-term dividends.
Very few jobs strictly use Excel, so anyone looking to start a new career will need supplemental training. However, learning Excel is foundational for anyone hoping to work in a data analytics or financial career.
This course has a prerequisite
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
Highly Reviewed by Our Alumni
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Learn the Skills Guarantee™
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
Hands-on training
Work on projects proven to boost retention
Time-tested curriculum
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
Learn from experts
Experienced educators who are driven to help you succeed
Retake for free
Refresh the materials for free within one year
Interactive Training
Learn in Real-Time with Small Class Sizes
Attend this course in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects. Switch between live-online and in-person as needed, even after the course has started.
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.
On Campus in NYC 185 Madison Ave, NYC
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.
- Live, interactive class
- Experienced instructor in the room with you
- Computer and software provided
Live Online Remote, from anywhere
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.
- Live, interactive class
- Experienced instructor teaching over Zoom
- Remote setup assistance provided
Expert Instructors
Our instructors are verterans of their field and experienced educators, driven to help you succeed.
Earn a Certificate of Completion
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
Free Retake & Class Recordings
Missed a session or need a refresher? We have you covered!
Free Retake
We offer a single free retake of the the class within a year.
Class Recordings
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
Excel Level III: Advanced Curriculum
What You’ll Learn at a Glance
- Cell management including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions such as nested IF statements
- Learn advanced analytical tools for data consolidation, conditions to exlude data, and pivot charts
- Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
- Record macros and relative reference macros for ad hoc reporting
- Create a project that applies key concepts from the class
Project Examples
Learn practical skills by working on real projects with instructor guidance and lectures to strengthen and improve your skill.
Course Syllabus
Advanced Navigation
Advanced Navigation
- Advanced navigation techniques
Fill Review
- Review of Autofill conventions and techniques
Cell Management
Advanced Cell Locking
- Create powerful formulas by locking either the column or the row
Hot Keys
- Transform the ribbon into a visual listing of pre-assigned shortcuts
Cell Auditing
- Observe the relationship between formulas and cells
Go To Special
- Quickly select cells that meet certain criteria
Special Formatting
Conditional Formatting-Formulas
- Create custom rules for Conditional Formatting with formulas
Date Functions
- Calculate dates with a variety of functions
Custom Number Formats
- Customize number formats to meet specific requirements
Advanced Functions
Nested IF statements
- Nested "IF" statements allow for more than just two possibilities in a single cell
IF statements with AND/OR
- Expand the functionality of the IF function by adding an AND / OR criteria
What If Analysis
Goal Seek
- Find the desired result by adjusting an input value
Data Tables
- Data Tables show the range of effects of one or two different variables on a formula
Advanced Analytical Tools
Calculation Options
- Minimize volatility by changing calculation options
Conditional SumProduct
- Use SumProduct with conditions to exclude data that does not meet certain criteria
Pivot Table-Base Fields & Sets
- Analyze data in a Pivot Table with increased granularity by defining base fields and sets
Pivot Table-Calculations
- Create calculated rows or columns in a Pivot Table that go beyond the source data
Pivot Charts
- Create dynamic, graphical representations of Pivot Table data
Advanced Database Functions
XMATCH function
- Return the relative position (column or row number) of a lookup value
INDEX-MATCH
- Efficiently return a value or reference from a cell at the intersection of the row and column
INDEX-Double MATCH
- Use a second Match function to create a powerful, two-way lookup tool
Introduction to Macros
Recording Macros
- Record macros that involve formatting and calculations
Dynamic Arrays
Dynamic Arrays
- Use formulas that can return arrays of variable size
End of Class Projects
Projects
- End of class project to review key concepts from the class
Frequently Asked Questions
Who is the target audience for this course?
This class is meant for those with prior experience with basic and intermediate-level Excel skills looking to learn Excel’s most advanced functions and capabilities, including advanced lookup functions, Pivot Charts, and macros.
What version of Excel does this course cover?
The instructors typically present using Excel 2019 or Office 365. However, you can also use Excel 2013 or 2016; the exercises and interface are compatible with what we teach (with some minor differences that the instructor will explain).
Does this course require any prior knowledge or experience?
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
Do you offer payment plans or student financing for this course?
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Can I take this course online (remote learning)?
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
How does attending “live online” work?
- Students can attend this training remotely through screen sharing software (we use Zoom).
- Participants can hear the instruction, ask questions, and even share their screen with the instructor.
- For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
- Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
- You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at hello@nobledesktop.com
What happens if I need to miss a session?
You have some options:
- You can watch a recording of the session. We will provide any course materials.
- If you can’t come into the classroom but can still attend remotely, we will provide you with the Zoom login information.
- You can use your free retake to make up any missed class time.
