Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
nyc@careercenters.com212 • 684 • 5151
Download Syllabus
Classes available in-person (strict social distancing) or live online with an extended free retake period. See details.
We provide computers to use during class. Choose a Mac or a PC during the checkout process.
Students may retake the course once within six months if there is an available seat.
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 Beginner Microsoft Excel course, including basic functions and formulas, printing, formatting, basic charts, and tables.
Customize your own schedule (choose dates at checkout), or choose a preset package track by expanding the dates below.
This course includes lifetime access to self-paced training videos, a $95 value.
We offer custom onsite training and discounted class vouchers.
nyc@careercenters.comI 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, Federal Reserve Bank of New York
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
22 Students gave Intermediate Microsoft Excel a 5-star rating
Are 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!
You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).