1 / 6

Excel 2003 Fundamentals: Key Concepts and Techniques for Effective Data Management

This guide covers essential Excel 2003 fundamentals, including maximizing data value with the MAX function, creating various chart types like bar and pie charts, and using COUNTIF for conditional counting. Learn how to transpose data between rows and columns, edit cell contents, and rename worksheets. Explore data import from external sources, advanced filtering techniques, and formatting options such as text wrapping and background filling. Improve your spreadsheet skills and efficiency with these fundamental concepts.

malory
Télécharger la présentation

Excel 2003 Fundamentals: Key Concepts and Techniques for Effective Data Management

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 2003 Fundamentals Brainbench2 Notes Mr. Martin Fundamentals of Admin Tech

  2. Info • MAX returns the largest value in a set of values; ignores logical values and text • A Bar chart has horizontal bars • XY (Scatter) chart has many points, but no connecting lines • =COUNTIF(range, criteria) shows the correct syntax for the COUNTIF() function • You can change the data from a column to a row by using Transpose • #10 shows an Organizational Diagram

  3. Info • You can change the background of a chart area to a picture by using Fill Effects • SUM adds all numbers in a range of cells • Double-clicking in a cell allows you to edit the contents directly in the cell • You can rename a worksheet by doing the following: Select Format>Sheet>Rename • You can import data into Excel from an external source by doing the following: Click Data>Import External Data>Import Data. Choose the data you want to import in the Select Data Source dialog box

  4. Info • You can adjust the worksheet to always display Column A, Row 2 by Placing the cell pointer in A2 and selecting Window>Freeze Panes • Wrap Text allows you to control the behavior of text • LOWER converts all uppercase letters in a text string to lowercase • You can filter data and place the results in another location by doing the following: Select Data>Filter>Advanced Filter>Copy to another location

  5. Info • For # 21, 5 appears in A5 after pressing the ENTER key • If you get #### for an answer after entering a formula that calculates numbers, the column width is too narrow to display the formula results • A Pie chart displays a circle cut into multiple pieces • The following toolbar button allows you to indent the contents of a cell:

  6. Info • The red arrow in the following image is pointing to Insert Hyperlink: • 18 will be displayed in cell D1 in the following image after you press enter:

More Related