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!

Visual Studio Code | Expert Resources & Extensions

Charles Watkins gives you the run-down and excellent summary of Visual Studio, with direct resources. Microsoft got it right.

Nicole Winn 0 373

 

Visual Studio Code (VS Code), by Microsoft, is a FREE small lightweight code editor that can be installed on Windows, MacOS, and Linux.  VS Code is not an Integrated Development Environment (IDE) like Visual Studio but it has many IDE-like features.

Numbering Systems & Conversions

Converting from one numbering system to another as a basic skill to other skills...

Nicole Winn 0 206

 

With anything related to IT someone needs to understand numbering systems and converting from one numbering system to another as a basic skill to other skills. This piece is related to that requirement which is a basic skill in the following CompTIA courses: A+, Network+, Server+, Security+, CASP, Cloud+, and CySA+ as well as Cisco and Microsoft certifications.

Anyone with questions is invited to communicate with me at drussell@nhnashville.com and I will be glad to communicate with them. 

Penetration Testing vs. Vulnerability Assessment

Penetration testing, ethical hacking, or pen-testing as it is often called, is a much more active approach to identifying and even attempting to exploit vulnerabilities in a particular system, while a Vulnerability Assessment is an exercise in checking the security state of a system at a particular point in time or under a specific configuration. 

Nicole Winn 0 182

 

Penetration testing, ethical hacking, or pen-testing as it is often called, is a much more active approach to identifying and even attempting to exploit vulnerabilities in a particular system, while a Vulnerability Assessment is an exercise in checking the security state of a system at a particular point in time or under a specific configuration.  

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.

In a FLASH!

Watch Excel magic happen with the Flash Fill Data Separation Tool

Nicole Winn 0 124

 

Flash Fill is a data separation tool that has been packaged with every version of Excel since 2013!  However, it is often overlooked and underutilized.

RSS

Theme picker

Loader