Instructor:  Robert Marra

FAMILIAR WITH THE WINDOWS ENVIRONMENT 

AN INTRODUCTION TO EXCEL 

THIS COURSE WILL FOCUS ON THE WORKBOOK PORTION OF EXCEL, INCLUDING ENTERING DATA, CALCULATING DATA AND INCREASING THE READABILITY OF THE DATA THROUGH THE USE OF FORMATTING NUMBERS AND TEXT 

OUTLINE OF MATERIAL COVERED INTRODUCTION TO EXCEL · INTRODUCTIONS · COURSE GOALS · STARTING EXCEL · VIEWING THE EXCEL WINDOW · WORKSHEET WINDOW · CELL POINTER · TITLE BAR · MENU BAR · NAME BOX · FORMULA BAR · SHEET TABS · ETC. · WORKING WITH EXCEL MENUS AND DIALOG BOXES · ACTIVATE CELL · FORMAT CELL · ALIGNMENT TAB · WORKING WITH BUTTONS · BOLD · TOOL TIP · ETC. · GETTING HELP · MICROSOFT EXCEL HELP TOPICS · INDEX TAB · ANSWERWIZARD · HELP BUTTON · MOVING AROUND THE WORKSHEET · ARROW KEYS · SCROLL BARS · EDIT · GO TO · CONTROL HOME · NAMING A SHEET · MOVING A SHEET · CLOSING A WORKBOOK AND EXITING EXCEL · CREATING A WORKSHEET · PLANNING A WORKSHEET · ENTERING LABELS · ENTERING VALUES · EDITING CELL ENTRIES · FORMULA BAR · F2 KEY · DOUBLE-CLICK ON CELL · WORKING WITH RANGES · USING THE NAME BOX · USING RANGES TO MOVE AROUND THE WORKBOOK · ENTERING FORMULAS · EQUAL SIGN · EXCEL ARITHMETIC OPERATIONS · ADDITION · SUBTRACTION · MULTIPLICATION · DIVISION · EXPONENT · ORDER OF PRECEDENCE IN EXCEL FORMULAS · CALCULATION OF EXPONENTS · MULTIPLICATION AND DIVISION · ADDITION AND SUBTRACTION · PARENTHESES · USING EXCEL FUNCTIONS · AUTO SUM · FUNCTION WIZARD · PREVIEWING AND PRINTING A WORKBOOK · PRINT PREVIEW BUTTON · ZOOM · PRINT BUTTON · FILE/PRINT · SELECT RANGE/NUMBER OR COPIES/ETC. · MODIFYING A WORKSHEET · INSERTING AND DELETING ROWS · COPYING AND MOVING CELL ENTRIES · BUTTONS · COPY/PASTE · POSITION POINTER TO EDGE OF CELL OR RANGE · W/WO CONTROL KEY AND DRAG · COPYING AND MOVING FORMULAS · BUTTONS · COPY · PASTE · DRAG FILL HANDLE · MENU BAR · EDIT/COPY/PASTE · EDIT/FILL · COPYING FORMULAS WITH ABSOLUTE REFERENCES · ABSOLUTE CELL REFERENCE · $ BEFORE LETTER/NUMBER · F4 KEY WHILE IN EDIT MODE · ADJUSTING COLUMN WIDTHS · POINTER BETWEEN COLUMNS · AUTO FIT · FORMAT/COLUMN WIDTH · COLUMN DRAG · FORMATTING VALUES · CURRENCY BUTTON · COMMA BUTTON · PERCENTAGE BUTTON · INCREASE/DECREASE · FORMAT/CELLS · CHANGING FONTS AND POINTS SIZES · CHANGING ATTRIBUTES AND ALIGNMENT · BOLD · UNDERLINE · ITALIC · CENTER ACROSS COLUMNS · NOTES · GRIDLINES · PRINT · VIEW · BORDERS · AUTOFORMAT · SHADING ·

Date(s)

Time

Location

A Units

Class Limit

AV Needs