Blog of Tips, Tricks & Resources from New Horizons Central

Becoming proficient with Connection tools in Microsoft Visio 2016

Connecting the shapes in organization charts and workflow diagrams

Nicole Winn 0 32

For 23 years, I have trained hundreds of students in Visio and OneNote, which are 2 of my favorite programs to work within. I have found over the years some students mainly have questions about performing faster and or quicker in each program. Let me begin with Visio and a quick tip to assist with connecting the shapes in organization charts and workflow diagrams.

How to Create a Custom "Content Type" in a SharePoint Site

Improve productivity and efficiency of team members working in the Document Library

Nicole Winn 0 170

Here is one example on how you can create a Custom Content Type in a SharePoint site, that provides more document template options for the site user when they need to create a new document in a library; when they use the New Document drop-down menu command on the file ribbon. Anything that we can do as Site Owners to improve productivity and efficiency of team members working in the Document Library, so everyone can work smarter and not harder! Teamwork makes the dream work!

Wasting Hours of Your Life Pulling Data for Reports?

Your search is over! Expert Eric Satterfield to the rescue with POWER BI

Nicole Winn 0 202

 

If you, like so many others, have been searching for an easier way, a faster way, a better way to work with your data, then read on to discover just three of the reasons why I think you need Power BI, Microsoft’s next-generation data analysis tool, and believe your search is at an end.

When VLookup doesn’t cut: Try Index/Match

The Index Function is a function that finds a value in a dataset, but it doesn’t care about Unique Identifiers.

Nicole Winn 0 240

 

If you know the row, it’s a go. If you know the Column, no problem. The Match Function finds Rows and Finds Columns. So, when their powers combine…we find values. Remember the VLookup is a function within Excel that finds a value in a Dataset by looking at a Unique Identifier and then finding the appropriate value in adjacent columns to the right.

Popular Microsoft Office Shortcuts

Here are some great tips from Marty Shepard! Lists and more lists!

Nicole Winn 0 163

 

Hello! My name is Marty Shepard from New Horizons Computer Learning Centers of Nebraska. I have been an Applications Instructor with New Horizons now for almost 19 years. (Time flies when you’re having fun!) Although my favorite classes to teach are Microsoft Access and Excel, Crystal Reports and beginning SQL Querying Fundamental classes, I have taught many classes in the other Microsoft Office Suite.

The Case FOR Dual-Axis Charts in Power BI

The ultimate goal of many reports is to help someone make a decision.

Nicole Winn 0 190

 

An easy way to get that information across is in a graphical representation (a fancy term for a chart). With Microsoft's Power BI, you can easily take all kinds of data and create many different types of charts and display them in an easy-to-understand report to tell a story about it. One quick and easy way to do this is by using a dual-axis chart.

Schedule short meetings by adjusting your Calendar view in Microsoft Outlook

Schedule short meetings by adjusting your Calendar view in Microsoft Outlook  You may find it difficult to schedule a short meeting because of Outlook’s default time scale setting.

Nicole Winn 0 422

 

Schedule short meetings by adjusting your Calendar view in Microsoft Outlook  You may find it difficult to schedule a short meeting because of Outlook’s default time scale setting. Instead of...

RSS

Theme picker

Loader