Posted in Business, Lifestyle, Technology, Tips & Ideas

#Tip of the Day: How to Separate First Name and Last Name in Microsoft Excel

It’s TIP OF THE DAY Tuesday!

Whether you’re working at the office or at home, this will be very helpful to you especially if you’re dealing with contact list or database. Of course, we don’t want to MANUALLY sort the names and consume a lot of time with one task that you can do in a snap, right?

So today, as obviously mentioned in the title of this post, I’ll be sharing with you some tips/tricks on how you can do name separation in Microsoft Excel effortlessly. There are two ways that we can do this. First is name by USING FORMULAS and second is by USING FLASH FILL.

Let us start with the first trick: FORMULAS.

1. Prepare your table with list of full name. Add two more columns for first name and last name.

2. Start to separate the first name using this formula:

Example:

3. Proceed on the last name using the below formula:

Example:

4. Click on the cell of first name/last name and drag the small dot (found on the lower right corner of the cell) downwards. You may also double click that small dot to copy the formula in the entire column.

Easy, right? Now let’s make it EASIER than that. ^_^

This next trick is the FLASH FILL. This is like “following the leader” technique. It follows the pattern that you set on your first row of name separation. Let’s proceed!

1. Prepare your table with list of full name. Add two more columns for first name and last name.

2. Type the pattern for first name and last name on the first row (first full name).

Example:

Type Joyce, as the first name, on B2 cell.

Type Lee, as the last name, on the C2 cell.

3. Click the first pattern. In the above sample, B2 cell.

4. Hold CTRL + E on your keyboard. The list will automatically be filled up following the pattern.

5. Do the same thing for the last name. From the above sample, click on C2 cell. Then repeat #4.

That’s it! Cool, right? ^_^

Feel free to try them and let me know how it goes. Enjoy!

Posted in Lifestyle, Mobile Game Review, Reviews, Technology

Mobile Game Review: Bakery Story

I could say I’m an “addict” of mobile games, but I SUPER HATE game requests and notifications on Facebook. They are annoying. They fill up most of my notifications that I find a hard time browsing the important ones. And I hate it when there are new game requests from my Facebook friends that I need to restrict or block again so as it won’t be included in my notification feed.

 

Hey, friends, we do not have the same tastes on mobile games and apps. I don’t want to be rude or something but I can browse and install any game I would like to play. You can suggest a good game but please DO NOT FLOOD my notif feed requesting to play with you on a particular game/s OVER and OVER!

 

Okay, this shouldn’t actually be a rant, rather, I would like to share would you one good mobile game that I’ve been playing for the past 2-3 months. It’s called BAKERY STORY.

 

wp-1466456949757.jpg

 

This ONLY an online game. Meaning, you cannot play without an internet connection. The TOP thing I like about this game is that you can have online friends who can play with you and help you accomplish your goals without asking or requesting to gain friends from Facebook.

 

As seen from the title, this is a baking game in which you design your own restaurant or café and bake food, brew drinks,  etc.

 

And as mentioned, you can add friends online through the game itself who obviously like, play and have interest in this game, too. They are also real people playing the game from different parts of the world whom you can chat or interact with through wall posts. You and your friends can accomplish the goals of the game by requesting parts (like materials in building an oven) and sharing in-game gifts. You get a summary of these notifications every time you log in to the game.

 

wp-1466456968141.jpg

wp-1466456962621.jpg

 

 

It’s up to you if you’ll either accept or decline the requests. Of course, I usually do accept so that my requests would also be reciprocated. It’s a give and take thing.

 

On the baking side, you get to enjoy various baked goodies and drinks as well as earn awards and get promoted. Some little accomplishments that keeps you going in the game…and crave for MORE. 😃

 

wp-1466456977780.jpg

 

The only “hard” thing about this game is earning much money for expansion. (Option: install other Storm8 games to earn gems to be used for the expansion.) But for me, it’s tolerable because that is what keeps you going on playing this game, right? Otherwise, if you can instantly get all you need for expansion and all, you can finish the game in no time and what’s next? Uninstall right away? Or give comments and feedbacks that the game is so easy to finish and that there are no more expansion updates or whatsoever? Think.

 

wp-1466456981831.jpg

 

It’s a user-friendly, easy to play and understand game. It’s a healthy escape from your daily routines. I could say, it is both entertaining and challenging. It can be played by kids and grown ups…uhmm..like me. Haha!

 

My only suggestion for now… I hope you can choose in which counter you would like to put your baked goodies especially if you have different designs of counters. Like dimsums for dimsum counters, or wherever you would freely like to put them. Other than this, I’m perfectly fine with the game. I will not delete it…so far. Haha!

 

If you are encouraged by my post, feel free to try it too. 😊 HAPPY PLAYING!

 

FWT signature

 

 

 

 

Posted in Lifestyle, Promos, Technology

Calling Out Gadget Aficionados, Citi PayLite is Here to the Rescue!

Citi, the country’s leading global bank, continues to reward its loyal cardholders and PayLite users, particularly techies and gadget aficionados!

 

Citi_Update your tech with flair_photo.jpg

 

Citi credit cardholders can now protect their existing tech and even upgrade their own gadgets in style on 0% Citi PayLite at Digital Walker, Beyond the Box, Asianic, FoneStyle, Switch and iStudio—all leading retailers of the latest electronics and accessories in the Metro—from now until June 30, 2016.

 

When you shop at Power Mac Center, you become a guaranteed winner! Pick a prize to win any one of the featured gadget accessories—Audio Technical headphones, a Mipow Voxtube 700 Bluetooth headset, or a Fluxmob Bolt portable power adapter—worth up to P2,800 when you spend at least P50,000 at 0% Citi PayLite up to 24 months.

 

Get your urban gear at Digital Walker, where you get to choose between a set of Coloud Knock headphones worth P1,195 or a Scosche Magic Mount worth P1,295 when you charge P25,000 or more on your Citi credit card.

 

Meanwhile, shopping at Beyond the Box allows you to enhance your listening experience. Take your pick from Coloud Hoop headphones worth P1,495, or a Scosche BT Boomcan compact Bluetooth speaker worth P1,495, after making a P50,000 transaction.

 

Looking for computers, mobile gadgets, and peripherals? Head on to Asianic, where you can also get a Orico 5-Port desktop USB charger worth P1,680. In need of mobile accessories, like a protective case or tempered glass? Drop by FoneStyle, use PayLite, and take home a SanDisk Ultra 32GB Micro SD card worth P1,399 along with your new swag. Eligible transactions in either store must cost at least P25,000 per receipt.

 

At Switch, a classy featured Moshi MacBook case worth up to P3,000 can be yours with a minimum single-receipt purchase of P50,000. And at iStudio, a single-receipt PayLite purchase of either P50,000or P25,000 gains you a long-lasting powerbank or a stylish case for your gadget respectively!

 

Plus, on top of all these cool freebies, get a free free 18-inch Yellow Cab pizza when you PayLite at least P25,000 at any Citi PayLite accredited merchants using any of your Citi credit cards from now until June 30, 2016.

 

The PayLite installment plan allows Citi cardholders to enjoy 0% interest at partner establishments and institutions nationwide, payable from 3 to 24 months. Along with the Citi credit card, it makes staying updated with the latest in technology and cool accessories conveniently easy!

 

To learn more about PayLite and other rewards exclusive to Citi cardholders, visit www.citibank.com.ph/yellowcab or call the 24-hour CitiPhone Hotline at 995 9999.

 

fwt-signature.png


FuentesManila
Unit 602 SEDCCO 1 Building
120 Rada corner Legaspi Streets
Legaspi Village, Makati City
Tel: +63 2 8939355
www.fuentesmanila.com

Posted in Technology

Acer Brings #TooZesty Party to Boracay

The summer heat is just getting hotter and the need to take a dip at the beach to cool things down a bit is just what most people need— chill under a shade on a powdery white sand beach while enjoying a cold drink, splash into the clear blue-green waters of the sea, and start to pump the evening up as the sun sets with some party beats at the beachfront. Acer, one of the world’s largest PC companies, is also #TooZesty and excited to bring the party to the best island destination – Boracay.

 

Known for breaking barriers between people and technology by offering innovative IT products and mobile devices, Acer brings in some fresh beats and tries to break the summer heat and quench everybody’s thirst for some cool and fun times.  On April 22, Acer invited two world-class DJs to get all the party people #TooZesty to raise their hands and pump their fists up in the air as they swing into the beats of Superstar DJ Romanova from Russia and DJ Callum David from Australia, happening in Station 2 at the Regency Hotel Beachfront where most of Boracay’s party crowd are enjoying the summer night life.

 

DJ Romanova 1.jpg

 

DJ Romanova will join the fun at the beach and will definitely bring a great atmosphere as the evening goes on deep with more people in the mood for partying. Her insanely charming and amicable style has already won the hearts of many passionate music followers and she is expected to do the same with the Filipino crowd. DJ Romanova has a dynamic style in mixing up music that allows her to captivate a variety of audiences, playing a wide range of pop, house, EDM, and deep house. Her impeccable attention to detail has allowed her to make fresh music for her audience as they fill the floor with more positive energy— this time to also drive the excessive heat of the weather.

 

Being one of the best female DJ in Moscow, DJ Romanova has scored a number of gigs in cities like Egypt, Bangkok, Jakarta, Cyprus, Morocco, Armenia, and Kazakhstan just to name a few. Her DJ residency in Moscow includes Shishas Lounge Bar, Demarco, Posh Friends, and Shishas Sfernum Bar. And to top everything off, she is also a sound producer and a member of FIJI DJs Project in Russia.

 

DJ Callum 1

 

Australian-born DJ Callum David, one of Manila’s top DJs— a regular in the metro’s hottest clubs, will take the front act as he pumps up the crowd and fill the floor with music and beats. A self-confessed party animal, DJ Callum’s style was crafted in Australia where he was exposed to a wide variety of dance music. And after traveling to Asia, DJ Callum’s passion drove him to share the musical influence he grew up with. He has performed in Thailand, Korea, Malaysia, and here in the Philippines, where he is now based.

 

Everyone is invited to join Acer and enjoy DJ Romanova and DJ Callum’s music, while getting #TooZesty in beating the summer heat in Boracay. Party with some sand between the toes and just let the cool sea water dry off from the clothes. Cool down, relax, and celebrate the first of summer at this party brought by Acer Philippines.

 

image003

 

Look for #TooZesty to see who’s joining the Acer party.  For more about Acer Philippines’ innovative products and other updates, go to www.acer.com.ph, follow Acer via Twitter (twitter.com/acerphils) or www.Facebook.com/AcerPH.

 


 

About Acer

Established in 1976, Acer is a hardware + software + services company dedicated to the research, design, marketing, sale, and support of innovative products that enhance people’s lives. Acer’s product offerings include PCs, displays, projectors, servers, tablets, smartphones and wearables. It is also developing cloud solutions to bring together the Internet of Things. Acer is celebrating its 40th anniversary in 2016 and is one of the world’s top 5 PC companies. It employs 7,000 people worldwide and has a presence in over 160 countries. Please visit www.acer.com for more information.