1 / 63

Microsoft Excel

Learn the basics of Microsoft Excel, a powerful spreadsheet program that allows users to organize data, perform calculations, make decisions, and create graphs. Understand how to create worksheets, enter data, format cells, and create embedded charts.

franka
Download Presentation

Microsoft Excel

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. Microsoft Excel Creating a Worksheet and an Embedded Chart

  2. Microsoft Excel • Spreadsheet program in Microsoft Office

  3. What is Excel? • A powerful spreadsheet program that lets users to organize data, complete calculations, make decisions, graph data.

  4. Why Learn Excel? • The main purpose of a spreadsheet is to solve problems that involve numbers? • Spreadsheets have many uses. • Calculating grades • Prepare a budget for several months • Determine payments for repaying a loan.

  5. The 4 major parts of Excel • Workbooks and Worksheets • Charts • Tables • Web support

  6. Worksheets • In Excel, a computerized spreadsheet is called a worksheet. • The file used to store worksheets is called a Workbook.

  7. When Excel Starts… • It creates a new blank workbook called Book1

  8. Workbook • Is like a notebook. • It is made up of column and rows • Data is put in the cells of the workbook.

  9. Worksheet • Spreadsheets inside the workbook. • Excel opens a new workbook with 3 sheets. • You can add additional worksheets as long as your computer has enough memory to accommodate them.

  10. Active Worksheet • The worksheet that is displayed in the work area.

  11. Sheet Tab • Each worksheet has a sheet name that is on a sheet tab. • Located at the bottom of the workbook.

  12. The Worksheet Explained • Organized into a rectangular grid containing vertical columns and horizontal rows.

  13. Excel Window Labeled.

  14. Rows and Columns ID • Column heading identified by a letter above the grid. • Row heading is identified by a row number on the left side of the grid.

  15. What is a Cell? • The intersection of each column and row • A cell is a basic unit of a worksheet in which you enter data. • Each worksheet has 16,384 columns, 1,048,576 rows for a total of 17,179,869,180 cells.

  16. Cell Reference • A cell is referred to by its unique address • To identify a cell, specify the column letter first, followed by the row number.

  17. Active Cell • The one cell into which you can enter data. • Active cell identified in 3 ways: • A heavy border surrounds the cell • Cell reference shows above column A in the Name box. • The column heading and row heading are highlighted.

  18. Identifying an Active Cell

  19. Gridlines • The horizontal and vertical lines on the worksheet itself. • Gridlines make it easier to see and ID each cell in the worksheet. • They can be turned off, but best to leave them on.

  20. Worksheet Window

  21. Worksheet Window • You view the portion of the worksheet displayed on the screen through a worksheet window. • Use the scroll bars, scroll arrows, and scroll boxes to move the worksheet around.

  22. Status Bar

  23. Status Bar • Presents info about: • the worksheet, • the function of the button the mouse pointer is pointing to • or the mode of Excel.

  24. THE RIBBON

  25. The Ribbon • The control center in Excel • Provides easy, central access to the tasks you perform while creating a worksheet. • The ribbon has: • Tabs, groups, and commands. • Each tab surrounds a collection of groups • Each group contains related commands.

  26. More on the Ribbon • Has seven top-level tabs: • Home, Insert, Page, Layout, Formulas, Data, Review and View.

  27. Home Tab

  28. Home Tab is.. • Called the Primary tab • Contains groups with the more frequently used commands. • The active tab is the tab currently displayed.

  29. Dialog box Launcher • When click displays a dialog box or a task pane.

  30. Dialog Box • Contains additional commands and options for the group.

  31. Task Pane • Is a window that has more commands and can stay open while you work on the worksheet.

  32. Formula Bar • Appears below the Ribbon • You can make bigger by dragging the sizing handle or clicking the expand button.

  33. The Excel Window

  34. Selecting a Cell • To enter data into a cell, you first must select it. • Easiest way to select a cell (make it active) is to use the mouse and click. • Use the arrow keys to move around the spreadsheet.

  35. Entering Text • In Excel, any set of characters containing a letter, hyphen (as in a phone number) or space is considered text. • Text is used to: • Place worksheet titles, column titles, and row titles on the worksheet.

  36. Alignment of Text • Excel left-aligns text in a cell. • Left-aligned means the cell entry is positioned at the far left in the cell. • When text is longer than the width of a column, Excel shows the overflow characters in adjacent cells to the right as long as these adjacent cells contain no data.

  37. Correcting Mistakes While Typing • If you type the wrong letter, and see it before you hit ENTER, use the BACKSPACE key to delete characters.

  38. Level 2--Packet • Formulas, Functions, Formatting and Web Queries

  39. Entering Numbers • You can enter numbers into cells to represent amounts. • A number can contain only: • 0 1 2 3 4 5 6 7 8 9 . + , - ( ) / $ % E e • If a cell entry contains any other keyboard character (including spaces) Excel interprets it as text and treats it accordingly.

  40. Formula • Equation that performs a calculation. • Function is a preset formula. • Every formula begins with an = • Formula includes: • Equal sign = • Values or cell references • Operator (* + - /

  41. Automatic Recalculation • Every time you enter a value into a cell in the worksheet, Excel automatically recalculates all formulas.

  42. Enter a Formula using Keyboard • = • Manually type in formulas such as =d4*c4 • Use the FILL HANDLE to copy the formula to adjacent cells.

  43. Fill Handle

  44. Point Mode • An alternative to entering the formulas in cells • Use the mouse to point and select cells for use in a formula. • Even with Point Mode you must type the = and the operator (* + -, etc.)

  45. When should I use Point Mode to Enter Formulas? • Using Point mode to enter formulas often is faster and more accurate than using the keyboard.

  46. Fill Handle • A small rectangle in the lower-right corner of the active cell or active range.

  47. Range Finder • Easy way to verify that a formula references the cells you want it to reference. • Use to check which cells are referenced in the formula assigned to the active cell. • Allows you to make immediate changes to cells referenced in a formula.

  48. Formatting Numbers Using the Ribbon

  49. Accounting Number Format • To add a dollar sign to a number, you should use the Accounting number format. • Shows a dollar sign to the left of the number, inserts a comma every three places to the left of the decimal point • Displays numbers to the nearest cent.

More Related