Category

Tech Tip

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
Tech Tip

Office 365 Tip: Adjust Your Teams Notifications Settings

Microsoft Teams is the successor to Skype for Business. You may be jumping straight into Teams or switching to it from Skype and want to ensure your notifications are tweaked to your needs. Here’s how to access your Teams notifications settings! Click your profile picture in the upper right corner. Choose Settings > Notifications. There are three categories for notifications: mentions (e.g. when someone @s you), messages, and other. For each type of notification, you can choose to receive one of these: Banner (a pop-up notification on your screen) Banner and email (the frequency of the email notification is set…
OTWAdmin
April 2, 2019
Office 365Tech Tip

Going on vacation? Set up your Out-Of-Office Automatic Replies in Outlook

Before you head out the door for your afternoon off or that long-awaited summer vacation, take a moment to turn on Outlook’s Automatic Replies for your email. Email piles up while you’re out. It’s polite to let people know you’re away and who to contact during your absence. (Who knows, when you come back, it may all be taken care of for you! Or that’s the dream anyway.) Automatic Replies in Outlook Go to File > Automatic Replies. In the window that appears, select Send automatic replies. Select an optional time range for when you want your automatic reply to…
OTWAdmin
March 4, 2019
Tech Tip

Editing Table Cell Margins in Microsoft Word

If you do a lot of work in Microsoft Word documents, it can be very helpful to know where to find the various options for styling a table. Sometimes tweaking cell padding or cell margins is all you need to turn a difficult, cramped table into an inviting, easy to read one. Here’s how to modify the cell padding in a table. Let’s start with a table that looks like this. This is what many default tables look like in Word. It’s a little cramped. If you look closely, you can see that there’s cell padding on the left and…
OTWAdmin
February 25, 2019
Office 365Tech Tip

Office 365 Tip: Sharing links instead of sending copies

Ready to send off a file attachment to your colleagues for their review and feedback? Wait a second, because there’s a better way in Office 365 to more easily and seamlessly collaborate with others on the same document or project. Don’t send copies – send a link instead! The trick is to use OneDrive to store your files and then share a link with everyone to the file (or even a folder with multiple items). Just save your file in OneDrive and you can use the share link feature in Office 365. From Outlook While composing your email, go to…
OTWAdmin
February 4, 2019
Business ProductivityTech Tip

Connecting and Presenting in Microsoft Teams

If you regularly use Skype for Business in your organization, you may now know that Microsoft has begun replacing Skype with Teams. Microsoft Teams is a new platform that acts as a hub within Office 365 and brings together chat, meetings, notes, and integrations with other Office 365 applications like SharePoint. Depending on how your organization is handling this transition, you may already be using Microsoft Teams and be rerouted to it for your chats, meetings, and presentations. The Teams UI is certainly different from Skype! Here are some quick tips on starting a chat, voice call, or video call…
OTWAdmin
January 2, 2019
SecurityTech Tip

Check email header information for signs of spoofing

Think about this scenario: A friend tells you that they received a message from your email address that wasn’t really sent from you. They think you’ve been hacked and your account is sending malicious emails to friends. How do you know if your email address account has been compromised, or if this malicious attempt is just spoofing your email address? Email “spoofing” means that an attacker is impersonating you by pretending to send an email from your account. The recipient of the email will see your email… but if you dig deeper into the email message’s contents, you can often…
OTWAdmin
December 3, 2018
Office 365Tech Tip

What is OneDrive for Business?

If your organization uses Office 365, then you have OneDrive. But you may not be using it. Office 365 plans for business – Office 365 Business, Office 365 Business Premium, and Office 365 Business Essentials – all include OneDrive. OneDrive is Microsoft’s cloud service that stores and protects your files, lets you share them with other people, and access them from anywhere, on any device. If you’re familiar with Dropbox or eFolder, OneDrive is a similar type of cloud storage service. When you use OneDrive with an account provided by your company or school, it's sometimes called OneDrive for Business.…
OTWAdmin
November 12, 2018
Office 365Tech Tip

AutoSave Feature in Office 365

The AutoSave feature in Microsoft Office 365 behaves differently than people may expect. This feature has changed somewhat recently. We want to make sure that Office 365 users understand what is happening to their data. With Microsoft’s AutoSave feature, any changes made to a document in OneDrive or SharePoint are automatically saved and the original document is lost. However, it is still possible to recover previous versions of the document using version history. For example, if you wish to retrieve the original version of a document in OneDrive, you can view it on OneDrive's website where the "history" icon is…
OTWAdmin
October 17, 2018