Jon Hood

Recent Posts

Create a Visio Org Chart from Excel

Posted by Jon Hood  /  March 10, 2016  /  Excel   —   3 Comments ↓

One of the most exciting parts of my job is to coach people, saving them time and making their day a little bit easier. I've found myself saying, "My job is to make you look like the hero!"

I used that phrase today, which inspired me to write about it. I just finished teaching a course on Microsoft Visio and the highlight was the lesson on organization charts, a huge hit among Visio users. Just click on the Organization Chart template to get going.

Read More ›

Tags: Excel

Multiple Timelines in Microsoft Project 2016 [Video]

Posted by Jon Hood  /  February 10, 2016  /  Microsoft 365, Office 2016   —   No Comments ↓

Timelines are a great way to give stakeholders a snapshot of how a project is going. But a single timeline can get stacked and cluttered. The solution? Multiple timelines in Microsoft Project. In this video, I'll show you exactly how to use this very cool new feature and export an image perfectly for Microsoft PowerPoint.

Read More ›

Tags: Microsoft 365, Office 2016

SharePoint Success Through Establishing Goals

Posted by Jon Hood  /  February 2, 2016  /  Microsoft 365, SharePoint   —   1 Comments ↓

 

Read More ›

Tags: Microsoft 365, SharePoint

Analyzing Earned Value in Microsoft Project 2013

Posted by Jon Hood  /  January 14, 2016  /    —   1 Comments ↓

Earned value is a powerful tool for monitoring project scope, time and cost, and it can help give you a picture of the total project performance.

Microsoft Project 2013 allows you to analyze and manage earned value, and in this video, I'll show you how!

Read More ›

10 Productivity Hacks Using Office 365

Posted by Jon Hood  /  December 10, 2015  /  Microsoft 365   —   No Comments ↓

You may be asking, "How can I make my team as productive and efficient as they can be and make the most of Microsoft Office 365?" Ultimately, you want to learn ways to maximize functionality to increase efficiency. Well, that's exactly what Office 365 is built to do!

Read More ›

Tags: Microsoft 365

How to Organize Your SharePoint Team Site for Optimal Results

Posted by Jon Hood  /  November 10, 2015  /  SharePoint   —   No Comments ↓

Make your SharePoint team sites sparkling clean

As you're building, creating, and managing your organization's SharePoint team sites, it's critical to do some planning. Big-time planning. Even planning on evolution, which may be why you're asking how you can create a logical and strategic setup for a team site that's already getting overwhelmingly difficult for users. How do you organize your SharePoint team sites for optimal results? Well, that depends on how you're using SharePoint, the size of your organization, and how much freedom users have to make changes.

Read More ›

Tags: SharePoint

How to Change Your Office 365 Password

Posted by Jon Hood  /  October 15, 2015  /  Microsoft 365   —   No Comments ↓

Changing your work or school account password in Office 365 for business is pretty easy! If you’ve completely forgotten your password and you need to reset it, use the self-service password reset tool (if your admin or workplace technical support has enabled it). Otherwise, you’ll need to contact them for help.

Read More ›

Tags: Microsoft 365

How to Use Adobe Acrobat Pro DC to Edit and Comment on PDF Files

Posted by Jon Hood  /  September 17, 2015  /    —   5 Comments ↓

Have you ever received a .pdf from someone and needed to make comments for review or edit text in a .pdf just like you do in Microsoft Word? Adobe Acrobat Pro DC allows the user to have lots of control over their documents. Productivity and efficiency are improved with the multitude of features! In this blog post, however, I’ll focus on how to add text to a pdf and how to add comments to a .pdf.

How to use Adobe Acrobat Pro DC to add a comment to a pdf:

Click Tools and then Comment.

Read More ›

What's the Key to a Successful SharePoint Migration?

Posted by Jon Hood  /  August 11, 2015  /  SharePoint   —   No Comments ↓

What is the key to a successful SharePoint migration? I think that we can all agree that a successful migration depends on a team of individuals who understand how it works! 

Read More ›

Tags: SharePoint

What’s the difference between Office 365 and Office 2013?

Posted by Jon Hood  /  July 29, 2015  /  Microsoft 365   —   No Comments ↓

You may ask yourself, “Should I get Office 365 or Office 2013?” “Are Office 365 and Office 2013 different?” “Can I get both Office 365 and Office 2013?” These are great questions to consider and I’d like to clear up a few things, including terminology.

Read More ›

Tags: Microsoft 365

Where Do I Put This Document? OneDrive or SharePoint?

Posted by Jon Hood  /  July 14, 2015  /  Microsoft 365, SharePoint, OneDrive   —   No Comments ↓

Read More ›

Tags: Microsoft 365, SharePoint, OneDrive

Excel: PivotTable, a PivotChart and a Slicer on One Sheet

Posted by Jon Hood  /  July 8, 2015  /  Excel   —   No Comments ↓

What is a PivotTable, a PivotChart and a Slicer in Excel? These are features that work very well together to create an interactive separate report. Take raw data and build that report and change the way it looks and analyzes your data. A PivotChart is an interactive chart where you can change the view, suppress things and instantly see your changes. A Slicer is push button interface that allows people to drill down and see specific results from your report. So, how can you create a report with a PivotTable, a PivotChart and a Slicer on one sheet? Check it out!

Read More ›

Tags: Excel

Excel: Automatically Subtotal Raw Data

Posted by Jon Hood  /  June 23, 2015  /  Excel   —   1 Comments ↓

Sorting, Filtering and using AutoSum are great ways to work with your data to present report-style spreadsheets but there’s a better way! How can you present raw data in a way to show subtotals and then suppress and expand to make a great looking Excel spreadsheet? This is an amazing feature that will add a row displaying a subtotal without having to write formulas. Here’s how.

Read More ›

Tags: Excel

How to Add Attachments in Outlook Web App as a Link to Your OneDrive for Business

Posted by Jon Hood  /  June 18, 2015  /  Outlook, Microsoft 365   —   No Comments ↓

You can add attachments to include one or more files with any email message you send, however, you have more choices with Office 365. When you add an attachment you can choose a file from your computer hard drive, but how do you send an attachment as a link using OneDrive? Well, this awesome feature is very easy to do. Is it possible to collaborate on email attachments? Yes, it is! If you choose a file that you have in OneDrive for Business, you can send it as a link. When you send a link, not only will you prevent clogging up other people’s inbox, but the recipients can automatically given permission to edit the file which is perfect for collaboration. When we collaborate in the cloud, there is only one file to keep track of which is perfect for version control.
Check out how easy it is:

Read More ›

Tags: Outlook, Microsoft 365

Reasons Folders in SharePoint Are a Bad Idea

Posted by Jon Hood  /  June 10, 2015  /  Microsoft 365   —   4 Comments ↓

sharepoint2013-1
As many of us already know, migrating to Microsoft SharePoint presents the risk of low user adoption. In our experience, we’ve seen resistance and a big mind shift with the concept of using metadata in SharePoint instead of the traditional folder structure. Most end users are comfortable with folders. After all, “that’s the way we’ve always done it.”  This cultural shift doesn’t come easy and requires continuous education and training.

Read More ›

Tags: Microsoft 365