Data Keluaran Search Results

How To: Find confidence intervals without the sigma in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...

How To: Use Microsoft Excel 2007 for statistics

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.

How To: Return many items for a single lookup value in Excel

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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...

How To: Extract records with an advanced filter in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Remove RC Lexan paint from a model car

To remove the lexan paint, obtain a bottle of brake fluid. Make sure you read the Material Safety Data Sheet (MSDS) for its harmful effects, and put on a pair of gloves to avoid contact with the hands when applying the brake fluid. To remove a large area of paint, pour a little amount of brake fluid onto some paper towel, and rub the area in a circular motion until the lexan paint is completely dissolved and removed from the area. A Q-tip can also be used to remove smaller areas. Apply as muc...

How To: Use an advanced filter to extract table data in Excel

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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.

How To: Create a dynamic break-even chart in Microsoft Excel

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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.

How To: Make an Excel dynamic named range across multiple rows

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...

How To: Use an array formula to filter data in Excel

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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...

How To: Use differential equations to solve for velocity

The guy first gives the definition of differential equations. He explains that a differential equation is an equation that contains the derivatives of an unknown function. He then gives some examples of differential equation and explains what the equation's order means. After that he gives an example on how to solve a simple equation. He calculates it and gives examples of graphs. Then he explains what a general solution is and how to narrow down the number of solutions using data from the pr...

How To: Make a frequency polygon with 2 or more lines in Excel

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. With this video tutorial from ExcelIsFun, the 329th installment in their series of digital spreadsheet video tutorials, you'll learn how to create a frequency table. Then see how to calculate the midpoint of each category and make a frequency polygon with two or more lines (two or more data sets).

How To: Tether iPhone's 3G Internet to iPad with MyWi App

If you don't want to spend an extra $130 to get 3G for your iPad, you can use the app MyWi to tether your iPhone's 3G connection to your iPad. This video shows you the easy way to tether your iPhone's 3G or EDGE Data Connection to your iPad, or any other Wi-Fi enabled device. So skip paying the extra dough and get a 3G connection for free! Be careful, as this can drain your iPad's battery!

How To: Use VLOOKUP with multiple lookup values in 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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.

How To: Find the percentage of total from a DB set in 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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.

How To: Add title labels & set data labels in MS Word 2007

This video is from HelpVids and describes how to change the axis titles on charts in Microsoft Word 2007. To access the chart tools, select the chart and the tools will appear above the ribbon. There are many different design options that you can preview on the screen to make your final selection. To change the chart title, click on the Chart Title button which is located on the Layout ribbon. You can then select where you would like the title to appear. Once you select the location you can t...

How To: Use calculation and summary fields in FileMaker Pro 10

If you are a user of FileMaker Pro then this video teaches you how to use calculation and summary fields in it while making new files. In Filemaker you can create a various kind of fields that you want your file to contain. In Filemaker a calculation is a data that gets computed depending up on the formula that is set in the Filemaker database settings. Calculations are very critical in file management. Open the Manage Database and there you can find some of the calculation fields. There in t...

How To: Use date fields with FileMaker Pro 10

Whenever deciding to use fields in FileMaker Pro 10, some fields require special handling like the date field. Date field is able to store any date between 1/1/0001 to 12/31/4000. It stores dates in the form of whole numbers. Now, to create a date field, it shows at the bottom of your data and date can be stored. The format of the date can also be changed. One can add dates as well as get the number of days elapsed. This is quite flexible in terms of format as well as keeping records.

How To: Create graphs in Illustrator

You will learn to create graphs in Illustrator. The best way to visualize data is a graph, and there are several different graph choices in this program. He chooses a column graph to show how he creates his graphs. Holding the left mouse button and dragging, he creates a rectangle which will be our graph. This brings up an input screen beside the rectangle for the graph; he puts information into the screen which shows up on the graph when he is finished.

How To: Use time/timestamp fields with FileMaker Pro 10

When defining fields in FileMaker Pro 10, one has to choose what type of field to decide for a database. There are two fields that accommodate special handling of data. They are time and time stamp fields. When one decides a field under manage>database,there is a option for "type". Under that, there is time and time stamp. The "time" one determines the time while the "time stamp" determines the time and date. This will help in preparing a proper and detailed database system.

How To: Use Excel keyboard shortcuts

This video is all about the keyboard shortcuts that are used in Microsoft Excel of the latest version. If you really need speed and efficiency then watch this video for its shortcut keyboard buttons. After typing all the data, if you need to see the page setup with the help of the mouse than it will take a pretty long time. By opting for keyboard shortcuts you can save much of your time and can invest it in another work. If you press 'alt' button then it will show keyboard shortcuts on the sc...

How To: Find data with Instant Search in MS Outlook 2007

Microsoft Windows Vista Tips - Finding Information with Instant Search in Microsoft Office Outlook 2007 - Somewhere in the hundreds, or perhaps thousands of messages in your Microsoft Office Outlook 2003 mailbox is the one that has the information you need about that client meeting on Thursday. So how do you find it without reading through every one of your messages? The new Instant Search feature in Microsoft Office Outlook 2007 allows you to find the information you need instantly. For more...

How To: Set the correct date and time manually on the Samsung Galaxy Tab

If you're not connected to the internet or don't have a data plan on your Android-powered Samsung Galaxy Tab, then chances are you don't have the right time and date. But don't worry, it's an easy fix! Simply go to MENU < SETTINGS < DATE & TIME and uncheck the AUTOMATIC to set the date and time manually. Choose SELECT DATE to change the date, SELECT TIME ZONE to change your area of the world, and SELECT TIME to adjust the hours and minutes of the day. Easy as can be.

How To: Sync a BlackBerry with a Mac and iTunes

In this video from AppleGenius0921 we learn how to sync a Blackberry with a Mac and iTunes. There is now Blackberry software for Mac. After downloading, start up the application. Take your USB cable and connect it from your Blackberry to your Mac. You can see all the applications on your Blackberry listed on your Mac. Here you can also check for updates and see your available memory. Also you can backup all of your data here. This will make a copy of everything on your Blackberry and put it o...

How To: Make notecards for your reasearch paper

In this video, we learn how to make note cards for your research paper. Note cards will help keep your data organized and easy to organize. Take a pen and write out the title of the card on the top, then write out the pages you got the information from next to that. From here, start to write down information on the card, covering one topic per card. Use any notes that will help you out and have the most amount of information on them. After this, use a highlighter to highlight the different wo...

How To: Create a line chart in Microsoft Excel 2011

Want to generate a line chart in Excel 2011? 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 fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started creating and using line charts to visualize data in your own MS Excel '11 projects, watch the video.

How To: Tell if your hard drive is failing in Ubuntu Linux

With this video, we learn how to tell if your hard drive is failing in Ubuntu Linux. If you have a failing hard drive, it will start making noises like clicking or grinding. If you hear these noises coming from your hard drive, you will need to get a new one before it fails completely and you lose all your data. You could have a failing hard drive but it doesn't make any noises. Hard drives come with a monitoring system so you can see what shape the hard drive is in. To see this, open up the ...

How To: Connect to Xbox Live with an iPhone & PC

In this tutorial, we learn how to connect to Xbox Live with an iPhone & PC. You will need: jailbroken iPhone with data plan, laptop, PDANET on the phone, Ethernet cord, and Windows. First, launch the application on your phone and then plug it into your laptop. After this, you need the Pdanet software, which you can download online. From here, right click on the software and connect. Next, you will connect the laptop to the Xbox console with the Ethernet cord and going to the network settings ...

How To: Download torrents

A torrent is a small file (usually less than 100 KB in size), which contains file details, URL details and other data, that enables peer-to-peer download using a torrent client.

How To: Hack your iPhone 3G

In this video, we learn how to hack your iPhone 3G. To do this, you will need: iPhone 3G, Firmware 3.0 or 3.1 file, charger cable, and the Redsn0w program. First, connect your phone to the computer and then start up the Redsn0w program on your computer. Turn the phone off, then restart it. The phone will now connect to the program on the phone and it will say "downloading jailbreak data". You will see a pineapple walking around on the screen. After this, restart your phone again and it will b...

How To: Use MIDI in Record

In this tutorial, we learn how to use MIDI in Record. First, automatically find your controller keyboard and set it up in your software. With this set up, create an ID8 instrument by clicking on the icon. Settle for a grand piano and record something to test it out. All clips are recorded and save mini notes, data, automation, and more. Clips can be moved, resized, duplicated, split, and joined through Record. These make up the arrangement and make the music. You can automate anything you wan...

How To: Boot up your computer faster with boot defragment

This video tutorial is in the Computers & Programming category which will show you how to boot up your computer faster with boot defragment. Boot defragment places all the boot files together in the hard disk making it easier for the booting process to start. Click on start > run, type in 'regedit' and click OK. This will launch the registry editor. Here you double click on hkey_local_machine to open it. Then you double click on software > Microsoft > dfrg >BbootOptimizeFunction Click on 'ena...

How To: Reset your browser history in Mozilla Firefox

In this video, we learn how to reset your browser history in Mozilla Firefox. First, open up Firefox, then go to the options menu. When you're on here, go to the privacy tab and then click on the options that will dump out the history that has been saved. You can also change your settings if you want to remove your search history and clear your cookies. At the bottom, check if you want it to clear private data. After this, press on the "ok" button and everything will be saved. When you are do...