Opening Office Files Safely Microsoft Word allows different ways in which to access documents. Depending on the situation, you can choose to open one in the normal mode that allows editing, for example, or allow nothing greater than read-only access. This can be useful when you need to distribute a document, making sure that no one makes changes. It's simple enough to do this. The easy way In Windows, go to the folder that contains the document that you wish to turn read-only, right-click on the file, and go to Properties. When the Properties dialog box opens, you simply need to go to the Security tab, click on Edit, and click on the … [Read more...]
Macro Security in Microsoft Excel 2007
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 … [Read more...]
Linking Data in Microsoft Excel 2007
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. … [Read more...]
Tips ‘N Tricks: Creating Shared Notebooks in OneNote
If you’ve ever tried to share electronic documents with a group of people, you probably know that lots of things can go wrong. Changes get lost, files get corrupted, and users get frustrated. A shared notebook in OneNote can solve many of the problems associated with shared files. OneNote is easy for users to learn, can store a variety of content, and will automatically save and merge changes from multiple users. Setting up a shared notebook in OneNote is a simple process. Let’s walk through the steps: Open OneNote and go to the File menu. Choose “New” and then “Notebook” from the menu options, as shown below: … [Read more...]
Microsoft PowerPoint 2007: Handling Presentation Windows and Views
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 … [Read more...]