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

Security in Excel: How to Protect Your Work and Your Information

Posted on March 16, 2017 by Angela Nino

  Whether you share your Excel file internally or externally, you may want to prevent someone from accidentally changing or overwriting your data. If you don’t want someone to delete your formulas or information, there are a few ways to protect your work. You can lock your data in the worksheet structure or in a workbook, or even set a password. Note Regarding Protection Setting up a password to be able to use or modify an Excel file is a good idea. However, the encryption for an Excel spreadsheet is very easy to work around, especially in versions prior to Excel 2010. Using a password can be a deterrent for most people who aren’t looking to steal your data but…

Read More

Creating Process Flows for Training Needs

Posted on March 9, 2017 by Angela Nino

  Are you struggling with being able to get a certain concept or instruction steps across to your training attendees? Or, do you just need to illustrate a process or procedure in your report but don’t have the time or energy to invest in learning Visio? You can do it right inside Word. The flowchart shapes and symbols are located on the Insert tab in the Shapes button menu. If you can insert a shape in Word, then you can create the flowchart. You just need to create a drawing canvas before you begin that will keep the flowchart items together. It is essentially a box that will help your group of symbols and lines stay grouped together. Insert a…

Read More

Creating Income Statements with Excel

Posted on March 2, 2017 by Angela Nino

  Income statements track revenue and expenses for an organization or business. Creating one does not need to be done from scratch, unless you have specific design requirements. There are many templates available for easy download. When searching for templates, it is not necessary to find one for your specific version of Excel. For example, I found a good one in Excel 2007 version and it pulled in perfectly into my Excel 2016 software. So, if you find one from a prior version of Excel, it will most likely work just fine in your newer program. Below are some resources for templates and instructions for building or using an income statement. Using a Template MyExcelTemplates.org has a good income statement…

Read More

Integrating Technology Training into Your Mentoring/Coaching

Posted on February 23, 2017 by Angela Nino

More and more of us are participating in a mentoring or a coaching relationship these days, whether on a personal or work-related basis. Working with someone else either as the coachee/mentee/trainee or as the coach/mentor can be a very effective way of growing and developing from a young age all the way through a more veteran/experienced age. Mentoring usually involves more of an informal relationship that does not necessarily have a goal-related focus. Coaching often revolves about performance related goals either for personal or business purposes. Onboarding/New Employee Many companies have all new employees participate in a coaching situation for their first year of employment. Other companies use it as part of their onboarding process. This allows the new hire…

Read More

Profit Loss Statements with Excel

Posted on February 18, 2017 by Angela Nino

Are you struggling with tracking your income and expenses? I have encountered instances where someone needed to monitor a budget without the need of the full services of an accountant. You may be in charge of an organization or a group that doesn’t have a CPA on call, but could use a spreadsheet to display profit/loss information. There are useful templates that have built-in features and functions to allow you to watch your yearly income and expenses. Microsoft has a good Excel financial management template on their Office website. See Figure 1. Figure 1 Download Template The Profit and Loss template can be downloaded as an Excel file for you to open in your Excel desktop application. See Figure 2….

Read More