Up to Date Share Search Results

How To: Use TEXT & custom number formatting in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:

How To: Spot a counterfeit Rolex watch

In this video tutorial, viewers learn how to spot a fake Rolex watch. Rolex watches are made perfectly and will not have any problems. Rolex watches are well maintained and are durable in water. There will be no water in the watch. Fake watched will always leak. Rolex watches will never have a date and day on the dial with stainless steal. A real Rolex has 2 1/2 times magnification, while a fake Rolex will only have 1 1/2 times magnification. This video will benefit those viewers who are plan...

How To: Calculate days with Microsoft Excel's INT function

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use date and time functions together. Specifically, you'll see how to use the INT function to calculate total days worked and the TEXT function to calculate total hours worked.

How To: Do the robot dance

The robot dates all the way back to the early eighties... some even say late seventies. They key to learning the robot dance is to only move one muscle at a time. Learn how to do this old school dance move with help from an expert.

How To: Spy on any iPhone anywhere

Kevin shows the different features and options with the program ownspy, which is through OwnSpy and is capable of tracking through phone a persons location as well as texts and phone calls. He first logs in and the first screen that opens is the tracking screen where you can sync how often the program will update the persons location. The second tab is SMS, which will show you all texts and conversations as well as the length, date, and time. The third tab lists all the persons contacts. The ...

How To: Use your iPhone with a microscope

This video shows us the procedure to use an iPhone with a microscope using iMicroscope. Open the application and focus the object correctly in the microscope. Bring the camera in the phone near the eye piece and click a photo once you get the object correctly focused. Hit 'Use' and put in the magnification of the image. Hit 'Accept' and view the image. You can see a magnification scale, date and an automatically scaled scale bar. You can zoom in the image. Save the picture in the camera roll....

How To: Format the X and Y axes in Excel

This video is about formatting the charts in Excel especially the x and y axes. The video begins by selecting a chart and right clicking the dates at the bottom of the data points. The format axis window pops up and by making changes to the style, color and the weight of lines given in the patterns tab, you can change the way the x-axis looks like. You can also change appearance of characters appearing close to the x-axis by selecting options in the font menu. You can also change the format o...

How To: Get out of the friend zone & date your crush

You need to realize that you can waste a lot of time thinking about a crush when you could be saying "hey, let's go out, let's go study, etc." You don't want to play it safe and find out 20 years later that someone had a crush on you and you didn't do anything about it. Don't worry about being rejected. If you have a crush you should ask him or her out today and get it over with. You will either be rejected or not. Either way, you will know what he or she is thinking.

How To: Make raw granola with almond milk

In this video, Raw food author and chef Jennifer Cornbleet shows you to make a great gluten-free raw granola, which is then topped with raw almond milk. She starts out by showing you have to make the almond milk by putting the almonds and water mixture into the blender. After she strains the milk and you are left with almond milk, which lasts up to five days in the refrigerator. Next she shows you how to prepare the gluten-free granola. She combines three different nuts and a date mixture int...

How To: Manage email with Conversation view in MS Outlook 2010

In this video David Rivers shows that the conversation look of Excel 2010 has greatly improved. Tracking and managing related emails, saves your inbox space to enable you to manage large number of emails effectively. By default, the conversations are arranged by date. Email interactions will have an arrow displayed. You can easily expand and collapse the conversation. The major improvement is the function of ignoring or clearing up conversation with just a few clicks. The future conversations...

How To: Use time/timestamp fields with FileMaker Pro 10

When defining fields in FileMaker Pro 10, one has to choose what type of field to decide for a database. There are two fields that accommodate special handling of data. They are time and time stamp fields. When one decides a field under manage>database,there is a option for "type". Under that, there is time and time stamp. The "time" one determines the time while the "time stamp" determines the time and date. This will help in preparing a proper and detailed database system.

How To: Use container fields with FileMaker Pro 10

This lynda.com video tutorial shows how to use container fields with FileMaker Pro 10. When you want to create fields in FileMaker database you have the choice on what kind of fields you want to make. Many general fields are self explanatory like text, date etc., but there is a special kind of field called the container field. FileMaker Pro container field is a versatile data type in that it can store any kind of binary data. Container fields can be used to hold binary data in four broad clas...

How To: Open PowerPoint in Keynote

If you're new to OS X, you may have seen Apple's presentation software, Keynote, but you might also have a lot of PowerPoint files lying around. After a while of watching the same fonts, images, transitions and builds, those presentations can seem a little dated or unoriginal. If you want to try to liven things up, import them into Keynote. Simply open Keynote, select import an existing file, and chose a PowerPoint presentation. That's it. For a step-by-step video demonstration, watch this OS...

How To: Make a Taurus fall in love with you

Those born under the Taurus sign need to be handled with kid gloves. To trap a Taurus you will need a loyal nature, a strong sense of self image an a respect for money. Take the tie to look extra special for your Taurus since they pay particular attention to appearances. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with a Taurus work.

How To: Clear up office clutter

It's easy to find yourself drowning in a pile of papers and nick-nacks if you're not armed with a good organization system. By taking the time to set up a system where everything is condensed and has a place you'll find it much easier to keep it that way.

How To: Avoid falling for a married man

If you find yourself always falling for married men Tracey Cox knows why. In this how-to dating video, Tracey talks about the often unconscious influences that can lead a woman to seek out a partner who is married. Once you learn of the factors that attract you to married men, you will know how to recognize them and avoid falling for a married man. Avoid falling for a married man.

News: Magic Leap Lands a New Investor from Europe's Media Sector

On Monday, German newspaper and digital publisher Axel Springer announced its role as the latest company to invest in Magic Leap. This is just the latest in a series of investments the augmented reality company has garnered from the likes of Google, Qualcomm, Alibaba, Legendary Entertainment, Warner Bros., and others amounting to almost $2 billion in overall funding.

News: The Nokia 6 Is Finally Coming to the US (Maybe)

The Nokia 6 has been out since January, releasing in China before having a slow trickle of releases throughout the year. Despite announcing a global release, the United States never received a street date for the smartphone, and for all this time, Nokia has left us out to dry. Now, it seems, their phone could be on its way as the 6 has received its FCC certification.