If you're just getting started in photography or if you're looking to learn a little bit more about your camera, then you may have run into the term "Aperture" or "Aperture Values", or those weird number numbers. Aperture is in the lens of your camera and determines how much light enters into the lens itself and helps to determine your focal length. In this video you will get a small lesson on what Aperture is, and how to calculate focal length and aperture values.
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 682nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to average times values that were exported from a database as text values instead of number values.
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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula.
We all get them: a friendship bracelet, a sweet little greeting card with warm wishes, or a tiny pendant that means a lot to us but is just too darn small to store anywhere without getting lost.
Looking for a primer on how to create and work with array formulas 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 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)
Are you in college? Too lazy to make a proper meal? Too cheap or poor to go out to dinner? But, still have that sophisticated pallet, this video will show you exactly how to eat like rich person and make these delicious meat lover wraps to enjoy any night of week. Don't be afraid to enter the kitchen after watching this video you'll be eager to have dinner guest.
To start off the process of publishing your access database online we first look at a sample MS ACCESS database with typical formats and a online searchable application where users can search by library name or city and get details of the library. There are 3 steps to publish the database. The first step is importing data which can be done through clicking on the file menu and then click on import data through a Microsoft Access Database. Now select the file you want to import through the bro...
You can order high quality Kodak prints of your photos right from iPhoto. Just choose the ones you want printed, enter the number you want, and pay.
Learn what jeans best fit your body, and what jeans should never enter your closet in the first place. This "Everything you need to know about denim" video is slightly opinionated but still GREAT advice. It's always a pleasure to have our friend William Sledd of Ask a Gay Man dishing tutorials.
In this video we learn how to find your IP address with the Command prompt. First, go to the start menu on your desktop. Then, find the run box and type in "cmd". After this, hit "enter" and then a black command prompt will show up on your screen. Next, type in "ip config" and then hit the enter button again. Now, a list of information will appear on the black screen. Look down the list to find the IP address listed on the page. Once you have this, you should write down your IP address and th...
This video tutorial belongs to the Computers & Programming category which is going to show you how to reformat your computer step by step. Go to BIOS by restarting your computer. Go to BOOT menu, select CD/DVD ROM and press f10 to save and exit. Now insert your operating system CD, don't let it run, restart your computer again and keep tapping f8. When the set up page is displayed, press 'enter' to set up Windows XP. Select your partition and press D to delete. Then press L to continue deleti...
If you want to create a Pareto Chart for categorical data in MS Excel you should first have your data input into Excel already. From your data, you should highlight the cells that you want to count the frequency for and in the frequency box you should type in =COUNTIF and highlight the data you want the frequency for and put in F4 and then press , click on cell to the left and click enter. Now this will work all the way down. If you have not sorted it, you can right click and then click sort....
In this video from wadeputtii we learn how to authorize or de-authorize a computer on iTunes. Go to iTunes, sign into your account. Now click on Share and you will see Authorize Computer or Deauthorize Computer. If you want to authorize, click on that and enter your apple user email address and password. Then click authorize. If you have a new computer or you want to prevent someone else from using your account on your computer and you want to deauthorize your old computer, go to Share and De...
FROMAN1115 teaches you how to change your NAT type to Open on your PlayStation 3. On the PlayStation 3, go to Settings-Network Settings-Settings and Connection Status List and write down your IP. Go to your PC and start your internet browser. Type in 192.168.1.1. This will bring up the router settings page. Go to Applications and games and then DMZ. Check the first box that says Enabled. Enter your IP address below and click ok. Your settings have been saved and you can enter a new internet m...
Open After Effects. Create a new composition by selecting "Composition" and "New" from main menu. Use default NTSC DV preset. Keep 30-sec default duration unless you need more time for the video scene to edit. Import several video clips by selecting "File," then "Import" from menu. Navigate to video files you want. Import at least 3 different video files using Import File dialog box. Double click on 1st video file you want to add to your timeline. The file will now open in a video monitor win...
Open your internet browser, type in the address bar 192.168.1.1 and enter your user name and password to access. Look in the right and search for Port Forwarding / Port Triggering. Click on Add Custom Service. Type a name to the service, like XBox Live, now access HushedCasket and scroll down to see the ports you need to open. Go back to the setting and select UDP in Service Type. Put 88 in Starting Port and Ending Port. Go to your XBox and enter in System Settings, go down to Network Setting...
Learn how to delete your old Yahoo account from this video in simple steps. First open your web browser on your computer and go to the Yahoo home page. Now sign into your account using your username and password. Now copy and paste this link "http://edit.yahoo.com/config/ delete_user" in your address bar. Enter your password to confirm the deletion of your account. Finally enter the code to confirm and delete your account.
Learn how to split a circle into segments with Xara Xtreme. First select the shape editor tool. Drag the tool to the circle. The dialogue at the bottom communicates what steps to choose next. Holding the Ctrl key drag a straight line within the circle, click on the selector tool (yellow arrow on the left of the middle row) to enable the option of selecting. This saves 1 line on drawing layer 1 also and enables the marquee (flexible box) that you want to manipulate around the circle encasing t...
It was bound to happen with all those numbers floating around in your brain – you've forgotten your Windows password. Here's how to recover it.
This video includes instructions on how to get your PlayStation Portable (PSP) onto the BGSU wireless network.
Wiping our shoes off as we enter the home reduces the amount of contaminated dirt tracked in. Large mats, that cover two or three strides, will ensure that even those that refuse to wipe will leave most of the dirt clinging to their shoes on the mat rather than your carpet.
Android 11 won't be available as a beta update for Pixel devices until May 2020. Until then, the only way to try the latest Android version is by manually installing it. Usually, this means carrier models are left out since their bootloaders are locked, but there's still a way to get it done.
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.
If you somehow forgot the pattern, PIN, or password that locks your Android device, you might think you're out of luck and are destined to be locked out forever. These security methods are hard to crack by design, but in many cases, it's not entirely impossible to break into a locked device.
In the last iteration of how to train your python, we covered basic string manipulation and how we can use it to better evaluate user input. So, today we'll be covering how to take user input. User input is very important to scripting. How can we do what the user says if we can't tell what the user wants? There are multiple ways to take input, we can give the user a prompt and take input from them directly, or we could use flags/switches, and take their input before the script is even execute...
Welcome back, my amateur hackers! When you are using and administering Linux, it is important to be conversant in the use of the log files. As you know, log files are the repository for much information about our system, including errors and security alerts.
Hello Everyone Today in this post I will teach you how to get a banner for your terminal.(Video Available at the End of the Post) To get a banner first we need "figlet" and then we have to configure it. Its Easy ..
Welcome back, my hacker apprentices! Although there is a multitude of different hacker types, the one target they all share is the database. I often refer to the database as the hacker's Holy Grail, or the ultimate prize for an effective hack.
Welcome back, my fellow hackerians! Today we'll be hacking Facebook profiles on your local network. You may think, "How is this useful, nobody but me is using my network." Well, you can use this on other Wi-Fi networks that are available for free (like at Starbucks) and crack their precious Facebook profile!
MAC addresses (not to be confused with Macs) are unique identifiers assigned to network devices in order to access the internet. Hotels use these Mac addresses in order to check if a registered patron has agreed to their terms and conditions, how much bandwidth is being consumed, and of course, whether they've paid or not.
We know it feels like you're surrounded by a wall of pink and red on Valentine's Day, especially when you enter any retailer, but you have to admit these two colors evoke quite the aura of romance.
If you like chips and don't have a massive overeating problem, you've probably had this problem: you're eaten half your bag of chips, but you don't have a bag clip to seal the bag and protect the freshness of your chips! Enter this video, in which a charming young Israeli teaches us how to fold a chip bag with an airtight seal without using a bag clip. You'll never have to eat a stale chip again!
Recycling things isn't nearly as efficient a means of conserving resources as reusing your waste material in it's current form. Enter this video. It will teach you how to make an awesome little trash can / waste paper basket out of perhaps the most appropriate material of all: old newspapers!
The TB-303 is nothing short of legendary on the electronic music scene. It is possible there would be no such thing as house music without it. They are rare and extremely complicated, so if you're lucky enough to have one you should pursue whatever help you can get on playing it properly. Enter this video, which will teach you how to quickly and easily program your 303 and get on your way to making phat old-skool tracks.
You can set up a dynamically driven Google Map widget that can display any sort of information - such as displaying a user's location based on what they have entered into their profile. This is a useful and interactive feature for any PHP/MySQL based website.
A great tool for any system administrators, the iPhone (or other Apple wifi device) app Ping a Majig allows you to enter in the IP addresses of websites. Then you can keep checking on them to make sure they are running smoothly and operating correctly. You can click on the website for more data regarding pings and site health.
This is an introductory video for those looking to enter the exciting and profitable world of 3D graphics. It walks you through the first few steps of creating 3D animations using Apple's 3D modeling software Cheetah3D. You will learn how to animate and model simple images, and afterwards be well on your way to creating more advanced and salable 3D images.
In this clip, learn how to enter the World Warrior tournament in Street Fighter IV and beat your opponents. With these tips you will become a master and even if you've been playing since the arcade days, you may still need to review the fundamentals to have success in the home version. So, check out this video from IGN and get the basic rundown of this new version and find out exactly how to beat it.
The 2010 head units for new Toyotas are very versatile. Not only can you use them as a radio and speaker phone, but you can also use them as a GPS. In this tutorial, get up and running with your new touchscreen and make sure you never get lost, no matter where you wind up.
