(212) 684-5151

Search Our Courses

Popular Searches

Intermediate Microsoft Excel 2016
  • Worksheet Management
  • Database Management
  • Database Functions
  • PivotTables & PivotCharts
  • Logical Functions
  • Statistical Functions
  • Pivot Tables
The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.

$229.00

Intermediate SQL Course
  • Subqueries
  • Insert, Update, Delete
  • Create Tables
  • Create Views
  • Create Indexes
Create advanced SQL queries, and manipulate and index tables. Course Objective: You will work with advanced queries and manipulate tables. You will also view and index table data.

$325.00

Beginner Access
  • Navigate Access Environment
  • Customize Configuration
  • Organize/Manage Data
  • Queries to Join, Sort & Filter
  • View, Access & Input Forms
  • Create Custom Reports
Covers the basic skills, including: identifying the components of the Microsoft Access 2016 environment, identifying the components of a database, organizing data in tables, viewing data in tables, querying a database, designing forms and generating reports.

$229.00

Advanced Microsoft PowerPoint 2016
  • Designing
  • Collaborating
  • Commenting
  • Navigation
  • Using Multimedia
  • Layered Objects
  • Charts from Excel
  • Tables from Excel
  • Custom Shows
  • Recording a Slideshow
Concentrates on some more advanced skills, including: customizing the PowerPoint environment, customizing a design template, adding SmartArt graphics to a presentation, adding special effects to a presentation, customizing a slide show, collaborating on a presentation and securing and distributing a presentation

$229.00

Advanced Microsoft Excel 2016
  • Special Formatting
  • Advanced Functions
  • What If Analysis
  • Advanced Analytical Tools
  • Advanced Database Functions
  • Introduction to Macros
Our advanced Excel training will delve into data tables, goal seek, advanced database functions (including INDEX-MATCH), recording macros, and advanced analytical tools. Throughout the course you'll be building speed with our revolutionary time-saving tricks.

$229.00

Beginner SQL Course
  • Simple Queries
  • Conditional Criteria
  • Organize Data
  • Join Tables
  • Aggregate Functions
Use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database.

$325.00

Beginner Microsoft Excel 2016
  • Perform Calculations
  • Modify Text
  • Format a Worksheet
  • Create Charts and Tables
  • Manage Workbooks
This beginner Excel course covers the fundamentals, including basic formulas, functions, formatting, printing, charts, & calculations. We'll also introduce you to some essential shortcuts to start boosting your speed. This class is the perfect introduction to Excel that will help you set a solid foundation in the software.

$229.00

Beginner Microsoft PowerPoint 2016
  • Creating Presentation
  • Images
  • SmartArt
  • Shapes
  • Layered Objects
  • Tables
  • Charts
  • Proofing and Editing
  • Animation
  • Running a Presentation
Covers the basic skills, including: exploring the PowerPoint 2016 interface and familiarizing yourself with the interface, creating a presentation, formatting text on slides, adding graphical objects to a presentation, modifying graphical objects on slides, working with tables in a presentation, importing charts to a presentation, and preparing to deliver a presentation

$229.00

Intermediate Access
  • Design a Relational Database
  • Join Tables to Retrieve Data
  • Validate Data Entered
  • Advanced Queries
  • Efficiency & Performance
  • Maintain Data Integrity
  • Customize Reports
Concentrates on some more advanced skills, including: streamlining data entry and maintaining data integrity, joining tables to retrieve data from unrelated tables, creating flexible queries to display specified records, allowing for user-determined query criteria, modifying data using queries, improving forms, customizing reports to organize the displayed information, producing specific print layouts and sharing data between Access and other applications.

$229.00