Connecting the shapes in organization charts and workflow diagrams
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.
Improve productivity and efficiency of team members working in the Document Library
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!
The Index Function is a function that finds a value in a dataset, but it doesn’t care about Unique Identifiers.
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.
Watch Excel magic happen with the Flash Fill Data Separation Tool
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.
Achieve extraordinary customer service and leverage your capabilities.
For most businesses, customer service is the difference between success and failure in the marketplace. With that in mind, Jim Lifter has put together some thoughts that will help you achieve extraordinary customer service and leverage your capabilities.
CLD Corner with Dr. Jason Pugh
With a Ph.D. in Instructional Management and Leadership from Robert Morris University, Dr. Jason Pugh re-joined the New Horizons team with over 12 years of teaching, training, and educational development experience.
Jason has a wealth of knowledge with conducting synchronous and asynchronous trainings and developing course materials for both live and online training sessions. He has been a training manager and an instructional coach for the last 3 ½ years, developing teachers and trainers to be successful in their endeavors.
Here are some great tips from Marty Shepard! Lists and more lists!
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 ultimate goal of many reports is to help someone make a decision.
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.
Here is a pivot table example from Tracy Haas, Applications Instructor at New Horizons CLC | Central
A lot of my students will say that the hardest part is just getting started, so I’d like to give you some help in that area by providing you with a few answers to popular questions.
Focus and participation are essential if you want to make the most of your learning.
How do you focus and participate when you have so many other things – work, family, reimagining the last season of Game of Thrones – on your mind? Let yourself have fun! Fun is stronger than fear...