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 527th installment in their series of digital spreadsheet magic tricks, you'll learn how to enter VLOOKUPs 3rd Argument in four different ways: Number, COLUMN function, COLUMNS function, or MATCH function. col_index_num or Column Number for VLOOKUP
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 318th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract data with the MID function and use VLOOKUP to retrieve a date.
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.
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 155th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the TRIM function to get rid of extra spaces when a VLOOKUP function should work but doesn't.
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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP 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 91st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the FORECAST function to solve linear algebra problems.
Brightstorm explains how to use definite integrals to find area. There are two basic area problems: one in which the area lies between the function and the x-axis, and one where the area lies between the two functions. In the first case, if the curve lies above the x-axis for x=a to x=b, the definite integral returns the area. If it lies below the x-axis for x=a to x=b, then the definite integral returns a negative area. In the second case, we assume that f(x) is the higher curve and g(x) is ...
In this video tutorial, viewers learn how to define an indefinite integral in calculus. Finding the anti-derivatives of a function is called anti-differentiation. The f(x) is the derivative of F(x), while F(x) is the anti-derivative of f(x). If F(x) is the anti-derivative of f(x), then F(x) + c are all anti-derivatives of f(x). This video is very descriptive and clearly explains all the functions of this mathematical function. This video will benefit those viewers who are students, and are in...
Link shortening is the process of cleaning up the URL link which is long and converting it into a short URL. You can use bit.ly to do link shortening. Using bit.ly you can not only shorten the link but also track the users who are using those links. To use this service go to the http://www.bit.ly website. There in the home page you are provided with a text box. Enter your long link in the text box and submit it. Now the website converts the long URL and provides you with a short link which ca...
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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
Adding formatting to plain Excel spreadsheet is a wonderful way of increasing the readability and improving the overall look and feel of your data. With this software how-to from ExcelIsFun, you'll learn all about using the Microsoft Office program's formatting features. As an added bonus, you'll learn about the ROUND function, which is also useful for cleaning up charts where great precision isn't required.
YouTube user NotesCollegeAlgebra teaches you how to evaluate combinations of functions from graphs. You start off with a graph and some functions. (f+g)(-3), (g/f)(0) and (fg)(-6). You start looking at the graph and the first line and you get (f+g)(-3)=f(-3)+g(-3)=3+1=4. (g/f)(0)=g(0)/f(0)=2/-3=-2/3. (fg)(-6)=f(-6)g(-6)=(-3). But then when you want to find out g(-6) you realize -6 is not in g's domain. So the answer to the last equation is that it doesn't exist.
Not sure about all the functions and abilities of Microsoft Excel? Luckily there are free video tutorials out in the world... or better said, the World Wide Web, to help you. In this video, learn how to use the RAND function and sort in Excel to select a random name from a list.
Professor ElvisZap teaches you how to stretch shift and reflect the graph of a square root. A square root function is the opposite of a squared function. You start with y=square root of (x-1) it becomes 0<=x-1. then 1 <=x. You use the graph and solve it as you would for any function using small values first, then you have y=square root of x - 1, the domain 0<=x. This shifted the graph down 1 unit. 0=square root of x - 1, 1=square root of x, 1=x. Then the range is [-1 + infinity). Continue in ...
You can use the vlookup function in MS Excel to create a dynamic table in your document. Creating a new dynamic table and a new dynamic lookup area enaables you to add new data or new columns to the lookup table. You can also create dynamic named ranges by using offset, vlookup table and the match table. This function is very useful to businesses working on Excel. This video will show you to create a dynamic table for vlookup in Excel.
In this how-to video the person gives a detailed evaluation of the functions of the ti-89 calculator. The video is a short but informative look at the Ti-89 calculator. During the video the person shows a difficult math problem and shows how to use the Ti-89 calculator to solve that problem. The video uses some of the functions on the calculator and shows a display of where the buttons are located on the calculator. It also shows how to properly use the calculator to solve the problem while w...
Have you been having trouble publishing your website? Well, using NetObjects Fusion Essentials v7.5 you can easily publish your website as well as upload it to the internet. This video shows you the exact steps to doing this in a quick and easy step-by-step guide. It shows how to set up your FTP, user name, and password. After doing this you can easily make changes to your website. So if you're having trouble using this program or are simply looking for a way to get your website published and...
If you are given an equation of ellipse in the form of a function whose value is a square root, you may need to simplify it to make it look like the equation of an ellipse. Now equate the function to a variable y and perform squaring on both sides to remove the radical. Now simplify the equation and get it in the form of (x*x)/(a*a) + (y*y)/(b*b) = 1 which is the general form of an ellipse. Now you will have the x and y intercepts which are a and b respectively. Using this values graph the eq...
In this tutorial the instructor shows how to complete the square to graph a quadratic function using transformations. You can do this by transforming your equation in a series of steps. First make the coefficient of the square term to one by pulling out its numerical coefficient. Now to complete the square of the first part add half the coefficient of the variable with a degree one. Now to maintain the original value of the equation also make sure that you subtract the same value from the equ...
In this video tutorial, viewers learn how to create a button or banner for a website in Adobe Illustrator. Adobe Illustrator is a vector graphics editor. These buttons or banners can be used on personal websites or website channels, such as YouTube. Users are able to customize their button or banner appearance. Basic knowledge on Illustrator is required, but it is straightforward. This video will benefit those viewers who design their own website and would like to enhance their the appearance...
In this video the instructor shows how to use the Round function and also format numbers in Microsoft Excel. Normally while calculating formulas in Excel, the formatting of numbers can get you into a lot of trouble and to get around this problem you need to use the Round function. To do this take some sample data in a Excel work book and apply any formula that you want on the data to arrive at some calculation. Now because of this formatting some times you can arrive at a wrong result as show...
In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if you pay attention during this presentation you'll pick up the skills quickly! Several ideas covered in this video are Formulas with cell references, how to find various Excel functions to use in formulas, and the Effect f...
Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks.
Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
The instructor, Diesel, teaches how to bypass blocked websites at school like MySpace and YouTube. He shows how to make a batch file which opens the command prompt. Next, he shows how to ping a website like MySpace and how to extract the ip address of the website from the command prompt by using the mark option. Now, you can copy that address, paste it into the browser and go to the blocked site directly. By watching this video, you can easily learn to access blocked websites by bypassing them.
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
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.
This video is one of the amazing videos in which we can see the use of the vertices in real application. The video gives a clear explanation on how to use vertices into optimization function. This is a not only basic example in mathematics but also an important foundation for the advanced problems in mathematics. Viewers can gain a clear idea about the vertices and how they are used in an optimization function. This is a very essential part of mathematics which every student should learn abou...
Austin from 'Best Buy Tips and Tricks' give out a mobile tip on how to extend the battery life of your Blackberry by using the Blackberry's built-in function called the automatic black light dimmer. This function changes the brightness of the back light automatically depending on the light intensity of the environment you use the phone. Activate this function as shown in the video so that your phone changes the brightness of your Blackberry screen to an optimal level depending on the environm...
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!
WebStarts.com is a free website creation and hosting interface with a powerful drag-and-drop design interface. In this video tutorial, you'll learn how to add streaming video to your WebStarts website. For more information, and to get streaming live video from your own WebStarts site, watch this web design video tutorial.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using LEN to count word length. To get started using the LEN function for yourself, watch this how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about concatenation using LEFT and RIGHT functions. For more information, watch this Microsoft Office how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using the DateDiff function to work out age from birth date. For more, including detailed instructions, watch this Access how-to.
In this web development software tutorial you will learn how to create a full width header and footer for a website using XSitePro 2. Starting with a blank template that's 800 pixels wide, you'll learn how to add a black stripe running along the top and bottom of the website page. If you are building websites in XSitePro 2, this tutorial will show you how to create 100% wide headers and/or footers.
Want to access a website without using bookmarks or, heaven forbid, typing its URL into your address bar? This video tutorial offers instructions for creating a desktop shortcut to a given website while running any version of the Windows operating system and running any browser. Take a look!
New to the Ruby programming language or simply looking to brush up on your skills? In this installation from his Rubyology series of Ruby tutorials, YouTube user cmatthieu demonstrates some of the cool time functions supported by the Ruby programming language. Make time for and with this how-to.
In this software tutorial you will learn how to make a simple website using Photoshop. You may think it's too difficult to create your own site and that you need to use a template, but this tutorial will change all that! See how easy it is to design your own web page without a template right in Photoshop.
PHP is a script language used for developing web pages. On a website, you can use PHP to create complex organizational systems like a calender or even a reservation system (great for a restaurant's official website).
