Requirements:
1.
Department (number of employees) | word processing | spreadsheet | database | presentation | accounting | | Sales (112) | 10.3 | 6.7 | 8.0 | 4.5 | 6.3 | | Operations (82) | 3.9 | 29.9 | 7.9 | 1.2 | 6.1 | | Accounting (55) | 13.6 | 65.5 | 14.9 | 4.5 | 45.5 | | Average for each program (Company) | 9.3 | 34.0 | 10.3 | 3.4 | 19.3 | |

Note: the red bolded numbers are the highest software usage for that particular department for all programs, with the average being at the bottom.
2. I would recommend training for the programs that are most used in each department. For example, in Sales I would recommend that they train in word processing as the most hours on average are spent on that program. For operations and accounting, the use of spreadsheets take up most of their time spent on software and thus I would train in the use of spreadsheets.
3. For the entire company, word processing takes up 9.3 hours on average, spreadsheets take the most at 34 hours, database take 10.3, presentation is last with only 3.4 and accounting comes in second at 19.3. If I were to recommend only one training program, I would suggest that training be spent on spreadsheets as they are used the most by the departments collectively. They are also the main program used for both operations and accounting by large margins.

4.

I think that graphs show a better understanding of the differences in program use between not only the programs themselves but also the different departments. A visual representation is a more vivid explanation of the average usage of each program. Likewise, both charts show just how much the spreadsheet programs are used by the company in comparison to the others. I think it is a more effective method.
5. One method that can be used is the use of at home training, this is quite popular amongst businesses, where a portal is created