If you have a smartphone with a good camera, chances are you don't think it's good enough. There's always something that can better with your mobile pics, and for me, that something is closeup shots. I love macrophotography. The finer things in life excite me, finer meaning t ...more
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, d ...more
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number ...more
If you're into photography, you're probably no stranger to the myriad of ways you can take macros with your smartphone. Your phone's built-in camera may not take great pictures up close, but you can modify it to do so with anything from a magnifying glass to a drop of water. H ...more
Hack N Mod offers an incredibly simple cell phone camera mod that delivers striking results. All you need is a lens from an old DVD player and you can magnify your zoom by five times. "You’ll find the lens directly under the disk tray. If you’ve just upgraded to Blu-Ray, now ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
It can be incredibly frustrating to take closeup shots with an iPhone camera—or any smartphone camera for that matter. Even if your phone's camera is top of the line, you'll still get a fuzzy picture if you get to close to your subject. To resolve this, you could always purch ...more
Watch this quick instructional photography video and discover how to do extreme macro photography without having any real specialized macro photo equipment. Use a couple of your existing lenses to create a super macro lens. Practice these tips and improve your photography skills.
In this article, we're going to create an additional button in our Word toolbar which creates a PDF file of our loaded file with one simple click. We are going to use the function to create Macros, which are little 'programs' in Office applications. The Macro we are going to w ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
Oh, no! Visual Basic macros are no longer supported in Excel 2008 for Mac, which might make things a little difficult for you if you're used them a lot in the past, or if somebody else gives you spreadsheets using them. The Microsoft Office for Mac team shows you just how to d ...more
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 funda ...more
Want to know the best way to take close-up, highly-detailed pictures of small objects? This brief video tutorial from the folks at Butterscotch will teach you everything you need to know. For more information, including detailed, step-by-step instructions, and to get started t ...more
UPDATE: Winner announced. See the winning photo here. This week's Giveaway Tuesday is all about macro photography. The prize is a combo lens for your camera phone that can shoot BOTH macro and wide angle—but as far as the entries go, we only want to see your extra close-up sh ...more
Lozzless demonstrates how to make a diy cheap macro lens with working aperture for his Canon 5D Mark II, coined the "SuperMacro". According to Hack a Day, "The process involves fashioning a connector ring from a lens cap, modifying an Electro-focus lens mount, and assembling ...more
There are tons of ways to make a macro lens for your smartphone, but if you need one for a DSLR, it's not quite as simple as using a magnifying glass or a drop of water. If you have an old kit lens, though, you can turn it into a macro lens in no time—all you have to do is rem ...more
If you've got an extra DVD drive laying around not being used, watch this video and learn how to give the lens new life—as a powerful macro lens for your camera phone! You'll be able to take incredible pictures on your camera phone using this clever mod. Video: .
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll ...more
Learn how to use create macros when working in Microsoft Access 2010. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well s ...more
The Costsheet demonstrates how to enable macros in Excel 2007 to run correct spreadsheets. First, open up the spreadsheet. Make sure that the macros are enabled. If they have not, enable the macros by placing them in a trusted source by saving them in a particular folder. You ...more
You can take macro photos on a huge variety of devices, whether you're using a DSLR with expensive lenses or just your iPhone (or any smartphone, for that matter). One common issue, though, is that it can be hard to get the image as crisp as you want because the depth of field ...more
Hey guys, gals, and everyone in-between! This week's WTFoto Challenge is a real humdinger. For the first time ever, we're asking you to ply your image macro skills and make us belly laugh like a drunken hillbilly at a corn festival. We've created our very own image macro for ...more
This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "I ...more
In this video tutorial we learn how to assign a macro to a button or a check box in Excel. The first thing you want to do is to place the macros you want to use in the spreadsheet. You can assign a macro to any object within Excel. Next draw the shape in the spreadsheet that y ...more
In Google definitions a macro is defined as "a single computer instruction that results in a series of instructions in machine language". Basically a macro is a programming script that tells the computer what to do. You can tell a computer (via a macro) to move a mouse, click, ...more
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Fi ...more
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll ...more
Say goodbye to your boring stock Apple keyboard, because when iOS 8 is finally released, you'll be able to use Fleksy, SwiftKey, Swype, TouchPal, and other third-party keyboards on your iPad, iPhone, and/or iPod touch. One of the new keyboards you'll be able to use in iOS 8 i ...more
Via WonderHowTo World, Cinematography: Lozzless demonstrates how to make a diy cheap macro lens with working aperture for his Canon 5D Mark II, coined the "SuperMacro". According to Hack a Day, "The process involves fashioning a connector ring from a lens cap, modifying an ...more
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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
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 229th installment in their series of digital spreadsheet magic tricks, you'll learn how to dump da ...more
Photographer Suren Manvelyan presents an incredible series of macro photographs of eyes, entitled: "Your Beautiful Eyes". The depth of detail makes these eyes look like they have the texture of otherworldly planets.
In this clip, you'll learn how to create custom macros on a Microsoft Windows desktop or laptop computer with AutoHotKey. For more information, including a complete demonstration of the process and detailed, step-by-step instructions, watch this home-computing how-to from PCMech.
New to 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 Excel tutorial from ExcelIsFun, the 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro ...more
Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Mac ...more
Looking for an introduction on how to work with macros in Microsoft Excel 2007? Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself ...more
Forget splurging on a fancy digital camera. All you need to do is attach a lens from a pair of dollar store reading glasses, and you'll get your macro shot. From Sean Lee, how to make a fifty cent macro lens. Before After Previously, Easy! Cell Phone Camera Macro Mod (5X Zo ...more
In this lesson, learn how to shoot compelling close-up shots using a macro lens. Tips on composition, lighting and controlling depth of field are discussed in detail. Watch this video photography tutorial and learn how to shoot close-up pictures with a macro lens.
Hello, life forms and inanimate objects the world over. This week's competition is the Hobo Image Macro challenge, and we want to see more entries! Don't be intimidated by the hobo's dull, yet threatening stare—it's easy to do! Just to prove it, here are ten pieces of Hobo adv ...more
Create your own macro lens using the standard 50 mm lens that is shipped with your Digital SLR camera. The presenter - Kip Kay explains how to do so in a very cost effective way using only a Pringles( or any other similar) can, a black cloth, your camera's body cap and a few ...more
This video takes us through a process of inserting Macros from internet into a excel workbook. Two shortcuts Alt-F11 and Alt-F8 is used. Alt F-11 is used to open the visual basic window and Alt-F8 is used to open macro lists window that opens all macros. These shortcuts work i ...more
If you want to engage in macro photography and can't afford a close-up lens, you may be in luck. By using a "G" lens (that is, a lens that does not have a built-in aperture ring) it is possible to reverse the lens and take close-up shots with your camera, without having to buy ...more
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 50th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a basic macro and then assi ...more
Crabfu demonstrates how to mod your iPhone with a microscope for just $5 (UPDATE: the $5 microscope from Amazon is now selling it for $12.50... read more). Incredibly simple to make! Check out the sample images taken below the video. Gears on the Kinekt Gear Ring. $20 Bill . ...more
If you want to take beautiful macro photos, without having to pay for an expensive macro lens, try the reverse lens technique and use the lens you already have. This is a creative way to get great photos without spending all of your money on equipment.
How to hack Yoville! Yoville cheats, tricks, hacks. Watch this video tutorial to learn how to max people with macros on YoVille (10/01/09). Maxing people with keyboard macros! One shortcut clicks the "Accept" button on the left side where it won't be obscured by the RPS wind ...more
In this Microsoft Excel 2007 for Dummies video the instructor shows how to record a Macro. Macros let you create a shortcut to perform a sequence of commands all at once. For example you can create a macro to quickly build a sales report template that you frequently use. When ...more
In this video tutorial, viewers learn how to remove the macro warning in Microsoft Excel. When you see the warning, click Enable Macros. Then right-click on of the sheet tabs and select View Code. Open the Modules folder menu. Now right-click on the module and select Remove Mo ...more
Amazing what you can get out of camcorder these days. "Discovering a whole tiny world in my father's small garden. There is a small pond with small falls, some stones, some plants, and plenty of life! Shot on Panasonic 500- Fujinon 17x7.6 HD lens." Video: Use the Panasonic HP ...more
Insekten!, test shots using Canon macro lenses and the Canon 5D Mark II, by YouTube user Powermaennchen. Incredible footage for a $2500 digital camera. I'm willing to bet Planet Earth used cameras that were a bit more expensive than $2500... Have a Canon 5D Mark II or thinki ...more
Macro extension rings are an affordable solution to buying expensive macro lenses, but there is no way to control the aperture when using macro extension tubes without contacts. However, by utilizing a piece of paper, you can easily control the aperture. Video: .
In this Fine Art video tutorial you will learn how to focus stack for great macro photos. This video is from EPhotoZine. The idea is to take several pictures of the same subject at different distances. For this you will need focus stacking. If you focus with a wide aperture, e ...more
The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the ...more
The macro mode on a camera can be baffling. What's it for? Well, if you've got something small and pretty to shoot, like a butterfly, macro gives you the best shot possible. It's also good for taking pictures of things that are small and ugly, like scratches in your car paint. ...more
Want to record your own custom macros within MS Excel 2007? See how it's done. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to ...more
Macro photography is a type of photography used to create interest by focusing the lense on one thing in a picture, generally something that's located in the foreground. The rest of the image (the midground and background) fades out into a blur. This is a special effect that ...more
The advantage of the camcorder is that sometimes, it can see more than the human eye when put close up to something. This cinematography video should help you make interesting shots as well as get really good extreme close-ups.
From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. This is Digital Photography for Dummies. Just watch this video tutorial to learn how to shoot close-ups in macro mode, For Dummies. Digital camera ...more
Some times when you upgrade your Microsoft Excel software to Excel 2007 your old macros may stop working. Some times this may be due to the settings and by enabling the macros you can get your old macros to work. Macros are turn off by default in Excel 2007. You can turn this ...more