Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
corporate@nobledesktop.com(212) 684-5151
Download Syllabus
Master VLOOKUP, Pivot Tables, formulas and functions in this intermediate Excel course. Build on your basic Excel knowledge by learning more advanced techniques like Sort & Filter, logical functions, and time-saving tricks.
The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.
Operating System Note: A PC or Mac with Excel will be provided (choose your operating system at checkout). The instructor will present on a PC but will explain the differences for Mac students, and the class files clearly outline the differences.
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Intermediate Microsoft Excel is rated 4.8 stars by 3,008 students
in the past 24 months
Great experience. I recommend the class.
Jonathan Agustin
This will help me in my day-to-day work as a Business Analyst.
Tyhessia White
This was my second Excel class with Mike. It built on the Fundamentals class, and already I feel I have a better handle on Excel. Mike is friendly, knowledgeable, and brings positivity and humor to what some may consider a dry subject material. He answers all questions and makes sure we are on the same page before moving on.
Nicole L.
This class built my confidence to create more dynamic materials with Excel.
Heath Fedele
I think this class was amazing for learning Excel.
Claire Mecke
Super helpful! Finally took the time to stop and learn about Excel, and I can already tell it'll be really useful.
Clay Hard
I really loved the follow-along workbook. It made it easier to understand and learn the new functions being taught. I especially love that we have it for future reference when attempting to utilize the new tools learned.
Elisabeth Swain
I had Mike as an instructor for Excel Level II and Excel Level III. The experience in both was superb. He made the experience relatable to real-world situations.
Bridgette Williams
As a person new to all things Excel related, Mike made the class relatable and enjoyable. I learned a lot and enjoyed all of it.
Bridgette Williams
Excel never stops adding new functions and features. If you work with data, this course is a must.
Stella Alvo
I liked that the teacher reviewed things that seemed small but make a huge difference in my everyday job. The class was amazing and I recommend it to anyone who is ready for that next step in Excel or who just wants to see what else they can do with that information.
Felicia Purvis
Very informative. Highly recommend this course for anyone looking to improve their Excel skillset.
Nicholas Passalacqua
I feel more confident using Excel now compared to two weeks ago.
Carla Joseph
A very good class for someone who has not used Excel for some time.
Irina Sher
I recommend this class to anyone who would like to level up their Excel knowledge. The instructor played an important role in engaging and explaining the content. Thank you for having this course!
Yamilka Mirambeaux
Excel Level II is for those who know how to get around in the software, but don't understand how powerful it is. This is a great introduction to how effectively you can manipulate data at scale and unlock its potential.
Luke Sanabria
This class has enhanced my Excel skills for my future endeavors.
Alain Garrido
Adebayo and NYC Career Centers make taking an Excel course go from daunting to even more enjoyable than I could even imagine. Will totally be recommending it to everyone who wants to improve on their Excel skills. Obviously a lot of information to take in, but was able to tackle it in smaller bites which made retaining information so much easier!
Jocelyn Torres
This is a great class for anyone who wants to learn more about Excel and its many functions! I was nervous at first about taking this class online but our instructor, Ade, was so knowledgeable and helpful.
Jennifer Kelly
If the class is about Excel and if the instructor is Debbie Cunningham, TAKE IT. Even if it's just a refresher course, I promise it will be both informative and enjoyable.
Manna Yamasaki
This course was amazing! I walked away with so many insights and tricks to help navigate Excel more efficiently.
Jenna Britton
Wow! I am going to be a better Excel user. Ms. Cunningham simplified the concepts and made them easy to understand. The most valuable tools for me to take away are XLOOKUP, VLOOKUP, Excel and Windows navigation commands, absolute reference, named range, Flash Fill, Pivot Tables, and slicers, to name a few.
Kenyetta Johnson
I don't consider myself an Excel expert, nor am I a total beginner - the Intermediate Excel course was a perfect fit for me. It reminded me of the essentials while improving on the overall Excel experience without being judged.
Yves Lin
The Intermediate Microsoft Excel was very useful for daily tasks. The instructor was clear, helpful, and took time to explain the different steps. The content format is easy to navigate. I have learned new useful functions.
Jennifer Giachino
I recommend this class if anyone needs a refresher in Excel, or to implement some new ways to streamline their work.
Sonia Lall
Really enjoyed the Excel class. It is very in-depth but easy to understand. There are a lot of concrete examples and exercises to practice & apply the content learned.
Jennifer Chan
I learned many aspects of Excel that will make my daily work life easier. This course was super informative and easy to follow. It was great!
Katie Brokke
I would recommend this class to anyone trying to increase their Excel abilities.
Kyle Frascarelli
I did Excel Level II and came away confident and eager to apply what I learned. Mike, our instructor, was outstanding!!! I plan to do Excel Level III next.
Monique Greene
Great Excel Level II class. The flow is easygoing and not rushed. Jeannette takes time to explain the functions and is willing to answer all questions.
Marlene Sullivan
I thought this class was super helpful, and really improved my knowledge of Excel. Would highly recommend this class to people who have a basic understanding of Excel and want to better their competency.
Lola Franco
Great experience. Taught me elements of Excel I didn't even know existed!
Aiden Dasilva
Best class I have ever taken. My Excel skills have skyrocketed!
Max Rathod
I have taken multiple classes in Excel over the years and this was by far the best experience I have had!
Elinor
All I could expect from an intermediate Excel class. Well worth the time and money.
Axel Meier
Great instructors, great class materials, and a great overall experience. In my experience, this course is far and away better than anything you can do on LinkedIn Learning and certainly better than just watching YouTube videos. It really made a difference in my knowledge of Excel. The main advantage of this class is being able to work with pre-loaded data on the provided spreadsheets, which provided me with real-world experience using the techniques taught in the class. I highly recommend it!
Jacob Wahl
Garfield is concise! Very patient and goes at a good pace. He focuses on the actual understanding of the process rather than just showing the formulas and moving along.
Marea Chaveco
Excel I and II have been very helpful in my new role. I work in hospital administration, and although I had some knowledge of Excel, it was extremely basic compared to all the helpful skills learned in these classes. I am already implementing some of them in my data analysis and presentation. Highly recommended!
Natalia Ruiz
This training was like Christmas morning for the Excel-curious. Debbie Cunningham is an excellent instructor and gives very practical information in a fun and professional way. I literally learned 5 new things in the first 10 minutes. So cool!
Chip Doherty
I have used Excel at work for years but I picked up so many tips and learned new functionality. I will be much more efficient after this class!
Chipo Sachirarwe
TMc
Really enjoyed this course. Super succinct and covers a wide range of topics.
Kelly Ginsberg
L'Oreal
OMG! Ade was an excellent instructor! He explained things in a very clear way; he was thorough yet not overwhelmingly so. Definitely would recommend.
TiffanyMarie Gorritz
Ortho Clinical Diagnostics.com
Great class if you're looking to enhance your professional skills!
Danniel Pandolfi
David Yurman
I feel confident about VLOOKUPs now after attending this course.
Alexandra Clark
Lazard Asset Management
Great class! Definitely excited to take these tips into the workforce.
Colleen Keegan
Small class sizes, patience experts with real life experience, and the opportunity to retake a course in 6 months! They really want you to succeed!
Jolina Harris
Point B
Great overview of basic Excel functions.
William Hedden
I am now an Excel Guru, no doubt!
Andreew Axelrad
MealCo
Here to Learn - Earn with what your Learn!
Bev Parker
Mitsubishi Corporation
I've been taking classes here over the course of many years. Convenient location, class schedule availability, individual attention, reasonably priced. Great opportunity if you want a classroom setting.
Phyllis ONeill
I initially took this class for VLookups and Pivot Tables, but there were so many useful tools just for everyday tasks in the office. I would recommend this class to anyone. I'll be back for Advanced Excel. Thanks!!
Ramona Boswell
Breaking Ground
The perfect boot camp to refresh my skills while also learning new, helpful tips! Great for beginners and experts alike. Would definitely take another class and recommend to other peers and colleagues.
Jeanette LeBlanc
Very interactive, great way to build skills with Excel.
Jack Dolitsky
Helped me distinguish my strengths and weaknesses in Excel and really advanced my skills and understanding of the software.
Robert Miller
N/A
Whether you are looking to firm up your skills, learn new skills, or just get faster and more efficient at the skills you already have, this is a great training experience!
Jordan Pratt
Uplift Education
Would highly recommend to anyone interested in improving their Excel abilities. Garfield is particularly wonderful.
Shubha Chandra
I did the all day class on a Sunday. I thought it would be a long grueling day, but it was actually enjoyable and went by really fast.
Lisa Dag
Merrill Lynch
Patrick is a fantastic instructor. This was my second time taking the Excel class with him. His pace is just right, he waits for every single person in the class to finish before he moves on to the next task and doesn't over-complicate things. He's always open to explaining again and sometimes shows shortcuts while he does that. His teaching style is incredible and I'd definitely recommend him.
Hanisha Grover
Macy's
Teaches tips and tools with step-by-step instructions that never leave you behind.
Rachel Saunders
Idealist
Learned so many tips and tricks. Thank you!
Sharon Ewing
The class session went very well. Ade does take the time to go through the lesson and allow students to ask questions.
Kelly Maxwell
Dept. of Environmental Protection-City of New York
Game changing! These tools will save me hundreds of hours of time at work :)
Rachelle Torres
The class was extremely helpful, even if you are a heavy Excel user! I learned many processes that will help me function much more efficiently. Vincent was a fantastic teacher!
Stephen Appel
Great class and they make it super easy to learn!
Jose Rodriguez
Jeanette was patient and did a very good job. I like the way she taught.
Akramul Ahsan
I am glad that I took the class and I learned a lot of information that I am sure will make working with Excel more efficient. I would recommend the class to anyone who has never taken a class and is self-taught. The shortcuts alone that I learned will save me so much time in the future.
Theola Riedemonn
I will definitely encourage my department to attend this class. Very informative.
Marianne Acosta
Ade was very personable and knowledgeable. He made a seven-hour course fun and engaging. I learned a lot that will make my life and job easier.
Aiyla
Kone
It was very helpful to learn more shortcuts! The material was in-depth without being overwhelming.
Christie Cravens
Everything provided can be used in my daily operations.
Kyler Epperson
Enjoyed the fact that the class had a workbook, very interactive!
Jimena
Dragados Canada
This course was very helpful and thorough!
Claudia Neddermann
Even though I have used Excel for years, there is always something new to be learned. Looking forward to taking more of these classes!
Susan Torell
HUGO BOSS Retail, Inc.
This class was definitely suited for intermediate Excel users. Not only was it a great refresher in some basics but it also covered many topics that were more complex. They made the concepts easy to grasp in order to write the formulas.
Jennifer McDowell
Hugo Boss
Ade's Intermediate Excel class was incredibly informative and explained in a very clear way that was easy to understand. The instructor had great energy, was very patient about answering questions.
Laura Lysle
Fantastic class, made it super easy to learn Excel!
Katherine Gonick
Senvest
I came into this class knowing nothing about Excel. After a class with Mike, I felt like a pro!
Severin Johnson
Career Centers has the best instructors and you get the best for your money.
Kenneth Nditsi
NYU Grossman School of Medicine
I would recommend this class!
Janna Garcia
NYU Langone Health
The course material was engaging and the structure allowed for increased retention of material.
Andrew Smith
NYU Langone Medical Center
Mike was a fantastic instructor and was very attentive to any student questions.
Austin McCarthy
Hinds-Bock
The course is very thorough.
Miguel Cedeno
I enjoyed the course and learned quite a lot.
Katherine Lebovics
Definitely worth the time investment. Great content, extremely applicable.
Tara Matteo
Vincent is so friendly and does a great job engaging virtually. He is sure to slow the pace when needed and patiently guides anyone who needs it.
Jacquelyn Roemeling
This is a life saver class!
Julie Zee-Seto
The best, most engaging Excel course I've taken to date! Mike was absolutely fabulous. I took the intro Excel course with him and was so excited to see that he was teaching this course today! Mike isn't just an exceptional instructor, but also a master at engaging his students. His teaching style is the perfect mix for me: keeping the topics light while introducing game-changing knowledge and insights.
Alex Gagne
Adebayo is very patient and attentive. He answers everyone's questions and make sure we all understand.
Gloria Snyder
Excel Intermediate with Debbie Cunningham was the class I didn't know I needed but I'm so glad I enrolled. She made everything seem so easy and always had a useful shortcut, which is essential for time management. If I could, I would take all of her classes.
Penfield Belton
Mike was very informative and explained matters in a way that was easy to understand.
Ken Yu
NYU Langone
I loved this class! The instructor went slow enough for me to actually understand and follow along. I think this class will help me work faster in Excel with all the shortcuts and new functions I have learned!
Reagan Sanders
Tinuiti
A good broad overview if you need to expand your skills from just basic Excel.
Heidi Harper
Mitsubishi International Corp.
The instructor was very clear. Explained concepts in detail and in a way that made them easy to follow. I was a bit apprehensive about taking the course online - however, I was pleasantly surprised.
Nanchi S.
He was very helpful, spoke clearly, and made sure nobody was left behind. Mike Green is a great instructor. He would ask questions and test us as he went on with the class which I really liked. He was clear about what we will need if we look into taking more classes, which I truly appreciated. I would refer this center to anyone looking in learning any type of software.
Nathia P.
I have been wanting to learn about Pivot Tables for years. So glad to finally know how they work! I am in Excel every day, but there is a lot for me to learn still - and it was great to learn tips on how to analyze my data more efficiently. The instructor was upbeat and not boring at all. It can be very easy to get distracted during online trainings, but I did not during this course.
Holly M.
Very good information! I have always thought I was fairly proficient in Excel, able to navigate easily and get the outputs I wanted, but this course definitely taught me some shortcuts and provided new knowledge.
Leha P.
I would recommend the Excel training classes at NYC Career Centers. If you are looking to enter back into the job market or just want to update your skills - then NYC Career Centers is the place to do it. The teachers are well versed in their courses and have a helpful attitude. The school is centrally located in NYC. The classrooms are extremely clean. They offer both online and in-person classes. Listen, it is time to go for it!!!!
Annette Peterson
Excellent, the instructor related the material to very helpful real-world scenarios. Patient and kind.
Justine Jackson
Excellent instruction. Pace, cadence, and delivery were perfect for an intermediate user like me. If Excel were easy, everyone would be doing it.
Jason Bojdak
Perfect for anyone who uses Excel in their day-to-day life! Learned many new shortcuts for Excel and my new favorite: the XLOOKUP.
Matthew Cadrin
Bob was incredibly knowledgeful and patient while teaching Intermediate Excel. The class was interesting and I was shocked to learn as much as I did.
Bennett Berlin
I would recommend this course to anyone who needs a greater level of understanding in Excel.
Tiffany Moore
I liked the class and would like to come back for the advanced course.
Klara Collaku
I thought the class was well organized, clear, and easy to follow, and the instructor was very knowledgeable with excellent presentation skills, Debbie did a great job. Overall the course is going to be very useful in my day-to-day job.
Lizbeth M.
I loved this class, especially taking it after the Excel for Business Level I - Fundamentals. The build made it much more seamless and the refresher at the beginning of the Intermediate class proved to be exceptionally helpful.
Erika Freeman
My Excel knowledge has exponentially multiplied since taking this class and Excel Fundamentals.
Vincent La
After years of confusion and struggle with functions such as IF statements and VLOOKUP, I finally feel comfortable using them!
Jessica Trinh
This class was extremely helpful in refining my Excel skills. I will definitely be using the new formulas I have learned on a daily basis to support my work!
Hannah Ritz
Excellent instructor Vincent taught me a lot of useful new things and tricks.
Lenka Miklosova Vrazda
Despite their level of Excel experience, everyone would find the Intermediate Excel class very useful.
Daniel Campos
Very glad I took this class. I have already started using some of the tips and tricks that I've been taught.
Asia Robinson
Excellent course! Highly recommend for individuals looking to enhance their Excel skills whether it be for career or personal development. Instructor goes through material step by step and there are plenty of opportunities for questions.
Jason Mui
If you have the opportunity to take Intermediate Microsoft Excel with Ade Norman, please do. It will change your business's efficiency and productivity.
John Campanelli
This course is great for anyone who wishes to advance their Excel level. Though it may be easy for someone who uses Excel every day, it serves as a good refresher for functions and tools that are perhaps not used on a daily basis. Will definitely help in my professional career.
Jose Bravo
I took this Intermediate Excel class and it couldn't be better. You can learn new Excel skills and improve your current skills. I highly recommend it if your work or any tasks in your life demands use of Excel. Great class! I will be back for the next level!
Pablo Varela
The course was very beneficial for me, it touched upon some of the most vital aspects of using Microsoft Excel. I thought that learning by example from the instructor was vital to retaining the knowledge.
Francisco Irizarry
It was a rich instructive experience because the instructor is very good at teaching. Her explanation is clear and concise with useful examples that show the learner not only how to execute the commands, but also the context of why so-and-so function is applicable.
Yvens Pierre
This course made me feel much more confident in my Excel skills!
Jessi Moore
I've been using Excel for a very long time but never really kept up on the updates, changes, and new features. The Intermediate class has been great at having someone walk me through how to use many of these newer features.
Scott Pisani
This is an extremely valuable course to take no matter your background and/or skill level with Excel.
Makayla Karr-Warner
This class is very informative and good. Professor Vincent is great at teaching the Excel materials and he is very funny—keeps the class laughing.
Delmarie Williams
This intermediate course touched on various formulas, Pivot Tables, functions, and other necessary tools that were extremely useful to learn. Our instructor engaged his audience by asking us how we think we could apply what we learn in our professions and fields. He was thorough, clear, and constantly checking to ensure that we understood what he was teaching.
Kimberley Campbell
I didn't even know how much there was to learn about Excel and this class just keeps revealing more.
Judith Baicich
Really helped me to understand how to work more efficiently in Excel.
Clara Brooks
This school makes Excel easy and understandable.
Carlos De Paz
Reliant
As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
We don’t currently offer discounts as we do our best to affordably prices our courses.
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
Learn with real-world projects
Step-by-step instruction to boost retention
The Career Centers instructors are highly skilled communicators who really know their craft. They are wonderful about explaining and re-explaining when necessary and I never felt rushed or foolish for asking a question.
—Diane Speros
Gain industry knowledge from professionals
Retake the course for free within one year
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.
Unlike other providers, these are not mass open-enrollment classes. At NYC Career Centers, 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.
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
We offer a single free retake of the class within a year.
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.
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
You have some options:
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of Intermediate Microsoft Excel with your selected courses.
Get going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow.
The Excel Specialist Certification program includes our three Excel courses (Fundamentals, Intermediate, and Advanced), two hours of private training, and the Excel Specialist Exam fee with a free retake.
Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts, Pivot Tables and scripts, and macros for automating tasks with ease.
Become an expert Excel user with this Advanced Excel course. Learn powerful functions like INDEX-MATCH, work with advanced Pivot Table functions, and start recording macros to automate workflows. Prepare yourself for any Excel challenge with this advanced Excel course.
We offer custom onsite training and discounted class vouchers.
corporate@nobledesktop.comAre you comfortable with the essential functions of Excel, such as entering data, basic calculations, and formatting spreadsheets? If so, there’s a lot more Excel can do to help with your business needs. In this intermediate course, you’ll learn the following skills:
Intermediate Excel covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with an understanding of basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, summary tables that calculate statistics and essential information from massive datasets.
If you’re using Excel to manage large datasets, Intermediate Excel will help you manage data better with lessons on basic database functions. Intermediate Excel also covers VLOOKUP and HLOOKUP to query columns and rows. We will show you crucial database management tools including Named Ranges, Sort & Filter, and Data Validation to help you enter data quickly and efficiently.
Throughout the class, we'll show you tricks and techniques to speed up your workflow, including navigational and keyboard shortcuts. In this hands-on course, you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end.
Our Excel video suite provides premium video lessons for Excel students. Review the course materials anytime you need a refresh with high-quality video and lifetime access on desktop, tablet or mobile. Intermediate Excel students receive the video suite, a $95 value, completely free with course sign up.
Do you want to improve your abilities in Excel? Our Intermediate Excel course is the perfect option. This course offers comprehensive training in Excel with hands-on exercises in our custom workbooks. You’ll leave this class with confidence and eager to demonstrate your knowledge of Excel at work!
Worksheet Management begins with Navigation techniques. To save time switching between keyboard and mouse, you can apply basic keyboard shortcuts to navigate around worksheets. You don’t need the mouse to highlight or move text from one cell to another. Paste Special, which illustrates how to copy data, formatting, and even formulas from one cell to another with a quick keyboard shortcut.
What if you put the first and last name of each client in one cell, but want to divide them into two cells? If you have 200 clients in one Excel spreadsheet it could take hours. Do you have to copy and paste text from one cell to another? Not with Intermediate Excel functions!
Split Text from one cell into multiple cells by using the ribbon and Join Text from multiple cells into a single cell with CONCATENATE and the ampersand “&”. You can also make calculations easier by using Named Ranges to classify an individual cell or a range of cells.
Keeping your data organized is essential to perform calculations and other data functions in Excel. Data Validation formats cells with a drop-down menu, thereby restricting the data that can be entered into a cell.
Sort & Filter will show you how to organize and search your data efficiently. Remove Duplicates demonstrates Excel’s ability to quickly examine a set of data and eliminate any duplicate rows.
Database Functions help you find data within the Excel worksheet quickly. For example, you may look up a product code, and return the name or the cost of that product. The VLOOKUP is easily considered the second most important skill in Excel and helps you find data within columns. HLOOKUP is used to find data within rows.
Logical functions help you find data that meets certain criteria. For example, with the IF statement you can design a true/false test and designate specific actions to perform for both true and false results. This powerful ability allows a single cell to offer two different outcomes. AND/OR functions build on the basic True/False property by implementing multiple logical tests to determine in a statement is true.
Pivot Tables are easily the most-sought-after skill in Excel. Pivot Tables are another way to analyze data in Excel through both consolidation and analysis. With the Grouping technique, you can consolidate row and column data into groups. You can also create Multiple Pivot Tables on the same worksheet page.
It’s hard to keep track of data within large datasets. The RANK.EQ, COUNTIFS, and SUMIFS provide additional information on data position and count within an Excel worksheet. Combo Charts are a unique visualization tool that allows Excel users to combine two charts.
At Career Centers, helping professionals master Excel quickly and efficiently is our #1 priority. We offer a variety of benefits to ensure every student succeeds. When you attend classes at Career Centers you’ll find small class sizes, a modern computer lab with PCs and Macs, and patient instructors that ensure everyone understands.
We also provide a free course retakes for all courses include Intermediate Excel. After the course, take time to practice and reinforce what you’ve learned with your Excel workbook. Take your Intermediate Excel course again within six months absolutely free of charge!
The first installment is due one week before the first class. Subsequent installments are spread out evenly across the duration of the course.
Installments | |
---|---|
10% non-refundable deposit | |
$249.00 | Total You Pay |