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 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.
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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
This video shows you how easy it is to use system restore on Windows XP and Vista to bring your computer back to life. System restore takes your computer back in time to a point before it had errors or problems. Go to the start menu, all programs, accessories folder, system tools, and system restore.
In this clip, you'll learn how to ask someone you like on a date when flirting with him or her. As a general rule, when flirting with someone, it's important that you be confident and natural. But, if you're feeling nervy, there's little shame in doing a little prep work with silly videos like this one. For more information, and to get started using this tip for yourself, take a look.
In this video the Miami dating coach answers the viewers questions and tells you everything you need to do to attract that guy, and make him interested in a long term relationship. You'll learn what to look for what moves to make to have that boy in love with you for a long time.
If you are having a difficult time getting someone's phone number this is the how to video for you. Watch and learn ten easy tips to getting a phone number and maybe even a date.
Professional Matchmaker, Samantha Daniels gives advice about how to date someone long distance. Long distance relationships are the most difficult relationships to have because you don’t have the easy and spontaneity of a regular relationship. However, if the person is worth it, you can make a long distance relationship work. Watch and let Samantha give you some simple tips for navigating and succeeding in your long distance relationship!
This video series come straight from Google. It's about their new web-based product called Google Voice, which provides you with one phone number for all of your phones (landline, cell phone, etc.), giving you full online control of your telephone experience. Google Voice also allows you to make free domestic calls anywhere in the United States and Canada, gives you a cool voicemail account that's just like an email account, and many enhanced calling features.
When you decide its time to retire, you will most likely need to cash in your Social Security benefits. In this official two part tutorial, presented by the American Social Secuity Administration, learn exactly how to use their website and apply online. Applying online is very easy, and takes a lot less time than applying in person. By applying online for social security, you will bypass all of the long lines and waiting that usually happens in one of the offices. Plus, you won't ever have to...
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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
This video tells us the method to use the WORKDAY & WORKDAY.INTL functions in Excel. These functions are used to find a workday after a finite number of workdays in the future. WORKDAY uses Saturday and Sunday as off days. Its syntax is WORKDAY(start date, days, [holidays]). 'days' refers to the number of days in the future and holidays is the list of holidays written below each other in the same column. If Saturday and Sundays are not your off days, use WORKDAY.INTL. Its syntax is WORKDAY.IN...
Celebrity Chef Phil Vickery teaches in this video how to make a British favorite dish: sticky tofee pudding. This tradition dish is served warm and in often during the winter. Phil soaks the dates in boiling water and baking soda to bring out more of their flavor for the dish. While the dates are soaking, he starts creating the sponge part of the cake. With basic ingredients combined, he creates his sponge cake in a way more like a batter than your tradition method of making a sponge cake. Ne...
This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
Chaya Ryvka from Raw living foods teaches to make raw chocolate-pecan crust. You will need: pecans, raw cocoa nuts and powder, dates, vanilla, salt and food processor. First put the pecans into the food processor. Later add the raw cocoa nuts (make sure its raw ) and raw cocoa powder. At last add some fresh organic dates and a pinch of salt in the food processor. Now process all the ingredients until the crust starts to rise and repeat the process until all the nuts are broken down. Now add t...
Samsung's Galaxy S8 and S8+ are excellent smartphones that wowed critics and consumers alike. So, it's only natural that Samsung's followup, the Galaxy S9 and S9+, would garner significant anticipation. While we don't know everything about these devices quite yet, we do have guesses to some key points of interest, including when the device will be announced and even released.
Sometimes, it helps to be prepared before jumping into a new relationship; look before you leap! To have a healthy relationship with someone who has an STI, it is advisable that you enter the relationship knowledgeable about sexually transmitted infections and what your risks might be.
Greasemonkey scripts allow Mozilla Firefox and Google Chrome to be augmented in powerful ways. Take these two Greasemonkey scripts will help add information to your favicons when using Google Calendar and Gmail - now you can see the current date and unread message counts on their respective favicons.
One of the coolest parts of DC Universe Online is it's tremendously complex super hero character creation system. The system i pretty daunting at first, but this video will guide you through making an awesome character that will be the envy of your guildmates online.
Unlock the "Date Night" trophy in the Multiplayer Theater of Call of Duty: Black Ops! This achievement is won by watching a movie with a second player.
This video tutorial is in the Food category which will show you how to make a no-bake oatmeal raisin cookie. Put dry oat powder into a mixing bowl, then add 1/2 cup of dates, 1/2 cup of raisins and a pinch of cinnamon. Now mix well with your hands to make the cookie dough. Normally the moisture in the dates should help in binding the dough. If that doesn't happen, you can add a little bit of water. The awesome thing about this cookie is that you don't have to bake it. After the dough is ready...
In this clip, you'll learn how to pre date or post-date content posted to your WordPress blog. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
In this tutorial, we learn how to make your first graph in Microsoft Excel. First, open a new graph and enter in your data. Click and drag down from the original date you enter to have the other dates automatically entered in. Enter the rest of your information, then highlight all the data. Go to the menu and click "insert", then "chart". Now, go through the chart wizard to select what kind of chart you want to make. When you are finished entering all your preferences, change your values so t...
If you have a hacked XBox 360, you've only accomplished part of the process required to allow you to played burned copies of games on your console. You also have to burn the games correctly, and part of doing that is stealth patching you ISO files to make sure that they are up-to-date and won't get you noticed by Microsoft. This video will show you how to use AGBX360 to stealth patch you files and make them ready to play.
Acne sucks, and don't we know it. Our prom would have been ten times better had we not developed that continent-sized cystic blemish right at the tip of our nose (no concealor invented as of yet can cover up that monster), and the only thing more horrendous than going on first dates is going on first dates with a face full of stress pimples.
If you are unhappy with your Mac's built in date and time and need something a little easier to access, check out this clip. In this tutorial, learn how to install, set up and use a free app called MagiCal on OS X to streamline your calendar and clock.
In this video, learn how to light your Zippo by slamming the lighter into your hand in one fluid motion. This "hot hand" illusion is very flashy and works well for impressing a date that needs a light. This trick is a little advanced, so practice, practice, practice! Have fun!
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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.
In this video tutorial, viewers learn how to negotiate with a credit card company. There are 3 main items that users can negotiate. The first item is the date of payment. Users are able arrange a more convenient date for payment. The second item is the annual fee. Users are able to work out a way to not have to pay an annual fee for using a credit card, which will help save money. The third item is the interest rate. Users can negotiate and try to lower the interest rate that they must pay. T...
Steve Hicks from Screen Cast Central demonstrates how to convert your Microsoft Word files into PDF files using the Easy PDF Creator. First, download and install the PDF Creator. Then, open Microsoft Word and open the file that you would like to convert. Choose the file option from the top tool bar. Next, click the print option from the drop down menu. The print menu will now open. Under the printer name field select the PDF Creator option. Click the OK button. The PDF Creator summary window ...
If you have a fossil, you can tell how old it is by the carbon 14 dating method. This is a formula which helps you to date a fossil by its carbon. If a fossil contains 60% of its original carbon, how old is the fossil? The half life of carbon 14 is 5600 years. That means this is how long it takes for half the nuclei to decay. After 5600 years, if we start with a gram, we end up with half a gram. This rather complex formula shows you how to solve this puzzle using accepted scientific methods.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck.
In this video from panlasangpinoy we learn how to make the Filipino dessert Food for the Gods. For this you need all purpose flour, brown sugar, granulated sugar, dates, walnuts, baking powder, baking soda, butter, eggs and salt. In a bowl put flour, baking powder, baking soda and salt. Stir this around a bit. Then in a bowl cream the butter using an electric mixer. Then add brown sugar and granulated sugar to the mix. Then add an egg in, mix that in. Then add the other bowl into this mix and...
Braided headbands are all the rage right now. Whether we have the classic movie character Heidi to blame, or the Lolita look that hits the fashion runways every other season, one thing is for sure... this look is feminine and vintage romantic: Perfect for a date or as an addition to a beautiful summer day!
Here are step-by-step instructions on how to write a check. 1. Date the check, and ensure it is dated for the day you intend the recipient to cash it.
Watch this video tutorial to learn how to book the best hotel room for your money. You've spent all year saving up for your dream vacation. The last thing you want is to end up in a hotel room that ruins the whole trip.
Aperture allows you to easily sort the images in the browser pane in several different way. By default, images are sorted by creation date.
Attention Central California Residents: This film shows the actual cutover date from operator assistance to direct-dial (local only) in Fresno and Madera, California.
With this video tutorial, you'll learn how to hack demo versions of applications such that they'll run indefinitely. You'll just need to modify the date and time on your computer. Learn how to use trials of programs without them ever expiring instead of buying the real thing with the hack outlined in this how-to video.