Advanced Topics in Excel

Mobile

Course: Advanced Topics in Microsoft Excel

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

 

Start Date: May 13
Fee: $275.00
Number of Sessions: 1
Course Location: 1 Martine Avenue, White Plains

Course #90711

 

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.

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

Course Outline for Advanced Topic 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