Help! The Laptop Ate My Homework

Posted on July 18, 2017 by Angela Nino

Most people have experienced the sheer panic of working on a document, presentation, or other file and then having it disappear. There are several tips that you can implement before or do after losing a document to help recover the item. Set up a Backup If you haven’t lost a file yet, don’t wait for it to happen. Be proactive and set up a backup for your hard drive. There are cloud services, if you want to set it up for automatic syncing with your system. Or, you can use a local backup. Either way, it is well worth the investment of a little time and money to ensure that you can recover a file if it goes missing. Check…

Read More

5 Outlook Tips for HR Experts

Posted on July 11, 2017 by Angela Nino

Juggling people, appointments, email, and tasks are all part of the daily routine in Human Resources. But, are we doing it in the most effective way? Microsoft Outlook has many great features that can help make the work life of an HR professional much easier and more productive. Peek at an App When looking at email in your Outlook inbox, you might want to “peek” at your calendar. If you point to your calendar icon, you can take a quick view of the current month date navigator and upcoming appointments. See Figure 1. Figure 1 Dock Your Peek Screen If you would like to dock the “peek” view on your screen, you can click the button in the top right…

Read More

Create a Risk Register Using Excel

Posted on July 3, 2017 by Angela Nino

If you are involved in any level of project management, then you have most likely seen, used, or even developed a risk register. Being able to quantify the risk associated with each part of a project is important in planning, design, and implementation phases. Noting triggers and mitigating actions in the analysis is important, as well. Microsoft Excel can help you with your risk register. You don’t need to create one from scratch. There are several templates and resources to help you. Check out the following sites to find templates, definitions of terms, and even tutorial videos. Risk Register Tips, Terms and Templates Tips, Components, and a Template Template, Benefits of a Risk Analysis, and Explanation of the Risk Management…

Read More

Create Your Own Family Tree with PowerPoint Templates

Posted on June 22, 2017 by Angela Nino

Genealogy is a fast-growing hobby in the U.S. and across the world. Many of us like to see who our ancestors are and learn our family origins. Several of my own and my husband’s family have had DNA tests to find out their genetic heritage. Once you have that information, even going back just a couple of generations, it is nice to be able to present it in a diagram format. Plugging in all of your information in genealogy software can be more that you want when you start. Using a PowerPoint template with a hierarchy diagram can be a simple solution. Download the Family Tree Template There are many PowerPoint templates available online. One template is set up specifically…

Read More

The Template to Keep Your Funding Organized

Posted on June 13, 2017 by Angela Nino

Are you struggling with the challenge of tracking your nonprofit funding, contacts, campaigns, and donors on a spreadsheet or manually on paper? Just listing donations, vendors, and amounts for tax purposes is a full-time job in itself. By training yourself to use a Microsoft Access database template, called Charitable Contributions, your organization can run much more smoothly and efficiently. You can run queries as well as deliver data and reports in a quick, presentable form. Download the Template To download the template, open Access and click in the “Search for Online Templates” box. Enter “charitable contributions”. Click on the Charitable contributions database. See Figure 1. Figure 1 A preview and description will appear in the window that opens. See Figure…

Read More

Creating a Histogram in Excel

Posted on June 5, 2017 by Angela Nino

Have you ever had data in Excel from a survey or sales commissions? You can analyze them by displaying the data in a histogram. A histogram is used to show frequency within groups. Sometimes a histogram is called a Pareto, which is a sorted histogram. The resulting histogram or Pareto appears as a column chart. See Figure 1. Figure 1 You just need the list of data points and the ranges (or bin numbers) that show the interval for Excel to measure. If you would like, Excel can even choose your intervals. Find the Data Start with your raw data. For example, you can have a list of employees and their sales commissions, a list of grades or scores, or…

Read More

The Cost of Incomplete Training

Posted on May 25, 2017 by Angela Nino

I cannot tell you how many times I am asked, “Why is training so important?” I believe that I hear it so often because training does not always involve a tangible product created at the end. We cannot “see” what we are getting so we question the cost. We struggle with the same issue with any version of education, Kindergarten-12th grade and higher education, too. My answer is always another question, “What happens when you do not invest in training?” The cost of not training can be even more expensive than devoting funds to and preparing your employees. Training is critical for employees to learn necessary skills, especially as technology changes. If you only focus on the bottom line and…

Read More

Defining Work Breakdown Structures with Excel

Posted on May 19, 2017 by Angela Nino

A Work Breakdown Structure (WBS) is a way to analyze and follow a project, but is more than just a task list. It is a way to mirror pieces and deliverables in Excel from a project perspective. You can see the organization, responsibilities, control points, and project scope. It can even help with determining costs and project estimates. A WBS can be developed from a task or deliverable orientation. Many of us look at projects as a group of tasks, which is easier to delineate in Excel. But, if you need to have your audience/stakeholders look at the WBS, then you might want to take the extra time to do a WBS from a deliverables standpoint. As you follow through…

Read More

Top 5 Word Add-ins

Posted on May 10, 2017 by Angela Nino

The built-in features of Microsoft Word improve productivity and workflow. But, did you know that there are Word add-ins that you can download from the Microsoft Store that can help you even more? There are actually hundreds of add-ins for all of the Microsoft Office products. There are 5 Word add-ins that have allowed me to be more efficient and to do tasks within Word that I was having to do outside of Word previously. The 5 top add-ins for me include: Picket Free Images, DocuSign for Word, Symbol Search, Vertex42 Template Gallery, and Office QR. Search for and Install Add-ins You can find add-ins through the Microsoft Store. If you prefer, you can also download them by going to…

Read More

Pro Tips When Giving a PowerPoint Presentation

Posted on April 29, 2017 by Angela Nino

Update on post: I realized that I need to go back and review this post about a week ago. I ran out of time and didn’t prepare my PowerPoint properly. I had not broken down my presentation into digestible, simple concepts. Because of that mistake, I ended up having to explain and elaborate on some of the topic areas. Take the time to review this post. The short time investment will pay off in the long run. Original Post About a month ago, I sat in on a presentation given by a good friend. She is a whiz at PowerPoint and seems to really “get” what it takes to reach an audience effectively. I am always impressed with her visual…

Read More