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

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

Tips to Make Any Word Document More Readable

Posted on March 23, 2017 by Angela Nino

  How do you get someone to read your printed page or on-screen document? There are many theories and ideas. I’ve compiled a few of my favorite hints and tips to help make your Word documents more readable. Some relate to grammar and word usage while others relate to formatting and layout. Editing Tips This is one of the lists that I have next to my computer. I use it almost every day. Jim Taylor developed the Eight Step Editing technique: Shorten sentences (average length should be 18 words) Take out the trash (eliminate jargon or explain it) Overcome the negatives (a positive statement to replace a double negative) Deflate pomposity (keep it simple) Eliminate equations (avoid saying “is” whenever…

Read More

Creating and Using an Outlook Template

Posted on February 13, 2017 by Angela Nino

Do you send a similar email message multiple times a week/month or need a standard worded email to use for your organization? If so, create an email template to make the repeated sending much more efficient. A template can also be created to use a certain font, style, or even include a company logo. Create your template, save it, reuse it anytime. Create the Template In Outlook, on the Home tab, click the New Email button to start a new message. Create the message as you would like it to look. Add a logo, wording, and anything else you would like to include. Click the File tab and Choose Save As. Enter your name for the template and set the…

Read More

How to Type Trademark and Other Symbols in MS Word

Posted on February 7, 2017 by Angela Nino

In Word, you might need to add a symbol. Symbols can range from math numbers/equations like (¼) , letters or words from other languages (ñ), special characters (ellipsis…), or little pictures called wingdings (P). There are several ways to insert a symbol: with a keyboard shortcut, via the Symbol dialog box, or by using a built-in AutoCorrect feature. Depending on the type of font and application that you use, you may find that some symbols are not available. I use symbols every day for my last name and for creating a bulleted list. The bullets pull from the symbol fonts, too. Trademark, Copyright, and Registered Trademark Here are a few different methods to insert the trademark, copyright, and registered symbols:…

Read More