Data Analyst Training NYC

All Locations NYC Los Angeles Chicago Online Boston Nashville Houston Washington, D.C. San Diego San Francisco Seattle Atlanta Denver San Jose Charlotte New Jersey Brooklyn

SQL Bootcamp: Learning the Language

General Assembly @ 10 E 21st St, New York, NY

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways Understand SQL vocabulary such as tables, schema, functions and JOINS. Understand the differences between...

Advanced Excel Level 2

New York Computer Training Solutions LLC @ 71 W 23rd St, New York, NY

While Basic to Intermediate Excel Level 1 focuses on the foundation of the Excel program, Advanced Excel Level 2 focuses on extracting data. We take the principal elements of the program and build on the lessons to create more dynamic spreadsheets.  Topics include: Working with Templates Data Validation VLookup Function IF Statement Pivot Table Data Manipulation Introduction to Simple Macros.  This course helps to prep for the...

Microsoft Office Excel 2016: PivotTables

NYC Career Centers @ 185 Madison Ave, New York, NY

Coding for Beginners Using Python

Reboot Labs @ 16 W 22nd St, New York, NY

This is a one-day intensive workshop with a limited enrollment to keep classes intimate and conversational. Get the attention you need to learn the skills to level up your career. How long have you wanted to learn how to read and write your own code? Have you been frustrated by online classes, been taken in by the promise of easy learning on your own time, and came away from the lessons with little understanding and more confusion than you started...

Python Programming 102

Practical Programming @ 49 W 33rd St, New York, NY

This is a follow up to the Python 101 class where you will practice how to combine loops, variables, and flow control statements into real working programs. Will get a better understanding how to choose the right data structures such as lists, dictionaries, and tuples. And master skills debugging your programs and finding common errors. Who Should Attend:  Everybody who attended Python Programming 101. No coding experience needed, anyone who...

Advanced Python: Best Practices and Design Patterns

Learning Tree International @ 1601 Broadway, New York, NY

Expand upon your fundamental Python programming skills to build reliable and stable applications. In this training course, you learn to implement Gang of Four (GoF) design patterns in order to solve commonly recurring, real-world software design programs, thereby avoiding pitfalls and greatly improving the effectiveness of your programming efforts. You Will Learn How To: Employ design patterns and best practices in Python applications Unit test,...

Advanced Excel Level 3

New York Computer Training Solutions LLC @ 71 W 23rd St, New York, NY

Advanced Excel Level 3 focuses on more advanced time saving functions to help format and extract data from a spreadsheet. Topics include Goal Seek Solver Tool Text Functions Data Functions Advanced Filters Financial Functions Conditional Formatting Introduction to PowerPivot. This course helps to prep for the MOE Excel Level 1 and Level 2 Exams. Course Outline: Lesson 1 - Proficiency using What-IF Analysis Tools Lesson 2 - Clean up Data...

Intermediate Excel: Formulas & Functions

General Assembly @ 10 E 21st St, New York, NY

The Intermediate Excel: Formula and Functions workshop is designed for students who have mastered the material from the Excel at Excel workshop and are looking to build upon those skills. Given that there lacks an enforceable prerequisite, the workshop does review a few topics from the Excel at Excel workshop, including conditional math functions and basic reference functions, to ensure that all participants have the basic knowledge needed for the...

Excel (2019/2016/2013) Combo

NetCom Learning @ 252 W 37th St, New York, NY

This course is suited for those using Microsoft Excel (2019/2016/2013). This course will be taught using Microsoft Excel. Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging.  Fortunately, this is where the power of Microsoft Excel (2019/2016/2013)...

Excel 2013: Level 2

NetCom Learning @ 519 8th Ave, New York, NY

After learning the fundamentals of Excel 2013 in the Level 1 course, the Excel 2013 Level 2 course prepares candidates to work with large worksheets, and manage multiple workbooks effectively. This program builds on the foundational knowledge developed through the Excel 2013 introduction course. Learn the basics of Excel 2013 Level 2 at NetCom Learning and develop the proficiency to create advanced worksheets to analyze vast amounts of data and...

MTA Microsoft Technology Associate: All Exams

NYIM Training @ 185 Madison Ave, New York, NY

Excel Modeling

NYIM Training @ 185 Madison Ave, New York, NY

Excel 2010 - Part 1

New Horizons Computer Learning @ 462 Seventh Ave, New York, NY

In this course, students will use Microsoft® Office Excel® 2010 to create spreadsheets and workbooks that they can use to store, manipulate, and share data. Who Should Attend This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2010 that is necessary to create and work with electronic spreadsheets. Upon successful completion of this course, students will be able to:  create a basic...

Excel 2013: Level 3

NetCom Learning @ 519 8th Ave, New York, NY

The Excel 2013 Level 3 course builds on the foundational and intermediate-level knowledge gained in the Excel 2013 Introduction courses Level 1 and Level 2. This course teaches participants how to do more with Excel 2013 by using advanced functionalities and features. Learn Excel 2013 Level 3 at NetCom Learning and enhance your ability to collaborate with colleagues on workbooks, use conditional logic, and automate repetitive and complex tasks....

Excel 2013: Full Package

NetCom Learning @ 519 8th Ave, New York, NY

Get trained in Microsoft Office Excel 2013 and gain the skills needed to express your ideas, solve problems, and connect with people. This course will go over foundational topics and build upon those to learn more intermediate and advanced skills needed to become a true professional in Excel 2013. Excel 2013: Level 1 (1 day)     Course Objectives: - Create a basic worksheet by using Microsoft Excel 2010. - Perform calculations in...

Excel Bootcamp: Formulas & Functions

General Assembly @ 10 E 21st St, New York, NY

If you have the basics of Excel down, and you want to start taking your knowledge to the next level, then this class is for you. In this class — ideal for people working in business, management, or simply interested in getting more organized — you’ll learn everything you need to perform at a high level in Excel. This includes formula writing, combining formulas, creating basic to intermediate charts, and of course the ultra-powerful Pivot Tables. ...

Excel for Business Level III - Advanced (EXPRESS)

NYIM Training @ 185 Madison Ave, New York, NY

Excel 2010 - Part 3

New Horizons Computer Learning @ 462 Seventh Ave, New York, NY

The students will learn about some of the more advanced features of Excel including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications. Who Should Attend This course is intended for students who are experienced Excel 2010 users who have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will...

Excel 2013: Level 1

NetCom Learning @ 519 8th Ave, New York, NY

Excel is an advanced and heavily utilized tool for analyzing and managing large amounts of data, as well as performing calculations. This Excel 2013 Introduction course at NetCom Learning explores the features and functionalities of Excel 2013. The Microsoft Excel 2013 online training and ILT classes explain how to open workbooks and navigate between worksheets while extracting and managing the required information sets. Learn the basics of Excel...

Advanced Excel Charts for Business Presentations

General Assembly @ 10 E 21st St, New York, NY

Appealing, focused, and easy to understand graphics can be the deciding factor on how your presentation is received. In more stark terms, making bad data visualizations can diminish your credibility as a business or data professional. In this bootcamp, we will learn how to create 10 Advanced Excel charts that will take your data analysis presentations to the next level. Step by step, you will see how different charts work best with certain types...