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 28th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use Excel's rounding functions, how to paste special values – and quite a lot more besides. Specifically, this video addresses each of the following topics:
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 31st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to build frequency tables and simple histogram charts in Microsoft Excel. Specifically, this video addresses the following subjects:
This video describes the process for inserting a 3D animation into a video clip. The video starts by outlining several software programs you will need to complete this project. Don't worry, the presenter gives web addresses and titles for all of the programs needed. After all software is loaded, the presenter beings inserting key frames and x, y coordinates to make the 3D animation move along the correct path. Finally, after the animation path is complete, the video shows how to render the fo...
Apple released iOS 13.0 on Sept. 19 and announced on the same day the release of iOS 13.1 on Sept. 30. But that deadline was pushed up to Sept. 24, and that's why we have 13.1 just five days after 13.0. But that's good news since we don't have to wait any longer for some of the features promised in iOS 13 that didn't make the first cut.
Smartphones and other Wi-Fi enabled devices send radio signals called probe frames to locate nearby wireless networks, which makes them easy to track by listening for their unique MAC address. To show how this kind of tracking works, we can program a NodeMCU in Arduino to sniff the air for packets from any device we want to track, turning on an LED when it's detected nearby.
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 47th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the PMT function to calculate payments. Specifically, this video addresses the following topics:
No matter what Android enabled mobile device you have, if you want to add a contact to it, it's easy and the process of adding contacts (phone numbers, names, email addresses, etc) is practically the same. But how do you do it? Best Buy has answers. The Best Buy Mobile team explains how simple it is to add a contact to your Android enabled cell phone.
Your IP address is what identifies your personal computer while you are online. You may want to change your IP address for privacy, to bypass website settings, to download, or for various other reasons. This tutorial will take you through the steps you need to start surfing more anonymously.
Want to forget about always pulling out your credit card to purchase something on your BlackBerry? There's a little application that can do it all for you? But how? Best Buy has answers. The Best Buy Mobile team explains how to use the BlackBerry Wallet application. This application can store personal information such as credit card information and shipping addresses on a secure website for easy access when shopping online.
In iOS 13, Apple Maps makes it easier for you to organize essential places on your iPhone, allowing you to save locations as favorites that you can access at a glance.
Whether you're white hat, black hat, or some shade in-between, navigating through a network is a core part of hacking. To do that, we need to be able to explore a network to discover the addresses of gateways, interfaces, and other attached devices. When ifconfig just isn't enough, you can steer your way around a network with a convenient tool called Ship, the script for everything IP.
Apple Pay can be used at retail stores, restaurants, markets, and millions of other locations in the US and abroad. It's used to buy everything from clothing to groceries and vending machine snacks, so it's important to ensure that the cards in your Wallet are always up to date with the correct billing and shipping addresses.
A reverse lookup zone will allow you to translate IP addresses to fully qualified domain names (FQDN). This can be a tremendous help against phishing in large organization. Keep your network secure by creating a reverse lookup zone in Windows Server 2003 or 2008.
Learn how to use After Effects CS5's built-in masking tools! Specifically, this clip addresses the creation and interaction of masks.
Learn how to use the official Google Voice app on an Apple iPhone 4! Specifically, this video guide from IntoMobile addresses how to choose a number, create and edit contacts, make and receive phone calls, write SMS text messages and set up push notifications. For detailed, step-by-step instructions, and to get started using Google Voice on your own Apple iPhone 4, take a look.
Fancify your home movies with the techniques demonstrated in this free video software tutorial, which, specifically, addresses how to create PIP, side-by-side & cutaway effects within iMovie '11. For detailed, step-by-step instructions, and to get started using these effects yourself, take a look.
In this clip, you'll learn how to view the list of your previously searched addresses on MapQuest Maps. It's easy. So easy, in fact, that this home-computing how-to can present a complete, step-by-step overview of the process in about two minutes. For more information, including detailed, step-by-step instructions, take a look.
Want to get involved with the information superhighway? E-mail is the best technology to stay connected with friends and family. Use these tips to create your own email account in Gmail, MSN or Yahoo! mail. Keep track of addresses, improve your networking and learn the basics of instant messaging.
In a boring lull after getting home from summer school and need some random play to perk your day up? Watch this video to learn how to quickly shut down someone else's computer from your own.
Big business is on the web these days and you don't have to build a shopping website or blog to get involved.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about basic form customization. Specifically, this video addresses the adding a few navigation buttons and a label to a form. Simple stuff! Take a look.
Have you recently switched to an Apple computer? This video how-to demonstrates three helpful techniques to make your transition from PC to Mac as smooth as possible. Specifically, this tutorial addresses workflow management and keyboard shortcuts. For more information, as well as to get started acclimating to your new operating system, take a look at this OS X tutorial.
In this Windows how-to, Digital Connector Jessica will show you how to change the appearance of your Windows XP desktop. Specifically, she addresses how you can use the classic Windows theme using the XP themes feature. For more on modifying the appearance of your Windows XP desktop, take a look!
If you're like most people running Mac OS X, you've got quite a large number of entries in your Apple Address Book. In this how-to, you'll find instructions for organizing your addresses into groups for easy access in Address Book, other applications, and even sync devices such as other Macs, iPods and iPhones. For more on using groups in Apple Address Book for Mac OS X, watch this video tutorial.
This video tutorial takes a look at using gconf-editor in the Ubuntu Linux distribution. In particular this video addresses what gconf-editor is, how to use it, and what it offers. While this tutorial is Ubuntu-oriented, its lessons will work on other systems such as Fedora and gNewSense, but only if they are GNOME-based. To learn more about gconf-editor, and why you should learn how to use it, watch this how-to.
This how-to video will walk you, step by step, through the process of upgrading the hard drive on your MacBook. More specifically, this tutorial addresses saving your old data by creating a copy, or cloning, your MacBook hard drive with SuperDuper, removing it, and installing the new drive. For precise instructions, press play!
If your cell phone doesn't have internet capabilities, or you're just unwilling to pay the insane price of the web connectivity rates, you can still access Google as long as you can text message. Google responds to text messages with the best match, so it's more ideal for looking up phone numbers, addresses, weather reports, or a word definition. Watch this video cell phone tutorial and learn how to search Google on phone through SMS text messages.
If you're baffled about how to get your own photographs into your Microsoft Office Word 2007 documents, watch this instructional video. A Microsoft employee who uses Word himself shows you how to insert your picture or digital photo into a document and format it the way you want. He addresses questions about terms like "inline" and "floating," and explains how easy it is to set up a watermark.
Segment on how to season a metal untreated wok from the Master Chef Apprentice Training Package. Brought to you by WokFusion, this tutorial addresses the skill and preparation that must go into preparing Chinese food.
Learn how to follow proper netiquette rules. You may be a model of decorum in person, but a bonehead online. Check out how much you know about Internet manners.
A little-known setting on your iPhone gives you the power to change the color of certain contact names and email addresses when drafting an email. Customizing the color works well for visually separating contacts at a glance, and it can even help you from sending an email to the wrong person.
When it comes to attacking devices on a network, you can't hit what you can't see. Nmap gives you the ability to explore any devices connected to a network, finding information like the operating system a device is running and which applications are listening on open ports. This information lets a hacker design an attack that perfectly suits the target environment.
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 ...
This video tutorial goes into how to set up composite textures for terrain when designing a landscape using Autodesk 3ds Max. Part Two then goes into some issues that users have had exporting their ADT terrain, and addresses the solutions to these problems.
In this tutorial, we learn how to get started out on Twitter. First, you will need to go to the main website and sign up by entering in your personal information. After you do this, you will be asked to enter in your other e-mail addresses to see if your other friends are on Twitter as well. After this, you can change your settings to change the icon that shows up on the site. Next, you will be able to start to follow people and enter in what you want your tweet to say. Go through the differe...
In this tutorial, we learn how to establish an account on Twitter. First, log onto Twitter. After you get onto the website, click on the sign up button, then enter your screen name and other personal information in. When you are finished signing up, you will be able to change your settings and import friends from your e-mail addresses. Under your settings, you will be able to change the background and colors on your page, as well as your icon picture. Next, start to follow people on Twitter, ...
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.
In this Computers & Programming video tutorial you will learn how to hack into a compuuter, the easiest way. Go to start > run, type in ‘cmd’ > OK. To find the IP address of a website, type in ‘tracert myspace.com’. This example is to find IP address of myspace.com. Then all the IP addresses of the website will be displayed. If you want to shut down a computer, now you type in ‘shutdown’. A remote shutdown dialog box will open up where you put in the IP address. That’s all. The ...
In this video from flytenewmedia we learn how to send from separate email addresses using Gmail. This is great for small businesses. To make it look like you are sending it from your other email address, and not Gmail, follow these steps. Click on Settings then click accounts. You need to add another email address that you own. Click on next step. Now Gmail will send a verification. click on the inbox and click the link within the gmail that you just received. Now it will say confirmation suc...
In this video, our author, atomicinteractive, shows use how to use Fetch FTP to upload a temporary webpage. Please make sure your directory has the html file. Please find your email with ftplogin information. This will also show login information for the control panel and creating alternate email addresses.
