Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
  • Excel shortcuts and formula training excercises
Originally published: 26/09/2018 10:24
Publication number: ELQ-13468-1
View all versions & Certificate
certified

Excel shortcuts and formula training excercises

Three comprehensive excel based excercises to teach common excel shortcuts and advanced formula use

courseexcel learningformulaslearningsshortcutsteach excel

Description
Includes 3 excercises with solutions covering excel shortcuts and advanced formula use.

Note that the training excercise is for someone who already has a basic knowledge of excel formulas but wants to improve their knowledge of shortcuts and more advanced formulas in order to improve their productivity at work.

Shortcuts that you'll learn include keyboard shortcuts to move quickly around a spreadsheet, trace dependents within formulas, undo and redo an action, and many more.

The functions excercises will test most excel users and cover a range of specialist functions that will help the user to improve their knowledge of excel. Functions include IF, MIN, MAX, MATCH, INDEX, CHOOSE, TRIM, LEFT, SUMPRODUCT, EOMONTH, COUNTIF, SUMIF, COUNTIFS, SUMIFS.

The excercises set up everyday workplace type scenarios in which to use the formulas and shortcuts.

The excercises encourage self guided learning by providing the answers in formula form. The user is encouraged to look at the structure of each answer. However, the best way to learn excel is to actually use excel.

Total learning time will depend on the starting level of the user. However, someone with a working level of knowledge of excel's basic features and basic functions will find that the excercises could take between 5 and 8 hours.

This business tool includes
6 excel workbooks and 1 PDF

Acquire business license for $25.00

Add to cart

Add to bookmarks

Discuss

Further information

For a user to teach themselves useful excel shortcuts and advanced formulas to improve their productivity when using excel

Someone with a basic understanding of excels features and formulas e.g. SUM etc

Where someone is completely new to excel

Reviews

  • No review yet!

More tools from ModellingGuy

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Excel Shortcuts And Formula Training Excercises?

The user community and author are here to help. Go ahead!

please wait...