Case 6

Excel Macro has been perceived to be an advanced Excel function and/or a programming function that for normal Excel users. In this example, we will show you that you can create a macro without knowing anything about programming and how you can make use of it to increase your productivity.

6.1 -6.3 Creating & Storing Macro

6.4-6.5 Add the Macro to the Quick Access Toolbar (QAT)

6.7 Delete the Macro from the Personal Macro Workbook

 

Quick Access to the other Hidden Secrets in Data Analysis with Excel cases.

Case 1

Case 2

Case 3a

Case 3b

Case 4

Case 5

Case 6

Case 7