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 start a career as a business analyst. 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.

The Business Analyst Certificate includes

Excel for Business Fundamentals

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.

Intermediate Excel for Business

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.

Advanced Excel for Business

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. 

PowerPoint for Business

In this beginner PowerPoint course, you'll create and run dynamic presentations; add images, shapes, animations and layered objects; create tables and charts; and prepare the slideshow for presentation.

Advanced PowerPoint for Business

In this advanced PowerPoint class, you’ll create a reusable PowerPoint Template, make an easily updatable, engaging, consistent presentation, import charts from Excel, use multimedia and layered objects, and record a slideshow.

Tableau Level I

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.

Tableau Level II

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.

SQL Level I

Learn how SQL is used within relational database management systems. Connect to SQL Server and write queries with conditions. Use functions to calculate and format data before it’s presented on screen. In SQL Level 1, you’ll learn everything you need to write SQL queries on your own.

SQL Level II

Master views, subqueries, logic statements, and data conversions in SQL Level 2. Combine advanced SQL functions with fundamentals like inner and outer joins to proof your work. Develop your skills in SQL by writing advanced functions to gain more control in your relational DBMS (Database Management System).