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

Working with Months in Excel

Posted on October 30, 2017 by Angela Nino

  For many of us, we use dates in calculations in Excel. In some cases, you may need to use months in your accounting, finance, inventory or other functions. You may not think you need the Excel MONTH function, but if you are doing your calculation the long way, you’ll appreciate the shortcut. Very similar to the MONTH function are the YEAR and DAY functions. They can pull a year or day of the month number from a date to use in a calculation or for queries. For example, the MONTH function for a cell that contains the date of October 15, 2017 would end up with a number of 10. The YEAR function would pull 2017 and the DAY…

Read More

Creating Process Flows

Posted on September 18, 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

Do you have the hottest MS Office skills for 2017?

Posted on August 31, 2017 by Angela Nino

Do you have the top MS Office skills for 2017? If you are job hunting or looking to advance, are you able to perform the tasks that are asked of you? Are you an expert in knowing what is needed in today’s office environment? From my experience with large, medium and small businesses, I have found that many of them use at least one Microsoft Office program. If you are searching for new employment, you will often see Microsoft Excel and Word on the description. I am seeing more organizations that rely on Outlook, PowerPoint and Access, too. Even SharePoint use is on the rise in many larger organizations. Here are some of the most desirable MS Office and SharePoint…

Read More

Microsoft Office Differences Between Mac and PC

Posted on August 8, 2017 by Angela Nino

Over the years, I’ve worked in a Microsoft Office application on PC and Mac. The Windows version has had more improvements and updates than the Mac version, even though Office was created for Mac before the PC. Even though the release for Mac was first, the PC version often received the focus for improvement and added features. Microsoft Office Versions In my opinion, the Mac version looks a little rougher around the edges than the more streamlined look on the PC. Outside of the interface differences, you will notice that Mac Office doesn’t have all of the apps that the PC version has. And, some of the visual basic functions are missing in Mac. Mac does have a better layout…

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

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

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

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