Microsoft Tip of the Month: Excel Flash Fill

Share on LinkedIn Share on Facebook Share on Twitter Share on Google Plus Share this Page

Microsoft Tip of the Month: Microsoft Excel Flash Fill

In Microsoft Excel 2013, Flash Fill can enter data automatically into your worksheet, saving you time and effort. Just like the fill handle, Flash Fill can guess what type of information you're entering into your worksheet. When a pattern is recognized in your data, Flash Fill enters the rest of your data in one fell swoop. This happens without the need for you to construct or copy any kind of formula.
Read this article...

Free Training Planning Worksheet

Share on LinkedIn Share on Facebook Share on Twitter Share on Google Plus Share this Page

Planning and organizing employee training for an entire year can be a challenge. That's why we're providing you with a simple worksheet to help you chart and organize the types of training classes that will be offered in a given year, the individuals who will attend those classes, their perceived skill level, and the timing of when they will attend training throughout the year.

Download Worksheet (Excel)

 

Instructions

Here are some simple instructions:

  1. Chart the individuals in your organization under the column "Name" and their corresponding department or position in the second column.
  2. List the classes that your organization plans to offer during the upcoming year at the top of the chart.
  3. Color code the cells for each individual based on the degree to which each employee needs training in a specific topic area or skill.
  4. Within each cell, insert the timing (month or month and day) of when you plan to offer this class or when each employee will attend this class.
  5. Insert any relevant comments around the individual.

Budgeting Assistance

Need quotes for particular training programs? Contact Chris Kutsko at (440)947-1286 or ckutsko@yourerc.com. You can also view ERC's full catalog of employee training courses online.