Microsoft Office Tips and Tricks

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

Microsoft PowerPoint 2007: Handling Presentation Windows and Views by Kelly Lynn

  How to show multiple presentation windows in PowerPoint If you need to, you are able to view more than one presentation window that you have open by arranging them: . Click on the View tab in the Ribbon . Click on the button marked Arrange All in the Windows Group A single large PowerPoint window will be opened showing all your active presentation windows arranged side by side. It is also possible to cascade your presentation windows in the PowerPoint program window when required: . Click on the View tab in the Windows Group . Click the Cascade Windows button Your presentation windows will be cascaded, one in front of the other for your convenience. To make a presentation window active to work on, you must switch to that … Continue reading

Introducing Macros in Excel 2007 by Kelly Lynn

  When working with Microsoft Excel, you may find yourself repeating the same calculations or typing the same text in multiple cells. A 'macro' simply refers to a very useful and labor saving function within Excel that will store the action (or text) and make it available to you whenever you need it to use it. Running your chosen macro will then cause Excel to complete the process for you automatically. Follow the steps below and you may be able to save yourself a lot of time and effort! Step 1 - Display your Developer Tab Macro tools are available through your Developer Tab and you have to set this up to be displayed : . Click the Office button, and select Excel Options button . The Excel Options dialogue … Continue reading