Need some help making sense of the Office 2011 Ribbon UI? This video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using the Office for Mac 2011 Ribbon interface yourself, watch the video.
Can't quite figure out how to run a macro when using Microsoft Excel 2011 on your Mac? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using macros in your own MS Excel '11 projects, watch the video.
Need a hand figuring out how to adjust AutoCorrect and AutoReplace settings in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoCorrect and AutoReplace in your own MS Excel '11 projects, watch the...
Looking for a quick primer on how to use PivotTable (or Pivot Table) reporting in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started employing PT reports in your own MS Excel '11 projects, watch the video.
Want to know how to align and layer objects in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using object and layer alignment in your own MS Excel '11 projects, watch the video.
Need to know how to create and use hyperlinks in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.
Want to generate a line chart in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started creating and using line charts to visualize data in your own MS Excel '11 projects, watch the video.
Need some help figuring out how to handle Office themes from within Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started better managing Office theme settings yourself, watch the video.
Want to create a formula to count cells in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started counting cells by formula in your own MS Excel '11 projects, watch the video.
Want to create an AutoSum formula in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoSum formulas in your own MS Excel '11 projects, watch the video.
If you have a folder that contains many images (say anything in excess of 200) and you open it in Windows Explorer with the thumbnail view turned on. You would notice that it takes some time for all the thumbnails to load completely.
In this tutorial, we learn how to resize photos in Photoshop CS4. First, open up Photoshop and then open up your picture. The quality of your picture will effect the outcome of what it looks like when you resize, so use a high resolution picture for the best outcome. Now, go to image and then image size. From here you will change the width and height to what you need it to be. Then, you will need to click on the boxes at the bottom, click on all of them. When finished, you will save this and ...
The quality of the turkey you roast in the oven on Thanksgiving day is tantamount to how successful your Thanksgiving table will be - turkey is, after all, the center of the celebration for most families (unless, of course, you're going the tofurky route).
In this video we learn how to strategically buy stocks in a bear market. In the last bear market, we were able to buy high quality stocks for a great price. These are great times for value investors to purchase cheap stocks and see their share prices go up as the economy becomes better. You also want the company to rise and become more popular so you are getting more of a return after the stocks that you have bough in the first place. When you do this, you can reinvest after this and get a lo...
Low angle shots are a great way to evoke a sense of panic in movies, but if you're trying to get good quality shots from ground level with just your hands, then it's not going to work. The video footage will be all shaky, unless that's another look you're wanting to achieve in your film. If you want steady, fast-tracking low angle footage, then Ritwika has a great trick on taking those ground level moving camera shots. You'll need a monopod, water bottle (with water), 2 rubber bands and your ...
If you think thrifting just involves hitting up your local Salvation Army and picking up a few pieces of secondhand clothing plus a cute little old-looking vase for your dining room table then you've got some learning to do.
Mystery shopping is a great way to make money on the side while getting a chance to shop, check out new stores and restaurants, and over all improve the quality of service at these locations. The key is to not let them know that you are there evaluating them. If you think you've got a knack for blending in, then check out this video. In it you will learn the process of signing up and becoming a secret shopper, what to expect, and some tips for how to carry out your jobs.
In this tutorial, we learn how to know the pros & cons of laminate flooring. The difference between laminate floor and wood floor is mainly the cost and quality. Laminate flooring will withstand damage better than regular oak flooring can take. But, laminate flooring does not do well if you spill water on top of it. Once the water gets on the edges and stays there for a while it will end up swelling the floor up so it becomes larger than the rest of the flooring. Other than that, laminate is ...
In this tutorial, we learn how to get high definition settings in Camtasia Studio. First, open up Camtasia Studio and your movie. After this, click to open up the link and go through the wizard. Instead of clicking on the pre-set mode, you will be able to choose the file format, which can be high definition. You can also change the name and add in a description. Then, click next and go through the QuickTime options. Go to the settings and change the frame rate to 30 and the quality to best in...
If you're a beginner to Chinese watercolor painter then you do have to do a little research and practice before you actually let your paintbrush hit the canvas. From using the right paint to the right brush, every single thing you employ for your art matters in the ultimate creation.
In this tutorial, we learn how to make a silver vintage-style bead necklace. First make sure you have silver wire and glass beads in the color that you prefer. Now, you will string the beads through individual wires and close them so these can be applied to the center of the necklace. This will create a long chandelier like quality on the necklace. After this, you will create the base of the necklace with the same color beads and silver. You will want to follow the pattern of creating silver ...
This clip presents a general overview of what's new to the latest version of the iOS SDK. If you're interested in writing apps for the iPhone, iPod Touch or iPad, you'll need to know how to use the iOS SDK. If you're entirely new to the dev kit, however, never fear: the web is awash in high-quality, free tutorials like this one, which will teach you everything you'll need to know. For more information, including detailed, step-by-step instructions, and to get started writing your own apps and...
When replacing flywheels on an LLV (Long Life Vehicle), which is a postal truck used by the United States Postal Service (USPS) and made by Grumman, always look for the quality of the new flywheels ordered. Just because they're new doesn't mean they're good. The ring gear can sometimes be welded off-center to the plate, which will make the starter teeth grind the new flywheel. If you don't want to replace the fly wheel a second time, watch this video to see how to spot check them.
In order to prepare your skin, before applying makeup for filming a tutorial, you will need the following: a line filler, primer, concealer, foundation, highlighter, powder, gloss, and bronzer.
If you are facing any problem to compress videos in Sony Vegas like not in very good quality or big in size etc. then you have to take these steps to get rid of it.
Christmas will be here before you know it, which means weeks of festive parties, spending quality time with friends and family, and, if you're the crafty type, making presents and other favors for friends. This year, surprise your loved ones with a truly unique gift by making this Christmas elf.
Did you know that the "Victoria's Secret" makeup look (you know, dark, sultry smokey eyes and nude lips) is the most often requested look at MAC counters and cosmetics counters everywhere? Okay, we're not entirely sure that's true, but every time we hit up MAC we always see girls getting primped with that same exact look.
In this tutorial, we learn how to blast effect a picture in Adobe Photoshop. First, open up a picture in Photoshop, then go to filter, then blur, and radial blur. Change the amount to 77, the blur method to 200m, and the quality to best. After this, hit "ctrl+I" to invert the colors. When you are done with this step, the picture will look like it has been blasted! To make this more different, you can change the colors on the picture or add in any other settings that you prefer. When finished,...
In this tutorial, we learn how to export in HD in iMovie '09. First, open up your iMovie, then go into "share", then "YouTube". If the HD is not checked, you will need to check it and then click "next" and "publish". That is the quickest way to export to YouTube. To do this from iDVD, click on the "share", then "iDVD" and then it will go to iDVD and you can export it in HD. You can do this for any of your movies by simply clicking on the share menu, and making sure your settings are changed t...
Want to export a movie from Sony Vegas Pro to YouTube while preserving its quality? This clip will teach you what you'll need to know. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.
New York's Magnolia Bakery has gotten so famous over the years for its creamy, fluffy cupcakes and pastries that it's been featured on numerous television shows, including "Sex and the City." As well known in New York as Sprinkles is in L.A., Magnolia Bakery is popular because it starts with the highest quality ingredients and boasts some kick-ass recipes.
In this video, we learn how to groom men's eyebrows with Aaron Marino. You will need: high quality tweezers, small scissors, fine tooth comb, and a pencil. First, use the pencil and place along the inside and outside of your eye to know where your eyebrow should start and stop. Now, take your tweezers and pluck the middle of your eyebrows, as well as the outside and underneath of the eyebrow. Next, take the comb and brush against the grain. Trim the hairs that come up at the top, making sure ...
The D-pad is no longer the preferred means of control in most video games, and it shows in the shoddy design of the one on the XBox 360 controller. It bumps against the sides of its enclosure as you try to push it to its limits, causing mistake and frustration. No more! This video contains instructions for shaving down the outer rim of the D-pad, allowing it to move more precisely and greatly improving the quality of your play in games that use the D-pad a lot like Oblivion and Street Fighter...
While some parents like to spoil their little babies with the highest quality (and most expensive) items from Dior, most of us know that babies and toddlers grow out of their clothes faster than weeds overgrow a garden. While their clothes should be appropriately cute, there's no need to shell out thousands of dollars on pricey apparel when you can make your own.
Learn how to create a motion blur effect with Mental Ray in 3ds Max 2010 or 2011. See how to control the camera's shutter speed, the quality of motion blur, and how to decide if a single mesh has motion blur or the entire scene. You'll also take a look at fast motion blur option using Scanline Fast Rasterizer option. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the application, you're sure to be well served by...
Just like with any A/C it's important that the filter be replaced every year to help make sure that it works properly. Not doing so can result in a lackluster A/C and bad air quality for you and others. The same holds true for car A/Cs as well. Not changing the air filter can be bad for the vehicle and lead to avoidable damage. So in this tutorial, you'll find out how to replace an A/C cabin air filter on a BMW E60 5-series. Good luck and enjoy!
Just like at home, your A/C unit needs its filter to be replaced on a consistent basis. Not doing so will result in a poor performing unit and bad air quality for you and others. The same goes for car A/Cs as well. Not changing it can affect how your A/C will perform. So in this tutorial, you'll be finding out how to replace a BMW E46 A/C cabin filter easily. So check it out and enjoy!
Building your own skateboard half-pipe in the confines of your own backyard, is a great thing for anyone who enjoys a little challenge. Certain weather conditions or travel issues, can make it difficult for some skateboarders who are looking to spend some quality time trying new tricks and perfecting skills. In this tutorial, you'll find out how to build a skateboard half-pipe with the help of former NFL star, Michael Strahan. So good luck and enjoy!
There's no getting around it: if you want to get good at playing the ukulele or any other instrument, you'll need to practice. Fortunately, the Internet is awash in free, high-quality uke lessons, like this one from Ukulele Underground. This particular tutorial provides a detailed, step-by-step overview of how to put a ukulele into standard (GCEA) tuning with a digital tuner. For more information, and to get started tuning up your own uke, watch this helpful how-to.
The Nintendo DS Lite is quite the handheld device. It has two screens, one being a touch screen, great sound quality, and a great selection of games. It is also a great accomplishment for Nintendo comparing the original Game Boy to the tech they have now. But despite its technological advancement, things can break, especially handheld devices like the DS Lite. In this tutorial, find out how to replace the original casing to a Nintendo DS Lite. Be aware that if you open your DS Lite, you may v...
