Advanced Topics in Excel

Advanced Topics in Microsoft Excel

Mobile

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.

Course Details
icon iPhone

 

Date: August 19, 2014

Days: 1

Fee: $275.00

Location: 551 Fifth Ave. 8th Floor, New York, NY 10038

Course Number: 90711

Date: December 9, 2014

Days: 1

Fee: $275.00

Location: 551 Fifth Ave. 8th Floor, New York, NY 10038

Course Number: 90540

icon

Course Description

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.

Click for Detailed Course Description

icon

You Will Learn To

  • Combine sheets into a single workbook
  • Use group editing to make consistent changes to all sheets in a workbook
  • Use linking, 3-D formulas, consolidation and Paste Special to work with multiple related sheets or workbooks
  • Use absolute and mixed cell addressing in formulas
  • Be aware of the statistical, financial, mathematical, lookup, logical, text, and date & time functions
  • Use PivotTables to reorganize a list of data into a table of data
icon

Who Should Enroll

Persons with mastery of basic Excel data entry, formatting, copying, and windowing skills who want to further enhance their ability to use Excel efficiently.

Prerequisite: Introduction to Excel or working knowledge of MS Excel.

icon

Course Format

One Day Class (9am- 4pm); offered Monday-Friday; Instructor-led.
COST: $275
CPE- 6 CREDIT HOURS

icon

Questions?

Please contact us at (888) 561-7223 or continuinged@pace.edu

Outline for Advanced Topics in Microsoft Excel

3-D FORMULAS AND EXTERNAL REFERENCES
Starting settings
Multiple Sheets
3-D Formulas
External References
Updating Links

CELL ADDRESSING
Type of Cell Addressing
Absolute Cell Adressing
Mixed Cell Add
Determining the Type of Cell Address

PASTE SPECIAL
Paste Special
Using Paste Special to Calculate New Values
Transpose
Replacing a value with Its Calculated Value


USING FUNCTIONS
Function Overview
Statistical Functions
Financial Functions
Mathematical Functions
Names
The Lookup Functions
Logical Functions The ISERROR() Functions and Nesting
Text Functions
Date and Time Function

PIVOT TABLES
Creating a PivotTable
Slicers
Creating a PivotChart


 

Other Courses That May Interest You

icon

Access

  icon

Excel

icon

Microsoft Project

  icon

Outlook

icon

PowerPoint

 

Word