This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
This video shows how to make a real 3d text in Photoshop. First open up Photoshop. Create a new document File > new. Then select width then OK. Fill the background with black. Then go to the text tool and write whatever we want. Choose a font with fat letters. Right click on the text layer and go to "Blending options". Then edit the text in our way. We can create a Gradient Overlay, Contour, Stroke and Outer Glow. We can add any effect we want. Again right click on the text layer and click "R...
First of all you have to take a plane wooden board which is about one foot and square shape, and place it on the floor. There should be a holder in the middle for inserting the rod. Now take a rod which is about four feet in length, and then insert it in the holder. Now use a tape and stick the rod firmly to the holder. Take two red color balloons and two blue color balloons which are joined at their ends. Now pass over these balloons two or three times at the ends so that the red and blue ba...
In order to make a brushed metal effects in Photoshop you should first go to your gradient tool and select a dark grey or a black and click okay. Shift and drag your mouse to create the gradient. Next, go to filter, Noise, and then add noise and change the percent to 40% and click okay. Now, go to blur and ocean blur and change the angle to 0 and distance to 100 pixels. Now, for the sides to look like brushed metal, crop those sides out. Now you have a metal effect. To make a screw, click on ...
In this how-to video, you will learn how to make a light saber or similar image in the Final Cut Express program. First, go to the effects tab and go to video generators and select color solid. Drag this to the viewer. Go to the control tab and select the blue color. Now drag it to the time line. Double effect the color solid and go to mask shape. Select filters and change the effects settings to 2.5 horizontal scale. For the vertical scale, select 75 to 85. Go to the effects, video effects, ...
The video shows how to solved mixed property problems using the exponent rules. See if there are any rules you can apply to the problem until you get to a point where you can't simplify anymore. The instructor shows in the example problem that the two bases are the same, but there is extras happening the numerator. The power to power multiply rule is applied removing the extra issues from the numerator. Next the quotient rules is applied as there is the exact same base to the power so we keep...
It seems like its hard to get as much sleep as we need, doesn't it? Sleep is important and effects how you function throughout the entire day. Follow these tips and you will be on your way to a good night's rest.
You can manipulate the AF fine-tune on your Nikon DSLR in order to optimize the sharpness and resolution of your lenses. This is a great tool for achieving the highest picture quality possible.
This video shows you how to properly focus your video camera. Usually cameras have two focusing modes, manual and automatic. Despite the sophistication of modern cameras and their auto focusing modes, manual focusing still gives the person operating the camera the most control. To focus in manual focusing mode you must first focus your eyepiece. To focus your eyepiece fully zoom in on your subject, then rotate your lens' focus ring until the subject becomes sharp and clear. Finally rotate you...
Click in File and New to create a new document, press OK and select the text tool and click once on your file and write something, then close the window. Click in move the active layer to make easier to move the text. Go again to the text tool and click on the Color to change the text color. Press Crtl+O, select the background layer and change the color to the one you want, now select the bucket tool and click on the background to paint it with the color you have selected. Go back to the text...
Objects used in the tutorial are available free at the website preceding this description. The project here involves two groups of paths. You will be shown three ways to change the order of these groups. Go to one of the groups and right click on the mouse, in the menu that comes up choose Arrange, and within the next box choose bring forward. This works with either group. Go to the other group, right click, choose Arrange, then choose bring forward and now this group will appear ahead other ...
This is really cool, you can make these awesome neon glowing lines using your Adobe Photoshop. This is a fun way to make creative and colorful designs and it looks really neat without spending time working on detailed shapes.
This video explains how to throw a football like a quarterback. With your elbows bent at a 90-degree angle, hold the ball in front of your chest with the fingers of your throwing hand across the laces of the football.
Justin is giving guitar lessons in the 12 Bar Blue Styles *In the lesson Justin is going to teaching 12 bar blue styles with a chunker chunker rhythm. Chunker chunker is just a word taught by Justin's teacher for the strumming action.
There's no Cheat Engine involved in this Bejeweled Blitz hack. This hack relies on Firefox and a certain extension made specifically for Blitz.
This video tutorial demonstrates an easy way to activate MMS on iPhone 3G or 3Gs Firmware 3.1 o. First download the File here.
You can learn to confidently and accurately sew a straight seam. You Will Need
Tower Blocks is a Facebook game that allows you to test your speed at building the tallest tower ever! Watch this video tutorial to learn how to cheat Tower Blocks on Facebook (08/05/09).
Save yourself back pain and injury by learning the correct way to pick up heavy objects. Watch this video to learn how to lift a heavy object.
Turning over your soil mixes the nutrients and makes the ground more suitable for planting. Watch this video to learn how to turn over soil.
Just like your living room rug, your car’s carpeting needs a thorough vacuuming now and then. Watch this how to video to learn how to vacuum your car. Don't pay those car wash prices!
There might not be a better brand partnership for the speedy Sonic the Hedgehog character than a fast-food restaurant. For that matter, augmented reality is also the ideal technology for promoting a movie that features an animated talking rodent living life in the real world.
Big-box retailer Target has been on a bit of an augmented reality advertising shopping spree via Snapchat lately.
Music streaming services make it difficult to transfer your favorite songs and artists from one service to another and for a valid reason: they don't want you to leave. But when it comes to switching, playlists are a big concern, because who wants to do it all over again? Luckily, if you're moving from Spotify to Apple Music, you can use a third-party app to take playlists with you.
As Facebook, Apple, Samsung, and others offer augmented reality selfie effects and content that challenge its platform, Snapchat has continued to innovate with its augmented reality capabilities.
Sure, you just got your Galaxy S8. But now, Samsung came out with their latest and greatest device — the Galaxy S9. While the S8 is still a great device, it's possible that the Galaxy S9 completely outclasses it, almost forcing you to pick it up. It is worth it though? That's a harder question to answer than you may think.
If social media apps were houses in a neighborhood and augmented reality photo effects were candy, then Facebook went to Costco and brought home a full pallet of treats.
Instagram Stories is one of the most flexible ways to share creative and original content with your followers. It allows you to alter text, markup images, and add cool graphics and stickers, along with other fun ways of expressing yourself.
Apple recently scored a patent (number 9,488,488) to create augmented reality maps, hinting at possible AR integration into the iOS Maps application for iPhone. Does this mean we'll be seeing super visionary projections of places in the app in the near future? Maybe.
Crayon, a free 3D drawing application by the mysteriously named arkalian, showed up in the Windows Store recently, so I gave it a try like I do all new apps for Windows Holographic. Truthfully, I loaded it up not expecting much, but wow, was I wrong. It's a simple idea, but it's executed well enough to make it a truly great experience on the HoloLens.
It's easy to grab a box of pre-prepared microwave popcorn at the grocery store. Yet with so much salt, butter, and other unpronounceable ingredients, microwave popcorn can go from a healthy snack to a complicated one.
What's not to love about a glass of wine? It tastes delicious. It takes the edge off your day. It helps you and your guests unwind and lets the conversation flow. All in all, it's a beautiful thing. What's not so beautiful is having someone knock over a giant glass of red and leave an indelible stain on your carpets or furniture.
Android's beauty is in its customization; you can have widgets for anything, launchers that look and feel completely different from one another, and fonts you can change at any time. And it doesn't stop at aesthetics—you can go much deeper than looks.
Presentational video for our DIY Camera Crane project. Video: .
The inclusion of the parallax effect caused a shitstorm amongst iPhone users when it was released in iOS 7, especially when it came to creating custom wallpapers. It was hard to control, and even disabling it didn't fully get rid of it, making it one of the most hated new features in Apple's latest mobile OS.
If you're constantly writing money amounts using rupees, which is the basic monetary unit India, Pakistan, Nepal, Seychelles, and other South Asian and East African countries, then you'll be relieve to know that there is a font you can use to create the rupee symbol in any word processor on your computer.
Hack the hex code in Bejeweled Blitz for a higher score! Everyone wants the top score in this popular web game, but it all comes down to how you get it. Do you have what it takes to come out on top? Check out this video tutorial to learn how to hack Bejeweled Blitz (07/24/10).
The video starts with the presenter explaining that he will be talking about harmonic oscillators, not the harmony of anything in sound, but something that moves back and forth in roughly the same speed back and forth.
Need some extra space on your computer? Grab those folders and zip 'em! Watch this tutorial and learn how to consolidate your folders into a single zip file, saving you space and keeping you organized.
In this video, you will be walked through the game Foreign Creature. There are human characters in this one, with word clouds, in an office setting with bulletin board, desks, rolling shelves, and tack boards. In another scene of the game, you will see a hospital setting with nurses, surgery table, patient, medical equipment, and doctors. In this setting, the patient is a foreign creature who blacks out the medical staff and proceeds to stalk the hospital. Police try to capture the humanoid-l...
