Class Schedule

About the class

The half-day class is absolutely the fastest and most cost-effective way to become comfortable with Microsoft Excel without spending a fortune on poorly taught classes or wasting time with thick books. Instead of making you take three separate classes or "levels", we combine all the most useful concepts and pack it into one powerful half- day class. When the class is finished, you feel comfortable creating your own spreadsheets, using formulas and functions, and solving common spreadsheet-related problems at work.

This class is perfect for all Excel users including those in finance, accounting, and consulting.

Our method is better

This class is hands-off and strongly encourages student participation. The interaction between the students and the instructor makes the class fun and engaging. We found that most students actually learn faster when they're interacting with the instructor- not wasting time entering data or fumbling with the mouse. We feel that learning should be done in class while practicing should be done on your own time. Why pay to watch other students practice and slow down the class? This method allows us to cover much more material than a traditional class could- in much less time! All students will receive take-home materials including a shortcut sheet and a copy of the lesson files from class.

About the instructor

The class will be taught by Michael Zumchak, an Excel expert with real-world finance industry experience (including years working for a high-profile energy hedge fund and a top 5 investment bank). To show you how confident we are that this will be the best Excel instruction you or your employees have ever had, we're offering a 100% Full Refund if you're not satisfied when it's over.

Curriculum Summary:

Getting Started

• An introduction to Excel and the differences between Excel 2003 and 2007
• Entering and formatting data
• Navigating the program; menus and toolbar shortcuts
• Navigating the worksheet and viewing options
• Copying, pasting, and moving data SAFELY and QUICKLY
• Time-saving keyboard shortcuts that increase working speed
• How to avoid losing your work and making dangerous mistakes
• Planning the structure of the spreadsheet
• Organizing your data for analysis

Formulas, Functions, and Data Analysis

• Learn how to write formulas
• Absolute and relative cell references
• Functions for calculating sums, percentages, and averages
• Logical functions including IF, AND, TRUE, & FALSE
• The powerful VLOOKUP
• Using formulas to perform financial calculations
• How to analyze large data sets by copying simple formulas

Presentation of Data

• How to use PIVOT TABLES.
• Formatting tables and data sets to be aesthetically pleasing
• Creating and editing beautiful graphs (pie charts, bar graphs, and plots)
• How to format your pages to print correctly

*These topics are a rough outline of what will be covered. We will tailor the material to the needs of the class.

Click here or call 646-325-9094 to reserve your seat for $89.

Class Location:
44 E. 32nd St. 11th Floor
New York, New York 10016

Class Schedule