Excel

Excel is one of the most popular components of the Microsoft Suite. This spreadsheet program has a variety of useful tools that are effective for the corporate work space. It ranges in financial and reporting functions from calculations to charts and graphs to pivot tables and macro programming language known as VBA (Visual Basic for Applications). When used properly, it can be an efficient and powerful time saving software for most work requirements.

This is where our training comes in to help YOU Excel at Excel.

 

Basic - Intermediate Excel Level 1

Excel Level 1 classes focus on the foundation of Excel and its features.

Core areas of learning include:

  • The Excel Work space
  • Simple Formulas
  • Formatting
  • Simple Charts and Graphs
  • Printing. 

 

This Excel class helps to prep for the MOS Excel Exam.

 
Excel.png

Advanced Excel Level 2

While Basic -Intermediate Excel Level 1 classes focus on the foundation of the Excel program, Advanced Excel Level 2 classes focus 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 Excel class helps to prep for the MOE Excel Level 1 and Level 2 Exams.

 
Excel.png

Advanced Excel Level 3

Advanced Excel Level 3 classes focus 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 Excel course helps to prep for the MOE Excel Level 1 and Level 2 Exams.

New York Computer Training Solutions LLC
(646)345-5713
info@nyctsolutions.com