We are offering a Microsoft Excel Seminar. The class will teach you how to create and modify worksheets, enter complex formulas, create Pivot tables and Charts, inserting objects, and working with tables. Our small classes allow everyone more time to interact with the instructor, learn faster, and more effectively.

This is a great course for someone looking for a job that requires the use of Excel or to feel more comfortable using the program. This one day course will turn any Excel user into a Power Users.

Benefits to this course:

• Small class.

• 100% hands on training. Every student gets their own computer to follow along.

• Full day of training or 2 evening. 8 hours of total training time.

• Convenient location in Midtown Manhattan. 2 blocks from Penn Station.

• Learn to create simple to advance formulas, from SUM functions to IF, VLOOKUP, HLOOKUP, and nested functions.

• Learn to create a variety of charts and data sets.

• Learn to create PIVOT Tables and Charts.

• Expert instructor with more than 10 years of financial experience using and teaching Excel.

• A free retake if needed

The seminar will include a customize manual with step by step directions and a certificate at the end, showing that you attended the class.

Beware of other companies offering half-day of training with no hands on exercises. People learn by doing the actual exercises, not by watching someone else do it!

Excel Seminar Cost: $139

**Summer Special**

Sign up for both classes the same day and get the Excel Expert class for $99.

Click here to find out about our Expert Level Class.

 

Topics covered:

Lesson 1: Creating a Basic Worksheet

Topic 1A: Explore the User Interface and the Ribbon

Topic 1B: Navigate and Select in Excel

Topic 1C: Obtain Help

Topic 1D: Enter Data and Save a Workbook

Topic 1E: Customize the Quick Access Toolbar
 

Lesson 2: Performing Calculations

Topic 2A: Create Basic Formulas

Topic 2B: Calculate with Functions

Topic 2C: Copy Formulas and Functions
 

Lesson 3: Modifying a Worksheet

Topic 3A: Manipulate Data

Topic 3B: Insert and Delete Cells, Columns, and Rows

Topic 3C: Search for Data in a Worksheet

Topic 3D: Spell Check a Worksheet
 

Lesson 4: Formatting a Worksheet

Topic 4A: Modify Fonts

Topic 4B: Add Borders and Color to Cells

Topic 4C: Change Column Width and Row Height

Topic 4D: Apply Number Formats

Topic 4E: Position Cell Contents

Topic 4F: Apply Cell Styles

 

Lesson 5: Printing Workbook Contents

Topic 5A: Print Workbook Contents Using Default Print Options

Topic 5B: Set Print Options

Topic 5C: Set Page Breaks

 

Lesson 6: Calculating Data with Advanced Formulas

Topic 6A: Manage Cell and Range Names

Topic 6B: Calculate Data Across Worksheets

Topic 6C: Use Specialized Functions

Topic 6D: Analyze Data with Logical and Lookup Functions

 

Lesson 7: Organizing Worksheet and Table Data

Topic 7A: Create and Modify Tables

Topic 7B: Format Tables

Topic 7C: Sort or Filter Worksheet or Table Data

Topic 7D: Calculate Data in a Table or Worksheet
 

Lesson 8: Presenting Data Using Charts

Topic 8A: Create a Chart

Topic 8B: Modify Charts

Topic 8C: Format Charts
 

Lesson 9: Analyzing Data Using PivotTables and PivotCharts

Topic 9A: Create a PivotTable Report

Topic 9B: Analyze Data Using PivotCharts