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.
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.
Adobe is best known for its photo and video editing software, but they also have a number of lesser-known apps that you may be interested in. Adobe Fill & Sign, available on iPhone and Android, is the best way to electronically fill out important documents on your smartphone with a third-party app.
You can't call yourself an Android pro without knowing about Recovery or Download Mode. These menus are critical to do more advanced tasks on your phone, include sideloading software updates and un-bricking a device. But this year, Samsung changed the button combinations that will get you there.
The Google Assistant is great about understanding what you actually mean, so you don't have to issue exact commands like you do with Amazon Alexa, for instance. But even though it's a master of colloquial speech, it could still be better, and that's where shortcuts come into play.
Google's Chrome Remote Desktop, which allows for remote access to your personal computer from your smartphone, has been out for almost a year now. Sadly, it's only been available for Android devices—until now. So, if you got an iPhone (or other iOS device), you can now access and control your computer directly from your smartphone or tablet just like with Android.
When you're on a limited data plan, bumping up against your monthly cap is a major concern. Overage fees are incredibly high these days, and being throttled down to 2G coverage almost renders a smartphone completely useless.
Yosemite is definitely an improvement over Mavericks, but there are still some painfully obvious and annoying bugs that occur within certain apps.
Apple introduced Touch ID on the iPhone 5S back in 2013, which let you unlock the device with your fingerprint. While it was an impressive feature, it could only do that one thing—unlock the device.
Unless you're waiting in line for your iPhone 6 or iPhone 6 Plus, it's a sure bet that you'll be sitting by at home for your new device to get delivered today.
There are a lot of instances where we find ourselves typing virtually the same phrase that we've typed many times before. Whether it's the standard spousal reply of "I'll be home in a few", or a work-related phrase like "I'll have that to you by the end of the day", typing phrases like these can feel very redundant at times.
While it may not serve much of a purpose here in sunny Los Angeles, it's still a good idea to keep constant tabs on the weather forecast, because you don't want anything to rain on your parade.
What's the easiest way to keep track of your website passwords? Maybe in a password-protected document on your computer? Makes sense.
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....
1. Describes how to setup a VPN connection on Windows XP. 2. Goto Start-> Control Panel-> Network connections.
In this video the teacher shows us how to use a TI-84 plus graphing calculator to graph a function, adjust the view window, and determine the values of several types of critical points on the graph such as x-intercept, y-intercept, local maximums, and local minimums. After entering the function in the Y= editor she presses the ZOOM button and selects Z-Standard this adjusts the view window to a range of -10 to 10 on both axis. To find each of the critical points requested the teacher uses the...
If you've received the "hal.dll is missing or corrupt" error message from your Windows machine, then you're in luck! This video will show you how to correct that problem with the Recovery Console tool that comes with the Windows 2000 and XP CDs.
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...
If you've ever wanted to know how to write checks in Intuit QuickBooks program, this instructional is for you. To write a check in the QuickBooks program: Select banking from the menu bar, and then the write checks command. Select the checking account for which the checks will be drawn from the checking accounts drop down menu. Assign the check a number if you will be printing the check. If you are printing the check, make sure that the "to be printed" box is checked. Enter the correct date f...
Nowadays many schools and colleges have blocked the social community sites from accessing them through school computers. The video shows how one can access to these sites using a command prompt.
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.
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.
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...
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 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...
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.
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 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.
So, you've entered the world of cake decorating and fondant icing! What is one to do with their projects once finished? In this video, learn from the best ways to store your fondant icing projects. Take some final precautions and store your cake the best way possible. After all, your time, effort and creativity have made it very special!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.
