1 / 11

Excel Project One

Learn how to plan and create a spreadsheet in Excel for managing and analyzing Dynamite Music's fourth quarter sales data. This project covers entering and formatting data, using functions and formulas, creating charts, and utilizing Excel's features for saving, printing, and correcting errors.

albertwiseman
Download Presentation

Excel Project One

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 Project One CIS101

  2. What is Excel? • Spreadsheet program with four parts • Worksheets – where you enter, calculate, manipulate, and analyze data • Charts – visual representation of relationships among data • Database – manage data (sort, search, select) • Web support – save in html format, access real time data using web queries

  3. How do you plan a spreadsheet? • Identify the following: • Needs • Source of data • Calculations • Chart requirements

  4. First Excel Project • Dynamite Music Fourth Quarter Sales • Needs: sales report for each product group • Source of data: Chief Financial Officer (CFO) • Calculations: • total sales for each of four product groups • total fourth quarter sales for each of four stores • fourth quarter sales for the company • Chart requirements: 3-D column chart comparing amount of sales for each product group within each store

  5. Start Excel • From start button begin Excel • Remove new workbook task pane • Set up buttons on two rows

  6. The Excel Worksheet • Row (numbered) • Column (lettered) • Cells (A1, C5) • Toolbars (invoke commands and functions)

  7. Selecting a cell • Use mouse to move the block plus sign to the cell and then click • Use arrow keys to select cells • A cell is active when a heavy border surrounds the cell

  8. Start entering text (1.17) • Click cell A1 • A1 becomes the active cell and a heavy border surrounds it • Enter text “Dynamite Music” • Text displays in the formula bar and in A1 • The text in A1 is followed by the insertion point (a blinking vertical line), indicates where the next typed character will display

  9. Continue Project One • Follow the instructions for Project One beginning on page 1.17

  10. Summary of Project One • Enter and format data (text and numbers) • Select a single cell, or use the mouse to select a range of cells • Use auto sum function • Apply auto format to a selection of cells • Name a cell

  11. Summary cont. • Create and embed a chart in a specific location on your worksheet • Use Excel help system • Save, print, and re-open your worksheet • Use the Auto Calculate area • Fix errors and change information

More Related