/excel-training-180509

Materials for excel training on 180509

Excel: Working Faster and Smarter

Features and Functions

  • Formatting soft copies
  • Formulas and functions
  • If logic
  • Pivot tables
  • Vlookup
  • Conditional formatting
  • Charts
  • Goal seek

Macros and VBA

Main technique

  • Record and edit
  • Online search
    • mrexcel.com
    • excelforum.com

Speed

Areas to gain speed

  1. Navigation
    • ctrl/cmd + direction
    • shift + direction
  2. Keyboard over mouse (windows)
    • alt and observe
  3. Macros

On the use of keyboard shortcuts

Hidden Costs of Graphical User Interfaces: Failure to Make the Transition from Menus and Icon Toolbars to Keyboard Shortcuts (2005) by Lane, Napier, Peres and Sándor

[...] It would seem natural for users to migrate from the use of easy-to-learn menu and icon methods to the more efficient method of keyboard shortcuts as they gain experience.

[...] Contrary to our expectations, most experienced users rarely used the efficient keyboard shortcuts, favoring the use of icon toolbars instead.

[...] The keyboard shortcuts were, as expected, the most efficient. We conclude that even experienced users are inefficient in their use of graphical interfaces.

Contact

Feel free to contact me at siowyisheng@gmail.com or WhatsApp me at 9002 2215 for any specific queries and I will try to help you.