Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple. The Microsoft Office for Mac team shows you just how to build formulas by using the new Formula Builder in this how-to video.
A function or signal generator is an electronic device that can create different types of waves and send them through a circuit without building oscillators. This video will teach you how they work and how to build a basic LED dimmer that uses one as an example.
There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...
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...
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.
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 206th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate commissions with the VLOOKUP function when the lookup value is an account type instead of a number.
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 252nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a cell range typed into a cell in a function.
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...
This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...
This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.
If you want to be serious about using Adobe Illustrator, then learning how to use type is an essential part of your skill set. Type can help you with a wide range of assignments, from designing logos to image building and much more. There are a number of settings and functions when using Type, so it's important to know all of the options that are available to you. This video tutorial will teach you how to use the area type tool in Illustrator.
Watch this video to learn about the fundamental commands of C++. Also covered are the topics of custom commands, different file types, headers, and the main function.
An electrophorus is a type of capacitor that generates electrostatic energy. Most of you probably know this force as static electricity, the domain of door handles and polyester shirts. It can be used for all sorts of other fun science experiments though, and this video will show you how an old hard drive, some plastic, Styrofoam, foil, a cat, and other simple materials can be used to make a a simple functioning electrophorus.
The factorial of a number n can be defined as the product of all positive integers that are greater than 0 but less than or equal to n.
Welcome to a tutorial explaining functions. This article will help clarify some things we have already been exposed to such as function prototypes, function calls, return values, etc.
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.
In order to cleanse your body of toxins, you first need to determine the types of toxins you've been exposed to. This can be done with blood screening or urinalysis or liver function tests. If the liver isn't functioning properly, then there will need to be some steps taken or the benefits of cleansing won't last very long.
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 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
Bucky from The New Boston serves up this Python video tutorial on how to build and program your own functions in Python. This is the program you use to write all of your Python code down. Learn how to create your own function!
Bucky from The New Boston serves up this Python video tutorial on how to program lists functions in Python. This is the program you use to write all of your Python code down. Fun with list functions!
Learn how to generate outlines from text when working in Illustrator CS5. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video guide.
While hackers adore the command line, working with the GUI (graphical user interface) of an operating system has some advantages. This is especially true when it comes to post-exploitation. When we can control the mouse and keyboard of a remote computer, we can truly say we have complete control over the device. Today, I'm going to introduce to you the PyAutoGUI module, which does just that, and just how much fun you can have with it!
This video instructs you how to use the "Finder" Button if you own a Mac on OS X. The "Finder" window shows the Mac user the contents of the hard drive. It describes functions of the Finder folder: i.e., adding an untitled new folder in the Finder file. It also discusses how you can view the "Finder" in a variety of layouts: grids, lists, etc. The video shows you how to use the buttons on the upper left hand corner of the "Finder" screen to maximize, minimize, or close the window. It also dis...
This video explains the different kinds of zones you will come across in Microsoft Windows Server 2008 DNS. The video has practical step by step instructions to managing these zones, as well as understanding their different functions and uses, and covers replication.
Utilize the mutli-out function using the Toontrack Superior Drummer plugin with the Logic sound program! This tutorial lets you create very professional sounding drums that you can add into your music projects. Select from a variety of different drum types.
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 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.
Sometimes the hardest step to operating a new mobile phone is just turning it on. This video guide to the LG C200 shows the basic getting started type functions, from turning it on and off, to charging, taking photos, and making phone calls. Watch this video cell phone tutorial and learn how to use the LG C200.
The Formula AutoComplete feature in Office Excel 2007 helps you avoid syntax or typing mistakes that can break your formula and display an error in the cell. Every step of the way, Formula AutoComplete guides you with ScreenTips that show you how to build your formula. Watch this tutorial and then try it yourself.
Which printer is the right one for you? The Lab Rats,Andy Walker and Sean Carruthers, go over the different types of printers: laser, inkjet, and multi-function and help you choose the right one for your needs.
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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...
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.
This video demonstrates how to open up the command line prompt and various commands which you can use to make your Windows experience easier. After clicking on the "Run" option from the start bar of Windows, you can then type "cmd" into the box, opening up the command prompt. The appearance of the command box can be changed by left clicking the small icon at the top left, going to properties, and changing the appearance. One useful command in the prompt is "ipconfig", which you type into the ...
Bucky from The New Boston serves up this Python video tutorial on how to program parameters in Python. This is the program you use to write all of your Python code down. Different parameter types in the same function!
Regression functions are a vital part of statistical analysis of populations, and if you're involved in business, science, or nearly any academic field you should understand how it works. This series of videos will show you how standard regression functions, ANOVA, ordinary least squares, and everything else you need to know.
Learn the techniques to create three different types of shiny bars and buttons in Adobe Illustrator. The classic button, the rounded "ball" button, and your basic shiny toolbar. Using gradients, transparency, and simple shape tools, in combination with the pathfinder. Whether you're new to Adobe's popular vector graphics editor program or a seasoned graphic arts professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application...
Step1. Determine the type of job you want. Make sure that you have a detailed and complete profile on ‘linkedin’. You must also have a number of connections. Then decide which job you are looking for and the typical functions and titles. Also choose which type of industry you would like to work in and also choose what locations. You also need to write down specific names of organizations that you want to work for and who are they.
This video shows you how to do a mathematical representation on computing the nCr function using a TI-89 calculator. You can write the nCr notation in different forms. It can be simplified from nCr to C(n,r). The symbol can either be read "n choose r" or "n taken r at a time" which are from it's probability applications. On the example to find "26 choose 17", go to the Home screen of the TI-89 calculator and then go 2nd 5 which is Math. Go choose probability and then to nCr to type in (26,17)...
It's been a while since I wrote up an article for this series but I did say that I'd be covering some WinAPI. So if you're interested in programming for the Windows platform, hop aboard and follow along.
Alright so last time I gave you a homework assignment. This week we're gonna look at my version of the UDP-Flooder.
What's up, peeps? In this quick tutorial, we will be looking at structs, a special kind of data type.
