Diane's blog: CIMA Excel class (cpd event))))

Hi all, I attended two full day event September 8,9 th 2014, in cima office (1st floor)

Title: Credit Analysis & management with MS Excel 2010.

Since I'm a cima student, I'm required to pay cash RM 200 and RM 400 will be deducted from my card (total RM 600)

1) WHAT IS THE LEARNING OUTCOME?

Overview of AR Management
Credit Analysis (Existing & New)
Credit Decision (Plan)
Ratio Analysis (Financial Statement)
Excel Skill (Auto fill, Cltr keys, V-look-up)
Two tables -Analysis, Chat into Analysis

2) WHY I JOIN THIS CLASS

At first, I've been given the cima student card for quite some time, the letter say RM 1000 were inside the card and d extra RM 200 bonus when you pay your subscription fee before 31 Dec.

For more information pls visit this website :

http://www.cimaglobal.com/Our-locations/Malaysia/Students/CIMA-student-card/

To improve excel skill- Since my excel skill is consider half past six, so I just join. Mainly I'm doing journal using excel (part of my job scope) in the company.
Gain experience (to know how the cpd event conduct).
Finish out the credits in the card.

                                                           WHAT HAVE YOU LEARNED?
A lot, I like the most is the pivot table, it is interesting that we can combine 3 file together into 1. Miss Joanne (out tutor) said that it is easy to company with a company with different businesses.

Other than than, I learned about the Ratio Analysis (Calculation)

Furthermore, those required formuale (if, sumifs, vlookup), I need some time to digest, it's a bit hard, I can't really catch up in the class also.

                                                              HOW MUCH YOU RATE FOR THIS CLASS?
                                                                            Overall 4/5,

These are some of the picture were taken in the class.

hohohoho