Microsoft Excel is the most popular spreadsheet software on the market. We cover all of the functions of Microsoft Excel. We also teach the Microsoft Office Specialist certification for both core and expert exams.

We provide onsite Microsoft Excel class in  in New York City. All Excel  lessons in NYC comes with printed materials that a student can have to practice at home or work.

We can create a customize list of topics to teach for an individual or business.

Here is a list of topics we cover:  

• Enter and edit cell content

• Locate specific cell content

• Locate, select, and insert supporting information

• Insert, position, and size graphics

• Filter lists using the AutoFilter feature

• Sort lists

• Insert and modify formulas

• Use statistical, date and time, financial, and logical functions

• Create, modify, and position diagrams and charts based on worksheet data

• Apply and modify cell formats

• Apply and modify cell styles

• Modify row and column formats

• Format worksheets

• Create new workbooks from templates

• Insert, delete, and move cells

• Create and modify hyperlinks

• Organize worksheets

• Preview data in other views

• Customize window layout

• Setup pages for printing

• Print data

• Organize workbooks using file folders

• Save data in appropriate formats for different uses

• Use subtotals

• Define and apply advanced filters

• Group and outline data

• Use data validation

• Create and modify list ranges

• Add, show, close, edit, merge, and summarize scenarios

• Perform data analysis using automated tools

• Create PivotTable and PivotChart reports

• Use Lookup and Reference functions

• Use Database functions

• Trace formula precedents, dependents, and errors

• Locate invalid data and formulas

• Watch and evaluate formulas

• Define, modify, and use named ranges

• Structure workbooks using XML

• Create and modify custom data formats

• Use conditional formatting

• Format and resize graphics

• Format charts and diagrams

• Protect cells, worksheets, and workbooks

• Apply workbook security settings

• Share workbooks

• Merge workbooks

• Track, accept, and reject changes to workbooks

• Import data to Excel

• Export data from Excel

• Publish and edit Web worksheets and workbooks

• Create and edit templates

• Consolidate data

• Define and modify workbook properties

All Microsoft Excel training in NYC is a 100% hands on class, where every student will have labs and step by step procedures.