Lecture 1

1. Lecture 1 Introduction toExcel 2010

2. OVERVIEW • Introduction • Basics of Cells • Modifying Columns and Rows • Formatting Cells • Saving • Working with Formulas • Basics of Worksheets • Printing

3. INTRODUCTION • Excel is a spreadsheet program that allows you to store, organize, manipulate, and analyze information. • A spreadsheet is a grid that organizes data into columns and rows. • Excel is a component ofMicroSoft Office suite and is the world's most popular information management tool

4. Introduction • Widely and increasingly used by Engineers to design complex systems and manage large datasets

5. Getting Started • An Excel file is called a workbook • Open Excel and create a new blank workbook • Start - All Programs - Microsoft Excel 2010 • Or use a shortcut on your Desktop

6. Create New Workbook

7. Open Existing Workbook • From File, Select Open • Navigate to the file location

8. Open Existing Workbook • Alternately click on recently opened workbook

9. Excel Environment

10. BASICS OF CELLS • Cells are the basic building blocks of a worksheet. • Cells can contain a variety of content such as text, formatting attributes, formulas, and functions.

11. Cell Address • Exceladdresses each cell on the worksheet • Users may use their own cell names if the so choose by typing in the Name Box

12. Selecting Cell(s) • Click on any cell to select it • You can also navigate through your worksheet and select a cell by using the arrow keys on your keyboard • Note that the Name Box updates itself to show address of cell location

13. Selecting Cell(s) • To select multiple cells, Click and drag your mouse until all of the adjoining cells you want are highlighted • Release your mouse.

14. Cell Contents • Data that can be entered into a cell include: • Text • Formatting • Comments • Formulas • Functions

15. Adding Cell Content • Click on a cell to select it • Type into the cell or type into the Formula Bar

16. Deleting Cell Contents • Select the cell(s) whose contents you would like to delete • On your keyboard hit Delete or Backspace • Or use the Clear icon

17. Deleting Cells • Deleting cell contents leaves the original addresses intact • Deleting cells results in the worksheet rows/ columns shifting to replace the deleted cell(s)

18. Copy and Paste Cell Content

19. Cut and Paste Cell Content

20. Other Paste Options By right clicking on cell

21. Moving Cells

22. Using Fill Handle • This is another way to copy and paste cell content

23. MODIFYING COLUMNS AND ROWS • To modify column width

24. Column Width By Measurement

25. Column Width By Autofit

26. Modifying Row Height

27. Row Height By Measurement

28. Row Height By Autofit

29. Inserting Rows

30. Inserting Columns

31. Deleting Rows

32. Deleting Columns

33. Wrapping Text • If a cell contains more text than can be displayed, Wrap text will make it display on multiple lines in that cell

34. Wrap Text

35. Merging Cells • If a cell contains more text than can be displayed, Merge cells will combine adjoining cells into one larger cell

36. Merging Cells

37. FORMATTING CELLS • Changing the font • Select the cells that you want to change the font

38. Font Size • Select the cells that you want to change the font size

39. Font Size • You may also Grow Font or Shrink Font to change the size

40. Bold, Italic, and Underline Commands

41. Cell Borders • Select the cells you want to modify

42. Font Color

43. Fill Color

44. Horizontal Text Alignment

45. Vertical Text Alignment

46. Text Orientation

47. Formatting Numbers • Excel enables numbers to be formatted in a wide variety of ways

48. Formatting Numbers • An alternate way to get to the Number Format as well as other formatting tools

49. SAVING • Using the Save As Command to save your workbook as Excel, previous Excelversion, pdf, and other formats

50. Save As Excel 97 - 2003