EXCEL XP FUNDAMENTALS

COURSE OUTLINE

 

SECTION 1 - INTRODUCTION

·        ·        STARTING EXCEL

·        ·        THE APPLICATION WINDOW

·        ·        WORKING WITH MENUS

·        ·        WORKING WITH TOOLBARS

·        ·        THE WORKBOOK WINDOW

·        ·        SELECTING AREAS WITHIN A SHEET

SECTION 2 - CREATING WORKBOOKS AND ENTERING DATA

·        ·        ENTERING DATA INTO A CELL

·        ·        AUTOCOMPLETE

·        ·        EDITING A CELL

·        ·        CLOSING A WORKBOOK

·        ·        STARTING A NEW WORKBOOK

·        ·        AUTO CALCULATE

·        ·        BUILT-IN FUNCTIONS

·        ·        WORKING WITH INSERT FUNCTION

·        ·        USING THE RANGE FINDER

·        ·        SAVING A WORKBOOK

·        ·        OPENING A WORKBOOK

SECTION 3 - EDITING AND FORMATTING THE WORKBOOK

·        ·        USING FILL COMMANDS

·        ·        COPYING AND PASTING CELLS

·        ·        ABOUT COLLECTING AND PASTING MULTIPLE ITEMS

·        ·        COLLECTING AND PASTING MULTIPLE ITEMS

·        ·        PASTING SPECIFIC ITEMS FROM THE OFFICE CLIPBOARD

·        ·        INSERTING ROWS AND COLUMNS

·        ·        DELETING ROWS/COLUMNS

·        ·        AUTOFILL

·        ·        MOVING ENTRIES

·        ·        CLEARING CELLS

·        ·        UNDO/REDO

·        ·        FORMATTING A WORKBOOK

·        ·        FORMATTING NUMBERS

·        ·        COLUMN WIDTHS

·        ·        FONTS & FONT STYLES

·        ·        USING BORDERS

·        ·        USING PATTERNS

SECTION 4 - ABSOLUTE REFERENCING

·        ·        ABSOLUTE VS. RELATIVE REFERENCING

SECTION 5 - PRINTING

·        ·        PRINTING IN EXCEL

·        ·        PRINT SETTINGS

·        ·        PAGE SETUP DIALOG BOX

·        ·        PREVIEWING THE PRINTOUT

·        ·        HEADERS AND FOOTERS

·        ·        SETTING PRINT TITLES & PRINT AREAS

·        ·        PAGE BREAK PREVIEW

SECTION 6 - CHARTING WITH CHARTWIZARD

·        ·        CHARTWIZARD

·        ·        DIALOG BOX COMMAND BUTTONS

·        ·        MODIFYING THE CHART

 

Course Length: 1 day

Prerequisites: Microsoft Windows

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EXCEL XP INTERMEDIATE

COURSE OUTLINE

 

SECTION 1 – USING WORKBOOKS

·        ·        WORKBOOK OVERVIEW

SECTION 2- LINKING & CONSOLIDATING

·        ·        WORKING WITH FORMULAS THAT LINK WORKSHEETS AND FILES

·        ·        CONSOLIDATING DATA FROM VARIOUS WORKSHEETS

SECTION 3 – USING EXCEL AS A DATABASE

·        ·        DATABASE OVERVIEW

·        ·        RULES FOR DESIGNING A DATABASE

SECTION 4 – SORTING AND SUBTOTALING

·        ·        SORTING A WORKSHEET DATABASE

·        ·        SORTING BY COLUMNS

·        ·        CREATING CUSTOM SORT ORDERS

·        ·        PRODUCING SUBTOTALS ON A SORTED LIST

SECTION 5 – USING FILTERS AND CRITERIA

·        ·        USING AUTOFILTER

·        ·        PLACING TOTALS BELOW A FILTERED LIST

·        ·        SETTING A CUSTOM AUTOFILTER

·        ·        USING THE TOP TEN AUTOFILTER

·        ·        WORKING WITH CRITERIA RANGES

SECTION 6 - USING A DATA FORM

·        ·        DATA FORMS

·        ·        SEARCHING FOR RECORDS IN A DATA FORM

SECTION 7 – CHARTING

·        ·        CREATING A CHART

·        ·        CHARTING ASSUMPTIONS

·        ·        MODIFYING THE CHART

·        ·        WORKING WITH SERIES-RELATED OPTIONS

·        ·        CHANGING SERIES ORIENTATION FROM ROWS TO COLUMNS

·        ·        CHANGING THE DATA SERIES ORDER

·        ·        ENHANCING THE CHART

·        ·        UPDATING A CHART’S DATA SERIES

·        ·        USER-DEFINED CUSTOM TYPES

·        ·        PRINTING CHARTS

 

EXCEL XP 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