Macro Photography Search Results

How To: Use Microsoft Excel macros securely

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52.5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about macro security. For more information on how to use macros safely, watch this free video guide.

How To: Create a macro & assign it to a form button in Excel

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 assign the macro to a form button. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Go to New Record in a form using macros in MS Access

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 learn about using a macro to force a form to open on new record. For more information on going to `New Record' in a form by using macros, watch this Access how-to.

How To: Enter formulas in Excel with a macro

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, delete the contents of the cell. Press Alt + F11.

How To: Input values & formulas into a cell in Excel macros

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", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...

How To: Completely hide the Ribbon menu in Excel

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...

How To: Use the range property in Excel macros

Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...

How To: Enable macros in Excel to run correct spreadsheets

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 can also choose to recognize the publisher as a trusted source. Click the office button and scroll down to Excel options. Click on the trust center option and go to trust center settings. Then, view the trusted locations...

How To: Automatically Hide the Ribbon Menu System in Excel

Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specific workbook in which the macro is implemented. Some helpful shortcuts are Ctrl+F1 which partially hides the ribbon, Alt+F11, which opens the Visual Basic screen, and Alt+F8, which opens the macros list. First, hit Alt+F11 to open the Visual Basic screen. Then double-click "This Workbook" on the le...

How To: Use gobos in photography

Here is a Harper Point Photography video on gobos for fashion photography. Nathan gives a simple but effective photo tip for creating dynamic light with a cardboard 'go-bo.' The gobo is a lighting element that texturizes lighting by blocking in strategically. Apply these directly to a light to shine texture or to light with words as a projector would.

How To: Prepare a photography portfolio presentation

Putting together a print portfolio for your photography? This instructional photography video provides some suggestions on photographic portfolios and how to assemble a portfolio. It is very important to have a good online presence, a nice gallery of your work to show. But there are advantages to having a print portfolio as well.

How To: Problem solve small product photography techniques

This instructional photography video explains how to problem solve small product issues. Two ways to tackle a particular challenge is through pre-production and the other in post-production. There are many different ways a photographer can approach and deal with a challenge. The more knowledge you have about different methodologies about photography, the better and easier you will be able to solve those problems when they occur.

How To: Remove the macro warning in Excel

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 Module. Click No to prevent the Module from exporting as a saved text. To go back to Excel, click on File and click on Close and Return to Microsoft Excel. Click on Save to save your workbook. This video will benefit those...

How To: Create and use macros when programming in Clojure 1.1

In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to create and work with macros in Clojure 1.1. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.

How To: Use macros in Microsoft Excel 2007

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 with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started using absolute and relative macros in your own Excel 2007 workbooks, watch this free...

How To: Automate tasks in Mac OS X with QuicKeys 4

This quick clip presents a general introduction to creating macros and automating processes within Mac OS X using QuicKeys 4. Whether you're new to Startly Software's popular macro and automation application or are merely looking to pick up a few new tips and tricks, you're certain to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, watch this video guide.

How To: Record absolute and relative macros in MS Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.

How To: Use macro and advanced filters in Microsoft Excel

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 Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.

How To: Use long exposure photography to paint with sparklers

Long exposure photography has long allowed photographers to do amazing things with light. Now you can do that! This video will show you how to use a long exposure, sparklers, and Photoshop to create amazing psychedelic art on your photographs. This new art form is called light painting or light writing, looks amazing, and is pretty easy to get started doing. Do it!

How To: Price your photography

While it might pain you to put a price on your art, if you want to support yourself through photography you may have to. Fortunately, it isn't as difficult as you might expect. It's so easy, in fact, that this free video tutorial can present a comprehensive overview of the process in just over three minutes' time. For detailed instructions, as well as to get started sharpening your own knives, watch this helpful how-to.

How To: Take advantage of depth of field in photography

The great thing about photography is that you're able to capture a moment that will be frozen in time forever. There are many different techniques that can be applied to capture specific moments in time, you just need to know which one works best for you. This tutorial describes the depth of field in photography and how to take advantage of it. Enjoy!

How To: Get started with flash (strobe) photography

New to photography and looking to learn the fundamentals in a flash? This free photographer's guide, which discusses flash photography and its terminology, will help you to accomplish just that. To get started learning the flash/strobe/speedlight basics (as well as to get a basic handle on the jargon), watch this free video tutorial.

How To: Tilt-shift photography to create a miniature effect

Kipkay from Make Magazine shows us how to create a photographic illusion, making things look smaller than they really are with tilt-shift photography. Materials needed include rubber plunger, an oversized lens, a plastic body cap, a single lens (or digital single lens) camera, a hot glue gun, a sanding file, and a disposable object for a plastic backing, such as a VHS tape case. With this great tutorial and a little work, create the illusion of a miniaturized world with this photographic tech...

How To: Creatively document events with photography

In this video sequence, learn how to choose a context when shooting and editing your photos, allowing themes to emerge in your narrative work. By simply documenting the events around you, you will find ways to creatively show what happens through photography. Documenting events will not only make your photography work more interesting, you will also become a better story teller. Practice grouping photographs to tell a story.

How To: Choose a narrative theme for a photo series

This instructional photography video provides some helpful tips on how to build narrative ideas surrounding body of photography work that you'll want to create. You can use these techniques when building a book, a web site or a series of consistent images for your story. You will not only make your photography work more interesting, but working with narrative will train you to become a better story teller.

How To: Test out different photography tripods

There are many types of photography tripods for using in different shooting situations. Watch this instructional photography video to test out different tripods from mini to mighty. Make sure to label your tripod with your name and address, because at a large photo shoots, tripods often get lost, stolen, or confused with other tripods. Most of these tripods work well with digital SLR cameras and 35mm film cameras.

How To: Shoot panoramic photographs

Watch this instructional photography video on how to shoot Panoramic photographs with What Digital Camera Magazine. Panoramic photography is a format of photography that creates images with exceptionally wide fields of view. You don't have to use a tripod but it's much easier than eye balling it while taking a series of photos of the landscape, and you won't have to crop as much.