1 / 30

Day 1: Getting Started with Microsoft Excel 2010

Learn the basics of creating, editing, and organizing data in Microsoft Excel 2010. This introductory course covers essential functions such as creating workbooks, modifying rows and columns, and entering data. Join us for Day 1 of the Ministry of Education Capacity Development Center's Excel training.

dboese
Télécharger la présentation

Day 1: Getting Started with Microsoft Excel 2010

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. Ministryof EducationCapacity Development Center Day 1: Getting Started with Microsoft Excel 2010 Dr. Aye SandarMyintAssistant Director CDC-4

  2. Microsoft Excel • Creating and editing spreadsheets • Unlike Microsoft Word, the Excel documents consist of columns and rows of data, made up of individual cells-like a big table • Use for storing, organizing and manipulating data • Eg. a monthly budget, track business expenses, or sort and organize large amounts of data • Due to its extreme versatility and power, Excel has become one of the most-used software programs • Click : All Programs ->Microsoft Office ->Microsoft Excel 2010 CDC-4

  3. Creating Workbooks • Click : File Tab-> New-> Blank Workbook • Choose Create CDC-4

  4. Creating a New Worksheet • Workbook has three worksheets • Excel’s main screen is called a worksheet. • Each worksheet is comprised of many boxes, called cells. CDC-4

  5. Add, Rename, Move and Copy Sheet • Right Click Sheet tab that you want to change • Can insert, delete, rename, move, copy the existing sheet CDC-4

  6. Move Sheets by Dragging • ClickSheet tab • Drag first sheet and release at last sheet tab CDC-4

  7. Move or Copy Sheet at New Workbook • Right Click at My Sheet and Choose Move or Copy • Select My Sheet at Copy Dialog Box • Click Create a copy check box • Choose (new book) at To book text box • Click OK CDC-4

  8. Coloring a Worksheet Tab • Right Click Sheet tab • Select Tab color and choose any color CDC-4

  9. Modifying Row and Column CDC-4

  10. Make a column wider Drag column separator to the right • To make Column B wider, point the cursor to the column separator between columns B and column C. • The cursor changes to a “Double headed arrow”. • Click the left mouse button and without letting go of the button, drag the separator to the right to make the column wider Column is now wider CDC-4

  11. Getting the Exact Width Double click here • To get the “exact” width, double click on the separator instead of dragging it. Column is now EXACTLY the correct width CDC-4

  12. Resizing a Row • Make a row taller or shorter by dragging the separator between the rows. • Click and drag here to resize row 5. Row is now taller CDC-4

  13. Draw Borders and change Color of gridlines CDC-4

  14. Working with Data CDC-4

  15. Entering Data • When enter data in a cell, data appears at Formula bar and cell name appears at Name box • Press Enter, selection down cell • Press Tab, selection right cell • Alt + Enter, new line at only cell CDC-4

  16. Selecting a Cell • “Select” a cell by clicking on it once (don’t double click). • Can move from cell to cell with the arrow keys or by pressing the “Enter” key. CDC-4

  17. Double Click to Modify a Cell • To modify the contents of a cell double click on the cell. • Use the right, left arrow keys and the Insert and Delete keys to modify the data. Double click to change “hi there” to “hello there” CDC-4

  18. The columns of the worksheet are named with letters The rows are named with numbers Column Names & Row Names Selected Cell CDC-4

  19. The name of a cell is a combination of the Letter Of The Column that the cell is in followed by the Number Of The Row that the cell is in. Example: B4 (NOT 4B) Excel automatically shows the name of the currently selected cell in the “name box” Cell Names (ex. B4) Name Box Selected Cell CDC-4

  20. Enter Text or a Number in a Cell CDC-4

  21. Enter a Date or a Time in a Cell • Use Slash mark (/), hypen (-) for date • 7/19/2017 or 19-July-2017 • Ctrl+; -> Current Date • Ctrl+ Shift+; -> Current Time • =TODAY() • =NOW() CDC-4

  22. Formatting cells with Dates and Times • Right click on the cell and choose “Format Cells” • From the “Category” list in the “Number” tab either • Choose “Date”, “Time” or “Custom” and choose an appropriate looking format CDC-4

  23. Change the Format of a Number • Click: Home->Number Group->Dialog box launcher->Number Tab CDC-4

  24. Custom Format • To display text in a cell, use “” • These characters are displayed without the use of quotation marks: $, +, (, :, ^, ’, {, <, =, -, /, ), !, &, ~, }, > • To format fractions or numbers that contain decimal points, use 0 (zero), #, ? and . •  To specify the color for a section of the format, type the name of colors enclosed in square brackets [] in the section. CDC-4

  25. Example Type the format $0.00 " Surplus";$-0.00" Shortage“[red] at custom format125.74 ->"$125.74 Surplus" -125.74 ->"$-125.74 Shortage." CDC-4

  26. CDC-4

  27. CDC-4

  28. CDC-4

  29. Assignment 1 • Create New Work Book , Assignment 1 worksheet • Enter text • Enter number, date, time with related data format and validation • Modify font and gridlines with color and cell format CDC-4

  30. CDC-4

More Related