Intro
• When you create a workbook by default it comes with 3 sheets and you can add or delete sheets.
• You can create a new workbook by clicking the Microsoft Office Button.
• You can customize the Excel 2007 program window
• You can customize the Quick Access Toolbar for your needs
Creating Workbooks
• When you start Excel it displays a new blank workbook
• You can save your file in different formats
• Once you have created a file you can set up different properties to make your file easier to find
• You can set up the properties by using the prepare button and then the properties button from the Microsoft Office button
• Use custom tab of the advanced properties to type a new property
• Save workbook and work once you are done creating it
Modifying Workbooks
• To display a worksheet click on the worksheet’s tab
• Excel workbooks have three worksheets
• When you create a worksheet Excel gives it a generic name
• Change worksheets name by double- clicking the worksheet’s tab
• Copy one worksheet from another workbook to current workbook
• You can change the worksheet’s location
• Change the tab color of a worksheet
• Delete worksheets
• Hide and unhide worksheets
Wednesday, February 17, 2010
Sunday, January 31, 2010
Apple Ipad
The new Apple Ipad has the internet, email, and you can watch videos. It is similar to the iphone. You can easily access the itunes store. Some new additions are the book reader and being able to take notes. You can purchase the new Ipad in the spring time when it becomes available. The pricing will run from $500 to $829. I think that this will have a big impact on technology because it offers a lot of features that are similar to those on a computer. I think that this will have an impact on society because everyone will want one. I also think that this will effect society because business people will start buying them for their jobs. I think this will effect education because college students will start buying them to use for their classes. I also think that it will effect education by having the needs for college students. I think that this will effect me personally in the future when I might need one in college. I think that the new Ipad is a great addition to the world of technology.
Friday, January 22, 2010
Current News
Newspaper- El Paso Times, Friday January 22- 11:30 a.m., Business Section
Title: Time Warner Offers Free Calls to Haiti
Time Warner cable is offering free calls to people contacting others in Haiti. This will last until February 2010. The customers do not need to make any changes to take advantage of the program. The cable company expects to provide 200,000 dollars to provide relief to the affected customers. However the program is only for direct- dial calls.
This is important to business because they will be making money to help provide relief. It is also important because people here in the U.S. will be able to make free calls to relatives they might have in Haiti.
Title: Time Warner Offers Free Calls to Haiti
Time Warner cable is offering free calls to people contacting others in Haiti. This will last until February 2010. The customers do not need to make any changes to take advantage of the program. The cable company expects to provide 200,000 dollars to provide relief to the affected customers. However the program is only for direct- dial calls.
This is important to business because they will be making money to help provide relief. It is also important because people here in the U.S. will be able to make free calls to relatives they might have in Haiti.
Thursday, January 14, 2010
Excel Intro 1 Tasks 1-10
1. Apply Style
To apply a style first make sure you are on the home tab. Under the styles group click on the cell styles button. Then choose whatever style you want.
2. AutoCorrect
First go to the Microsoft Office button. Then go down to Excel options and click on it. On the side bar click on proofing. Then once you are in proofing go to auto correct options and make any changes you want then click ok.
3. Bold Cell Contents
First select the cell contents you want bolded. Then make sure you are on the home tab and under the font group click on the bold button.
4. Cell Formatting Remove
First select what cell contents you want removed. Then make sure you are on the home tab. Under the editing group click on the arrow next to the clear button. Then go down to clear formats and click on it.
5. Center Across Cells
First select what you cells you want centered. Then make sure you are on the home tab. Under the alignment group click on the Merge & Center button.
6. Chart- Create
Go to the Insert tab. Under the charts group click on the button of whatever kind of chart that you want to create.
7. Clear Cells
First select the cells that you want cleared. Then make sure you are on the home tab. Under the editing group click on the arrow next to the clear button and then click on the button that says clear contents.
8. Color Text
First select the text that you want colored. Then go to the home tab and under the font group click on the arrow next to the font color button and choose whichever color you want.
9. Copy Cells
First click on the cell that you want to copy. Then go to the home tab and under the clipboard section click on copy and then drag the cursor until what you want is copied.
10. Create New Workbook Blank
Click on the Microsoft Office Button. Then click on new. Then the box willl pop open and click on create.
To apply a style first make sure you are on the home tab. Under the styles group click on the cell styles button. Then choose whatever style you want.
2. AutoCorrect
First go to the Microsoft Office button. Then go down to Excel options and click on it. On the side bar click on proofing. Then once you are in proofing go to auto correct options and make any changes you want then click ok.
3. Bold Cell Contents
First select the cell contents you want bolded. Then make sure you are on the home tab and under the font group click on the bold button.
4. Cell Formatting Remove
First select what cell contents you want removed. Then make sure you are on the home tab. Under the editing group click on the arrow next to the clear button. Then go down to clear formats and click on it.
5. Center Across Cells
First select what you cells you want centered. Then make sure you are on the home tab. Under the alignment group click on the Merge & Center button.
6. Chart- Create
Go to the Insert tab. Under the charts group click on the button of whatever kind of chart that you want to create.
7. Clear Cells
First select the cells that you want cleared. Then make sure you are on the home tab. Under the editing group click on the arrow next to the clear button and then click on the button that says clear contents.
8. Color Text
First select the text that you want colored. Then go to the home tab and under the font group click on the arrow next to the font color button and choose whichever color you want.
9. Copy Cells
First click on the cell that you want to copy. Then go to the home tab and under the clipboard section click on copy and then drag the cursor until what you want is copied.
10. Create New Workbook Blank
Click on the Microsoft Office Button. Then click on new. Then the box willl pop open and click on create.
Excel Intro 2 Tasks 11-20
11. Enter Number
First choose the cell that you want to have a number. Then on the keyboard type the number you want in that cell.
12. Exit Excel
Go to the Microsoft Office Button and go to down to exit excel and click on the button.
13. Fill Series Drag and Drop
First select the cell that you want to fill the series. Then the cross arrow will appear at the bottom of the cell and just drag and drop until what you want is filled.
14. Font Size
First select the cell you want to change the font size. Then under the home tab under the font group go to font size button. Click on it and pick the font size you want.
15. Fonts
First select the cell that you want to change the font. Then go to the home tab and under the font group go to the font button. Then choose which font you want.
16. Function- Autosum
First select what you want to autosum. Then go to the home tab. Under the editing group click on the arrow next to the autosum button and click on which one you want to be autosummed.
17. Go To
Go to the home tab. Under the editing group go to find & select. Click on the find & select button. Then click on the go to button.
18. Help- Display Help Contents
Go to the Microsoft Office Excel Help button. Click on it. Then click on the show table of contents button. Then look for whatever you need help with.
19. Help- Search
Go to the Microsoft Office Excel Help button and click on it. Then type in what you need help with in the box and click on the search button.
20. Modify Formula
Click on the cell that you want to modify the formula. Then go to the formula bar and erase the cell numbers and cell letters until the first parenthesis and change the cell numbers and cell letters to the formula that you want.
First choose the cell that you want to have a number. Then on the keyboard type the number you want in that cell.
12. Exit Excel
Go to the Microsoft Office Button and go to down to exit excel and click on the button.
13. Fill Series Drag and Drop
First select the cell that you want to fill the series. Then the cross arrow will appear at the bottom of the cell and just drag and drop until what you want is filled.
14. Font Size
First select the cell you want to change the font size. Then under the home tab under the font group go to font size button. Click on it and pick the font size you want.
15. Fonts
First select the cell that you want to change the font. Then go to the home tab and under the font group go to the font button. Then choose which font you want.
16. Function- Autosum
First select what you want to autosum. Then go to the home tab. Under the editing group click on the arrow next to the autosum button and click on which one you want to be autosummed.
17. Go To
Go to the home tab. Under the editing group go to find & select. Click on the find & select button. Then click on the go to button.
18. Help- Display Help Contents
Go to the Microsoft Office Excel Help button. Click on it. Then click on the show table of contents button. Then look for whatever you need help with.
19. Help- Search
Go to the Microsoft Office Excel Help button and click on it. Then type in what you need help with in the box and click on the search button.
20. Modify Formula
Click on the cell that you want to modify the formula. Then go to the formula bar and erase the cell numbers and cell letters until the first parenthesis and change the cell numbers and cell letters to the formula that you want.
Wednesday, January 13, 2010
Current News
Newspaper- 1/12/10
Business Section
The article I read about was about the Helen of Troy profits. The profits jumped by 64%. It jumped because of lower operating costs and recent product acquisitions. The total sales in the third quarter was $189.4 million compared to the same time last year.
It is important because this company is doing well despite the recession. It is also important because they are making more money and they are a local company.
Business Section
The article I read about was about the Helen of Troy profits. The profits jumped by 64%. It jumped because of lower operating costs and recent product acquisitions. The total sales in the third quarter was $189.4 million compared to the same time last year.
It is important because this company is doing well despite the recession. It is also important because they are making more money and they are a local company.
Wednesday, January 6, 2010
Excel Plan
This six weeks my plan is to connect everything I have learned from Microsoft Word and put it into Excel. I plan to get help if I don't understand something about Excel. I will also use the knowledge that I have learned in Word and apply it to things in Excel. I also plan to use the studying method that I used with Word and do the same with Excel. Also the programs that we used in Word I will use them to help me with the Excel program.
Subscribe to:
Posts (Atom)
