tailieunhanh - Thủ thuật Microsoft Excel

You use Microsoft Excel to create spreadsheets, which are documents that enable you to manipulate numbers and formulas to quickly create powerful mathematical, financial, and statistical models. In this chapter you learn about Excel and you find out the kinds of tasks you can perform with Excel. You also learn how to start the program, and you take a tour of the program’s major features. This chapter also shows you how to work with Excel Ribbon and the Ribbon’s galleries, how to customize the Ribbon and the Quick Access Toolbar, how to work with smart tags, and how to customize the view and other aspects of the program | You use Microsoft Excel to create and statistical models. In this You also learn how to start the to work with Excel Ribbon and customize the Ribbon and the Quick Access Toolbar how to to customize the view and other with Excel Chapter Working spreadsheets which are documents that enable you to manipulate numbers and formulas to quickly create powerful mathematical financial chapter you learn about Excel and you find out the kinds of tasks you can perform with Excel. program and you take a tour of the program s major features. This chapter also shows you how the Ribbon s galleries how to work with smart tags and how aspects of the program. Getting to Know Excel Start Excel Tour the Excel Window Work with Excel s Ribbon Work with Excel s Galleries Customize the Quick Access Toolbar Customize the Ribbon Work with Smart Tags Change the View Configure Excel Options 4 6 8 9 10 12 14 16 18 20 Getting to Know Excel Working with Excel involves two basic tasks building a spreadsheet and then manipulating the data on the spreadsheet. Building a spreadsheet involves adding data formulas and functions. Manipulating data involves calculating totals working with series creating tables for your data and visualizing data in charts. This section just gives you an overview of these tasks. You learn about each task in greater detail as you work through the book. Build a Spreadsheet Add Data You can insert text numbers and other characters into any cell in the spreadsheet. Click the cell that you want to work with and then type your data in the Formula bar. This is the large text box above the column letters. Your typing appears in the cell that you selected. When you are done press Enter. To edit existing cell data click the cell and then edit the text in the Formula bar. Add a Formula A formula is a collection of numbers cell addresses and mathematical operators that performs a calculation. In Excel you enter a formula in a cell by typing an equal sign and then the formula text. For