Microsoft Office Tips and Tricks

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

Navigating Your Way Around Microsoft PowerPoint 2007 by Kelly Lynn

  Discover convenient shortcuts, learn about Screen Tips, navigate your way around the Office button and customize your Quick Access Toolbar with this informative article. Microsoft PowerPoint has several handy shortcut key combinations, including: . Ctrl + C - Copy . Ctrl + P - Print . Ctrl + N - New presentation . F7 - Spell Checker HINT: To find out if a particular button or group has a shortcut key already assigned to it, point your mouse at it without clicking it. If it has one it will be shown. Screen Tips A Screen Tip will appear when you point the cursor at any command button without clicking on it. It will display: . The name of the command . A short explanation of the tool . The … Continue reading

Linking Data in Microsoft Excel 2007 by Kelly Lynn

  In this tutorial, linking your data in Excel will be explored. You will learn how to link information contained in a single workbook or across multiple worksheets/workbooks. The SUM function and using the Shift key across more than one workbook will also be explained. The tutorial concludes with instructions on how to copy and paste information in Excel, while still retaining the link to the original values. Linking data The most important feature of spreadsheets is the ability to reference the contents of cells and their ranges, to be able to create charts and perform the calculations you require. When you are working with formulas in Excel, you have the ability to use cell references that refer to cells in: . The same worksheet . The same workbook but … Continue reading

Microsoft Excel 2007: Formula Auditing and Error Tracing by Kelly Lynn

  Excel has a group of functions which allow you to audit your formulas and trace where you went wrong if there are errors in your work. They also allow you to view which cells a particular formula is calculated from, known as 'precedents' and which cells depend on what is placed into another cell, known as 'dependents'. Collectively, these tools are known as the Formula Auditing Group and you must display this manually:   . In the Ribbon you will see a tab marked Formulas . Click on this to display the Formula Auditing Group How to Trace Precedent Cells Tracing a precedent cell simply refers to showing how the current value of a cell came to be, i.e. - which other cells were involved in calculating that value. … Continue reading