In this video tutorial, viewers learn how to create tables in Microsoft Word 2007. Begin by clicking on the Insert tab and select Table. Then users are able to create a table by dragging the mouse across the squares to determine he amount of columns and rows. Make the final selection by simply clicking. Another option is to click on Tables and select Insert Table. Then users are able to input the number of columns or rows. This video will benefit those viewers who use Microsoft Office 2007, a...
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 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...
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 31st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to build frequency tables and simple histogram charts in Microsoft Excel. Specifically, this video addresses the following subjects:
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 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.
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. In this Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...
Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
De-fragmenting a hard drive improves the performance of a hard drive and it is recommended to de-fragment your hard drive from time to time as shown in this video. In Windows 7 you can use the Disk De-fragmentation tool. To do this go to the start menu and open the Control Panel. In the right column select the Performance Information and Tools. Now in that window in the left hand column select the Advanced tools option. In that new window scroll down to the Open Disk De-fragmenter link. Click...
The trinity stitch looks very complicated, but this easy tutorial makes it simple to create a crochet pattern that has three columns of eyelets which punctuate your stitch.
Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to build complex layouts in less clicks with paragraphs that span or split columns in InDesign CS5.
This square dance video teaches the following square dance calls on the mainstream list: Spin the Top, Alamo Style Wave, Wave Balance, Circulates (Column, Box, Split, 1 1/2), Chain Down the Line, Sweep a Quarter
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 713th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the max number of items in succession in a column of data using the FREQUENCY, IF, MAX and ROW functions.
In this tutorial, we learn how to calculate and add running percentages in Excel. First, write out your value and percentage into the different columns. Next, write the formula in the cell where you want the answer to appear. To have the answer appear, highlight the box and drag it down, then the answers will start to appear in each of the different columns for the different equations. This is an extremely simple way to calculate these percentages without having to do any math! As long as you...
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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.
In this tutorial, we learn how to use templates in Dreamweaver. First, go under "create new" and click on "hdml". Start with a table that has three rows and one column at 100% width. Click in the middle one and split the cell into two columns. Now, click "insert", "template objects", then "editable region". Type text into this box, then it will show up on your page. Whenever you open a file, this will be the part you can edit, while you won't be able to change anything else. Now go to "file" ...
In this Software video tutorial you will learn how to make a basic bar graph in Microsoft Excel. You will also learn how to give your chart a title and how to label the axes. First you put in all your data in to an Excel spreadsheet. Then you highlight the data you want to put in your graph, select the 'insert' tab, then' column' and choose the basic column chart. Next you select the title tab, go to option and choose new title. Now you add the title to the graph. To label the axes, go on top...
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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.
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 192nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the middle name in quotes from a cell that has last, middle and first name using Excel's in-built text-to-column tool.
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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).
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. In this Excel tutorial from ExcelIsFun, the 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.
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 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.
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 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Excel Table feature and Table Formula Nomenclature for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup tabl...
The video shows us how to solve a system of equations with the elimination method. First write the two equations one on top of the other, as it is going to be elimination method and it is recommended to write it in that way. Here the 2 equations are x+y=-3 and x-y=1. In the elimination method we need to add the 2 equations by columns. So adding it column wise we get to have 2x=-2 and solving this we will get the value of x=-1. Then you need to substitute this value of x in any of the two equa...
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that.
In this Excel magic trick video the tutor shows how to print labels on each page of a large spreadsheet in Microsoft Excel. He shows how to download the sample work book so that you can try the tutorial hands-on. He shows a spread sheet which he intends to print and wants the label of columns to be printed in the top and left of a page. For that he shows the page setup preview where you can check the print preview of the pages about to be printed. He shows that the columns appear on only the ...
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
For people who are learning basic math skills, this video will show you how to subtract larger numbers which involve borrowing. If the top number on your rightmost digit is smaller than the number before it, you will need to borrow from the column before it. To do this, you will have to cross out the left hand number, subtracting one from its value. You can then add 10 to your original number and continue with your subtraction. If the left hand number is 0 and too small to be borrow from, you...
The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.
Collecting cerebrospinal fluid in a dog may be required to help determine a dogs illness, and help determine treatment of the sore puppy. This video tutorial for veterinarians will show you how to collect the cerebrospinal fluid of a dog, properly.
This step-by-step instructional video shows how you can do it yourself for your next party or event decorations. Air and helium filled balloons were used along with other easy to find supplies. Make your obsession for twisting balloons useful.
The Start menu is finally back in Windows 10, but a lot has changed since we last saw it in Windows 7. From a visual standpoint, the first difference you'll notice is the addition of live tiles, which occupy the right half of the Start menu and provide quick information from your "Universal" Windows apps.
When I compare my iPhone 4S to my friend's iPhone 5, I notice that his elongated screen gives him an extra row of applications. Am I jealous? Yes, a little.
The discomfort and inconvenience that comes from knee and hip pain can prevent you from enjoying the things you love. As part of the Johnson & Johnson Family of Companies, DePuy is a global leader in finding solutions in orthopaedics, spinal care, sports medicine, and neurosciences. Check out this video from DePuy to learn how a real-life patient was able to enjoy one of DePuy's many movement solutions and return to living a normal life.
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...
Slack recently released a dark mode for its Android and iOS apps, and for the most part, it works great. Super dark gray backgrounds and light gray fonts, which is much easier on the eyes than blinding white backgrounds and black text. But there's one thing that is not affected by the new night mode setting — your sidebar.
