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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.
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 588th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine whether an employee is exempt from a tax using a VLOOKUP in an IF function, and if not use a second VLOOKUP lookup query to look in tax tables to look up and calculate the tax
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this Family video tutorial you will learn how to teach kids how to eat right. First you got to educate your children. Robin from greensmoothiegirl.com presents this video along with her kids. The 1st step is to educate the kids. For example, in the video, she explains the functions of the parts of a wheat kernel. She tells them that the white bread is made up of only the glue from the kernel which carries no nutrients. Whereas, the brown bread is made out of the whole kernel and it carries...
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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.
New to 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 Excel tutorial from ExcelIsFun, the 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
New to 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 Excel tutorial from ExcelIsFun, the 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.
New to 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 Excel tutorial from ExcelIsFun, the 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...
New to 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 Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
This video is a tutorial for a music producing software program called Ableton Live 8. In this tutorial he shows you how to apply effects to effects to audio using the audio effect rack function. The way this function works is by being dragged into the bottom of the program and being applied as a place to hold various effects. Using the effect rack you can modulate and manipulate the sound waves in the effect. This is a very convenient tool to have in Ableton because it allows you to have mor...
This video instructs you how to use the "Finder" Button if you own a Mac on OS X. The "Finder" window shows the Mac user the contents of the hard drive. It describes functions of the Finder folder: i.e., adding an untitled new folder in the Finder file. It also discusses how you can view the "Finder" in a variety of layouts: grids, lists, etc. The video shows you how to use the buttons on the upper left hand corner of the "Finder" screen to maximize, minimize, or close the window. It also dis...
This how-to video produced by Photoshop Universe gives step-by-step instructions on how to batch automate a process in Adobe Photoshop. With this tutorial you'll be able to learn to correct white balance, enhance colors, resize, and save for the web whole folders' worth of images in one go. The first step to doing this is to open up one of the images in your folder and correct the white balance, enhance the colors, resize the photo and save. The next thing you want to do is to record all of t...
Have you ever gone to websites and seen an entire URL address you have to copy and paste into your browser window? Is the thought of having such an inconvenience on your page making you wish there was a better way? Today is your lucky day because success is going to teach you step by step how to make a HTML hyperlink that user of your website can use to navigate to different portions of your website without the inconvenience of copying and pasting long dragged out links.
Using GoLive CS2, you'll learn how to create some CSS-based rollovers. This is really an easy way to create some rollovers, using CSS, which is an incredibly useful and powerful way to style and design your website pages. In this GoLive video tutorial, learn how to style not only your links, visited links, and active links using CSS, but you will also see how to give your links a rollover or hover style as well. You will quickly see how much more you can achieve by styling your links using CSS.
In order to block websites on your computer, you will need the address for the website that you want to block. Gather that information first. Then, click on Start. Then, go to Run. Next, type in the following: c://windows/system32/drivers/etc. Click OK.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 92nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the TINV and TDIST functions to test a hypothesis.
This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
Here you will learn how to use the double space function in MS Word 07. To use the double space function in MS Word, do the following: Open MS Word 07. After typing in some text, highlight the part which you want to double space. Click on the Icon that says "Line Spacing". Click on it and scroll down to find 2.0. Click on it. Now your work has been double spaced. A shortcut to do this would be to click Control and 2, and it will automatically double space everything for you.
This video tutorial gives you a way to access websites that you can not normally access because of a web block or filter. What you need to do is click on the ‘Start’ button and then click on ‘Run’. In the small window, type in ‘cmd.exe’; this then opens a black window. Then type in ‘ping’ and the website; this gives you an address that you type in directly to your web browser, granting you access to a normally blocked website. This comes in very handy when you are in such locations like schoo...
For all you Facebook-addicts out there (or anybody else that needs to access blocked websites anywhere they want), this is a video that you will want to watch. In just a minute and thirty seconds, any ordinary person can learn how you can access any website they want anywhere they want, bypassing any blocks and firewalls that the network administrator has put up to stop users from getting to their desired website without using complex computer commands or other complicated methods.
There're plenty of great ways to get traffic, especially this off-site optimization technique using classified ads to point website traffic back into your site itself.
A CNC router machine is probably the most useful tool a hobbyist can own, but the price for a CNC machine on the market is way more than the average hobbyist is willing to spend. You can build your own CNC with very basic tools, little knowledge of machinery, mechanics, or electronics, but be warned, these machines are inherently dangerous, so wear the proper protection and use common sense. At the very least, read the instructions and precautions on every tool you use.
Some very cool features that you can do at Zamzar.com, and its all free. Check out Zamzar for some Great URL integration functions.
This AutoCAD 3D tutorial covers some fun with AutoCAD in making 3-D graphics using 3-D functions and rendering solid form.
This tutorial shows you how override functions inside UnrealScript for Unreal Tournament 3 (UT3). Specifically, create a customize trigger that plays a sound instead of triggering an event.
This video shows you how to use the basic functions of a Mini DV Camcorder and apply its various settings.
A spreadsheet software wouldn't be much good if you couldn't use formulas and functions on your data. This tutorial goes over how to use them in Numbers '08.
Ever since iOS 7, you could ask Safari on iPhone to show you the desktop version of a website, and in iOS 9, it became even easier to do. However, it's always been a hidden feature, something you wouldn't know is there without reading articles or tips online telling you what to do. Apple's iOS 13 update shines a light on it so everyone will know it's there, ready to use.
It's been a while since I wrote up an article for this series but I did say that I'd be covering some WinAPI. So if you're interested in programming for the Windows platform, hop aboard and follow along.
The digital pen on the Surface Pro 4 and Surface Book is an indispensable tool for serious note-takers and artists alike.
Developing GUI apps in python is really cool. I ask those who understand the language to help convert some of the command-line or console programs or apps ( I mean programs that are useful to a hacker ) to GUI. I know GUI makes us lazy and not wanna learn but we should all know its fast. Today's tutorial is on p2p chat app I developed last week and decided to share it with the community since its kinda cool.
Apps that save your passwords have been around for quite a long while. But apps that complete the entire login process automatically? Now that's a different story.
This tutorial video will show you Facebook generated temporary password to login app or website through Facebook. This may be harmful if the app or website uses our Facebook detail unethically. So to avoid such situation Facebook generated temporary or one time password for login. So you don't have to share your original Facebook password. Watch the video.
Welcome back my fellow army of hackers! Today we'll be hacking a website. Hacking is technically not the right word used here. It should be defacing! So we are going to deface a website...
If you want to create a shortcut in Mac OS X, or if you want to change the default hotkey for a function on your Mac computer, check out this quick tip from Tekzilla. It will help you learn how to access the system preferences on your Mac and gain access to the full list of keyboard shortcuts, allowing you to remove, add, or change all the hotkeys on your Mac.
In this video, learn how to alter the center of gravity within a coke can so that it leans on its side like the Leaning Tower of Pisa. Later, learn how to balance a coin on a dollar bill. Take a look at how this is done and learn a little bit about how gravity functions in the process
The autofocus functions showing up on new DSLR cameras are quite useful if you know how to use them. The Nikon D3100 is no exception, and this video will teach you about the different auto-focus modes and which ones you should use to make your pictures look as good as easily as possible.
An electrophorus is a type of capacitor that generates electrostatic energy. Most of you probably know this force as static electricity, the domain of door handles and polyester shirts. It can be used for all sorts of other fun science experiments though, and this video will show you how an old hard drive, some plastic, Styrofoam, foil, a cat, and other simple materials can be used to make a a simple functioning electrophorus.
Dead or hot pixels are one of those annoying camera problems that won't make you buy a new camera but will piss you off for years. There's a free solution that may work for you though if you have a Canon 5D or 7D, and this video will show you how to do it with the sensor cleaning function.
