JOEC – Lesson B2

The best feature in MS Excel and also included in this certification package are the Macro Recording & Watch Window. It is for the Windows OS PCs as Watch Window feature does not exist in IOS PCs and Macro Recoding update has not been done in IOS MS Excel.

MACRO Recording:

The Macro Recorder, a very useful tool included in Excel VBA, records every task you perform with Excel. All you have to do is record a specific task once. Next, you can execute the task over and over with the click of a button. The Macro Recorder is also a great help when you don’t know how to program a specific task in Excel VBA.

Watch Window:

Sometimes a great feature in an application never gets the recognition it deserves and the Watch Window in Excel is a great example of one such feature. If you use Excel regularly, you probably have worked on some very large worksheets that span hundreds, if not thousands of rows. It could be useful if some of the cells you need to monitor often could be displayed in a separate window so that you could see the current value and formula at a glance. Microsoft created the Excel Watch Window for that exact purpose.