EXCEL 2000 ADVANCED

COURSE OUTLINE

SECTION 1 – ADVANCED WORKSHEET SETUP

· WORKING WITH NAMED RANGES

· VALIDATING ENTRIES IN A CELL

· DOCUMENTING YOUR WORKBOOK WITH COMMENTS

· FLAGGING ENTRIES WITH CONDITIONAL FORMATTING

SECTION 2 – ADVANCED CALCULATION TECHNIQUES

· FUNCTION OVERVIEW

· PLACING FUNCTIONS ON THE WORKSHEET

· UTILIZING MORE ADVANCED FUNCTIONS

SECTION 3 – TROUBLESHOOTING FORMULAS

· WORKING WITH RANGE FINDER

· USING FORMULA AUDITING TOOLS

SECTION 4 – WORKING WITH PIVOTTABLES

· PIVOT TABLES

· PIVOT CHARTS

· MODIFYING THE DATA DISPLAYED IN A PIVOT CHART REPORT

SECTION 5 – FORECASTING WITH EXCEL

· WORKING WITH SCENARIOS

· USING THE GOAL SEEK TOOL

· WORKING WITH THE SOLVER

SECTION 6 – AN INTRODUCTION TO MACROS

· OVERVIEW OF MACROS

· PLANNING AND REHEARSING THE MACRO

· RECORDING A MACRO

· RUNNING THE MACROS

· CHANGING A MACRO’S OPTIONS

· APPENDIX – IMPORTING DATA FROM OUTSIDE EXCEL

· OVERVIEW OF TEXT FILES

· IMPORTING A TEXT FILE

· PARSING TEXT TO MULTIPLE COLUMNS

Course Length: 1 day

Prerequisites: Excel 2000 Intermediate