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 3rd installment in their joint series of digital spreadsheet magic tricks, you'll see three methods to count records that contain the letter D.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 144th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to work around data validation's one-rule limit by creating a second shrinking list that looses values as they are used in the data validation area.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 107th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use DATE and TIME in the same cell to solve a common time math problem.
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 92nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how the AVERAGE function sees zeroes and uses them in calculating an average but does not see blanks.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 90th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see a complicated average calculation with multiple criteria using the MONTH function on a date field. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 69th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Excel's Auto Fill tool.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to work with radical equations containing invalid or "extraneous" solutions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 39th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the RIGHT, LEN, FIND & REPLACE functions in a formula to deliver a sheet tab name to a cell!
In this how-to video, you will learn how to perform basic circuit bending. You will need a screw driver, alligator clips, solder, a soldering iron, wires, a wire stripper, a button or switch, and a drill. Open up the device you want to circuit bend. Once the side of the board with the solder points is exposed, take your alligator clips and find two solder points that make an interesting noise. Be careful of areas where the battery is connected, as you might shock your self or destroy the devi...
This video shows you how to use flacs inside of iTunes. FLACS are higher quality audio files than your average mp3.FLAC stands for Free Lossless Audio Codec. It is designed for people who want to hear their music in a great high quality. For Mac users, download fluke. If you have iTunes up already, select open applications and open with. Select fluke and import it into iTunes. Once it has finished doing its thing, your music will open and you can play it. Essentially the system is tricking it...
The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...
The bookmarklet tool lets you send Gmail messages with the click of a button so you don't have to visit your Gmail account. It's an application called GmailThis! From the developer's website, drag the GmailThis! link to the browser's toolbar. Then, if you are already logged into Gmail, just click on the bookmark and a Gmail applet will pop up with a link to the website you were visiting, along with any text you may have been highlighting. You may notice that the subject line is already filled...
This video shows us the procedure to use an iPhone with a microscope using iMicroscope. Open the application and focus the object correctly in the microscope. Bring the camera in the phone near the eye piece and click a photo once you get the object correctly focused. Hit 'Use' and put in the magnification of the image. Hit 'Accept' and view the image. You can see a magnification scale, date and an automatically scaled scale bar. You can zoom in the image. Save the picture in the camera roll....
This excellent video, which is easy to follow and understand for chefs of any level teaches you how to make some yummy comfort food. Homemade buttermilk biscuits with milk gravy, a traditional southern meal for any occasion. The chef takes you step by step, to a delicious final dish.
This video tutorial explains how to use Adobe Photoshop in order to create a unique metallic black and white effect. This simple technique (accessible to both newbies and experts) allows one to easily make photographs appear metallic. This technique requires minimal prior knowledge, walking viewers through the steps, from the application of filters (such as high pass) to the introduction of a black & white gradient. Finally, a subtle sepia tone completes the effect. This technique is useful f...
Need to make a sample or draft of a booklet from your home computer? Caren Borowitz provides a straightforward way to complete the task. She presents a step by step method for organizing the pages using a total pages grid that can be modified to fit as many pages that your booklet or brochure may contain. She uses straightforward dialogue, visuals, simple tools and supplies to show the viewer, piece by piece, the process of organizing and assembling draft brochures.
There's nothing better than a cool logo design, except maybe a cool 3D logo design. A 3D logo might just be what you need to have your company stick out. Watch this Illustrator video tutorial to learn how to make a 3D logo. You may want to apply a glassy text feel to the finished 3D text logo. It is a pretty complex logo, but it is good to learn some great techniques for doing some interesting things in Illustrator.
Create some cool comic vectored effects! Watch this Illustrator video tutorial to learn how to make some comic styled text. You will learn how to break text down and add gradients. You will also learn how to create a fake 3D effect as well as some stroke options. All of these techniques will come together in the end as we create a comic book cover worthy logo.
Retro is in, but then again… when was retro ever out? Watch this Illustrator video tutorial to learn about making retro looking sparkles for whatever reason you may need (or want) them. The bulk of the video will cover the many advantages to using symbols, when and where you can, in your illustrations when dealing with many of the same graphic objects. Learn to edit 100's of objects in no time, and learn about many of the symbolism tools available to you in Adobe Illustrator!
Metal is sleek, metal is stylish, so why not incorporate that metal look into your designs? Watch this Illustrator video tutorial to create those nice little metal buttons, which can also be used as icons for your phone or desktop. Everything in this video is 100% vector, so it can be used virtually anywhere!
The Apple iPod and iPhone are the hottest electronics on the market, so keeping up with the times means keeping up with designs people like. Apple incorporates all kinds of cool images and icons into their products, so learn how to re-create them so you can modify them or get ideas for your own designs. Watch this Illustrator video tutorial to create a gel progress / loading bar-similar to the progress bar found on an iPhone and iPod -- from start to finish.
If you don't have CS3 and have an older one, you should still be able to follow along with this tutorial. Watch this Illustrator video tutorial to create vectored swooshes and swirls. Learn how to create vector swirls and swooshes which can be easily re-used by using these fairly well known techniques
This is all about vector, swirling rainbows. Have you ever seen those looping, swooshing, swirling rainbow graphics used in all kinds of graphics ranging from logos, and sketches, to grungy and retro illustrations? Well, you are going to create one of them in Illustrator. Watch this Illustrator video tutorial to create vectored rainbows. Also, learn how to export it to a program, such as Photoshop, as a smart object, to utilize it as a smart object so we can both retain vector scalability whi...
Take a look at some vectored hearts… it's fully vectored. Older versions of Illustrator should be able to handle this project just fine. Watch this Illustrator video tutorial to learn this heart-shape design. A vector heart is great for Valentine's Day. No source files are needed. Just Adobe Illustrator and some time. Learn about using the grid, the basic pen tool, gradients, swatches, blend modes, masking, and so much more.
Increasing the contrast in Photoshop could help when performing this Illustrator technique. This subject: the eyeball. Watch this Illustrator video tutorial to learn how to vector an eyeball in CS3. Vector an aye of a model of your choice using simple techniques that will be useful, not only in vectoring eyes, but tracing techniques that are used for full face and body vectoring and vexeling.
Changing the way the Bridge looks is a personal touch everybody can make to streamline their workflow. Changing layout settings in the bridge is actually quite easy and very helpful for customizing for individual needs. In this video tutorial, see the ways that you can change the Bridge's look and feel to suit your work environment and to free up the space necessary to have a comfortable working window. This video also covers the viewing options given to you by the Bridge to allow for quick a...
An interesting feature of Windows 7 is the ability to run Windows XP in a virtual machine in order to use applications that don't currently work with Windows 7. This is different than using other virtual machine options because in the final version of Windows 7, several versions will ship with this for free as opposed to other options such as purchasing VMWare and an XP license.
This beauty video demonstrates how to create an easy smoky eye for beginners.
This beauty video demonstrates how to create a Barbie Loves MAC makeup look with MakeupGeek.
This beauty video demonstrates how to create an arabic makeup look with MakeupGeek.
This beauty video demonstrates how to apply eyeliner. If you are just beginning to wear makeup, you may be overwhelmed by the many types and brands of eyeliners out there. Depending on what look you want to achieve, you will want to use different eyeliners to get that desired result.
This beauty video demonstrates how to do rockstar makeup photoshoot style.
This beauty video demonstrates how to create sexy Valentine's Day makeup.
This beauty video demonstrates how to do a MAC brunette blonde redhead makeup look.
This beauty video demonstrates how to do a MAC danger zone makeup look: red and black .
This beauty video demonstrates how to create a green & white holiday makeup look.
