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 video we are shown how to clean laminate floors using HG Laminate products. HG laminate powerful cleaner is used to remove grease, stubborn dirt as well as old layers of HG laminate gloss coating. To use, dilute it with water depending on how severe the staining is. Apply with a slightly damp cloth and work it in briefly. Make sure to mop up well afterwards. Another product, HG laminate wash and shine leaves tiny acrylic balls behind on surfaces that you've cleaned with it. These prot...
Make a great online dating profile with this tutorial! Having a good profile is very important because when it comes to catching someone's eye and getting them to contact you. You have maybe a few seconds so your profile has to stand out, be interesting, and personable. Photos are also very important. You need 3-5 nice solo photos to put on your profile. Photos will help a person decide if they are interested in you. Posting good head and shoulder and full body photos is important. Do not use...
Everyone gets an upset stomach from time to time. The first line of defense in this high-tech age is still old-time remedies! Watch this video to learn how to sooth an upset stomach.
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.
Las Vegas is known as the city of sin, a place for gambling, fine dining, and decadence. Now, you can add another notable characteristic to that list: West Nile. You may want to hold off on scheduling your trip to the Sin City — or at least stock up on bug spray — because health officials have reported that mosquitoes in Southern Nevada have tested positive for the virus.
Uber resumed its pilot program for driverless cars after one of its autonomous vehicles crashed in Tempe, Arizona last weekend.
I.M. Healthy Original Creamy SoyNut Butter was recalled on March 4 after being linked to 16 Escherichia coli cases in nine states. Montessori of Alameda preschool in Portland is the latest victim in a multi-state E. coli outbreak caused by the nut-free butter.
Researchers have discovered a "severe vulnerability" that allows attackers to use eBay to distribute malware, and the online auction company has no plans to fix the problem.
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.
Harnessing the power of the sun is something that Captain Planet made cool before it was the go-to for renewable energy. Solar-powered energy is quick and cheap, and can make for some really cool DIY projects. And for those of you wondering what you should do with your old satellite, look no further. Aaron from Sharealikelicence offers up a way to create a DIY outdoor satellite cooker. He started with an old Ku Band dish and covered it with aluminum tape, for better reflection of the sunlight...
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.
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.
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!
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!
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.
With a few basic parts and accessories, you can take the same projector you bought for your home theater and set it up in your car and create a drive-in theater anywhere. This is a great idea for a romantic date or camping trip!
One of my longest videos to date, but well worth it if you have half an hour to kill. This is to thank you all for putting up with me until now what with the voices and poetry and secrecy of my real voice and all.
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...
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...
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.
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...
There are a number of items that you will have to use your mouse and click onto in the process of changing your clock, language and religion in Windows XP. Click START-CONTROL PANEL-DATE/TIME/REGIONAL OPTIONS. This will get you to the window that allows you to change any of these settings. To change the date or the time click on Date/Time icon. Here is displayed the current time. If you change the time here, you will have to click the Apply button to enable the new setting. Set to the correct...
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.
