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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH functions.
In this clip, you'll learn how to navigate and use the basic features and functions of a Samsung Epic 4G mobile phone. Whether you're the proud owner of a Sprint Epic 4G Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration of the rooting process and detailed, step-by-step instructions, and to get started using your own new Epic 4G phone, watch this helpful how-to.
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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.
This video demonstrates how to open up the command line prompt and various commands which you can use to make your Windows experience easier. After clicking on the "Run" option from the start bar of Windows, you can then type "cmd" into the box, opening up the command prompt. The appearance of the command box can be changed by left clicking the small icon at the top left, going to properties, and changing the appearance. One useful command in the prompt is "ipconfig", which you type into the ...
In this clip, you'll learn how to pre date or post-date content posted to your WordPress blog. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS functions.
Looking for a quick guide on how to brighten your smile with Photoshop? It's easy. And this clip will show you precisely how it's done. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
Need some help figuring out how to rotate and crop images in Adobe Photoshop CS5? It's easy. And this clip will show you precisely how it's done. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
Want to remove pimples, wrinkles and other blemishes from a portrait? With Photoshop, it's easy! And this clip will show you precisely how it's done. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, and to get started removing blemishes from your own digital photos, ...
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 713th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the max number of items in succession in a column of data using the FREQUENCY, IF, MAX and ROW functions.
If you've downloaded Autodesk Inventor and are kind of confused how everything is supposed to work, you're in luck! In this great video series you will learn all the steps how to do some of the basic functions of Inventor, including: Extruding the bass, shelling the brick, adding nubs and more!
In this video, we learn how to add a feed burner count in Thesis navigation bar. First, go to the custom file editor, then click "custom_fuction.php" and then click "edit selected info". After this, you will get an error message. Now, go to your FTP and type in the path "/public_html/adwordsshop.com/wp-content/themes/thesis_16/lib.functions/launch.php". Once you do this, open launch.php, then copy the code from the website and paste it into the PHP site. Then, copy the entire thing and paste ...
In order to build Google Chrome extensions, you will need to familiar with scripting and codes. These are small programs that add additional functions for programmers. It is a compressed directory. These files must have a particular name: i.e. "manifest" (manifest.json). An extension will have at least one of the following: browser actions, page actions, content scripts, and utility web files.
In this video, we learn how to check your engine health with a PICO scope. First, you will want to attach your computer to the PICO scope that is connected to your vehicle's "brain". After this, you will run through the different sections of the car to see how each of the different functions are running. Compare the results you are getting to a chart that shows what the healthy charts should look like. As you go through these, record the results you get, then print them out if you need to. Wh...
Want to sign up for a new WordPress account? This clip presents a complete overview of the process. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.
Want to link to your favorite blogs on your WordPress website? Create a blogroll! This clip will show you how. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.
Want to know how to add contributors to your WordPress blog so other people can post to it? This clip will show you precisely how it's done. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.
In this video, we learn how to control your Windows PC with an iPod Touch or iPhone. First, go online and search for 'Logitech touch mouse server', then download and install this software. Now, go into the software and launch it on your phone. You should now be able to use your computer and your phone simultaneously as long as you have a wireless connection. Now, you will be dragging the mouse on your phone and it will be working on your computer. You will have full functions while using your...
Occasionally you can run into problems when you try to wrap, bend or twist 3D text. This is usually because the faces or sides of the text need more segments so that the text can be deformed cleanly. This tutorial shows you the main controls for getting clean text every time. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. Fo...
In this tutorial, you'll see how to create a dynamic cascading text animation with C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
This tutorial covers building a brick wall and destroying it nicely using SilverBullet for Cinema4D and a little custom Xpresso. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
In this tutorial, you'll learn how to use Cinema 4D and Mograph to create spinning text with specular highlights. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
Learn how to model a fairytale Book in Cinema 4D with this video walkthrough. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
Need some help figuring out how to generate proxy objects in RealFlow? Never fear. This guide will show you how it's done. Whether you're new to RealFlow's popular fluids and body modeling software or are just looking to get better acquainted with the application its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own RealFlow projects, watch this 3D modeler's guide.
This clip discusses how to use the basic modeling tools within C4D to create a classical pillar and egg. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
In this tutorial, you will learn how to utilise UV maps for both root colour and hair length. This guide also offers a quick look at polygon selection tags and organising a scene with hair objects as well. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cin...
In this tutorial, we learn how to unlock the iPhone 3G to work on other carrier networks. First, purchase an ATT Universal unlock SIM card and cut it so it is the same size as the SIM card in your phone. Don't cut any important parts off the back of the card. Now, remove the card from the iPhone and install the Universal unlock card. This is all you have to do and now you can run your iPhone on a different network. This is the most simple way to use your phone on another network. You can rese...
Something that every gardener needs to know is how to prune and trim your plants properly.Being able to perform both of these functions is important for keeping your garden beautiful and making sure that they will last for a long time. When pruning or trimming plants, it's important to always use the right tools for the job.
This tutorial will guide you through the steps involved in setting up a sidebar on a WordPress page. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.
In this short video tutorial, you'll see how to create a Space Octopus character using Low Poly Modeling (Box Modeling) and HyperNURBS in Cinema 4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started creating and rendering your own Space Octopus, watch this 3D modeler's guide.
See how to resolve a WordPress MySQL database connection error with this free video tutorial. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.
Here is a step by step tutorial on inserting media (images, audio, video etc), from your computer, into your blog posts and pages. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
Using the My Page Order plugin, you can simply and easily change the order of the pages on your WordPress navigation bar (or nav bar for short). See how it's done with this free video blogger's guide. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about ...
See how to insert a hyperlinked reference to a Wikipedia article in your blog post or page with this free video blogger's guide. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
Learn how to create a blog roll (blogroll) of your favorite sites on your WordPress blog with this free video software tutorial. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
This clip presents a general tutorial on how to work with and embed HTML code into your WordPress posts and pages. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
See how to create a main page with a drop down menu revealing secondary pages — also known as parent/child or main and sub pages (subpages). Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
If you need to display thumbnails on a WordPress page and link the smaller thumbs to the original larger pictures, this post shows the process involved, using the Lightbox plugi,n which creates a special overlay effect when an image link is clicked on. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also mak...
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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...
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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.
