Microsoft Office Tips and Tricks

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

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