Microsoft Excel Courses New York City
Hands-on Excel training classes in Manhattan, NYC
Sign up today for NYC's premier Microsoft Excel classes and corporate training! Basic, intermediate, advanced, VBA, and private training, TCC has a wide offering of courses and class dates to choose from.
Our Excel courses are taught by engaging instructors in interactive classes. You'll get personalized training in small class sizes and our comfortable New York City facility. We offer a wide-range of training resources, including a cutting-edge online video suite. Our corporate training program has become the industry standard in providing flexible and customizable courses for any business.
Beginner to advanced Excel Training
Beginners, start with our Beginner Excel Course, where you'll review calculations, charts, formulas, and tables. In our Intermediate Excel Class, we'll dive into multi-input functions, Pivot Tables, and Sort & Filter. For advanced training, our Advanced Excel Class will show you how to automate workbook functionality, use advanced lookup functions, and forecast data using What-If Analysis. Microsoft Excel VBA & Macros will show you how to automate your daily work.
Upcoming Excel courses in New York City
- Perform Calculations
- Modify Text
- Format a Worksheet
- Create Charts and Tables
- Manage Workbooks
- Special Formatting
- Advanced Functions
- What If Analysis
- Advanced Analytical Tools
- Advanced Database Functions
- Introduction to Macros
- Develop a Macro
- Format with Macros
- Make Interactive Worksheets
- Work with Many Worksheets
- Perform Calculations
- Prepare data for PivotTable
- Analyze Data Using PivotTables
- Work with PivotCharts
- Summarize PivotTable Data
- Navigate with Macros
- Use Loops & Conditions
- Create Forms
- Understand Variables
- Handle Events
- Worksheet Management
- Database Management
- Database Functions
- PivotTables & PivotCharts
- Logical Functions
- Statistical Functions
- Pivot Tables
- Beginner Microsoft Excel 2016
- Intermediate Microsoft Excel 2016
- Advanced Microsoft Excel 2016
- Working with Databases
- Using AutoFilter
- Working with Advanced Filters
- Lookup Formulas
- Exporting and Importing Data
- Creating/Revising PivotTable
- Apply Formula and Functions Basic
- Statistical and Logical Functions
- Lookup and Reference Formulas
- Text Formulas
- Date and Time Formulas
- Array and Database Functions
- Create Reports
- Manipulate Data
- DAX functions
- Distribute PowerPivot Data
- Import Data
- Linked Tables
What will I learn in these Excel classes?
With Excel being such a necessary skill in today's workplace, a new user may find themselves asking "what can Excel do?" and "Why is Excel so much more in demand than any other program?"
The answer lies in the way Excel works and the many different functionalities that it possesses. Here's a brief overview of Excel's robust capabilities.
Calculations Excel can calculate everything from basic formulas (addition, subtraction, etc.) to complex statistics and everything in-between.
Functions exist (such as Sum, Average) to enable the user to perform advanced calculations with minimal effort. On top of all of this is Excel's extraordinary ability to take a single calculation and to apply it to hundreds or thousands of additional rows of data (Autofill).
Excel contains a very sophisticated library of functions which are brilliantly organized for ease of use. Some of the categories include Financial functions (IRR, NPV, PV), Logical functions (If/Then, And/Or), Text functions (Proper, Concatenate), Date & Time functions (Weeknum, EOMonth), and Lookup & Reference functions (Match, Index).
Working with Text Even though Excel is a spreadsheet program, it possesses a significant number of capabilities for dealing with text. Excel can split text from one cell to multiple cells (Text to Columns), such as with names, or it can combine text from several cells into one cell (Concatenate), such as with addresses.
Excel can also be used to analyze data to remove any duplicate rows/entries (Remove Duplicates). Furthermore, as Excel is increasingly being used internally by companies for forms, it can provide a structure such as drop-down boxes (Data Validation).
Elaborate Charts and Graphs Ever since its first introduction to the business world, Excel has consistently set the standard regarding charts and graphs—both regarding design and ease of creation. Excel boasts both vivid and detailed depictions of your data all in just a few simple keystrokes. From basic (Line charts, Column charts, Pie charts), to complex (Histograms, Stock charts, Combo charts), Excel provides countless ways to visualize your data for optimal reporting and decision-making purposes. Learn chart essentials in our beginner courses.
Data Analysis with Pivot Tables Pivot tables are a very cutting-edge approach to analyzing data, by creating visually-appealing tables that provide both consolidation and calculation of results. Excel can create a Pivot table from several different data sources that are both customized and easy to use regarding filtering (Slicers) and data availability (Grouping). Summarize data with Pivot Tables in our intermediate class.
Data Extraction from Tables While Excel offers a lot of special functionalities for organizing data (Tables), efficiently leveraging that information is another challenge that Excel minimizes. Data can be analyzed and summarized (CountIfs, SumIfs) or simply retrieved (VLOOKUP) from a larger source through specialty functions, making database work much more efficient. Build these formulas in our intermediate Excel course.
Advanced Data Tools Forecasting data becomes almost second-nature when utilizing Excel's "What If" analysis abilities. You can change the result of an equation and have Excel calculate the necessary variables to make it true (Goal Seek). You can also create single or multi-variable data tables (Data Table) to map out possibilities.
Recording Macros Do you have reporting responsibilities at work that involve repetitive tasks? Ever dreamed of a magic wand that could instantly compose that report/perform those repetitive tasks for you? With Excel, this is no longer a dream (Macros)! Excel can record your steps/keystrokes and translate these into code (VBA) for future reference. The next time you need to complete that task, simply run the macro and watch the magic!
Learn advanced data analytics tools and macros in our advanced Excel course.
These are just a few of the more useful abilities that Excel possesses. By learning Excel, you do more than add a line item to your resume; you acquire these skills, as well. Imagine going to work with the knowledge that whatever task comes your way, you feel confident that you can handle it. How? With Excel. Because that is the kind of magnitude that this software possesses, and these are the types of skills that Excel makes easily transferable to the user.