Essential Microsoft Word shortcuts for more efficient writing
Posted on October 12, 2007 - Filed Under MS Office Tips | 4 Comments
Here’s a list of Microsoft Word keyboard shortcuts that I have been using for years and that I thought I would share with the other billion Word users out there who may not readily use them. Word is amazing powerful and if you become well-versed in using the shortcuts, you can really save yourself a lot of time having to move your hand to your mouse in order to right-click or highlight text.
Now I’m not going to go through the really easy shortcuts like copy and paste as I am assuming you have used Word many times before reading this post!
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>Excel Tutorial - Example of how to use the VLOOKUP function
Posted on September 5, 2007 - Filed Under MS Office Tips | 6 Comments
Here’s a quick tutorial for those who need help using the VLOOKUP function in Excel. VLOOKUP is a very useful function for easily searching through one or more columns in large worksheets to find related data. You can use HLOOKUP to do the same thing for one or more rows of data. Basically when using VLOOKUP, you’re asking “Here’s a value, find that value in this other set of data, and then return to me the value of another column in that same set of data.”
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>Download Microsoft Excel, Word, Outlook, & PowerPoint 2007 training manuals for free
Posted on August 14, 2007 - Filed Under MS Office Tips | 21 Comments
You can now download four Office 2007 product training manuals for free from Purdue University web site. In their ongoing efforts to switch over to Office 2007 from Office 2003, they have created four VERY useful guides for beginners and advanced users of Excel, Word, Outlook and PowerPoint 2007.
Each document also goes through the differences between Office 2003 and 2007 in detail.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>Excel Tutorial - How to make a simple graph or chart in Excel
Posted on July 27, 2007 - Filed Under MS Office Tips | Leave a Comment
Excel is a powerful tool that you can use to create charts and graphs for small or large amounts of data. In this Excel tutorial, I’ll show you how to take a small set of data and create a simple bar graph, along with the options you have to customize the graph. Once you have the basics down, you can use those same techniques on larger sets of data.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>Ribbon Customizer - Add-In for Office 2007 that allows full customization of the ribbon interface
Posted on July 19, 2007 - Filed Under MS Office Tips | Leave a Comment
I thought it was quite silly of Microsoft to sell Office 2007 with it’s new fancy ribbon interface and not give the user the ability to modify the ribbon! RibbonCustomizer is a third-party tool that Microsoft has been promoting which allows you to modify just about everything on the ribbon interface: tabs, buttons, sort order, etc. There is a Free Starter Edition that allows you to add groups to tabs and customize the ribbon dialog.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>How to use Data Validation in Microsoft Excel to create dropdown lists
Posted on May 13, 2007 - Filed Under MS Office Tips | 3 Comments
If you’re a big Excel user, then you may have found yourself in a situation where you wished you could have simply picked a value for a cell from a dropdown list of choices rather than having to copy and paste text between cells. For example, let’s say you have an Excel sheet for your own personal budget and every time you enter a transaction on a new row, you type in whether it’s an expense or it’s income.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>
