Functions Diligently Search Results

How To: Security-Oriented C Tutorial 0x01 - Hello, World!

Welcome back, reader! In this tutorial, we will be covering our first program! So let's get to it. We all know the unspoken tradition of the first program when learning a language and of course, here we will respect and complete it. Fire up your favorite text editor (be it vim, emacs, gedit, it's all the same to me, no h8) and try to keep up.

How To: Use hotkeys to navigate 3DS Max for beginners

For 3D artists new to 3DS Max, learning your way around this massive piece of software can take a long time. It need not do. This video will teach you how to use some of the many hotkeys in the program to navigate it like a pro, easily accessing all of the most popular tools and allowing you to save a lot of time modeling. Now that you know what buttons to press to access functions, watch some of our other 3DS Max tutorials for more advanced functions.

How To: Create a distribution for categorical data in MS 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 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...

How To: Use repeat (REPT) function in Excel

There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. Just looking at the numbers, it is hard to compare the different sales easily, but a more visual approach may work better. Next to one of the cells, type in "=REPT(" which is the repeat function. A popup should say "=REPT(text, numbertimes)". For "text", type in *** or anything, really. For "numb...

How To: Test a hypothesis with Excel's TINV & TDIST functions

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 92nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the TINV and TDIST functions to test a hypothesis.

How To: Use the double space function in MS Word 07

Here you will learn how to use the double space function in MS Word 07. To use the double space function in MS Word, do the following: Open MS Word 07. After typing in some text, highlight the part which you want to double space. Click on the Icon that says "Line Spacing". Click on it and scroll down to find 2.0. Click on it. Now your work has been double spaced. A shortcut to do this would be to click Control and 2, and it will automatically double space everything for you.

How To: A Hacker's Guide to Programming Microcontrollers

While hackers know and love the Raspberry Pi, many don't know of its cheaper cousin, the microcontroller. Unlike a Pi, which can be used more or less like a regular computer, microcontrollers like the Wi-Fi connected ESP8266 require some necessary programming skill to master. In this guide, we'll build an Arduino program from scratch and explain the code structure in a way anyone can understand.

SPLOIT: How To Build a Peer to Peer Chat Application in Python ( GUI - Linux )

Developing GUI apps in python is really cool. I ask those who understand the language to help convert some of the command-line or console programs or apps ( I mean programs that are useful to a hacker ) to GUI. I know GUI makes us lazy and not wanna learn but we should all know its fast. Today's tutorial is on p2p chat app I developed last week and decided to share it with the community since its kinda cool.

How To: Create collapsible and expandable cell ranges in Excel

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...

How To: Build the y-axis gantry rail support for a CNC router

A CNC router machine is probably the most useful tool a hobbyist can own, but the price for a CNC machine on the market is way more than the average hobbyist is willing to spend. You can build your own CNC with very basic tools, little knowledge of machinery, mechanics, or electronics, but be warned, these machines are inherently dangerous, so wear the proper protection and use common sense. At the very least, read the instructions and precautions on every tool you use.

How To: Use the groove function in Ableton Live 8

In this tutorial, we learn how to use the groove function in Ableton Live 8. A group settings consists on points along the timeline where hits sit. If you have something with no groove applied, it will sound robotic. By adding a groove, you will shuffle around the midi from the hard quantized parts. This will add more human element to the audio. There is a button on the left with two lines that show the library with options you can use. You can also apply this to other clips, scroll through t...

How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions

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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Sum values after a deadline in Microsoft Excel 2010

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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

How To: Add yearly totals from monthly data in MS Excel 2010

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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.

How To: Extract records with 1 criterion via Excel's AGGREGATE

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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...

How To: Use Boolean logic for AND & OR formulas in MS 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 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. Also see how to create array formulas in two different ways: the SUMPRODUCT function (DON'T have to use Ctrl + Shift + ...

How To: Use the COUNT and COUNTA functions 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 658th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells.

How To: Access all Windows 7 settings at once

In this video tutorial, viewers learn how to access every Windows 7 setting at once. Users will need to download the Windows 7 in a Box program provided in the video. Once downloaded, simply click on one of the functions (Functions, Folders, Internet Settings, Programs, Tools and Settings) on top of the window and select the option that you wish to use. This program will organize all the Windows 7 settings into an easy to comprehend layout. This video will benefit those viewers who use a Wind...