This one day course, for experienced users of Excel, will teach you to use many of its advanced features, including advanced statistical and financial functions, 3-D formulas, pivot tables and more.
Using Excel at this level of sophistication will set your skills apart from those of less advanced users, and make you more valuable at your job.
Date: May 14, 2015
Location: 551 Fifth Ave. 8th Floor, New York, NY 10038
Course Number: 90711
This course is ideal for persons with a mastery of basic Excel data entry, formatting, copying, and windowing skills who want to further enhance their ability to use Excel efficiently. This class is designed to get to the bottom line faster with the use of PivotTables, functions, absolute and mixed cell references, and multi-sheet calculations. Learn how to combine sheets into a single workbook, use group editing to make consistent changes to multiple sheets in a workbook, create external references, transpose cells, and use Paste Special to paste and calculate in the same step. Increase your power level within Excel with these procedures.
Type of Cell Addressing
Absolute Cell Addressing
Mixed Cell Add
Determining the Type of Cell Address
Using Paste Special to Calculate New Values
Replacing a value with Its Calculated Value
The Lookup Functions
Logical Functions The ISERROR() Functions and Nesting
Date and Time Function
Creating a PivotTable
Creating a PivotChart