Excel 2003 Formatting Tutorial

EXCEL 2003 FORMATTING. WORKSHOP DESCRIPTION. Apply Conditional formatting to worksheets. Learn how to create a template, apply the necessary formatting and then save it for future use. Understand use of Formula’s and Functions Learn how to create Charts Work with Mail Merge & Create meaningful lists.

More PDF Content

Excel 2003 Formatting Tutorial
Conditional Formatting …3 Apply Conditional Formatting …3 Conditional Formatting Formulas …4 Formatting Styles …5 Templates …6 Creating a new template: …6 Exercise # 1 …7 Formulas …8 Precedence of Operators …8 Cell Referencing…9 References to worksheets in the same workbook …10 References to worksheets in other workbooks …10 Functions…11 Entering functions manually …11 Entering functions using the Function Wizard …12 Exercise # 2 …13 Charts…14 Creating a new Chart …15 Step 1: Choosing a Chart Type …15 Step 2: Specifying the Data to Plot…16 Step 3: Choosing Chart Options…17 Step 4: Telling Excel Where to Put Your Chart …18 Exercise # 3 …19 Mail-Merge Data to Word …20 Lists …21 Sorting …22 Entering data into a list …23 Auto Filter …24 Designated Lists …25 Exercise # 4 …26

Download Excel 2003 Formatting Tutorial pdf from www.csus.edu, 26 pages, 1088.82KB.