NYC Career Centers

In this 9-day comprehensive Microsoft Office bootcamp, students with little to no Microsoft Office background will be able to build the fundamentals they need to succeed in the modern workplace. Students in this course will learn four of the most in-demand Microsoft Office tools, including Excel, Word, Powerpoint, and Outlook. In the Excel course, students will start with introductory material, like workbook fundamentals, before progressing on to more intermediate topics like formulas, charts, tables, and more. In the PowerPoint course, students will learn the basics of making clean and compelling presentations and slide decks. The Word portion of this course will help students learn their way around Word documents, as well as learning tips and tricks to work efficiently. And finally, the Outlook section of this course will introduce students to working with Outlook, how to manage, search for, and format messages, and much more. This course also offers a free retake within six months to allow students to revisit any concepts needing to be refreshed and walk away with a much stronger grasp of the material.

This 2-day comprehensive Tableau course is designed to provide beginners the skills they need to start working in Tableau and creating powerful data visualizations. In the beginner part of the program, students will begin learning the tool's essentials, including data connecting, manipulation, and calculation. Then students will begin to create visualizations from their data with charts, graphs, and dashboards. In the advanced section of the course, participants will learn advanced visualization techniques creating data maps, visualization maps, and custom charts.

In this 2-day PowerPoint course, beginners will become advanced users of PowerPoint to start creating professional presentations. This course covers the beginner to advanced topics, from creating presentations to creating reusable, professional templates. The course opens with basic techniques and navigation in PowerPoint, like the Outline View, working with images, and inserting charts. Participants will then learn design techniques, templating, collaboration methods, and more to advance their skills. This course provides students with a free retake as well as a full video suite for course review.

In this 8-day intensive Data Analytics bootcamp, students with little to no background in data analytics will learn how to use Microsoft Excel, SQL, and Tableau to summarize, display, and discover key insights hidden in data sets. By the end of this bootcamp, students will be able to use Excel to aggregate and summarize data, sort data with PivotTables, create charts and tables in Excel, use SQL to filter and sort large data sets, use advanced database queries, create visualizations with Tableau, and much more. Students will also be able to reinforce what they learn through the numerous projects they encounter throughout the course. This course also offers a free retake within six months to allow students to revisit any concepts needing to be refreshed and walk away with a much stronger grasp of the material.

This 3-day SQL Bootcamp consists of three courses (Levels 1-3) and helps students with little to no prior SQL experience go from novice to pro in a couple of days. The first course, SQL Level 1, covers the basics, including an introduction to SQL and relational databases, the graphical user interface (GUI), and some of the coding basics. The second course, SQL Level 2, introduces students to SQL queries and subqueries, using JOINS, math and logic functions, as well as variables and user functions. The third and final course, SQL Level 3, walks students through importing and exporting data, building control structures, temporary tables, and stored procedures. Each course concludes with student labs to help cement the skills students learn in each course.

This 3-day Microsoft Excel Bootcamp consists of three courses and helps students with little to no prior Excel experience go from novice to pro in a couple of days. The first course, Excel for Business Fundamentals, covers the basics, including writing formulas, using absolute references, formatting, common charts and designs, as well as general workbook best practices. The second course, Intermediate Excel for Business, introduces students to more advanced topics, including advanced paste functions, working with text, VLOOKUP, PivotTables, statistical functions, and some advanced charts. The third and final course, Advanced Excel for Business, walks students through some common skills used primarily by more experienced Excel users, including cell management, nested IF statements, What If analysis, advanced analytical tools, INDEX-MATCH, and macros to help automate repetitive tasks. Each course concludes with a final project to help cement the skills students learn in each course.

This 1-day Microsoft Excel course is intended for those who have little to no prior Excel experience looking to build foundational skills working with spreadsheets. This course covers all the basics to make students feel at ease when working with Excel. There are a number of topics covered in this course, including data entry, working with basic formulas, formatting data, an introduction to charts and tables, and workbook management. The course is punctuated by a final project to help review and solidify the major topics covered in the class.

This 1-day Intermediate Microsoft Excel course is designed for individuals with some prior Excel experience but who are looking to add to their Excel toolbelt and continue building their spreadsheet knowledge. There are a number of intermediate topics covered in this course, including learning helpful keyboard shortcuts, working with text, functions (statistical, LOOKUP and logic functions), working with PivotTables, and an introduction to combo charts. The course is punctuated by a final project to help review and solidify the major topics covered throughout the course.

This 1-day Advanced Microsoft Excel course is designed for individuals with a strong grasp on Excel but who are looking to add to their Excel toolbelt and learn advanced functions and features to become an Excel expert. There are several advanced topics covered in this course, including advanced cell management and cell locking, special formatting, advanced functions (like nested ifs), What If analysis, PivotTable calculations and charts, Index-Match, and a Macros primer to help students automate repetitive tasks. The course is punctuated by a final project to help review and solidify the major topics covered throughout the course.

This 2-day Excel Visual Basic for Applications (VBA) course is designed to help individuals automate their workflow and reduce user errors in Excel. This course covers a range of VBA topics and is mainly structured around learning and writing code for macros. The first day of the course introduces students to macros and the VBA editor, teaches students how to write VBA code, provides an overview of objects, outlines logic and looping statements, and shows students how to make their code interactive. Day two focuses on the VBA editor and editing code, how to invoke macros, revisits objects and logic statements, shows students how to handle errors, and more. By the end of the course, students will feel confident using macros to make their workflow in Excel more seamless and less error-prone.