Excel-I-2002 Tutorial

This tutorial was adapted from a tutorial by see its complete version at http://www.fgcu.edu/support/office2000/excel/index.html http://webfaculty.aub.edu.lb/~acc Excel 2002 – Tutorial I Spreadsheet Basics • Format Painter • AutoFormat • Screen Elements • Title bar Formulas and Functions • Menu bar • Standard toolbar • Formulas • Formatting toolbar • Linking Worksheets • Drawing toolbar • Relative, Absolute, and Mixed • Scroll bars. Referencing • Task Pane • Basic Functions • Autosum Modifying Worksheets Sorting and Filling • Moving Through Cells • Adding Worksheets, Rows, • Basic Sorts Columns, and Cells • Complex Sorts • Resizing Rows and Columns • Autofill • Selecting Cells • Moving and Copying Cells Page Properties and Printings • Deleting Rows, Columns, and Cells • Page Breaks • Freeze Panes • Page Setup • Margins Formatting Cells • Header/Footer • Sheet • Formatting Toolbar • Print Preview • Format Cells Dialog Box • Print • Formatting Worksheet • Dates and Times Academic Computing Center - AUB Excel 2002 - Tutorial I http://webfaculty.aub.edu.lb/~acc Spreadsheet Basics Excel is a spreadsheet program you can use to organize, analyze and attractively present data such as a budget or sales report. Each Excel file is a workbook that can hold many worksheets. The worksheet is a grid of columns (designated by letters) and rows (designated by numbers). The letters and numbers of the columns and rows ...