A couple of the guys at work are required to enter data but are reluctant to do so since they are either unfamiliar with basic Excel procedures or computer illiterate. So I'm wondering if there's a simple way of creating a workbook with
individual sheets that have some show me how to examples contained upon them.
By this I mean that the examples would carry instructions and have sections which require the user to take some form of action, ( cut & paste cells to another location, drag a value or formula down a range to show how each are different, Inserting new columns or rows, using consistant formating, Use of shortcut keys etc).
Can this be done within Excel or do we need to be looking at an outside set of software? We had a classic case on Friday, where the Workshop Supervisor told me he spends an hour a day re-entering the same formula by hand when trying to caclulate total hours per equipment used. When I showed him how to simply enter the formula once and then drag down to the required range. He said "I simply didn't know, and didn't know who to ask".
Perhaps a workbook with basic examples, depending on the needs of the company, that I can add to from time to time might remove the inefficiency in his work time.
Ted