Macros in EXCEL

Sometimes, working life can be SUPER boring especially when no job is assigning to you. However, i do appreciate the working experience that i am gaining from G&P company; they are priceless~

The work that i am dealing with now, is more to data analysis and modelling. When we talk about data analysis, that simply means you are dealing with tonnes and tonnes of numbers! And through this internship, i have learned to use Macro function in repeating the steps that i want in Excel. It is awesome! Saving my time!~

EXAMPLE

If let say you are having a range of monthly data from year 1990-2005 and your task is to plot monthly graphs.

---> Macros is of GREAT help in selecting only a certain month that you desired~!

Step 1: Make sure your data is sorted accordingly (by months and years). Now, point your cursor on Jan-90 as shown in Figure 1.

Figure 1

Step 2: Go to “View” and click on “Macros”, then select “Use Relative References” as shown in Figure 2. [NOTE: Do not remove the cursor on Jan-90]

Figure 2

Step 3: Click on “Record Macro…” from “Macros” function. Then, insert a shortcut key in the pop-up menu, let say, Ctrl + “w” as shown in Figure 3. [NOTE: Do not remove the cursor on Jan-90]

Figure 3

Step 4: Highlight rows from Feb-90 to Dec-90, then right click to delete them as shown in Figure 4.

Figure 4

Step 5: Now, point your cursor at Jan-91, then click "Stop Recording" as shown in Figure 5.

Figure 5

Step 6: By pointing the cursor on Jan-91, you may now press on "Ctrl+w" (the shortcut key that you set earlier) repeatedly until your task is done. Finally, only the data for the month of January are selected while the rest of the data are deleted automatically using “Macros” function. DONE~!

***Macros is a very useful function in repeating any task you want. Most importantly, be very certain of your desired starting and ending points***