tech sectiontech section
Microsoft Excel is one of the most powerful and popular spreadsheet creation programs in existence. Learn why you should be using Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Using Microsoft Excel to catalog books gives you a document that you can then easily browse through in the future. Use Microsoft Excel to catalog books with help from a professional programmer, designer, and developer in this free video clip.
Putting the date on a cell in Microsoft Excel gives you another way to organize all of your information. Put the date on a cell in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Making a bracket on Microsoft Excel is just one of the many functions that you can add to your spreadsheet. Make a bracket on Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Microsoft Excel is a spreadsheet program included with all copies of Microsoft Office. Learn about the different functions of Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Converting Microsoft Excel files to text removes a lot of the formatting but leaves the actual information in tact. Convert Microsoft Excel files to text with help from a professional programmer, designer, and developer in this free video clip.
When you print out a spreadsheet in Microsoft Excel, you don't have to print every last element that you see on screen. Omit column labels in an Excel printout with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Shifting everything down in Excel doesn't require you to manually change every last cell in a spreadsheet. Shift everything down in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Changing a letter to a number in Microsoft Excel requires you to make a few key adjustments to the formula that you're already using. Learn about changing a letter into a number in the formulas at use in Microsoft Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
The quadratic formula is most commonly represented as "AX squared plus BX plus C equals 0." Use a quadratic formula in Microsoft Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Entering a birthday formula in Excel may be a little time consuming, but so long as you know the basics of the program it shouldn't take too long. Enter a birthday formula in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Making a cell turn a color in a formula in Excel requires you to play with some of the formatting options present in Microsoft's program. Make a cell turn a color in a formula in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Editing a formula in Excel is a great way to change a number of different cells in one fell swoop. Edit a formula in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Making a totaling column formula in Excel is a great way to keep track of lists of items, like how many hours you've worked in a week. Make a totaling column formula in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
If a formula contains an invalid reference in Excel, you'll begin to see incorrect results in every cell that uses that formula in any way. Find where a formula containing an invalid reference is in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Adding a number in Excel doesn't have to inadvertently change the calculations present in the rest of a table. Add a number without changing the formula in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Displaying only the positive results of a formula in Excel is a process that requires you to filter out results that you don't want to see. Display only the positive results of a formula in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Building a formula in Excel on a Mac is really just the process of making sure that the syntax of the formula is copied correctly. Build a formula in Excel on a Mac with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Modifying the conditional format formula in Excel will require you to take a closer look at the values of a couple of different cells. Modify the conditional format formula in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Displaying a percent sign in an Excel formula is something that you can do by clicking on a few key options within the program. Display a percent sign in an Excel formula with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
A formula sheet on Excel is a very useful tool to use to keep track of large amounts of information. Do a formula sheet on Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Copying a formula to multiple cells in Excel is a lot like copying text in Microsoft Word. Copy a formula to multiple cells in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
When editing the quantity of a cell in Excel, one thing you have to do is protect the formula so the rest of the spreadsheet doesn't get messed up. Protect the formula but edit the quantity in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.
Subtracting a percentage in Microsoft Excel is something that is accomplished by comparing the values of two distinct cells in a table. Subtract a percentage in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
The methods by which you must write formulas in Microsoft Excel are also referred to as the "syntax." Write formula to X in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
If you don't use the proper syntax when referencing a constant value in Microsoft Excel the entire spreadsheet could stop functioning properly. Reference a constant value in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Many people don't realize that you can actually use Microsoft Excel to perform complicated mathematics problems like finding and calculating exponents. Calculate exponents in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
The "Getting Started" window doesn't have to be a permanent addition to the Microsoft Excel program window if you don't want it to be. Remove the "Getting Started" window from Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Adding a counter in Microsoft Excel doesn't require you to download or install any additional software or plugins. Add a counter in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Microsoft Excel isn't just for spreadsheet creation - you can also use it to perform calculations and even find ratios. Find a ratio in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Sorting in Microsoft Excel 2007 can help you organize a table of information by a variety of ever-changing criteria depending on the situation. Sort in Microsoft Excel 2007 with help from a professional programmer, designer, and developer in this free video clip.
Making a grade sheet in Microsoft Excel allows you to quickly enter grade changes with a series of basic equations into a table. Make a grade sheet in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip.
Locking numeric values in Excel is something you can do with a few quick mouse clicks. Lock the numeric values in Excel with help from a software engineer with broad and extensive experience in this free video clip.
You can make your own Excel template for nearly anything you want, including nutrition facts. Make your own Excel template for nutrition facts with help from a software engineer with broad and extensive experience in this free video clip.
Defining a list name in Excel is a great way to keep track of all the data in various columns. Define a list name in Excel with help from a software engineer with broad and extensive experience in this free video clip.
Making a tooltip on a cell in Microsoft Excel is a great way to add information to a particular project. Make a tooltip on a cell in Microsoft Excel with help from a software engineer with broad and extensive experience in this free video clip.
Copying numbers in Excel that were derived by a formula is something you have to do in a very particular way. Find out how to copy numbers in Excel that were derived by a formula with help from a software engineer with broad and extensive experience in this free video clip.
Deleting duplicate photos from your Facebook account is a great way to clean up your albums. Delete duplicate photos from your Facebook account with help from a digital, mobile and social media aficionado in this free video clip.
Using division in Microsoft Excel is going to require the use of a few specific formulas. Find out how to use division in Microsoft Excel with help from a mechanical engineer with 32 years of experience in this free video clip.
The types of tables and charts that Microsoft Excel allows you to create are a great way to keep track of various types of information. Make tables and charts in Excel with help from a mechanical engineer with 32 years of experience in this free video clip.
Microsoft Excel has a wide variety of different real world uses, especially in the workplace. Learn about the uses of Microsoft Excel in the workplace with help from a mechanical engineer with 32 years of experience in this free video clip.
Important vocal clips is when a track really begins to come together. Import vocal clips into GarageBand with help from an audio engineer in this free video clip.
Counting the number of plus signs in an Excel formula isn't going to take nearly as long as you might fear. Count the number of plus signs in an Excel formula with help from a mechanical engineer in this free video clip.
Calculating a sum squared in Excel is going to require you to use a very particular equation. Calculate a sum squared in Excel with help from a mechanical engineer in this free video clip.
Rounding when multiplying in Excel can help make your data easier to read and understand. Round when multiplying in Excel with help from a mechanical engineer in this free video clip.
Getting the product of columns in Excel is something you can set up through the careful use of a few basic equations. Get the product of columns in Excel with help from a mechanical engineer in this free video clip.
Getting Excel to calculate division with remainders only requires the careful use of a few key tools. Find out how to make Excel calculate division with remainders with help from a mechanical engineer in this free video clip.
Incorporating trig functions into an Excel spreadsheet is very easy and only requires the right syntax. Use trig functions in Excel with help from a mechanical engineer in this free video clip.
Charting the tides in Excel is something you can do through the careful use of a regular table. Chart the tides in Excel with help from a mechanical engineer in this free video clip.
Microsoft Excel is a great program that will allow you to do many things and can even let you perform comparative graphic. Learn how to do comparative graphing in Excel with help from a mechanical engineer in this free video clip.
