Microsoft Office offers a set of software packages that have proven to be crucial for all sorts of reasons over the years. Whether you’re a digital noob or not, you’ll have come into contact with them multiple times. In all honestly, you’re probably using them for hours-on-end on a daily basis for work purposes. They’re easy to use when it comes to their most basic functions, but they also pack a lot of power under the hood. With just a few simple tricks, you can streamline your work to make things much easier.
- You know when you need to highlight something, but it’s just a bit finicky to do? You drag over the text, but you miss one letter. Then, you end up moving words by mistake! Try this. When you want to highlight an entire sentence, hold the Ctrl button while you click any word. This will get the job done!
- Don’t go wasting your time with Word to PDF converters! When saving your document, click the drop-down menu, and you’ll find a list of choices. PDF is one of them.
- You know when your pictures just won’t go where you want them to? Never fear! Highlight the picture, click the ‘Format’ tab, and then choose ‘Wrap Text.’ You’ll find a list of choices to solve your problem.
And remember, there are plenty more tips online and you can also find Word templates across the web.
- Instead of manually adding data to every cell, use the Autofill option. You can do this by clicking in the lower-right section of a cell and dragging down.
- PowerView is a fairly new feature addition to the Excel package. It allows you to create presentations from your work without needing to go into PowerPoint. Useful, indeed!
- The Quick Analysis feature of Excel allows you to access a variety of features around a small data set. It minimizes the time spent tinkering with options, giving you quick access to the information you need. To find it, highlight your data and click the bottom-right button.
Excel is difficult to learn! There are Excel resources by Training Connection and other places that might just come in useful. Take the time to research as much information as you can to get the best out of Excel.
- When you click on an email, it normally gets marked as read automatically. This isn’t always a good thing, as you might forget about it later. By browsing to the ‘Mail’ tab of the options screen, you can make this a manual process instead.
- Are you the type of person that regularly forgets when public holidays are scheduled? Your employees aren’t going to be happy if that’s the case! Luckily, you can add public holidays automatically to your calendar through Outlook. This time, go to the ‘Calendar’ tab in the options screen.
- You know when you’re working on something, and a desktop email alert ruins your momentum? You can turn them off, too. This is also located in the ‘Mail’ tab of the options screen.