Thanks for visiting our blog!
Be sure to check back frequently for the latest industry news and workplace tips.
Everyone has heard of Microsoft Office. Whether you are an avid writer or just create an occasional work PowerPoint presentation, you are familiar with it. There is a good reason it has been the most popular office suite for three decades – it's the best. The following information will be helpful at home and work. No resume is complete without Microsoft Office.
Read on for tips that can benefit every user.
Word is a simple tool for editing school or work documents, maybe the occasional list or letter. It is often used for basic things, but here are a few tips that can make your work easier.
When you have a Table of Contents, it keeps your work organized so you can easily navigate to any section. Steps are labeled in the screenshot below.
Quick Note: There are different heading styles (such as “Heading 2” and “Heading 3”) that will create subheadings as you work.
Templates lessen your workload if you use a similar document frequently, like meeting notes or company presentations.
Excel is the most complicated Microsoft Office program. It can be used for a variety of projects, from math to storing user info, and its abilities seem never ending. A whole post could be written on Excel alone. These are a few simple tips to start with.
If you already use Excel, you probably know how to write a formula using the equal sign and simple math. Functions can simplify this work even further.
Occasionally, multiple rows or columns need to be added between cells that are already filled. If you need to add 10 rows at once, doing so individually is a lot of work. To save time, you can add in groups of rows or columns at a time.
Quick Note: Inserting rows or columns isn’t always intuitive.
You can filter out specific parts of your Excel document. It is very useful when you are working on a large spreadsheet and want to focus on only part of it. Maybe you have a list of employees at different locations, with a column called “Users” and a column called “Location”. Filtering will allow you to see one category (or location) at a time.
Quick Note: You can sort by category and/or alphabetize at the same time!
Everyone has used PowerPoint at least once, maybe occasionally in high school or every week at work. PowerPoint is one of the most straightforward programs, and there aren’t many quick tips to it. That’s why it has been combined with OneNote, which is not as well known, but is very useful.
You might know how to change the background of a slide, but doing it one by one takes extra time and might look messy. Use a theme instead.
Quick Note: Themes have different layouts for many slides, so your presentation will be color coordinated but your slides will have variety.
OneNote is designed to store your “notebooks” on your computer. Those notebooks can then sync through One Drive onto other devices. Use it for lists, to make a quick note during a call, a post-it note, or to create a new notebook.
These are just a few tips to make you more productive with Microsoft Office. Hopefully, you were able to find something helpful.
We covered details about Microsoft Word, like creating a Table of Contents and your own personal template. We discussed a few tricks for Excel: using formulas, inserting multiple rows/columns at a time, and filtering a spreadsheet. We went over how to use a PowerPoint theme, and dove into the basics of OneNote with quick notes and notebooks.
If this information has piqued your curiosity, you can find more information at Microsoft’s Office Help and Training website:
If you are looking to move to Microsoft 365 from a local Exchange server, or migrate over to Microsoft 365 from Google Workspace, don't hesitate to reach out to Superior Managed IT's Sales Team for a free consultation! You can reach us through our Contact Us page or by giving us a call at 612-999-6200.
1306 County Rd F West
Minneapolis, MN 55112
Service Desk: 612-788-9233
Contact Us Today for a Free Consultation
Superior Managed IT can manage, or assist you with, your IT assets across their entire lifecycle.
From assessment, design, migration and deployment to ongoing management and security. We serve small to midsize businesses across the Twin Cities as their trusted business technology partner.
Contact us today for your free consultation!