Vast Array Search Results

How To: Use the TRANSPOSE & FREQUENCY array functions in Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 38th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TRANSPOSE & FREQUENCY functions.

How To: Count days excluding Sundays 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 189th installment in their series of digital spreadsheet magic tricks, you'll learn how to count all the days except for Sunday using an array formula for a given date range with a specified start and end date.

How To: Count values between a lower & upper bound 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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.

How To: Use type hinting in your PHP design patterns

Type hinting in PHP appears frequently in design patterns but can be distinctively confusing unless you are totally familiar with it. This walkthrough from JREAMdesign raises your exposure levels to using type hinting in your parameter functions with objects and arrays.

How To: Create a simple form letter when programming in PHP

In this clip, you'll learn how to employ variables and arrays to generate a form letter when coding in PHP. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Implode and explode when using array functions when coding in PHP

In this clip, you'll learn how to implode, explode, splice and slice when coding in PHP. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Find & count the longest or shortest word 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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to find and count the longest and shortest words/strings with the MAX, MIN and LEN functions in an array formula.

How To: Choose a jigsaw

A jigsaw can be used to cut wood timber, metal, and plastic. The jigsaw is a very versatile tool, and comes in an array of options that may or may not work for you. Watch this video home improvement tutorial and learn how to choose a jigsaw.

How To: Set eyes into a reborn baby doll

When building a reborn doll, you have an array of options for how to put the baby together. This how-to video demonstrates the process of putting eyes into a reborn baby doll. You will need the reborn baby doll head, a setting tool, and the eyes that are being installed. Watch this video doll-making tutorial and learn how to set eyes into a reborn baby.

How To: Create a roof with inference locking in SketchUp

As a follow-up video to inference locking, this Google SketchUp tutorial shows how to combine a series of roof forms together using inference locking. You will also use arrays and copying to create dormers. Please keep in mind, this isn't a video on roofs, but an example of various inference locking techniques and how they work in Google SketchUp.

How To: Use Aussie slang

In this language tutorial video, Phil Rosenbaum interviews Australians about their favorite Aussie slang phrases. In Australia, of course the official language is English, but Australians have a rich and colorful array of expressions and slang words that they use. Check out this instructional language video and learn the meanings of several Aussie slang phrases.

How To: Use the move tool in Google SketchUp

Take a look at this instructional video and learn how to use the move tool in Google SketchUp. The move tool is actually several tools combined into one. The move tool functions as an auto fold and an array tool as well. This tutorial covers how move is an auto-selecting tool, how to pre-select objects for more control, moving objects with precision, and some common problems.

How To: Track fingers with the Wii remote

Using an IR led array and some reflective tape, you can track fingers in thin air using the Wii Remote by Johnny Chung Lee from Carnegie Mellon University. The grid software is a custom program written using a C# wiimote library and DirectX. Take a look at this instructional video and learn how to perfom this with the Wii remote.

How To: Security-Oriented C Tutorial 0x11 - Command Line Arguments

In many programs on Linux, you'll come across programs which allow you to specify additional arguments instead of just simply running the program by itself. If you've used the Kali distribution, I'm more than certain you'll have come across these with the command line tools, else if you have been following these tutorials, we have already come across three tools which also use the same technique, i.e. gcc, gdb and wc. How do we do this with C? Let's find out.

Basics of Ruby: Part 1 (Data Types/Data Storage)

Ruby is a dynamic, general-purpose programming language created by Yukihiro "Matz" Matsumoto in Japan around the mid-90's. It has many uses but with it's flexibility, it makes a great language to write exploits in. In fact, the entire Metasploit Framework is written in Ruby! The sole purpose of this series is to teach hackers the basics of Ruby, along with some more advanced concepts that are important in hacking.

How To: Find gold in rivers and streams

This film is about gold. Gold diving. Use of the hookah rig to find gold. Gold flakes, nuggets, and platinum nuggets are shown. Gold and platinum are 15-19 times heavier than other streambed materials and concentrate in low pressure areas and cracks that run across rivers and streams. You look for a crack on the bank, and follow it out until you meet the "gold line" and there you suck it out with your dredge. Gold will be on the outside edge of a river gravel bar, at the head of the bar (larg...