Category

Tech Tip

Tech Tip

Tips for using Outlook calendar

Confession: I am not an Outlook Calendar junkie. But if one of my coworkers looks at my calendar, they’ll likely see a smattering of events, tasks, and outside work commitments on my calendar. I also have a very long list of “Shared Calendars” so I can check up on coworkers’ schedules – it’s not lurking if it’s business! Like most people at my company, I use Outlook Calendar to remind myself and everyone else (who cares to know) when I am and am not available. Outlook Calendar is an invaluable tool if you’re in the habit of checking if someone…
OTWAdmin
February 3, 2020
Tech Tip

Basic math in Excel: Addition, subtraction, multiplication, and division

Are you new to Excel, and not sure where to start with formulas and operations? Many spreadsheets use basic math: adding and subtracting numbers or multiplying and dividing. Understanding these math formulas will help you graduate to more complex equations to manipulate your Excel data. How does basic math work in Excel? Excel uses formulas or functions to manipulate data. A function takes an input, which is the content of cells plus some operating symbols that say what to do with the data. You can input a single cell into a function or a range of multiple cells. For addition,…
OTWAdmin
January 13, 2020
Tech Tip

How to Add a Background Image to a PowerPoint Slide

Let’s say that you want to add a full-size background image to one of your PowerPoint slides. Maybe you want to show off your photography or liven up the background behind your talking points. But how do you add the image as a background? Right click on the slide. From the menu, select Format Background. A sidebar will appear on the right. From the Format Background menu, select Picture or text fill. Then click Insert, choose From a File, and then open the image you want to set as the background. Adjust the Transparency if you want to lighten the…
OTWAdmin
December 2, 2019
Tech Tip

Create Rules to Automatically Sort Incoming Mail in Outlook

When you receive a lot of email, your inbox becomes cluttered and difficult to navigate. Thankfully, you can use create Rules in Outlook to sort your incoming email. Here are the steps to set up a rule in Outlook that will automatically put incoming mail from a particular sender into a specific folder: Select an email in your Inbox from the sender you’d like to create a new folder for. Go to Rules > Create Rule on the toolbar. Check the “From…” box at the top of the Create Rule window. Check “Move the item to folder:” at the bottom…
OTWAdmin
November 4, 2019
Office 365Tech Tip

Dictate Instead of Typing in Office 365 Apps

Did you know that in many Office 365 applications you can dictate text instead of typing it? You may find this useful, especially if you need to respond to an email message and your hands aren’t free, or if you want to brainstorm out loud and capture your thoughts without taking notes by hand. First you should check if you have a working microphone. If you're using Windows 10, you can use the Voice Recorder app to do a test. Open this program and record a small snippet of audio. Play it back in order to see if your microphone…
OTWAdmin
October 7, 2019
Tech Tip

How to Add Voting Options to an Outlook Email

Need to take a quick poll? Maybe you need to find out how many people in the office are coming to lunch – and this quick tip will show you how the voting options work in Outlook! To making voting options available in an email you are composing: Click on the Options tab on the Ribbon. In the middle of the ribbon, click on Use Voting Options, and select which answers you want to make available. After clicking, you should see an information message that says “You added voting buttons to this message”. Send your email! Recipients will receive your message with…
OTWAdmin
September 2, 2019
Tech Tip

How to Resize and Crop Images in Microsoft Paint

Microsoft Paint is a simple graphics editor included with the Windows operating system. If you need to do some basic image editing, Paint is the perfect lightweight app. In this tech tip, we'll look at two tasks: how to resize an image and how to crop an image. Resizing an Image Open an image in Paint. Right click on the image file and choose Open with > Paint. Choose Resize from the toolbar. In the window that appears, you can resize based on percentage or pixels. Choose which option at the top. Make sure Maintain aspect ratio is selected at…
OTWAdmin
August 5, 2019
Tech Tip

Inserting Word Quick Parts into Documents

Microsoft Word Quick Parts are fields or variables that can be referenced and reused to automatically fill out information in your document. They range from complex objects like inserting a table of contents, to simple options that let you insert the current page number into a document footer, or the number of words or characters in the document. Here’s how you add simple Word Quick Parts like document properties, and more options like page number fields. Inserting Quick Document Property Fields Go to Insert on the Ribbon toolbar. In the Text group on the right, click Quick Parts. Choose from…
OTWAdmin
July 1, 2019
Tech Tip

Transposing Rows and Columns in Excel

What's transposing in Excel? “To transpose” means to make items change places with each other, or to flip a grid or table such that columns become rows and rows become columns. This may be a little hard to grasp, but it’s something that you may frequently want to do in Excel: How do you take values in a row and flip them so that those values are stacked in a column? (Or vice versa.) The answer is transposing them. This is how. Transposing in Excel Say you have data in rows, like this, and you want these names to be moved…
OTWAdmin
June 3, 2019
Tech Tip

Organize Using Outlook’s Color Categories

Want to become more organized in Outlook? You can create your own color-coded labels with the Categorize feature to know at a glance what emails and calendar items are. Here’s how! Outlook’s Categorize Feature You can find the Categorize option in Outlook on the Ribbon or toolbar. You can start using the categories as is, or you can customize them with your own labels. Changing the Category Labels You can label the default color categories for your own needs. Go to Home > Categorize (in the Tags group) on the Ribbon From the drop-down list, choose All Categories. Click on…
OTWAdmin
May 6, 2019