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.
Related Books

One Response to “Excel 2003 Formatting Tutorial”

  1. kettlebell workouts pdf on October 22nd, 2014 at 3:21 pm

    I’d like to thank you for the efforts yyou have pput in penning this blog.
    Ireally hope to view the same high-grade blog posts by you
    in the future as well. In fact, your creative writing abilities has motivated me to get my own, personal webvsite noow ;)

Leave a Reply