tag:blogger.com,1999:blog-10541137682343080332024-08-30T09:27:36.047+08:00What I Learned from Internet. For My Reference. For Your Reference.Anonymoushttp://www.blogger.com/profile/17633121126858889258noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1054113768234308033.post-24131028846415638652012-08-10T04:04:00.000+08:002012-08-10T04:04:06.879+08:00<div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;">Hi!</span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;">One of my tasks as the Executive in charge of Mobility, Promotion and Performance Management System is to prepare proposals that consists of staff and position details.</span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;">inspired by my colleagues in KL, who came up with the automation template (which is based on VLOOKUP), oh yes, our proposals are done in Spreadsheet; I developed also my own Proposal Automation. As of now, I am still using Excel, but I have plans to fully integrate all Proposals into Access, so as we could prepare the proposals and immediately store in the respective database.</span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;">but that is a different story altogether.</span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;">The management, on top of the normal proposal template, insisted on providing them the staff photo as well. It was a difficult task at first, as I have no idea on how to automate the process.</span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;">But then I found MrExcel, and boy, does the video taught me a lot.</span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;">I hope you will enjoy this video as much as I do!</span></div> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span> <div class="separator" style="clear: both; text-align: center;"> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/0sA6J1lTDfg?feature=player_embedded' frameborder='0'></iframe></span></div> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><a href="http://www.youtube.com/watch?v=0sA6J1lTDfg">http://www.youtube.com/watch?v=0sA6J1lTDfg</a> </span><br /> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span> <span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span> <br />Anonymoushttp://www.blogger.com/profile/17633121126858889258noreply@blogger.com0