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

How to Add Checkboxes to Excel

Posted on April 14, 2017 by Angela Nino

Are you ready to use a great feature in Excel that could potentially cut down on data entry errors? Do you need to have data to use in formulas/functions? I’m always searching for ways to increase accuracy and have found checkboxes in Excel to be very useful. Turn on Developer Tab To insert check- boxes in Excel, you need to be able to see the Developer Tab. If you have is showing on your ribbon, then you can skip this section. Otherwise, you will need to go to the File tab and choose Options. On the Excel Options window, select Customize Ribbon on the left. Click in the box in the right column next to Developer. See Figure 1. Figure…

Read More

After Hours: When the printer is closed

Posted on April 8, 2017 by Angela Nino

So, you are working late on a project and realize that you need something printed at the print shop, which is now closed. What can you do? What items are you able to create on your own computer and printer? Or, are you on a budget and could use a less expensive alternative to using a professional print shop? Here are a few of the items that are available to you and links to resources for printing: Business Cards (Microsoft Publisher) Forms, Contracts Gift Tags Holiday Gift Tags Greeting Cards Miscellaneous Cool Items (Popcorn boxes, calendars, music paper, moving labels, etc.) Newsletter (Microsoft Publisher) Print on Carstock and other Print Setting questions Photo Bookmarks (Microsoft Publisher) Photo and Art Prints…

Read More

Building Blocks in Word – Revisited

Posted on April 3, 2017 by Angela Nino

Note: After working on a few documents recently that called for using Building Blocks in Word, I knew it was time to run this post again. I really don’t think I can make it through a single week without needing this feature! Several versions ago, Microsoft introduced a new feature called Building Blocks. Using Building Blocks, you can create cover pages, headers, footers, tables, and much more. Seven years later, many people do not know about and even fewer use this amazing tool. When you design a building block, you are crafting a reusable item. You just invest a little time on the front end to be able to recycle the element you produce multiple times. It really pays for…

Read More