DNS spoofing - how to use the hosts file in Windows XP to block unwanted spyware/popups/etc, block programs from reporting to a site, filter/block/redirect websites, and locally create forward lookups (IP to name resolution in network)
When you're browsing the web, going through emails, or reading a book or magazine, you'll occasionally come across a word or phrase that you haven't seen before. This would be a perfect time to have some sort of built-in dictionary lookup service, but most Android apps lack such a feature.
You may need to perform routine maintenance on your DNS server from time to time by clearing the cache. Servers keep records of the lookups they have performed, and when they become resolved records they can be cleared. Follow the instructions of this how to video to clear the DNS cache in Microsoft Windows Server 2008.
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 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.
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
The author shows how to identify the IP address of a email. He shows how to check the 'Show Original' options in Gmail and in that content how to identify where the email came from and exactly its IP address. Now we can take that IP address and go to any of the many IP lookup websites and trace the original geographical location of that IP address. By following the steps in this tutorial you can easily trace out the origination IP address of an email from which you can extract a lot of useful...
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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.
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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.
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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.
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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER functions.
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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
In this video, we learn how to do a free reverse cell phone look up for call records. This will work for some cell phones, but not all of them. First, go to the website Your Spying Eyes. This is a great search tool where you can look through records of cell phones to find out who someone is and more information about them. There is a small fee you will have to pay to get this information, but it's worth it. You can also look up phone numbers on Google, by simply searching for the phone number...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...
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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to organize your desktop with Microsoft Scalable Fabrics.
Need help tracing an IP address to a location? Well, Tinkernut has a clear and effect way to help out.
Show your love and appreciation (or you distaste and hatred) to your fellow podcasters and review their work in iTunes. Giving reviews in the iTunes Store for podcasts and other things is a great way to help others decide the worth of such items. One way in which podcasters get ‘seen’ more by the iTunes logarithms is by having people leave reviews to podcasts.
Acrobat 9 Pro is an essential tool for creating, reviewing and sharing comments with others you work with. In this video you will learn about commenting PDF files and the methods for including others in your review process with Adobe Acrobat and Adobe Reader. Learn how to use comment tools and review cycles in Acrobat 9 Pro as well as how to collaborate via email or Acrobat.com and share pages.
Video: . IF function
In this video, we learn how to send documents for review by email in Acrobat 9 Pro. First, go to the comment button and choose "attach for e-mail review". A wizard will now open with an e-mail based review. Anyone who has Adobe will be able to open this up. Use a PDF file that you want to use, then click "next" and invite your reviewers by typing in their e-mail addresses or finding them in your address book. Then, add in the subject and send the e-mail. From here, the document will send and ...
In this tutorial, we learn how to use Microsoft SharePoint to view Acrobat 9 reviews. First, go to the comment bar and click "send for shared review". In this wizard, click internal and then click next. Then, click SharePoint workspace, then type in the URL to the server, then click "get workspaces" and you now may have to enter in your username and password. Now you will have to choose your workspace and document library. After this, click on next and click if you want to have it attached fo...
In the changes to the App Store Review Guidelines for iOS 11, Apple has announced that developers must use the App Store rating API. The API was introduced in the iOS 10.3 beta period as something that would eventually become mandatory. Now, Apple has followed through on that promise.
Ratings and reviews apply everywhere, from a restaurant you want to try to a new camera you're thinking of buying and games you might want to play. Podcasts are no different. Reading reviews of shows can help determine which are worth listening to, and your opinion is valuable to other people too. In Apple Podcasts, there are a few different ways to read, rate, and review shows.
Earlier last week, there were a number of fake five-star WhatsApp reviews to be found on the Google Play Store. Now, Gmail, Chrome, Messenger, and Firefox are all the latest victims to be saturated in five-star spam that wrongly refers to the word "game" in reference to non-game apps.
During the last few months, WhatsApp's Google Play Store ratings have been tanking—all the way down to an average of 3.4 stars from the instant messenger's usual average of 4.1. Within the last week, though, WhatsApp has received thousands of seemingly fake 5-star reviews that have bumped up the company's overall average to a 4.4.
With the release of the iOS 11.3, iPhone users have new features to both sift through and look forward to, such as increased battery health information and control, new Animoji on iPhone X, and Health Records in the Health app. A smaller change with the update, however, is also a useful one — a new way to sort App Store reviews.
One thing that annoys the hell out of me is when a popup appears on my iPhone in an app I'm using asking me for a rating or review on the iOS App Store. I like to share my opinion on applications just as much as the next person, but I want to give stars when I'm good and ready. Now, iOS 11 lets me.
Traveling is a rich and rewarding experience. When you don't speak the language, however, your trip can present some tricky obstacles. Google knows this, which is why they will now automatically translate user reviews in Google Maps and Google searches.
In this tutorial, we learn how to write a literature review for thesis writers. The three elements are: discuss the most relevant theory, introduce and define key terms, and discuss recent research in the field. You will need to include the most important literature, quote directly only if you discuss at some length, and use indirect quotes as well. Focus on notions you will use in your empirical study. It should be ten pages or less and sources of all quotes must appear in your works cited p...
Have you ever wanted to give a Podcast maker a piece of your mind? Did they say something that really irked you, or how about something that really inspired you? In this video, learn how to write a review for a podcast in iTunes. Tell that person what you think!
Going to school to become a nurse? Then one of the things you are sure to learn includes proper airway management. Follow along in this nursing how-to video to review simple to advanced airway management. Watch, learn, and practice during nursing lab.
This medical how-to video reviews the basics of casting and splinting procedures. Follow along and learn how to splint and cast the wrist and forearm in case of a broken or fractured bone. A splints and casts can be placed in many different positions and aid in stabilizing injuries. Note that this medical procedure is intended for medical professionals.
Check out this instructional language video to learn how to speak Cherokee! In this lesson, learn how to tell time and review the numbers. This tutorial is great for beginners who want to improve their Cherokee language skills. Practice your Cherokee by learning how to tell time. This video also provides a review of the numbers.
Now that you've created your presentation, you want to make sure it's ready for your audience. This Microsoft Office PowerPoint 2007 tutorial shows you how to preview a presentation on your own computer to make sure it looks as you expect; check the spelling; and make comments on the slides if you want colleagues to review the show first. It steps you through preparing speaker notes and printing handouts.
If you're a master at Autodesk Maya 8.5, then great, but if you are feeling a bit rusty, maybe this review on cleaning up your geometry will help. This video tutorial will help your animated character come to life in Maya by doing a little geometry cleanup. So, for great 3D modeling tactics, check this Maya video out, reviewing freeze transformation, parenting, binding, smoothing...
This video will demonstrate how to properly set our top 4 Rat Snap Traps. The models reviewed include the two most common traps, the original Victor Metal Trigger Trap as well as their newer Expanded Trigger Trap. Also reviewed are two new designs which are both easier and safer to employ. Baiting these traps is also discussed.
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 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.
