Microsoft office hacks that will make your work easier
The term, Excel, and PowerPoint are the most common applications in the Office Suite. Here, we present you with some tips, tricks, and hacks that can be used with these apps to help you maximize your effectiveness.
MS Word is a writer’s best mate, whether you need to write a novel or complete an assignment. Interestingly, there is a lot more than you think you can do in Expression. Here are several ways for you to use it to your advantage.
1. Begin to use Document Styles
You should use styles if you need to build a lot of documents similar in nature. You can use it again for another similar document once you create a style template. You can develop a letter style if you write a lot of letters and it will save you a lot of time.
2. Modify your order to paste
Have you ever tried to paste some text and found that all the formatting it was meant to hold was lost? Well, you may customize how the paste option functions on MS Term, actually. Only go to the Office tab, go to Word Choices, and then go to the Advanced tab. There, you can see the Cut, Copy, Paste option that allows you to make adjustments.
3. Often use substantiated formatting
Formatting Reasoning looks professional because it’s neat. While you can adjust any text block to justify it if and when appropriate, by clicking the Office button, then going to Word Options, and then clicking on the Layout option under Advanced, you can set your default alignment to ‘justified.’
4. To gain more control of your text, use sections
The pages are not seen by MS Office the way we see them. They see them broken into pieces. And if you also split your work into sections, you can independently manage-section and have much more control over your paper than you currently do.
5. Cover to remove distractions from the ribbon
Anything apart from a white text space can be distracting when you are in the mood for some serious writing. Just press Ctrl+F1 if you want to cover the ribbon at the end. By clicking on it again, you can make it re-appear.
6. Get rid of all the formatting operations
We’ve all faced a situation where the entire paper is ruined by a little change in formatting. The next time this occurs, use the Simple Format button to delete the formatting after choosing the text that you need. It will return the piece of text to plain text.
7. Copy/paste using Spike
There’s something here now that you might not use a lot. You can cut different words from a document using Spike and paste them together. Use Ctrl+F3 to copy, instead of the normal cut/copy order, and use it for as many words/phrases as you want. And when you paste them at the end, all you copied will be pasted in.
8. With a single click, pick all your info.
Did you know that all your data is automatically selected when you click on the top-left corner button? This is quicker than Ctrl+A, also.
9. Customize the ShortCut Menu
Save, Undo Typing, and Repeat Typing are typically the three shortcuts on the top menu. You may, however, add to this list more of your commonly used shortcuts. Go to File-> Options-> Easy Access Toolbar and add the requisite shortcuts.
10. Add several columns/rows
You may know how to add to a spreadsheet a new column or row. But it would be boring if you used the same way to add several rows or columns. In the spreadsheet, either above or to the left of where you want to add them, a simpler way to do it would be to drag and pick n rows/columns. Right-click the highlighted rows/columns after dropping them, then pick Insert.
11. Moving and copying whole columns easier,
To shift an entire data column to a new position, simply select the column and shift the cursor to its boundary. You can drag the column into its new position as soon as the cursor switches to a crossed arrow symbol. Only do the whole thing with the Ctrl button pressed if you need to copy it.
12. Using wild cards to make it better to scan
You can use wild cards if you need to find anything but are not sure what. Using a question mark means searching for one character, and searching for several characters means using an asterisk. Attach them to your search question before or after or in between.
13. To navigate quicker, use the Ctrl+Arrow keys.
Using the Ctrl button is an easier way to work through an excel spreadsheet. To leap in any direction to the end of the line, use Ctrl and any arrow button.
14. Cells transpose
Transposing details will help you get a clearer view sometimes. Fortunately, Excel has a feature for transposing. Simply copy the region you want to transpose, shift the pointer to a blank spot, and go to Home-> Paste-> Transpose.
MS PowerPoint Facilitates,
15. Size the slides according to the specifications.
Not many people know that you can actually modify the size of your slide using PowerPoint. Go to File-> Page Setup to build your own slide size and enter the height and width you like, and voila, you’ll have custom size for all your slides.
16. Build your own template
You can also make custom templates just like your size. Click on Edit Master and then Slide Master when you go to the Themes tab. You will be able to make a lot of adjustments to the current themes and the new design you just created will have all your slides.
17. With a single click, align your photos with
There are easier ways to prosecute all the pictures that end up aligned than using just the cursor and the eyes for scale to change them. Simply select one of the pictures, then, while keeping Shift, select others. Then, on the right, go to the Align button and pick the alignment type you need.
18. Make it stand out for your title
The title on a slide is necessary to make it stand out. There are different forms of formatting that you can use on your title on the text that helps you do so. If you right-click the text portion and click Format Text Effects, you can see a variety of formatting options you can use. Before you figure out which one fits best for you, play around with them.
19. Using Slide Transfer Custom Length
The best solution could not always be the same time span between all transition results. Some items have to be quicker and some have to be slower. Although this trait has been around for a long time, it is widely underused. More frequently, individuals can use custom lengths for slide transfer.
20. Merging various shapes
Changing and adjusting shapes and images can become a little troublesome if you don’t know how to use Photoshop. You can combine shapes easily in PowerPoint, however. In the Insert tab, you’ll find a lot of shapes in a lot of colors, just add them to your slide, use the Ctrl key to pick all of them, and under the Format tab, go to Blend Shapes and press Combine.