Microsoft Office Tips and Tricks

Three Neat Moves on Microsoft Word by Kelly Lynn

  Microsoft Word has a great many features and shortcuts that most of its users never learn about. The three handy features described here are among the most useful on the program. Go To (for quick skipping about within a document) The Go To feature in Microsoft Word is one of the program's most ignored. It can be of particular value if you work on multiple-page documents where you repeatedly move back and forth between specific points. The function appears as a tab on Word's Find and replace feature. It's easy to directly access, too. You only need to use the Ctrl + G shortcut or simply press F5 from within Word. Once you have the Go To dialog box open, you simply need to select Page in the Go … Continue reading

Is Your Microsoft Office Document About To Rat You Out? by Kelly Lynn

  Each of the programs included in Microsoft Office maintains a metadata record that is kept hidden from plain view. The record on each document includes information on the name of every person who has worked on it, the amount of time that has been spent on it, information about every version of the document that has ever existed and the comments and changes inserted, among other things. Anyone who needs to send an Office document to someone else would do well to think about this additional information appended to it. It could get them into trouble. What could possibly go wrong? Many people take the risks involved in Office document metadata lightly and only wake up to the dangers involved when they actually get into trouble. A few examples … Continue reading

4 Useful Word Features You Probably Never Knew Existed by Kelly Lynn

  Microsoft Word comes with an extremely rich feature set. With thousands of options to dig through, though, the average user can find it hard to know where to look. some of these great features on Word are in plain sight. Yet, many users have never noticed them. The multiple Cut+Paste feature For some reason, the standard Cut feature on Windows has always only been able to hold one piece of information at a time. If you need to assemble a number of sections of text from different places in a Word file and add them to your clipboard, the standard Cut utility doesn't help. Microsoft Word, though, has an advanced Cut feature that helps: it's called Spike . For each block of text that you wish to cut to … Continue reading

Five Expert-Level Tips for Microsoft Word by Kelly Lynn

  Microsoft Word comes with a number of advanced features to help in nearly every kind of situation that calls for writing. The five tips below can be useful additions to your bag of Word tricks. Use Kerning While many word processing software packages usually only offers fixed character spacing, professional-level desktop publishing software always comes with an expert-level feature called kerning. It allows customizable character spacing for a visually pleasing effect. Microsoft Word offers kerning, too -- even if it doesn't come activated out-of-the-box. Clicking on the little pop-out button on the Fonts section on the Home tab  turns brings up the Fonts Properties dialog. Under the Advanced tab on the  box, clicking in the checkbox named Kerning for fonts turns the feature on. Insert Excel charts from within Word You … Continue reading

Five Outlook Tips for Better Productivity and Workflow by Kelly Lynn

  If Outlook in Microsoft Office is your primary email tool, every tip or trick that you learn will help you become more productive. Try the five tips on this list. Be ready with canned passages with Quick Parts If you often use set passages of text in your emails, Outlook comes with a feature called Quick Parts that gives you a way to save them for repeated use. To save a passage of text, highlight it, go to the Insert tab on the Ribbon and look on the drop-down menu for Quick Parts . Pick Save selection to Quick Parts gallery . The next time you need to use that passage, you'll see the full canned passage pop up when you type the first few words of the passage … Continue reading

Handling Chapters in Word by Kelly Lynn

  Introduction Microsoft Word is the world's most popular word processing application. You can use it to create letters, blogs, email, articles and books, among others. It has extensive publishing capabilities and can integrate with Microsoft Excel and other programs. Word can easily accommodate large manuscripts, but the first time you deal with chapters can be a hassle. Chapters in Word If you are writing a book or other multi-chapter work, you will definitely want to keep all the material in a single file, so that you can apply global changes, such as a font change, in one easy operation. If it's the first time you are working with chapters in Word, you'll need to consider a few items: . Chapter separation . Numbering 3. Headers and Footers . Table … Continue reading

Sorts and Filters in Excel by Kelly Lynn

  Working with large data files in Excel can be daunting because as the size of the spreadsheet grows, it becomes harder to read and digest the data. Excel has built-in sorting and filtering functionality to help make large spreadsheets easier to use. Learning about the sorting and filtering options in Excel will help you move through your spreadsheets more easily and efficiently. Sorting - Sorting is a great way to make your data more usable. Excel's sorting function lets you arrange various columns in ascending or descending order. This is helpful when you need to sort text in alphabetical order or when you need to sort columns with numeric data. To do a very simple sort, simply place your mouse in the column you want to sort on and … Continue reading

Microsoft Excel 2007: How to Edit/Delete Macros and Save Your Macro Enabled Workbook by Kelly Lynn

  If you make a mistake when recording a simple macro, the easiest thing to do is delete the macro and start again, but it is also possible to edit the function of a macro using the Microsoft Visual Basic Editor. This tutorial will explain how simple changes can be made to macros that require little or no understanding of Visual Basic Editor. More complex editing requires an in-depth understanding and so will not be explained here. The special actions that must be performed in order to save a macro-enabled workbook correctly will also be outlined. To edit a macro: . Click the Developer Tab within the Ribbon . In the Code Group, click on the button marked Macros . Choose your desired macro from the list click Edit . … Continue reading

Microsoft Excel 2007: Useful Macro Information by Kelly Lynn

  This tutorial deals with some useful features and shortcuts that Excel has to offer when using macros within your work. By the end you will be fully proficient in creating a shortcut key, along with assigning and deleting a button for a macro. Create a macro shortcut key: . Click the Developer Tab found in the Ribbon . Click into the Code Group - Macros button . The Macro dialogue box will then be displayed and you will see a full list of all your macros . Choose the relevant one from the list and click the button marked Options . This will display the Macro Options Dialogue Box . Have a look at the Shortcut key box - if anything already appears in there, you will need to … Continue reading

Macro Security in Microsoft Excel 2007 by Kelly Lynn

  It is important to remember that macro-enabled workbooks can hide nasty viruses that can seriously damage your computer files. When receiving a workbook that is macro-enabled off another person (either via email or the Internet) your first consideration should always be security. The security settings in Excel will allow you to open and edit the workbook, but the macros will NOT work.[/font] There are 4 levels of security that can be set to prevent any damage from infected files: Disable all macros without notification: All macros in the workbook will be disabled upon receipt and you will not be made aware that they were there at all. Disable all macros with notification: This option shows you all the available macros and you have the choice to enable them or … Continue reading