Search

Event Guide
Advanced Excel 2003
Event Date: 2010-03-23

Advanced Excel 2003

Date: 23rd March

Location: Boston Scientific

Price:  €80 Per Person

Course Prerequisites

You MUST be able to do the following intermediate level items before attending this course:  Create, Understand and Use, Absolute cell referencing, i.e. dollar symbols in cell references ($A$1).  Create and Manage NAMES - Name a cell or range of cells and use names in formulae instead of cell referencing. You will be required to do the above items from the very start of the course.  Create Graphs & Charts  Sort columns of data;  Use Filters. All the items listed above are covered at Intermediate level and will not be covered in this course. N.B. This course DOES NOT cover VBA (Visual Basic for Applications) or Advanced Macros Module Creating or Editing. 

 

 

 

 

 

 

 

 

 

 

 

 

This level of Excel starts by introducing some of the more advanced functions within Excel for managing database material. It will then cover many of the advanced features. This course will give a fuller understanding of "Why" functions work rather than just "How" to perform them and will prepare you for continued learning of Excel. Please ensure you meet the course Pre-requisites before attending this course. The course will specifically cover the following areas:

o

Field Settings.

o

Pivot Tables.

Creating Formulas in

o

Rearranging and filtering Pivot Tables.

o

Grouping data in Pivot Tables.

o

 Protect a document.

 Creating and understanding basic Macros.

 How to Nest one function within another function.

 Dealing with error messages in formulas.

 Use the following Excel functions:

Creating Pivot Charts.

o

VLOOKUP

o

IF, IF AND (IF OR)

o

SUMIF, COUNTIF

o

DMIN, DMAX, DSUM, DCOUNT

o

ISNA, ISERR, ISERROR

 Importing text delimited files (CSV or Tab delimited).

 Consolidating (linking) data from different worksheets.

 Use data validation to force compliance with input standards.

 Auditing formulas tracing Dependents and Precedents.

 Use subtotals.

 Creating scenarios.

 Creating data input tables.

 Converting lists into Tables.

 Using Goal Seek.

 Create and use a Pivot Table.


« Back to All Events

About Clonmel

About Us

Contact Us

Initiatives

Join Us

Membership

Skillnet

Style Clonmel

Clonmel Chamber of Commerce, 8 Sarsfield Street, Clonmel, Co. Tipperary
Tel :+353 (0)52 6126500
Site Design and CMS by Systech, Clonmel