Microsoft Office Tips and Tricks

Using the Security Features Present on Microsoft Office by Kelly Lynn

If you use Microsoft Word to create important business documents, you may want to lock up access with a password to make sure it doesn't get into the wrong hands. To do this, you need to click on File -  Save as - Tools (Tools is at the bottom of the dialog box, right next to Save), and General Options. You can type in different passwords both to open the document and to modify it under File sharing options. You do get access your document as long as you have the password. What happens, though, if you lose the password? It could be a document that your business depends on. The general feeling tends to be that password-protected documents are lost forever. It's a reasonable idea -- Word uses high-strength … Continue reading

Opening Office Files Safely by Kelly Lynn

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 check boxes that offer restrictions for various activities. This simple approach, though, isn't particularly meaningful. Anyone who … Continue reading

Fun Microsoft Word Tips and Tricks by Kelly Lynn

Fun Microsoft Word Tips and Tricks   The more you learn about the special little abilities that Word has, the more efficient you can be using the program. Here are new tips to try out.   Going freehand in Word   Word might at first appear to tie you down to the tyranny of line flow. It can seem as if you simply cannot move around an empty document at will -- to type into a line halfway down the page, for instance. You'd have do something about the intervening space. This isn't true, though. A double-click is all it takes to bring your cursor to any empty part of a Word document. You can type anything you want, leaving it to Word to automatically prepare any tabs and hard … Continue reading

Convenient Word Functions You Should Know by Kelly Lynn

If you use Microsoft Word a lot, you need to know about these functions. Some of them purchased cool tricks; others are truly useful. Here's a collection of Words tricks that are both convenient and cool.   Word can judge your writing   The Flesch-Kincaid readability test is the world standard to judge the ease of comprehension of any writing by. It was developed by the U.S. Navy in the 70s, and has been since been applied to nearly every piece of writing meant for the public at large. Government forms, schoolbooks, magazines and novels are all judged with the help of this standard. The Flesch-Kincaid readability test is so widely accepted, it is bundled with Microsoft Word. Whatever you write, you get to evaluate it on this scale, and receive an … Continue reading

Trying the New Office 2016 Preview by Kelly Lynn

Trying the New Office 2016 Preview In March, 2015, Microsoft allowed users of its Office productivity suite their first real look at the upcoming Office 2016 release in the form of a developer preview. Now, in May, it has announced a release for everyone else: the Office 2016 Consumer Preview. Right now, anyone who wants an advance look at the latest iteration of the popular software suite can have fun with their very own free, official preview copy. As expected, Office 2016 isn't a radical departure from earlier versions. Instead, it offers evolutionary steps in several directions. Preparing for the new Office 2016 Consumer Preview on your computer   While getting the preview is easy enough, you need to prepare your computer for it. As with full, final releases of … Continue reading

Two Tips for Powerpoint Videos and Microsoft Office Privacy by Kelly Lynn

These two tips should help you get a lot more out of Microsoft Office.   Create PowerPoint videos PowerPoint puts the power in everyone's hands to create impressive multimedia presentations. You get to blend music, pictures, text and webpages into slick shows that look effortlessly professional. There's one trick that you may not be aware of yet, though -- you can turn those carefully choreographed slides into video. The trick, when you have a fully finished presentation, is to stay away from the Save button, and to instead go to Export. You can do this by clicking on File-Export-Create a video. When you hit that button, Office opens a Create a video dialog box with two drop-down menus. The first one lets you set the level of quality that you … Continue reading

Useful Shortcuts to Use in Microsoft Excel by Kelly Lynn

  While Excel is a very useful tool, it can be complicated to use. Here are tricks that should make excellent experience much nicer. You can use names in Excel The Formulas function is part of Excel and lies under the  Name Manager function on the Ribbon . This feature allows you to pick any individual cell or range of cells, and label it with any easy-to-remember name that you choose. Once you've labeled it, you can use the name to refer to the cell at any time. For instance, assume that you have a simple geometric formula to calculate the area of a triangle. This is the formula: Area = ( Base x Height)/2 . If you have a series of values for the base of the triangle in … Continue reading

Do You Know That You Could Customize the Ribbon on Every Office Program? by Kelly Lynn

  Every program in Office 2013 offers quick and convenient access to all kinds of features on the Ribbon. The problem with using the default set of features is that it results in a crowded Ribbon that's full of functions that you never use, and not the features that you do use. There's a lot you can do to customize the Ribbon, and make it display only what you want it to. You can even add tabs of your own with just the functions that you need. Add more functions to an existing tab Whatever tab you want to add an extra function to ( Home , Insert , Page Layout and so on, for instance), select it, place your mouse on an empty area in the Ribbon, right-click, and … Continue reading

Customize the Office Quick Access Toolbar Just the Way You Want It by Kelly Lynn

  The Ribbon in every Office program places every important Office feature within easy reach. It can still take some time to access a given feature, though, because there are so many of them. This is what the Quick Access Toolbar is for -- it allows you to put every specific function that you need front-and-center for one-click access. By default, the QAT comes with just Save, Undo and Redo buttons. You can add a great deal more, however, and save plenty of elbow grease. Customizing the QAT is easy. All you need to do is to click on the little arrow to its right, and then hit More commands when you see the drop-down menu. Alternatively, you can place your mouse any empty spot on the Ribbon , right-click, … Continue reading

Secret Word Features That Are Useful, and Fun by Kelly Lynn

  If you just want a few paragraphs of text At times, when you're experimenting with a feature in Word and just want some text to test it on, you'd find some text somewhere, copy it and paste it in. To save you the trouble, Word includes a text generator feature: =rand() . Typing this string in and hitting Enter generates paragraphs of text, usually from the Help manual. You can tweak this feature for more customized results: you need to put two numbers in the brackets and separate them with a comma. For instance, the string =rand(7,5) will result in five paragraphs of seven lines each. When a Word file has become corrupted Sometimes, Word files get corrupted and refuse to open. Your first option should be the automatically … Continue reading