Are you looking to learn Office 2007 from scratch? The Microsoft Office website has an excellent resource for learning Word, Excel, Outlook and PowerPoint. Geared to the true beginner, this training walks you through Office 2007 programs step-by-step.
Last Topic
Tampilkan postingan dengan label Microsoft Office 2007. Tampilkan semua postingan
Tampilkan postingan dengan label Microsoft Office 2007. Tampilkan semua postingan
Hyperlink to Another Document in Microsoft Excel 2007
One of the greatest features in the Microsoft Office Suite of products is the ability to reference and link to any other document or file on your computer or network. I will run through a quick tutorial on how to link to another document from within Microsoft Excel.
To start, open your document. Select the cell to which you would like to hyperlink.
Then, click on the Insert tab followed by the "Hyperlink" button. You will see the following screen.
If there was text in the cell that you selected to hyperlink, then it will appear in the "Text to display" box. Otherwise, you can specify what you would like the hyperlink to say by adding text to the "Text to display" box. (eg., Click here to see the file)
Next, select the file that you would like to be hyperlinked. This can be done by browsing through the mini-Explorer window beneath the "Text to display" box. Once you select the file to which you would like to link, click the "Ok" button.
You should now be presented with a new blue link in the original cell you selected. If you hover over the selected cell you can see to where the cell is now linked. To go to the location, hold the Ctrl key and click on the link.
That's it! You have successfully created a hyperlink to a document in an Excel document.
To start, open your document. Select the cell to which you would like to hyperlink.
Then, click on the Insert tab followed by the "Hyperlink" button. You will see the following screen.
If there was text in the cell that you selected to hyperlink, then it will appear in the "Text to display" box. Otherwise, you can specify what you would like the hyperlink to say by adding text to the "Text to display" box. (eg., Click here to see the file)
Next, select the file that you would like to be hyperlinked. This can be done by browsing through the mini-Explorer window beneath the "Text to display" box. Once you select the file to which you would like to link, click the "Ok" button.
You should now be presented with a new blue link in the original cell you selected. If you hover over the selected cell you can see to where the cell is now linked. To go to the location, hold the Ctrl key and click on the link.
That's it! You have successfully created a hyperlink to a document in an Excel document.
View Two Excel Workbooks in One Window
One of the students in my Beginning Excel class this week asked me how to look at two different Excel workbooks in the same window. It is fairly easy.
First, open one of the workbooks you want to view. Next, click on the Office Button in the upper left hand corner of the window and click on Open. Select the second workbook you want to view, and click on Open. Both workbooks are now open.
Under the View tab, in the Window group, click on Arrange All. You have the option to view the workbooks side by side (Tiled or Vertical), top and bottom (Horizontal) or one on top of the other (Cascade). Clicking in one workbook or the other allows you to edit that workbook.
First, open one of the workbooks you want to view. Next, click on the Office Button in the upper left hand corner of the window and click on Open. Select the second workbook you want to view, and click on Open. Both workbooks are now open.
Under the View tab, in the Window group, click on Arrange All. You have the option to view the workbooks side by side (Tiled or Vertical), top and bottom (Horizontal) or one on top of the other (Cascade). Clicking in one workbook or the other allows you to edit that workbook.
Microsoft Office 2007 Service Pack 2 Released
Users of Microsoft Office 2007 should check their Windows Update to receive the new Service Pack 2 that was released on April 28.
The new service pack has a long list of improvements to the Microsoft Office suite of products. For the complete list, check out this link (Excel file).
Some of the highlights of this release are as follows:
- Speed improvements to Microsoft Outlook
- The "Save as PDF" option has been implemented throughout the entire Office suite
- Support has been added for the ODF format (Open Document Format)
- Various bugs have been fixed
If you can't wait to grab Service Pack 2, go to this link to pick up the download.
Microsoft Office 14 Coming in 2010
Finally comfortable with Microsoft Office 2007?
Well here is something to which you can look forward: According to Lifehacker, Microsoft is getting ready to release a new Office -- Office 14 -- in 2010.
Stay tuned!
Well here is something to which you can look forward: According to Lifehacker, Microsoft is getting ready to release a new Office -- Office 14 -- in 2010.
Stay tuned!
Best of Office Online: 2008
Microsoft has released a list showing their most popular Office Online resources for 2008. Categories include templates, clip art, training courses, and columns. This list includes resources for both Office 2003 and Office 2007.
What I Did Not Blog about While I Was at the MLA Conference
Sabtu, 25 Oktober 2008
Label:
Elections,
Excel,
Google Maps,
Microsoft Office 2007,
Newspapers,
Outlook,
Politics,
Voting
Yesterday, I returned from the MLA conference and caught up on my reading. Here are a few interesting posts about which I did not have a chance to blog earlier this week:
Microsoft has announced the spring 2009 release of Service Pack 2 (SP2) for Microsoft Office 2007. Microsoft is promising that SP2, scheduled between February and April 2009, will speed up Outlook and improve the charting function in Excel. If so, it will make a very good product event better.
This sounds cools, but I admit, it has limited applications: Blogger Amit Agarawal, has created a way to translate a latitude and longitude value into a street address on Google Maps. All you need to know is the the latitude and longitude where you are. Hm.
[via lifehacker]
As cities and states experiment with different types of voting machines, comes this unsettling report from The Princeton University Center for Information Technology Policy about security vulnerabilities that researchers have detected in the voting machines used by the New Jersey. According to the researchers, the machines can be completely compromised by replacing a single ROM chip — a task that they were able to complete in only seven minutes.
[via arstechnica.com]
I'm a news junkie, and Spreed:News sounds like a dream-come-true. According to lifehacker:
Microsoft has announced the spring 2009 release of Service Pack 2 (SP2) for Microsoft Office 2007. Microsoft is promising that SP2, scheduled between February and April 2009, will speed up Outlook and improve the charting function in Excel. If so, it will make a very good product event better.
This sounds cools, but I admit, it has limited applications: Blogger Amit Agarawal, has created a way to translate a latitude and longitude value into a street address on Google Maps. All you need to know is the the latitude and longitude where you are. Hm.
[via lifehacker]
As cities and states experiment with different types of voting machines, comes this unsettling report from The Princeton University Center for Information Technology Policy about security vulnerabilities that researchers have detected in the voting machines used by the New Jersey. According to the researchers, the machines can be completely compromised by replacing a single ROM chip — a task that they were able to complete in only seven minutes.
[via arstechnica.com]
I'm a news junkie, and Spreed:News sounds like a dream-come-true. According to lifehacker:
"Free speed-reading webapp Spreed:News lets you choose from a wide array of news sources and have their articles read to you in small clusters of words. Working from the principles that make for faster reading, you can scale the tool between 240 and 1500 words per minute, and set up an account to save your favorite sources — from Boing Boing to the New York Times and dozens more — for quick browsing."I haven't had the time to try it, yet, but if you do, let me know what you think.
