You can use the vlookup function in MS Excel to create a dynamic table in your document. Creating a new dynamic table and a new dynamic lookup area enaables you to add new data or new columns to the lookup table. You can also create dynamic named ranges by using offset, vlookup table and the match table. This function is very useful to businesses working on Excel. This video will show you to create a dynamic table for vlookup in Excel.
Dan shows us how to pack a suitcase perfectly as to not take up much space but still include everything you need. Start with a list of what you need. Make sure you have all of your documents i.e. itinerary, passport, drivers license, etc. Use the 3-1-1 technique for flying. 3 oz. bottles, 1 oz. bag, and 1 carry on. The store sells packet bags that promote more organized packing. It allows you to store shirts in an orderly way without getting wrinkled. They come in all shapes and sizes so that...
Hulldo teaches you how to create indented text in GIMP. First, create a new document of any size. Then use the text tool to write some words. Next, select that text and go to Script fu-layer effects-inner shadow. Once you've done this, duplicate the layer. You will now want to filter-blur-Gaussian blur. Apply that to your second layer. Now you can either merge the layers or leave them as they are. You can also play with the text settings, if you want a larger shadow, a bolder text and so on. ...
HelpVids user mel_bone teaches you how to cut, copy and paste to the clipboard in Microsoft Word 2007. Select the first paragraph by either triple clicking on it or selecting it with your mouse. Click "Copy" in the top ribbon or press "ctrl + c". Then use "Paste" or "ctrl + v". To cut a paragraph, select it and click "Cut" or press "ctrl + x". Using the paste options, you can only paste the text, without its formatting. By clicking the small icon next to the Clipboard tab, you will open the p...
In this video the instructor shows how to use the drag-and-drop feature in Microsoft Word 2007. You can use drag-and-drop to copy and move information within the Word document. This is particularly useful when you want to move and copy information within one page. However, if you want to move information between different pages, use the normal copy-paste feature. If you want to move any information, first highlight and select the data. Now click and hold down the mouse button in the middle of...
This tutorial will show you how to set up your college essay using MLA style formatting in Microsoft Word. Follow these steps to set up MLA style formatting: Open a new document and change your margins to 1". Set your font to 12 point Times New Roman. Set the header by typing your name, your professor's name and your class and section. Add the date from the Insert Menu. Set your spacing to double. Enter your title in the center of the page. New paragraphs are indicated by indents, and not spa...
In this tutorial CreativeIceDesigns shows you how to make really cool electricity text effect by using Photoshop. To do this you need to open Photoshop and create new document. Layer will be black. Go to Type tool and type the word which you want to give effect. Now duplicate the layer and hide one. After that go to filter, stylize and wind option. Give this effect from all side. Change the color and unhide the text layer. After watching this you will be also able to make electricity text eff...
How to resize the background image in Xara3D6? First go to windows>frame size. Go in Sara and change the size of the image to the frame size. Make the image transparent. Then export the image as a PNG format. Now go back to Xara3D6 and go to view>background texture and open the previous image which was saved. That’s it; the image is resized to that particular document properly. It will help in resizing photos to be uploaded on the net.
In this video tutorial, viewers learn how to use the traditional Japanese stab stitch binding to make books. Stab Stitching is used mainly for office documents and in essence is two or more very strong, long staples that bind together loose sheets up to 25mm thick. The video provides all the materials required to make a book. The materials include: filler paper, two sheets of card stock(must be same size as paper), string, pencil, ruler, ice pick, X-acto knife, needle(must be same thickness a...
A PDF Portfolio is a bundled collection of content compressed into one PDF file. Watch this 5 minute overview and learn how you can bundle documents, e-mail, drawings, flash presentations and even video into one sleek package that can be used for presentations or project management for your organization. Your portfolio can include introductory text and sets of data that can be sorted geographically by being linked to clickable maps. Not only can the entire portfolio be branded with your logo ...
The ability to create professional and clean presentations can be a valuable asset to one’s career. With this video tutorial, learn how to use Adobe Presenter in order to augment Power Point presentations. Presenter offers users the ability to record narration under a set order of slides in a simple interface, and provides an interactive quiz option to further engage audience members. Alternatively, users may also convert a presentation into PDF format, for use as a physical or virtual document.
The Epson video describes how to print two-sided on one piece of paper. When document is ready, go to "File" and then "Print". Click the "Properties" button and select Page Layout tab and turn on the two-sided printing option. Click "OK" in print window. Wait for Epson printer to complete the first page. Take paper, flip over and put it back upside down in the paper feeder. There are instructions that will pop out on screen for this. Click resume and the second page will be printed on the bac...
In this tutorial the instructor shows how to use commenting tools in Adobe Acrobat 9. He says that the look and feel of the commenting tools are very similar to the previous version tools which were used to mark and comment documents. He shows how to open the comment button from the menu bar and explains about the options present in there to use the commenting features. He demonstrates many ways to enable comments and markup tool bar in the application. Now he shows about the various ways of ...
This video shows how to use a special tool to redact or remove sensitive information from Adobe Acrobat 9. This includes hidden metadata, file attachments, comments, hidden text and layer elements within a PDF file. You can also set it up when you're emailing. The Examine Document function highlights information that you may want to remove. You can then select the different types of data and choose which things you want to remove.
Oktay1979 takes a look into writing an annotated bibliography. Learn the steps such as citing a source, summarizing your reading, accessing your source, documenting your authors credentials, and reflecting on your source. Each bibliography is usually 150 words long and done in new times roman. You can also get a form to show you how to format the bibliography correctly. Make your writing process unique and accurate. Make sure you're doing your bibliography right by following the correct steps...
Rod Milstead brings us a video on how to create a brochure in Microsoft Word. He shows us how to navigate Microsoft Word in order to create the brochure. He gives us step by step instructions on how to get a general template to work with. Then he explains how to work with the template once you have pulled it up. He shows us that it is a two page document and that page one in the outside and page two is the inside. He says that while it might be a little hard to use at first, once you get used...
In this video the author shows how to perform custom number format for turnover ratio in a Microsoft excel document. He shows how to perform custom number formatting in which he shows how to display a decimal value in words. He opens the Format Cells option and there he shows how to set the Custom option. He shows how to configure different options so that we can format the decimal value and display it as text with some meaning attached to it. In this video the author shows how to use custom ...
In this Adobe Acrobat tutorial the instructor shows how to export PDF files to other office formats. He shows how to do this with a live example. He chooses the file menu and from there goes to the export sub menu and shows all the different file format options that are available for exporting. For demonstration purposes he saves the current PDF in Microsoft Word format. He opens the converted file and shows the results of conversion. This video demonstrates the features of Adobe Acrobat 9 to...
This all-in-one printer's versatility will help you in any aspect of home office printing, whether it's business documents or family photos. Learn how to print photos without even turning on your computer. Printing and organizing photos will now be a breeze!
Bucky from The New Boston serves up this CSS video tutorial on how to use direct and indirect selectors with CSS web development. You can make stunning websites with CSS and XHTML.
Bucky from The New Boston serves up this CSS video tutorial on how to group elements using CSS web development. You can make stunning websites with CSS and XHTML.
Many wonderful things come from the workshop. However, it's hard to document this land of screws, sweat, and metal on the organized pages of a scrapbook. In this how-to video, Carmen pays tribute to her brother's workmanship and demonstrates how to create a page that tells a story of forged steel. So get out those photos of your favorite craftsman, some wire and a hammer and get ready to test your metal! Watch this video crafting tutorial and learn how to create a wrought iron rose scrapbook ...
The Apple Spotlight application in Mac OS X can do more than just searches for documents. Throughout your day, you may need to perform a calculation or look up a definition for a word. You can now do that directly from Spotlight. To acccess Spotlight, you can either click on the magnifying glass icon at the top right of your screen or hit command spacebar to bring up the search field. To learn more about using advanced features in OS X Spotlight, watch this video tutorial.
Oftentimes a friend will send you a PDF, MP3 or some other type of document such as a spreadsheet. When you open the file, an application opens. But sometimes it's not the application you wanted to associate with that file. In this video tutorial, you'll learn how to define which programs open what sorts of files. For more, and to learn how to set filetype application defaults in Mac OS X, watch this video tutorial.
When you copy text from one application to another, or even within the same document, you may notice that you're not just copying the text but style along with that. And when you've been spending a lot of time on the look and feel of what you're working on is right where you want it, you'll want to make sure it stays that way. For instructions on pasting and matching style, and copying and pasting a style without copying and pasting its attendant text, watch this video tutorial.
Have you ever worked on a document or graphic and found that perfect color but later were never able to recreate it? All you have to do is click on your colors palet, click on the magnifying glass, and select the color you wanted. To ensure that you don't lose it, drag it to the color well in the bottom of the palet. For a video demonstration of the color favoriting process in Mac OS X, watch this video tutorial.
Does your company use the same font for all of its documents and letters? Well, if you run Mac OS X, instead of changing it every single time, you can set up a favorite. Just open up your Fonts pallet; choose the font you want; change the size; and then click on the little gear button and add it to your favorites. For a video walkthrough of the OS X font favoriting process, take a look!
This tutorial shows you how use Blackboard, a popular content management system, to make a podcast available to your students. Blackboard provides an easy an easy way to upload a podcast and make an RSS feed for it available to your students. The tutorial is available on the companion Tech Ease for Mac site and includes a PDF document with the instructions. Learn how to upload podcast content to Blackboard and how to make an RSS feed available so you students can subscribe to the podcast feed...
Working closely with SketchUp models is key to LayOut and the primary feature that makes LayOut so unique. Take a look at this instructional video and learn how to place a SketchUp model in LayOut. To place the model, go to file and simply click insert. Find your model and then open it. The great thing about viewing a model in LayOut, is that it is presented in 3D form and you can build complex documents with infinite views of your model all with just one SketchUp model.
Learn how to add color, shape, and emphasis to your text and data in Microsoft SmartArt graphics in this tutorial. See which one works best for getting your point across. An organization chart? A time line? A process with sequential tasks? Non-sequential items? Pick one, and optionally customize it with colors, animation, effects such as shadows, bevels, and glows, and more.
It's no secret that Apple's Notes app supports attachments such as photos, videos, and web links, as well as other file types like PDFs, word documents, spreadsheets, locations on a map, and audio tracks. While images, videos, and document scans are simple to add on an iPhone or iPad, other file types aren't as easy — at least until you know how.
Melvin from QZPStudios takes you on a quick tutorial in which he creates an embedded text effect in Photoshop. This could be a useful trick for website designers who want to create banners containing text which have a shadow effect.
Step 1 In the Adobe Flash program, select “Flash File (Actionscript 3.0)” from the “Create New” menu. Switch the workspace layout by clicking on the dropdown menu in the upper left of the top menu bar, and selecting “Designer.” You can adjust the size and color of the document by adjusting the settings in the Properties panel.
Stop throwing out the rolls when the paper towels are gone. There are dozens of good uses for them. You Will Need
This tutorial will explain how to make buttons and links to flip between pages in InDesign files. Create sleek looking, easy to use documents that can be used as websites or PDFs. This video will show you how to use InDesign to its full potential.
In this tutorial, we learn how to bypass a blocked site on a school computer. You will need a proxy to do this safely. First, go to a proxy site like Proxify. Going through here will prevent the school blocking system from coming up and ruining your fun. If you are blocked, you can use a text file document and run CMD on your computer. This would be the more technological way to do it. Try doing the website first to see if it works, if not, then you can try to change the firewall on the compu...
This video is about combining Microsoft Project 2010 and SharePoint 2010. This combination helps project teams to collaborate and share project information. Information can be displayed on a dashboard. We will also discuss various levels of project management such as starting the project, planning, tracking and reporting on the projects progress.
In this Software video tutorial you will learn how to mount an image using Daemon Tools Lite. This software takes many different types files and puts them on a virtual DVD drive. Go to www.daemon-tools.cc and download the Daemon Tools Lite program. You then install it. After that double click on the icon on your desktop and it will appear on the bottom right hand corner of the screen. It will say Daemon Tools and the version. Right click > virtual Cd/DVD ROM. To mount an image, click on ‘mo...
This video teaches you how to open .zip files with a just few easy steps. First, you need to download a program Winrar. The download can be found at http://www.rarlab.com/download.html and the download should start immediately. Once the download is complete, open the program.
A three-part lesson in how to count and play your way through 12-bar blues changes on your harmonica. Required: a copy of "Harp Attack," a 1990 Alligator Records release.
