Have you ever looked at your iPhone dock and wished you could place an extra, essential, or highly utilized app on there? Currently, with the basic settings you can only place four, but there's always that one that you wish could add to the mix.
In this video, we learn how to connect your Xbox 360 using a USB modem. First, plug in your Xbox to the USB and then plug that into your computer. From here, go to the network connections section of your computer. You can do this by going to the start menu on the right hand side column. When this window comes up, go to properties and then click the advanced tab at the top. From here, click on the box underneath the sharing section, then hit the 'ok' button again and you will be able to connec...
Need to know how to create and use hyperlinks in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.
In this tutorial, we learn how to use vocal effects and Auto-Tune in Fruity Loops. First, load on your audio and then set it to a channel FX. Add in the effects that you want and then drag them into the right hand side column for the different effects. From here, you can use the mixer to add in different beats and tunes. Then, you can add reeverb to the audio and then change the settings for it how you would like it. Continue to edit the different effects as you continue to scroll through the...
In this video, we learn how to find the determinant & area of a parallelogram. The determinant of a 2x2 matrix is equal to the area of the parallelogram defined by the column vectors of the matrix. Graph both of the equations that you are given on the vertical and horizontal axis. After you have all of the coordinates in place, you will be able to plug in the correct numbers to figure out what the answer to the equation in. This is more advanced math, so if you have not done it before, you sh...
In this software video tutorial you will learn how to merge and unmerge cells in Excel. A cell in an Excel spread sheet is assigned a row and a column number. You will mostly need to merge cells when you are trying to create headers that span across two or more cells. For this select the cells that you want to merge by clicking and holding down the left mouse key on the first cell and then dragging it across the other cells that you want to merge. Then go to the 'home' tab, click on 'alignmen...
In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...
When you are organizing the panels of your comic, you should keep in mind the way you want eyes to follow it. With multiple panels on a page, your spacing between them will determine where the eyes will go. If you want the reader to read up and down and from left to right, then you should create columns, by leaving more space in the middle.
If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...
This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...
This video shows how to create a menu with rollover images in Dreamweaver. Open a new document and create a table with one row and one column. To add your rollover images, go to the "Image" tab and select “Rollover Image”. In the “Insert Rollover Image” box, give the image a name, then click “Browse” under “Original Image” to find your images. You can select your rollover images in the same window. Then enter your alternate text and click OK.
First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.
In this how to video, you will learn how to remove acne with Photoshop. First, open the image you want to edit in Photoshop. Go to the left column and select the healing brush. Next, set the brush size and find a part of the image that is clear. Hold alt and click. Next, start clicking on the areas that you want to remove. As you can see, the spots are replaced with the color that you chose earlier. Keep on doing this until the image has been completely healed. This video shows you just how e...
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to return multiple items from one lookup value and see a formula to return just the numbers from a column containing both text and numbers.
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formula for a stem and leaf chart for numbers that have more than two digits. This is accomplished through use of the IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL and ROW functions.
Jacky Liao and Tony Liao describe the main attributes of Sudoku and provide tips on how to solve the puzzle. Sudoku is a popular puzzle just like crossword. It is a puzzle of a 9X9 square sub-divided into 3X3 squares. You have to fill each column and row with digits 1 through 9 in any order. Each 3X3 sub-square must include all digits 1 through 9. Every Sudoku game starts with a few of the squares filled in. The more squares that are filled in the easier it is to play. As you fill in the squa...
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...
The author teaches us how to graph the linear equations with tables. Given a set of linear equations in terms of "x and y", first we have to draw a table having a column each for x and y. We have to enter an arbitrary value of x in that table and substitute that value in the given equation to get the corresponding y value. Once you obtain both x and y values, the next step is to plot them in a graph. Consider an example: in the linear equation x=2y,on substituting an arbitrary value of x=2,we...
In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semi-weekly, bi-weekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you w...
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.
This videos explains how one can easily find the parallel line to a given mathematical equation. He starts by explaining what it means for two lines to be parallel mathematically speaking. Defining two lines, then comparing the slope of both lines you can mathematically determine that they are in fact parallel. He then moves to common math problems found on tests where you are given a point and a linear equation. He then forms a T-table with one column being line one and line two and illustra...
In this video you learn how to understand the basics of matrices. The video includes how to do matrices with addition, subtraction and multiplication. The teacher explains in this exercise that you will need to know the number of rows and columns. He breaks down all of the steps required to solve these problems. Not only does he show how to understand the basics of matrices, but he does it dressed up like a king and with a little reggae music. You can hear the class's reactions to his jokes i...
This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...
Follow this video to learn how to formulate calculations in Microsoft Excel. First type in a list of numbers in the cells. In order to calculate the median click on the cell where you want the answer to be shown. Then type equals, average, open bracket and insert the cell code where the first number is, colon, and then type in the cell where the last number in the list lies, and close brackets. In practice this is an example where the numbers are in a list from cell A1 to cell A11: =AVEARAGE(...
Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
In this Excel basics video, the instructor talks about the basics of charts. There is an enormous difference in how you make charts between Microsoft Excel 2003 and 2007. In both the versions, to make charts the first thing you do is highlight the data cells in your workspace. Now use the toolbar and click on the charts button there. Now Excel automatically generates the charts based on the data and the column and row names. But there are various changes between the charts produced in the dif...
MotionTraining gives an overview for using Microsoft Excel for beginners in this video. This video gives a rundown and overview of the basics of this spreadsheet program: from typing in the columns and rows, adding dollar signs to data, and how to make basic calculations. MotionTraining will show how to make text stand out with bold and italics, adding colors to your data, and how to make a grid appear during the printing process. Creating various charts of the data in the spreadsheet is also...
ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.
Welcome back, my amateur hackers!
If you want to create a Pareto Chart for categorical data in MS Excel you should first have your data input into Excel already. From your data, you should highlight the cells that you want to count the frequency for and in the frequency box you should type in =COUNTIF and highlight the data you want the frequency for and put in F4 and then press , click on cell to the left and click enter. Now this will work all the way down. If you have not sorted it, you can right click and then click sort....
1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a cell in Region and Right click and select Sort A to Z 5. Then click a cell in Region and select Data->OutLine->SubTotal 6. In the SubTotal Window select 1.Each Change in: Region 2.Use function:Sum 3.Add subTotal to:Sales...
This video teaches the simple steps to make an animation resume at Ani-Jobs. An excellent summary is given below. First click on the Resume cafe tab on the top menu, log in or create an account if you don't have one. Select a suitable category like 2d Artist, click the Storyboard sub-category. Add your name to enter the resume building page and start to input your details. In the reel column give the number that comes after "v e" in the link. Upload your résumé, artwork and your comments, lea...
This video will show you an interesting trick which you can use to access Facebook or other web pages on a school server or other place where Facebook is normally blocked with the help of Google. You will need to first go to the Google homepage and find the button at the top of the toolbar which says "more" and go to the pull-down option of "even more" options. This will open up a new web page. You should then go down to the "translate a webpage" option on the right hand column of results and...
Now that Android Nougat lets you add your own custom Quick Settings tiles, your pull-down menu is probably getting a lot more crowded than it used to be, with all sorts of new and useful toggles. But the trouble is, you can only add up to nine entries before your Quick Settings tiles spill over into a second pane that you have to access by swiping, and that's not exactly "quick."
We've all heard our fair share of roommate horror stories, or have some of our own, because we never truly know who someone is until we've lived with them. Cohabitation issues generally revolve around things like bills, chores, cleaning, and groceries. Approaching a roommate, especially an adult one, to remind them to do their chores can be an anxiety-ridden and daunting task. After all, we're roommates, not parents!
Learn to use text area, text column, spell check, dictionary tool, font-faces and font-size and text justifications. Many other text attributes are covered as well. Their are some other features available for the text tool but they will not be covered until a much later tutorial. If you have any questions or tutorial request just leave a comment.
Learn how to massage your dog. Man’s best friend gets stressed, too! A massage can benefit your dog’s health as well as their mood.
In this software video tutorial you will learn how to create a column line graph in Microsoft Excel 2007. First you type in the data in to the work sheet. Then highlight the data and click 'insert' on the menu bar. Here you select the 'column' option and go down and click on the type of column that you want. And the graph is automatically presented. Now click on 'move chart' and select a sheet where you want the graph to be moved to and click OK. To change any field in the chart in to a line ...
