Getting Started with VBA in Excel

Getting Started with VBA in Excel

VBA – Visual Basic for Applications in Excel

 

This post will show you can make use of Microsoft Excel’s VBA.  The slides here show a step-by-step approach on how you can use VBA within excel.

I hope you can make use of this for your Excel automation work.

Advertisements

Date with Freedom 2017 (Virtual Careers Summit)

22424369_10204417086102968_8451422142662391219_o

 

I was invited by my Marketing, Virtual Profession and Success mentor Jomar Hilario to his event Date with Freedom: Virtual Careers Summit.  It happened on October 14, 2017.  I saw a lot of Virtual Professionals and aspiring remote workers.

Yes I work remotely, but securely.  I talked about “How to Negotiate with 5 Clients”.  Everyone got interested on that topic, but the question I got is more about “What is Data Science and Analytics”.

IMG_20170919_080434

Above is my secure remote machine located on my client’s office.  I used that computer to login to my client’s client. It seems like an unmanned computer that when you turn on the screen you will see what I’m working on it remotely.

To simplify data science please see the diagram below:

This Venn Diagram (a diagram that shows overlaps) shows that data science is the intersection of Mathematics/Statistics, Computer Science / Information Technology and a Domain Expertise: Business, Research, Sciences, or Marketing.  Yes, Marketing, sounds familiar?

Let me show you what an Analyst or Data Scientist does for digital marketing industry:

I know most of you does those above.  The secret with these data is to measure or keep track of the values over time.  Be in Spreadsheets (Excel), text file, or tools like Instagram Insights, FB Insights and Google Analytics can help you understand your client’s customer.

I know most of you will say, I’m not techie, I’m not a geek nor a nerd.  You can, “Yes you can!”.  I said, “You can!”.  Did you know that businesses would like reports not in Math or numbers?  Did you know that clients would love to hear stories from their data?  Did you know that visuals, graphs, charts and INFOGRAPHICS simplifies the dissemination of information?  Does all those sounds familiar to you?  I know you do. Jomar taught those in his skills courses, story telling courses and other courses.

My analyst / data scientist colleague used to laugh about presenting a mathematical formula versus a well defined story with some visuals.  The presentation with a story and visualization or graphs are well appreciated by the client.

I heard some people say SQL is hard.  You don’t need that geek language, there are tools that can help you build that, yes like point and click, drag and drop.  Nothing is easy nor hard.  I went to the hard part since it’s my up-bringing in the past, I accidentally was exposed to this due to IT Engineering which is another story.

In the Philippines, we started out with Data Science Philippines on Google Groups, then on a Facebook Page.  Today we have Data Science Philippines on Meetup.  I’m a regular attendee of R Users Group Philippines because of the values of people there: “Humility”.  They know how hard the numbers are, but are still willing to help others to get started.

URL List of Live Meetups:
https://www.meetup.com/Data-Science-Philippines/
https://www.meetup.com/Manila-Analytics-Freelancers/
https://www.meetup.com/Visayas-Analytics-Freelancers/
https://www.meetup.com/R-Users-Group-Philippines/
https://www.meetup.com/Manila-Excel-Ninjaz-Meetup/

Thank you for all the attendees of Jomar Hilario’s 2017 Date with Freedom.

Jomar Hilario Courses: Virtual Careers Academy 

How to Teach Yourself R Programming

Learning R is important nowadays, as the analytics, big data and the application of data science to different industries is needed.  Mostly beginners, as what they say compared to SAS has a steep learning curve, but let’s see a quick tutorial.

First, you have to install R or Microsoft R Open.  Download from https://cran.r-project.org/

Also install RStudio for a good IDE (Integrated Development Environment) to use R and understand what data the variables has in memory. Download from: https://www.rstudio.com/

After you have these, you can get yourself in a quick environment by installing and using Swirl Package for a self run tutorial. Check out: http://rpubs.com/wenmi01/learn_r_swirl

R BioConductor Package Basics

R BioConductor package is a packaged used in genomics, computational biology or bioinformatics.  The sequences of DNA, proteins and other information are handled by a wide array of BioConductor package.

BioConductor is a collection of packages used in BioInformatics, it is almost the same as those used in BioPython, and BioPerl.

Here is my rpubs page for R BioConductor Basics: http://rpubs.com/wenmi01/r_bioconductor_basics

 

Virtual Careers Book

Many of the business are thinking, if they will allow for remote work.  Some are used to the 8-5 routine of the daily business days, however due to the traffic in Manila alone, it’s better to give flexible hours to our talents.  Time and again, letting them work remotely is another thing.  How do we really know who knows how to work remotely?

In the past, there are some uneducated virtual workers, they don’t know how to handle their employers / clients well, but thanks to the Online Marketing Guru of the Philippines, Jomar Hilario.  He found out that more people are wanting to earn dollars at home, so he started to teach Virtual Assistant lessons, and after the events, he made the lessons downloadable.  Through the years, he added more advanced lessons for the VA, and later called them Virtual Professionals.  They became professionals not just because they are remote workers, but also they are taught how to act professionally online, and only work with legitimate businessmen and industries.2015-09-20-Virtual Careers Book Launched

From the office desk, he will teach you how to be on your home office desk, or home desk to work from any part of the world and deliver astonishing results for your client, no matter where you are.

He recently launched his book, Virtual Careers (Jomar Hilario) to reach more people and Filipino workers.  The readers now have the potential to earn dollars at home, eliminate daily stress and embrace their family more.

Follow Jomar Hilario on his website http://www.jomarhilario.com

Pre-order at: http://virtualcareersbook.com/

#virtualcareers

My Journey as a Data Scientist / IT Engineer

It was long ago, when I was a curious kid on how the world works.  I like the science experiments in school, watched the Beakman’s world.  There are times that I’m thinking what will it be if no one has invented the light bulb, the engine motor, and many other things like the cellphone and computers.

On my journey, I had met a computer when I was in Elementary level.  My uncle left me a computer with Windows 3.0 on it, I tried exploring it, used Microsoft Office, read a book about DOS (Disk Operating System) and saved tons of diskettes with Microsoft Word Documents, Powerpoints, and played with Visual Basic for Application.  During my highschool, I met two programmers.  One who taught me and showed me DOS-based programming languages like C, Pascal, QBASIC, DOS and Visual Studio especially Visual Basic.  I read a book that they are using Teach Yourself Visual Basic in 21 Days, it’s fun and easy to understand so I tried creating some of its contents.  Wrote a couple of DOS batch files program.

On my 4th year highschool, I tried to take the examination for IT Engineers.  I just tried it, but since I have no mentor, I got a fairly almost passing score for IT Engineer examination, a Japanese standard certification given by JITSE (Japanese IT Standards Examination) now PhilNITS (Philippine National Information Technology Standards) which is under ITPEC (IT Professional Examination Council) headed by JITEC (Japan IT Engineers Examination Center).  One of the youngest taker at the age of 16.  After some years after taking up BS IT (college) I successfully passed the exam at the age of 20.

I was sent in Yokohama, Japan to undergo for the Training Program for IT Engineers in Asian Countries in 2007.  The youngest in the batch at the age of 20.  My expertise is COBOL (Common Business Oriented Language).  Learned Linux, JSP and other technologies including the Japanese culture.

I’ve helped OLPC (One Laptop Per Child) community to grow here in the Philippines as a Project Manager, today e-Kindling is handling the project, and they have deployed a pilot OLPC in some parts of the Philippines.

On 2010 I was sent again to undergo for Bridge Systems Engineers training (coordinating Systems Engineer) in Tokyo.

In the past, I used to do the full Software Development Life Cycle as a Systems Engineer.  I have done some work as a Network Surveillance engineer too in a contact center.  Lately, I worked with a social media site Friendster.com too as Systems Administrator.  My stay in Friendster have helped me learn more of monitoring systems, automating, testing and Quality Assurance work on systems.

I’ve helped some organizations as a consultant too in the past.

I’ve learned how to cook servers using Chef and other tools, linux, python, perl.  From there I started to love data, from MySQL to MongoDB, to CouchDB, using logs, AWS cloud services, Munin, Nagios.

After some time I’ve been interested to learn R, but then it led me to learn the Data Science Specialization from Johns Hopkins University through Coursera.  I took several courses on Data Analysis, Analytics, Process Mining and more.

Today, my learnings, combined with my experience with systems engineering, data, consulting and things I’ve learned from Marketing and Business school (MBA) helped me to become a Data Scientist / IT Engineer.  I also learned Online Marketing and Virtual Profession, so I know how to work remotely well from a guru in the Philippines named Jomar Hilario.

Nowadays, I’m exploring to learn more Mathematics from Pure to Applied, doing some research, Genomics, BioInformatics and other applications of Data Science, Science and Technology.

https://sway.com/MDvT9CFp9a1bvIvu – Sway Data Scientist Ri
https://sumry.me/wenmi01 – Sumry.me Rowen

  • Rowen Remis R. Iral