In this Excel basic video the instructor shows how to setup a spreadsheet and use cell references. Cell references are used in Excel to refer to other cells in a formula. When a formula contains data based on the cell reference the formula auto generates the result each time the value in the cell changes as the formula contains only the reference to the cell and not the actual data present in it. In this video the tutor goes on and shows how to write a few basic formulas using cell references...
Want to get more from the raw data you're entering into your Excel worksheets? Now you can create two distinct pivot tables in Excel comparing, for example, monthly and quarterly sales data. Not familiar with the pivot table? Pivot tables summarize spreadsheet input by counting, sorting and totaling data within a list and providing at-a-glance computations within the same sheet. Become an expert on the subject within 5 minutes and 24 seconds by following easy to understand instructions narrat...
Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
MotionTraining gives an overview for using Microsoft Excel for beginners in this video. This video gives a rundown and overview of the basics of this spreadsheet program: from typing in the columns and rows, adding dollar signs to data, and how to make basic calculations. MotionTraining will show how to make text stand out with bold and italics, adding colors to your data, and how to make a grid appear during the printing process. Creating various charts of the data in the spreadsheet is also...
Raku pottery artist Simon Leach feels that while most people who work with ceramics are taught how to make them, very few are taught how to decorate them. Simon will show you how to draw inspiration from your ceramic pots that will lead you to the perfect decorations. He shows you both how to decorate a ceramic pot in order to enhance its shape, while also showing you that sometimes it is the decoration that truly makes a ceramic pot special.
In this Adobe Acrobat 9 Pro tutorial you will learn how to develop a business workflow. Learn how to work with Microsoft Office products like Excel, PowerPoint, CAD drawings and more to create PDF versions of your Office documents, or create entire portfolios to give to clients right in Acrobat 9. Learn how to send files for review, add comments and interactive elements, and enhance PowerPoint presentations in this Acrobat 9 Pro tutorial.
How to listen effectively by Jeffrey Berman, professor of communications at Salem State College. Professor Berman explores all elements of listening to enhance interpersonal skills for managers. Don't confuse hearing with listening.
To draw water in black and white, accent the shadows and reflections to make it appear wet. Depict water in black and white with tips from a professional illustrator in this free instructional video on drawing. Enhance your landscapes with you new water drawing skills.
To draw oak bark, first understand the way the bark grows, and use natural, uneven lines to indicate each piece of bark. Render oak bark in a natural way with tips from a professional illustrator in this free instructional video on drawing. If you learn how to draw oak bark, you can enhance your landscape drawings.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using a pivot table to summarize data.
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 relationships and queries to pull data from tables. For more information, watch this Microsoft Office Access how-to.
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 an append and delete query sequentially using a macro. For more on archiving data in Microsoft office, take a look.
Need some help getting started running reports? This installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite covers the basics of running reports and sending data to those reports. Did you know there are four ways you can manipulate what data is sent to a report without any direct report customization? Take a look!
Filters are a powerful mechanism in OnTime used for searches and other forms of data manipulations. In this installment from Axosoft's own series of OnTime Project Management Suite video tutorials, you'll focus on the simplest application of filters: searching data in your main grid in OnTime 2008.
Master the technique with single lashes with this how-to video from Elle magazine. Enhance sparse eyelashes with some falsies. Watch this video makeup application tutorial and learn how to apply fake eyelashes.
Microsoft ASP.NET is a free technology that allows programmers to create dynamic web applications. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications. All you need to get started with ASP.NET is the free .NET Framework and the free Visual Web Developer. In this introductory video, Alex James will show you how to build a simple Entity Data Model in a short amount of time.
Microsoft ASP.NET is a free technology that allows programmers to create dynamic web applications. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications. All you need to get started with ASP.NET is the free .NET Framework and the free Visual Web Developer. In this introductory video Diego Vega will show you how to use the Entity Data Source in an ASP.NET Application.
Dave demonstrates six key stretching exercises to help enhance your range of motion and prevent injury. Follow along in this how-to video to learn the top six stretching exercises. Watch this video workout and learn to do the lying leg crossover, hip flexor stretch, perfect periformis hip glute stretch, partner hamstring stretch, partner squad stretch, and the shoulder back lat pec stretch. This six stretches are to get your muscles relaxed and ready for you next workout.
This data management tutorial shows you how to take a Microsoft Excel Spreadsheet and import it into a MySQL Database using CSV files and PHPMyAdmin in cPanel. Being able to move data from Excel to MySQL is an important part of database content management, so if you use cPanel to manage your databases, you'll want to watch and learn how to import Excel spreadsheets into your MysQL databases.
Check out this instructional cross country video that demonstrates how to eat properly so that you love running more. Because every runner is different, develop a nutrition plan that works for you. Experiment to find out what meals work best for you. Check out this tutorial that provides tips on eating properly to enhance your running workout.
If you're new to DreamCoder for MySQL, one of the things you may want to know how to accomplish is how to exchange information between two remote MySQL databases. Happily, this tutorial will walk you, step by step, through the process. To learn how to transfer data between two MySQL databases simultaneously within DreamCoder for MySQL, take a look!
Here's an instructional DIY video on how to extend your I/Os using 74HC595 chip and CUBLOC CB280. The input/output of a computer's memory can be enhanced with a modification using a microprocessing board and a mini-board. Watch this video computer-circuitry tutorial and learn how to extend I/O on a computer using a 74HC595 mini-board and a CUBLOC CB280.
Check out this step by step instructional video to learn how to make a Cosplay Sword from cardboard and wood! Make sure you have all of the following materials to start making your Cosplay sword: spray paint, hard cardboard, wooden dowel, bendable metal wire, silver colored tape, embellishment, super glue, hand saw, paper clay, masking tape, scrap papers, pen knife, and a PVC pipe. Watch this Cosplay video and enhance your role playing with this tutorial!
This Home & Garden how to video is a DIY basic about accentuating outdoor living space with solar lighting. Watch and learn all about strategic placing of solar powered lighting to enhance the look and feel of your front yard. Always start with a plan before setting up and installing the lights on your walkways.
You don't have to check the settings for every control individually — you can use the Logic Inspector to see a form's business logic displayed in a single window, grouped by features such as data validation, calculated data values, rules, and programming. Take a look at this instructional video and learn how to view the logic in a form template with Microsoft InfoPath.
Take a look at this instructional video and learn how to customize progress meters, icons, color coding, and other graphical elements to emphasize sales trends, product performance, critical deadlines, or whatever information is contained in the data behind your diagram.
Take a look at this instructional video and learn how to use a Microsoft Office Excel worksheet that contains employee data to create shapes, connect them according to your organization's structure, and add data to each shape in your drawing automatically.
A PivotDiagram is similar to an Excel PivotTable report: It arranges data in a visual way. Check out this tutorial and learn how to look at the same data from different angles to establish and analyze relationships that you might miss in a table or a worksheet.
Follow a few simple steps to make a set of vellum origami cubes. Then enhance the cubes with decorative paper, sequins, and sticky Zots. With a string of small white or colored lights, the origami cubes serve as perfect homemade party lanterns. More than an origami lesson, vellum lantern cubes can provide mood lighting for any room.
Watch this tutorial with Bill Myers and learn how to use the audio equalizer to sweeten the audio in Sony Vegas Movie Studio.
In this video tutorial, Scott Golightly shows how to implement a simple HttpModule that uses the BeginRequest and EndRequest events to store some data about the request and later display that data to the user. Scott also shows how to register the module in the Web.config file.
In this video tutorial, Chris Pels will show how to share data in between JavaScript and server-side code by using a hidden field in an ASP.NET page. Next, learn how to use the RegisterHiddenField method in server-side code to programmatically create a hidden field on the client. In addition, see how to programmatically create a HiddenField server control for sharing data on an ASP.NET page. Finally, use the RegisterArrayDeclaration method to create a container in server code for storing mult...
A video tutorial showing you how to export data from Excel to a Word document in a couple different ways. Copying from Excel to Word doesn't always do it right. Try exporting.
Brining turkey enhances flavor, tenderizes the meat, and reduces your bird's cooking time. Learn how to brine a turkey for you next Thanksgiving holiday or big turkey meal.
One of Korea's most famous beef dishes, bulgogi is made up of thinly sliced sirloin that is marinated to enhance its flavor and tenderness. Try making this delicious bbq beef at home.
Learn an easy way to enhance your pearl jewelry by using a sterling silver enhancer, which is versatile enough to be attached to several different kinds of jewelry.
This video shows you how to take apart a Nintendo Wii. WARNING: this will void warranty. All time and date data will be reset, but the game save data should remain the same.
Learn about the weapon effects in Dungeons & Dragons Online (DDO).
Austin Chau does a short tutorial about how to use the JavaScript Client Library with the Google Calendar Data API.
Make up artist Beau Nelson demonstrates how to do proper contouring to enhance your facial features.
