Master the tools of a business analyst and launch your career as a Business Analyst by learning Excel, PowerPoint, SQL, & Tableau in hands-on classes.
This program is perfect for professionals looking to build skills in business analytics. In these hands-on classes, you'll work with the key tools you'll need to succeed as a business analyst and get yourself job-ready. Work on real projects in Excel, PowerPoint, SQL, and Tableau to really gain mastery of the tools. You'll boost your resume with some of the most in-demand skills and be ready to succeed on the job.
You'll learn how to work with data in a variety of formats, generate insights from data, automate work, create amazing visualizations, and wrap it all together in a presentation.
The Business Analyst Certificate is open to beginners and requires no prior Excel, PowerPoint, Tableau, or SQL knowledge.
This is the recommended order, but some courses may be taken in a different order.
Unit 1 6 Hours
Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.
Unit 2 6 Hours
Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.
Unit 3 6 Hours
Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have a strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you.
Unit 4 6 Hours
Unit 5 6 Hours
Unit 6 6 Hours
In this course, you will be introduced to the field of data visualization and the various tools Tableau Public offers. Through concepts and exercises, you will learn to identify datasets to connect to, explore, analyze, filter and structure your data to create your desired visualizations.
Unit 7 6 Hours
In this course, you dive further into Tableau tools and customization of your visualizations. You will learn to create a variety of maps to represent your geographic data, and build actions to control your visualizations within your sheets and dashboards. This course requires to have completed level I in Tableau.
Unit 8 6 Hours
Unit 9 6 Hours
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
If you want to learn AutoCad, this is the best class.
In this course, I learned a lot about Excel that I didn't know previously. I would certainly recommend it to those looking to learn more about the software.
This is the perfect beginner class to ease your way in to Excel.
Intermediate Excel was great! Our instructor, Mike, was very patient and happy to answer any questions that came up along the way. VLOOKUPS aren't nearly as intimidating now that I've taken the class.
Picked up a few little tricks that I hope to use more regularly.
Everything felt like it flowed from beginning to end with extra tips in between and he was able to provide different tips based on how you were working in Excel.
When my job offered these courses I hopped right on board. I am familiar with PowerPoint but I wanted to be sure I refreshed my memory and gain new skills as we know technology changes every second, and I am glad I took the opportunity to enroll as I am now able to do so much more with my presentations.
I would definitely recommend these classes to improve your excel skills. I use excel everyday and having this knowledge will cut time on work significantly.
Even though I prefer an in-person class, I'm grateful for the opportunity to still enhance my knowledge and skills through Zoom.
Class and instructor was very patient and informative. I really enjoyed the session.
We could ask as many questions as necessary, and Garfield answered them all.
I definitely recommend this course for professional development in any field where MS Excel is used.
Life-changing, super helpful! I loved the energy the instructor, Mike, had. It was very interactive and informative. Learned a lot :)
Tons of helpful tips and tricks for everyday Excel use.
This was a great class, even if you know excel there are formulas/functions that can give you faster results then what you are doing now.
Very good class. Trainer was very good, very patient.
Love this class. Can use what I've learned at work.
I highly recommend Beginner Microsoft Excel. I have spent many days working on spreadsheets. Had I taken this course sooner I would have cut my time spent on coordinating spreadsheets and enabled me to appropriate time to other projects.
After participating in the Intermediate Excel for Business training, I now feel much more confident about using Excel in my job. I've been intimidated by Excel for quite some time but now I see it as a tool to experiment with and learn from!
If you would like a better grasp on how to maneuver your Word program, this will help so much. It touches on all important points for program.
I learned more in this than I did in college with excel and hope to apply it more in my work setting.
Never in a million years would've thought that an Excel training workshop would actually be enjoyable!
A fantastic class. Whether you are new to the advanced functions of PowerPoint, or if you are simply trying to brush up on your skills, this class will provide you with the information you need to take that next step. Plus Ade is a great instructor.
An engaging, informative perfect way to learn or refresh your skills!
Thorough, patient, and enthusiastic instructor; super helpful Excel tips for business.
Showing 25 of 177 reviews
Learn the concepts and skills covered in this true or your tuition is on us. See details and terms & conditions.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
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 NYIM Training, 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 any module or the whole program 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.
Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required.
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:
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.
This program is a discounted package of classes that is 15–25% off the individual class prices, so additional discounts do not apply.
