• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Logging actions performed in excel

L

lunchboxkid

New Member
I teach a course on Excel at work and I am interested in a way to personalize a cheatsheet of the most useful shortcuts for each student. Is there a way to log all excel activity so that you can find out what actions were performed the most?

It would be sort of like a keylogger, and after a week or so you would be able to review the log, see what actions you performed the most (e.g. pasted values 156 times, removed cell borders 150 times, etc.) and then learn the shortcuts for those actions.
 
Not really. Excel can log changes made to cell, but not how it was changed.

Key logger can log key press, but not what tools are accessed via menu.

Macro Recorder can record actions. But then you need to ensure it's turned on and create code to export out recorded macro as text file or bas file. Even then, there are many operations which aren't captured by it.

For your purpose, simple survey might be best option.

FYI - Some short cuts to underused tools may be beneficial as well. Such as Pivot Table Wizard (ALT+d then p).
 
You must log in or register to reply here.
Back
Top