DIY Business Cards with Microsoft Publisher

Posted on February 16, 2018 by Angela Nino

  Starting a new business or wanting to update your current business cards? There are many places online that offer you the ability to create a discount card. The disadvantage of these web sites is that you cannot do much in the way of customizing. If you want to be able to make your own layout and text, you can design your card using Publisher. You can print the cards yourself or send them to a printer to get a professional look. Choosing Your DIY Business Card In Publisher, you can choose from a variety of designs, or even create your own from scratch. When you open the Publisher application, click on the “Built-In” templates. This will be under “New”…

Read More

DIY Valentine – Heart Shaped Text

Posted on February 9, 2018 by Angela Nino

Are you struggling with a Valentine’s Day gift idea for that special someone? Are they hard to buy for and you are out of ideas? Or, do you just want to do something special to create a DIY Valentine? Last year I decided that I wanted to do something creative for my two boys and husband for a Valentine gift. I thought that a special card for them would work best. I had written a poem for them in a previous year so had to scratch that off of my list of possibilities. I ended up creating a heart card for each of them and for my parents, too. Ideas Inside the heart shape had the name of the child…

Read More

Mail Merge Labels in Word

Posted on January 31, 2018 by Angela Nino

  As I was getting my holiday cards ready to send recently, I realized again how useful mail merge was to create labels in Microsoft Word. If you are not using the mail merge feature, then you are missing out on a great tool. In my past training classes, I have encountered many students who think it is too complicated since it involves several steps. Usually when I go through the steps with them, they realize it is much easier than it seems. One of the best ways to start out with mail merge is to create basic mailing labels. For small and large businesses, creating labels can be a big time-saver. Start the Mail Merge Open a blank Word…

Read More

Convert Your PowerPoint into a Video

Posted on January 23, 2018 by Angela Nino

You put so much time into creating the perfect presentation to show your colleagues. You would really like to have the presentation in a video format. You are in luck! PowerPoint video can do that! PowerPoint 2013 and 2016 versions can turn your file into an MPEG-4 video (.mp4) or Windows Media Video (.wmv). The video will include your narrations, PowerPoint laser pointer movements, animations, transitions, and your timings. Recipients of the video can now play the video on many devices. It can also be easily viewed from a web site. Create the PowerPoint Video With your file open, make sure you have saved the latest version. Then, click on the File tab and choose Export on the left. From…

Read More

My Computer Crashed – Can I Get My Word Doc Back?

Posted on January 5, 2018 by Angela Nino

Just the other day, I had a frantic phone call from a friend. She uses me as her help desk and troubleshooter in many software application questions. Her question was about her Word document recovery when her computer turned off during one of our storms. The computer shutdown when the electricity turned off. She had not turned it back on because of the storm. She wanted to know if she could recover the document that she was working on at the moment the computer turned off. She had not saved it on her hard drive yet and was concerned that she would need to completely re-create it. Many of us have encountered the same situation as my friend. If you…

Read More

Last Minute DIY Christmas Gift Templates

Posted on December 21, 2017 by Angela Nino

I always have the best of intentions to get all of my holiday shopping done early. It rarely ever happens. Between work, family, friends, and many other obligations, buying presents can get pushed to the back burner. Or, I rack my brain trying to find the perfect gift for someone who has everything and end up rushing around at the last minute to find them something. No matter how it happens, I usually end up needing to figure out Christmas presents at the last minute for a few people. When I compound that with trying to live within a budget, I often look to something that I can create. If you are having the same experience this year, try some…

Read More

More Excel Time-Saving Tips

Posted on December 15, 2017 by Angela Nino

Excel Time-Saving Tip #1 When auditing or checking a workbook, I have been grateful to be able to select all the formulas in the worksheet at once. This Excel time-saving tip will even select the hidden formulas. You can use the Go To command to get started. Use Ctrl + G as the keyboard shortcut to open the Go To dialog box. See Figure 1. Figure 1 Next, click the Special button in the bottom left corner of the Go To dialog box. To select all of the formulas, choose formulas and all of the items that you want underneath it and click OK. See Figure 2. Figure 2 Excel Time-Saving Tip #2 Have you ever needed to update a…

Read More

Tips for Planning Training Times and Budgets

Posted on December 8, 2017 by Angela Nino

As we are entering the budget preparation time of year for many companies, planning training and justifying the investment can seem daunting. Evaluating the past year’s learning and development for even a small organization is important but often can be overwhelming. You have to think about what type of classes are needed, how often they should be held, and how to make them the most cost effective. That is enough to wear out even the most seasoned learning practitioner. Below are some tips to help. Planning Training Before you can plan anything, you need to assess your current learning and development program. One place to start is to determine your ROI for training over the past year (or more, if…

Read More

3 Excel Formula Tips to Increase Productivity

Posted on November 30, 2017 by Angela Nino

  For many of us that live in Excel every day, we get a little giddy to learn about time savers. We search out anything that can help us be more productive. I’ve created macros and templates, but Excel offers many other great opportunities for increasing your efficiency by making it easier to work using formula tips. One way is through using formulas and functions. The three formula or formula-related tips that I think will help dramatically improve your productivity are using the VLOOKUP function, exploring text functions, and copying the results of formulas. VLOOKUP formula tips One of the biggest time wasting activities in Excel is having to look up items manually in a list. The function VLOOKUP in…

Read More

Calculating Net Present Value (NPV) with Excel

Posted on November 22, 2017 by Angela Nino

  In the past, when I have taught the concept of NPV (Net Present Value), I often ask if everyone understands it. If not, then I go over it in basic terms. Some training modules can make it sound like a difficult concept. But it is actually much easier than it initially comes across. Net Present Value (NPV) NPV is a function in Excel that helps you to calculate the difference between money you receive (cash inflows) and money you pay (cash outflows) for a project or investment. A positive result from the function would mean a profitable project/investment. A negative result would indicate a net loss. NPV Function In Excel, the function syntax is NPV(rate,value1,[value2],…). The rate and value1…

Read More