Whether 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 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for stock portfolio return & standard deviation.
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 344th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the max value given more than one critereon (i.e., multiple criteria).
On Yay Math, Robert Ahdoot, founder of Yay Math, will show you some square root functions and some inequalities. He begins with the problem y=x². Then he makes a sketch with two intersecting lines in a t shape. The problem is illustrated by a curved U shape, the U's bottom resting on the horizontal bar, which represents x, while the center takes the vertical line. The vertical bar represents y. This U is directed up because the x² is a positive number. If the number were negative, the U would...
Take a look at this tutorial and learn how to get additional features on your iTUnes with Growltunes. On top of polling features, this application allows you to use various instant messagers such as amsn, msn, and skype.
Continuing with the trigonometry series, this lecture focuses on cosine and arc cosine.
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.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:
This is the demo showing how match quadratic equations in the graphs. Plug in x=0. So everything with x cannot disappear. There is only one negative three in the equations. Let's look at the equations that has the four as y in the set. One of the difference between each equations are the negative in front of the x square and not in the second one. B is the set which opens down and C is the set which opens. Now lets look zero as y on each set. Both of them are opened. Let's look at X intercepts.
To find a vertical asymptote, you are trying to find values of x that produce 0 in the denominator but not in the numerator. If 0/0 occurs, that means you have a "hole" in the graph. A vertical asymptote is a place in the graph of infinite discontinuity, where the graph spikes off to positive or negative infinity. To find the vertical asymptote, set the denominator equal to zero and solve for x. Check that the values also do not give a zero in the nominator. If the values work, you have found...
This C++ programming tutorial goes through the use of functions, pointers, how to make fullscreen, and changing colors per line.
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.
Some very cool features that you can do at Zamzar.com, and its all free. Check out Zamzar for some Great URL integration functions.
This AutoCAD 3D tutorial covers some fun with AutoCAD in making 3-D graphics using 3-D functions and rendering solid form.
This tutorial shows you how override functions inside UnrealScript for Unreal Tournament 3 (UT3). Specifically, create a customize trigger that plays a sound instead of triggering an event.
This video shows you how to use the basic functions of a Mini DV Camcorder and apply its various settings.
A spreadsheet software wouldn't be much good if you couldn't use formulas and functions on your data. This tutorial goes over how to use them in Numbers '08.
Windows Media Player 12 is ONLY available for Windows 7 (sorry Vista and XP users), but with it's functionality, it may be worth the upgrade (if you haven't already). This video outlines a few of the simple tasks that WMP12 can perform in W7.
In need of a new knife but don't know which one to get? In this how to video Chef Jean Pierre explains what knives are best for your kitchen and what their functions are. Never choose the wrong knife again.
In this music recording software video tutorial, learn how to use one of the latest programs for bands and musicians: Apple Logic Pro. This software allows the user to record a song from beginning to end, bounce tracks, master, and do a final mix down to CD, mp3, and other desired formats. Our expert will walk you through the operations you need to understand to create audio tracks, lay down drums, keyboard, and a bass part, edit and master them, and mix to a final song
Driving around and notice an accident the road keeping you from getting where you need to go? Well, you're in need of a GPS navigation system. Check out this video tutorial on how to Use media functions on a TomTom Go 930 Traffic navigator device. You'll see how to use the GPS system in details and see all of the key features of the Go 930 TomTom, like playing music, listening to audiobooks, and watching videos.
Chris Pirillo demonstrates some lesser known features of the XBox 360 including: the Shut Down feature, Custom music, the manual moving visualization, composite and component video, and changing the vision camera effect.
Top-Windows-Tutorials is a great site dedicated to Windows tutorials for almost all things Windows. Whether you are a computer novice or an expert in Windows operating systems, you'll find useful information in these guides catering to your level of expertise. These user friendly and easy to follow free Windows tutorials will show you all that you can do with your Windows PC.
This is a great instructional video on how to find oblique asymptotes of rational functions. Let us take the example f(x)= x square+4x-12 over x-6. Now we have to find the horizontal or oblique asymptotes of this rational function. The higher power here is x square which is at the top and hence we have to find oblique asymptotes of this function.When we divide x square+4x-12 by x-6 we get x=10 and the reminder is 48. Now you can easily write down the final answer. The oblique asymptote for th...
If you're having a little trouble operating your newly purchased Samsung Instinct cell phone, let Sprint help you out. This Sprint video mobile phone tutorial takes you through every step necessary to fully familiarize yourself with the Instinct cell phone by Samsung. This instructional tour will help you learn how to use the basic functions, like touching the screen, touching the buttons, making a call, finding contacts, enter numbers, check your email, text message, video message, search yo...
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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.
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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.
Need help in determining the amplitude and period of sine and cosine functions? This free video lesson will show you how. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
MapForce includes a powerful visual function builder that lets you create new data processing functions in a graphical way using existing functions and libraries. Learn how to combine multiple separate functions that returns a single result with this tutorial.
The is a video from free math tutoring that teaches you about in-equations or inequalities and optimization functions of algebraic problems.
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 and Mr. Excel, the 23rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKINGDAYS.INT, RANK.AVE, PERCENTILE.EXC, CONFIDENCE.T, T.DIST, T.DIST.RT and T.DIST.2T functions in MS Excel.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 13th installment in his series of Excel array formula series, you'll learn how to do multiple regression and linear algebra problems with Excel's LINEST array function. Also see how to use the SLOPE, INTERCEPT and the FORECAST functions for linear algebra and how to create a s...
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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use date and time functions together. Specifically, you'll see how to use the INT function to calculate total days worked and the TEXT function to calculate total hours worked.
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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
In this clip, you'll learn how to make calls into JavaScript functions with .NET code when working in Silverlight. Whether you're new to Microsoft's popular web application framework or a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free MS Silverlight programming lesson. For more information, including a complete demonstration and detailed, step-by-step instructions, take a look.
In this tutorial, we learn how to determine if you have a function. You will start off with two functions and their points. The 'x' values make up the domain of the function and the 'y' values make up the range. The input values are the domain and the output are the range. If you're checking to see if you have a function, you will need one 'y' for every 'x'. This means that each value has another one that goes with it. Each of the points need to have one partner with them, no more and no less...
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 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table values.
This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...
This video deals with solving quadratic functions. It does not involve the use of the quadratic equation; rather, only factored equations are used. The speaker starts out with a factored quadratic equation. The speaker goes on to do the mathematical steps necessary to find both the x and y intercepts of the quadratic function at hand. The author then continues on with the example to find the function's minimum. Next all of the points that have been solved for are plotted and the function is s...
