1 / 11

Excel Starts to SHINE

This guide provides essential considerations for designing effective worksheets in Microsoft Excel 2003. Learn how to determine the purpose of your worksheet, create meaningful titles, and identify desired outputs. Discover the importance of labels for data readability and how to format values for various calculations. Get tips on using relative and absolute cell referencing in formulas, and understand how to apply BEDMAS rules in calculations. Additionally, explore common functions such as SUM, MIN, MAX, and others to enhance your spreadsheet skills.

banyan
Télécharger la présentation

Excel Starts to SHINE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Starts to SHINE Microsoft Office 2003 Info copied from Microsoft Help Files

  2. Planning & Designing a Worksheet Considerations • Determine the purpose • Give it a meaningful title • Determine the end result/output • Determine calculations • Sketch on paper • Format columns and rows Info copied from Microsoft Help Files

  3. Labels • Help you identify the data – making it more readable • Labels can contain text and numerical information not used in calculations • Labels are left aligned by default • TIP: If you want to create a label that starts with a number; type an apostrophe before typing the number Info copied from Microsoft Help Files

  4. Values • Are used for calculations • They include numbers, formulas and functions • Right aligned by default • To see true values; press the ctrl key and the ~ (key in the top left corner above the tab key) Info copied from Microsoft Help Files

  5. Values can be formatted as: • Number type • Currency type • Accounting type • Date type • Percentage type …. Info copied from Microsoft Help Files

  6. Cell Referencing in calculations • Relative reference in a formula, such as A1, is based on the relative position of the cell. example of a calculation using relative referencing = a1 + b1 • Look to see what happens if you use the autofill feature with a relative reference. Info copied from Microsoft Help Files

  7. Cell Referencing in calculations • Absolute cell reference in a formula, such as $A$1, always refers to a cell in a specific location • It will not change when using the autofill feature • Click F4 after selecting the cell that you want to use absolute cell reference; Excel will change the syntax for you Info copied from Microsoft Help Files

  8. When creating a calculation, be mindfull of BEDMAS • Brackets • Exponents • Division • Multiplication • Addition • Subtraction Some information has been copied from Microsoft Help Files

  9. Math Operators in Excel Info copied from Microsoft Help Files

  10. More on Calculations • Operations can be combined together. For example: =A1-A2/A3 OR =(A1+B1)*.50 Some information has been copied from Microsoft Help Files

  11. Common Functions • Sum() • Min() • Max() • Average() • Today() Some information has been copied from Microsoft Help Files

More Related