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 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...
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 345th installment in their series of digital spreadsheet magic tricks, you'll learn how to locate the first positive number in a list and assign it the number 1.
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 197th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a specified total score with weights assigned to different categories.
In this how-to, Gary Rosenzweig shows you how to use GarageBand to make your own iPhone ringtones. You can use music and effects from GarageBand, or import your own sound files. Then you can transfer them to your iPhone via iTunes and assign them as your main ringtone or specific ringtones for specific contacts. You can also go to http://macmost.com/iphoneringtones/ to get some free ringtones to use.
Learn how to draw and paint snowy, rocky mountains for manga, anime, comics and illustration in Photoshop. This step by step video shows you how to do so by laying down the base color, blocking in shape for painting, assigning value and color composition, and refining detail for the final concept painting.
Learn how to assign and change keyboard shortcut assignments on your Mac.
Schools today assign 50% more homework than when your parents were students. Make your workload lighter with these simple tricks.
The video shows us how to count the cards using the Hi-Lo system. This involves steps and the first step is to assign the values to the cards. Take any deck of cards and then assign the value '+1' to the cards from 2 to 6, value '0' to the cards from 7 to 9 and the rest of the cards Ace, 10, Jack, Queen and the King are assigned the value '-1'. This is a helpful strategy. When the count is higher, there are more high cards than low cards in the remaining cards. When the count is lower, there ...
Jotting quick notes can be a pain. There have been countless occasions where I've needed a pen and paper to quickly write something down, but either didn't have them near me or was doing something on my phone and neglected to remember.
This tutorial shows you the basics of employing animation in your Maya project. Set up a series of rigid bodies, like dominoes, and then have them fall, one after the other, using the techniques outlined in this video. Make sure you've assigned them the proper attributes!
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 50th installment in his "Excel Statistics" series of free video lessons, you'll learn the basics of probability:
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.
After you generate the world and choose a location for your fortress in Dwarf Fortress, it's time to prepare your party of seven dwarves to journey there. This video will show you how to assign their skill points and choose the right items to help you reach the fortress and succeed there.
In this video tutorial, viewers learn how to add to the Fire Mozilla browser tabs. Begin by going to the Firefox Mozilla add-ons site and search for "colorful tabs". Click Add to Firefox to install it onto your web browser. Once installed, the browser tabs will be randomly assigned to a color. In the add-on options, users are able to configure the color scheme, selected tab and miscellaneous. This video will benefit those viewers who use Firefox Mozilla as their web browser, and would like to...
If you have a group of iPhone users to manage, whether for work assignments, planning a trip, or organizing an event, Reminders might just be your new best friend. With iOS 14, the app now lets you assign reminders to contacts, so everyone knows what they're supposed to be working on.
This is the classic game of musical chairs with a little fruit added. You Will Need
Want to let the world know who made your photo? Then choose File Info. Here you can assign a title, an author, a copyright, and a Web site. No image should go out without a visit to File Info. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step i...
This quick Blender 2.5 video tip tutorial demonstrates how to use multiple background images. This feature is very useful and allows for layering images in the viewport and assigning separate images to specific viewing angles. Without the need for multiple viewports. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video ...
Learn how to use a 'do while loop' in your Java programming. 1. Set up an 'int' variable named 'counter' and assign it a '0' value. 2. Set up a standard 'do' loop. Make sure to add a counter, so the loop will end 3. Then write the 'while' condition. Make sure that you set the condition to the same variable name that you used in the counter from step 2. Set the variable to '=' 10 (or any number desired)
Here, see some tips on the collections and smart collections in the Adobe Bridge. Bridge has a lot to offer and is a great organization tool. Collections and smart collections are great workflow features available to you. In this video tutorial, learn about organizing your files without messing up your folder structure and automatically bringing files in that you want based on your settings you assign to that collection. Check them out and learn a great new feature of Adobe Bridge CS4.
When the climate changes, so do all the things that rely on the climate, including people, plants, and pathogens. A European study recently took a broad look at what kind of microorganisms are most likely to be affected as climate change heats, cools, dries, and wets the world around us.
Rooted users have been able to remap their hardware buttons since the earliest days of Android, allowing them to change the functionality behind one of the most centralized methods of interacting with a phone or tablet. Up until now, however, non-rooted users have been left out in the cold, meaning these buttons could only perform the functions assigned to them by the device manufacturer.
If you're a fan of double-tap to wake gestures, you're going to love the newest app from ElementalX developer Aaron Segaert. On supported kernels, it allows you to associate custom apps and activities with each of the wake gestures you've set up, which will immediately be launched even with the screen off.
I once had a collection of over 300 different wallpapers for my MacBook, set to randomly change every 30 minutes. Needless to say, my desktop never got boring. Wallpapers can facilitate a mood, imply a political stance, or just add aesthetic appeal, so having to manually change them on my iPhone is a bummer because of how many times I want a new home or lock screen look.
Like the buttons on your computer's mouse and keyboard, the Home key on your Samsung Galaxy S4 serves a vital function in navigating through your device. It can get pressed dozens of times a day, going through hours of use and abuse.
In this tutorial, we learn how to add delay to monitor mix on Studio Live 16.4.2. First, hit the mix control and turn up channel 15 for some volume. Next, you will assign a digital delay to effect a. To do this, hit the effects button, then page down to the first page and you will see the value knob. Put in a mono-delay, then hit recall. You can manually adjust the decay time, or it will automatically adjust to the tempo to the song. When finished, add this to your music and play back to see ...
In this tutorial, we learn how to use task types in MS Project 2007. First, open up the form view of all the different tasks you have. Now, look at the unit task type and see if it's effort driven or fixed units. Now, change what you want the task type to be and then click on the next button. Assign a second resource if you need to, then change the duration if you need to as well. Continue to change the task types depending on what durations you have then make sure to save this. Double check ...
In this tutorial, we learn how to set up the calendar in MS Project 2007. First, open up your calendar and then click on the "work week" tab. Now, set your working times into the slots for each different day. Make sure you set your start and end times correctly. Now, go to options and change the default start and end times so they match your working calendar. When finished, save this and then start to enter your task information to each different slot. When you enter this, the start and finis...
The tutorial shows how to use trigger grouping in QuicKeys, which essentially means instead of assigning a single trigger to activate shortcuts, you can use a group of keys as a trigger. In this example, you'll see how to set up a macro to launch Calculator by simply typing the letters “cal” (short for Calculator) in the Finder. Whether you're new to Startly Software's popular macro and automation application or are merely looking to pick up a few new tips and tricks, you're certain to be wel...
This video demonstrates how to change a drive letter to a certain drive in your Windows 7 computer. On you Windows 7 computer, go to Start > Control Panel. In the Control Panel, select System and Security then open the Administrative Tools. Look for and open the Computer Management tool. On the left side pane of the Computer Management window, select Disk Management. Look for and right click on the drive you want the drive letter changed. Select 'Drive Letter and Paths...'. Click change and s...
This is a tutorial video on uploading HD quality video onto YouTube. The video is simply a screen shot view of the YouTube home page. As the narrator goes through the steps the cursor moves and clicks on what you should click on. He advises to click on upload; he clicks to choose a video. The video must have a certain resolution to be assigned HD video. He indicates that YouTube will accept a variety of file formats to upload. You must use the 44.1 kHz frequency rates to get the best resoluti...
Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT() functions to pull text from Microsoft Excel 2007 cells & assign them to different columns.
In this video by Task Tutorial we will learn how to create a simple flash button with sound. The first step is to create a text layer in flash, then convert your text into a button, then double click on the button to enter a sub menu and create a new layer for sound. Then simply add some sound files from your library and assign the sound file. Now you can change the color so you can see when the button is pressed. Then finally go back to your main scene and test your Flash movie. Using these ...
Many of us install TikTok just to see what it's like, but most of us stay for good. Inevitably, that involves creating an account. The problem is, TikTok assigns you a username, usually based on your email address — an odd choice for a platform made for self-promotion. If you're not happy with your random TikTok handle, you can change it.
When you make an awesome song or beat that you're proud of in GarageBand for iOS, one way to show it off is to turn it into a ringtone or alert tone for your iPhone. That way, anytime you get a phone call or a notification, your musical creation will sound off, and everyone around you will hear it in all its glory. Plus, it's way cheaper to make your tones than to buy them off of iTunes.
The world around us keeps getting smarter. Not only do we have advanced AI services like the Google Assistant, but now we've got the Internet of Things connecting physical objects to the digital world. It's amazing when you think about it, but the real sci-fi stuff starts to happen when these two technologies intersect.
Since it was released last fall, Super Mario Maker has offered us a glimpse into the minds of some of the most evil people on the planet. The game, for Nintendo Wii U, lets players create their own Super Mario levels using a deep list of objects, enemies, and green pipes, which can then be uploaded for anyone to play.
Welcome back my friends !! Today we'll go through the second part of this C# series
Certain contacts on my iPhone have special ringtones so that I know exactly who's calling or texting without looking at my screen (like Adele's "Hello" for all my exes). But when my phone is silenced and tucked away in my pocket, these contact-specific ringtones can't really help me out. Luckily, there's something else that can—custom vibration patterns.
The sovereignty that's granted when we jailbreak our iOS 7 devices can only be described with one word—liberating. With this freedom comes countless themes and apps that let us manipulate our devices to really own them and turn them into something that is truly ours.