Blog

EXCEL Basic

A Series of MS Excel Basic Tutorial

excel-1

 

So here’s my first try in writing blogs. Actually I had a hard time starting, thinking of a perfect topic that would interest readers. So, to get over that writer’s block…I decided to observe people around me… ooohhh I’m a teacher by profession by the way, been teaching computer subject for quite a while.

For a week now I’ve observed both colleagues and students (our 3 year technician program, our bachelor’s degree and newly opened senior high school STEM track), what I saw is that most were having problems working with spreadsheet software (Open Source or MS Excel) though most have already been using it since High School- or since they’ve started studying ICT subjects. Conclusion is that, most users were aware of the basics but not the programming part, where it can make working with spread sheets a lot better.

With that, I am hoping to create a series of online articles that would help my readers in navigating through different computer or mobile applications. Like I said, I better start off with Microsoft Excel, where we can REALLY use it to make a lot of database type of data be processed easily. So here’s my try:

NAME NAME NAME

Do you know that you can name a cell in particular, or a group of cells?  Yes!!! How?

Let me show you the way…

1

Yep, the name box, there is really a reason why it is being called a name box. Well, besides the fact that it gives you the column letter and row number a.k.a Cell Name as what most call it, you can absolutely rename a cell, give it a nickname (I know my sample is lousy because I named my cell B3 as NAMES well guess what I normally apply it in my teaching thingy so please bare with me). Giving a cell a name normally gives you an advantage in searching, because all you have to do is go back to our friendly Name Box and type the cell’s name.

2

Or in this case (from the figure above) you can use that handy dandy drop down arrow in the name box and choose the name of the cell you needed. From the example above you can see that I’ve named 3 cells. Viola!!!

 

How about doing it in a group of cell? Here’s how…

3

What you have to do is highlight that group of cells that you want to reference, then go to the name box and rename it… on my example from the figure above I named my cell group as details. And again whenever I need to go back to it, all I have to do is go to the name box and type the name of the cell or the group of cells, or use the drop down arrow in the name box to choose from the list like what you see from the figure below.

 

4

If you have a sheet with a lot of data, (unlike the samples I have in this online article) it would be very convenient if you give it a name, rather than scrolling your worksheet up and down or from left and right and get frustrated in the process, because at time we overshoot scrolling right?

 

This ends my first article of how to’s, I do hope you liked it and watch out for more. I know this article is kind of basic, yet can be an essential help for computer users like you.

Blog

5 Life Lessons and Benefits of playing Video Games

Life lessons: When I was a grade school student, my older friend ask me to come watch him play “Counter”(Counter-Strike). I said “Yeah..?, by the way what’s that?”.. “You’ll see”, He said. Then we went to computer shop meters away from home and he started to play with his friends. They were shouting and obviously having fun as if there’s no tomorrow.

As a grade school student, It’s fun to watch them playing in a simulation world. Going to war with your team and enemy is ok. They just respawn anyway and ready for another fight. It triggers something inside of me that I also want to learn and play with them.

Suprisingly, after months of playing, I’d became addicted and wanted to play more games rather than sticking to 1 particular game play. It made me anxious and bored to hell if I am not playing any computer games that I like. But still, I managed to figured out how to balance the system of studying and playing games without any failing subjects with also help of my mom to wake me up in the morning.

Here’s the 5 Life Lessons have video games taught me:

1. Strategy   

I’ve been into a lot of decision-making when I was still a college student, “Soon! I will be a part of a team where I can showcase my knowledge in computers.” That’s always what I say to myself.

After I graduated having a ladderize course of Computer Engineering Technology at TUP, I planned to finish it as a BS in Computer Engineering at Adamson University. I passed the entrance exam eligible to take any courses, enrolled and it worked. But after a year, things has changed. My parents can’t support me for another school year even though I can handle to surpass the grades of the rich kids at school.

Sometimes, I envy those kids who are easy-go-lucky students, they don’t care even they will fail. I even told myself, If they could just give me their tuition fees, their parent’s money will be worth it AF.

Moreover, I’ve thought that I need to get a job to sustain my studies for another school year even just a part time or maybe a scholarship. I revised my current plan and aligned it to my situation. I went to different call centers at MAKATI, more like 10 of them rejected me. Ah no, all of them. yes it could be my grammar, sorry for that. I also went to DOST scholarship program, also got rejected because of my father’s salary which is beyond the limit p.a required.

It feels like all of my towers(confidence) and barracks(courage) burned down like there’s no comeback.

But no, I still figured out another plan to keep defending myself not to eat me with the state of being defeated.

I grabbed the opportunity of being a production operator at solar company at Batangas and luckily they accepted me.

 

2. Level Up.

My story continues, I was accepted being a production operator and I am really happy that I now have a job. I now have the opportunity to get a broad experience at work and soon be part of a team that I could contribute my skills in computers just like what I’ve always said to myself, yes it feels really great.

Few months has passed, from the peak of excitement down to the support line. I got bored. Repetition of my job burns me down to ashes. Maybe because I am not very social to my collegues or in other words, Introvert.

I received my first NTE (notice to explain) from my supervisor because my process line received an open audit finding. I was so self pity and anxious that time. The reason was, I forgot to logout my account and was used by other operators.

What I did was, I challenged and urged myself to close the audit finding. Luckily, I have a background on how to program using VBA in MSExcel but not that really well though so I self-studied the basics and search for syntax in the internet.

I presented the proposal for closure and suprisingly they closed the audit finding and the supervisor who gave me NTE decided that my program will be disseminate to all process line.

Right from there, I become more enthusiastic to create more program using VBA not just to help my collegues but also all supervisors to track down their outs and wip. There are some people who discouraged me through indirect way of saying:”That’s non-sense”. But it didn’t let me to stop what I know will lift me up from being an operator.

 

3. I can type faster than you. 

What video games taught me first hand that I already applied directly is Typing. Chatting with your friends while playing boss fight is I think the best way to practice your typing speed and skills without even lookin on the keys. Thanks Dragon Nest!

 

4. Losing

We play games to WIN and have fun but losing the game is inevitable. For me playing games strengthen my cord of patience. Give respect for the other players if they lose or win. That’s just life. It’s either you quit or train hard.

 

5. Analyzing the location

 This is the funny thing I realized when I am in different places. I always look around and memorizing every corners of the road or people in the area I didn’t know. I’m always ready to run or fight back (it depends). I always wonder where am I on top view and remember every single alley I went through.

This leads me to make better decision even in fast-pace commitment. Analyzing my current situation just like in video games helped me to make the best counter move with the least risk involved in real-life.

 

TL;DR:

  • Playing video games taught me life lessons that even the hardest of rocks, there’s always a comeback. Create and revise your strategy on how to win this trials of life. I know it’s easier said than done but we are still here. We will respawn to our savepoint and there’s still a chance to win this fight.
  • Video games taught me that don’t let anyone stop you from leveling up. Always make improvements from taking on the challenge to learn more. I got promoted from being an operator last 2015 and fortunately, I am still programming VBA from time to time and I am now currently enrolled to finish my BS Computer Engineering at STI.

(also solving math problems like Differential Equations can improve your decision-making) *wink*