Share this Page URL

Part 3. Using Excel - Pg. 212

212 Chapter 3. Using Excel The second most popular program included in the Office suite is Excel. Excel is an excellent tool for keeping track of data and crunching numbers. With Excel, you can create worksheets to add up sales for your department or to track your personal expenses. You can use Excel to set up a budget or to create an invoice. You can even use Excel as a simple database program. With Excel, you can perform any kind of mathematical calculation, from the simplest to the most complex, and or- ganize data so that it becomes meaningful and useful. When you start Excel, the screen presents some familiar elements, such as a menu bar, toolbars, the status bar, and scrollbars. You'll also see some unfamiliar elements, such as the Formula bar, which allows you to view and edit data. The work area is divided into a grid called a worksheet -- initially, there are three worksheets in a workbook (which is the term for an Excel file). You organize data within this grid. In the tasks in this part, you learn how to enter and format data, add and delete rows and columns, and enter formulas. In addition, you'll learn some of Excel's more advanced features, such as sorting and filtering data and creating charts. Task 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. How to Enter and Edit Cell Data How to Navigate Worksheets How to Select Cells How to Use AutoFill How to Move and Copy Data How to Insert and Delete Columns and Rows How to Remove Data or Cells How to Set the Column Width and Row Height How to Define a Range Name How to Find and Replace Data How to Sort Data How to Filter Data How to Work with Worksheets How to Create Formulas How to Use AutoSum How to Enter Functions How to Use Absolute and Relative Cell Addresses How to Fix Formula Errors How to Change Number Formats How to Adjust the Cell Alignment