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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...
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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT functions.
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 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.
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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
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 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
Microsoft had boasted that Windows 10 starts up as much as 30% faster than Windows 7 would on the same device, but depending on your setup, this can still be incredibly slow. Many programs choose to start up alongside Windows, which can make booting your PC quite a hassle.
Meat tenderizers are absolutely necessary when dealing with leaner, tougher cuts like flank or skirt steaks. And while fruit like papaya, kiwi, and pineapple contain enzymes that can tenderize meat, the results can be hit-or-miss, and impart a fruity flavor that you may not always want.
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.
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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.
In this video, we learn how to create a free Weebly website. First, type a title in that you want for your website. After this, you will be brought to a new page where you can change the elements and designs. The design can easily be changed until you find one that works for you. After this, you can start to customize the template that you have chose and add in new paragraphs, columns, pictures, and more. Next, you can change the pages and add in links and more information. Adjust the setting...
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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.
In this tutorial, we learn how to create links between tasks in MS Project 2007. First, select the task you want to link, then click on the link task button on the toolbar. You will now see a finished task link between these tasks. In the entry table, you will see the predecessor, which is task two. You can also type the numbers in the predecessor column and enter the information in. You may want to create a link that is different, so you don't confuse two things that will start at the same t...
In this tutorial, we learn how to set up work resources in MS Project 2007. First, go into your chart and click on the resource sheet from the file menu. Now, you will be able to change the different sections that show up on this sheet. Go through the different columns to change the information and type in additional information, the more you insert the better. When you click on the tabs, you will have more options where you can enter in notes and make custom fields. Go through the entire she...
In this tutorial, we learn how to lock and unlock cells in Excel. First, right click one cell and click on format cells. Go to the protection cell, and then un-check the locked category. Click ok, then go to protect sheet, inside of tools. Now, do now allow locked cells to be checked. Now, you will not be able to select cells in the worksheet except cells that are unlocked. This is a great way to protect your information, so it won't accidentally get deleted or ruined. You can do this for ent...
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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....
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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
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 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:
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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add conditional formatting to data bars and icons to show relative size, icons to show relative size, to highlight values within 1 standard deviation, to highli...
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...
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 338th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension.
To do the Faro shuffle card trick, first divide the deck in half. With practice you should be able to accurately make an even division. Hold your left hand underneath the deck and your right hand on top of the deck. Use the two halves to square up the deck. Go in on an angle, intertwining the cards. Make them meet on the bottom and apply a little bit of pressure to them. They will naturally intertwine. Spread out the cards on a table in two columns to check your shuffling technique. You can a...
This video tells us the method to use the WORKDAY & WORKDAY.INTL functions in Excel. These functions are used to find a workday after a finite number of workdays in the future. WORKDAY uses Saturday and Sunday as off days. Its syntax is WORKDAY(start date, days, [holidays]). 'days' refers to the number of days in the future and holidays is the list of holidays written below each other in the same column. If Saturday and Sundays are not your off days, use WORKDAY.INTL. Its syntax is WORKDAY.IN...
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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.
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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.
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 279th installment in their series of digital spreadsheet magic tricks, you'll learn how use the ADDRESS, LEFT, ROW, ROWS, and COLUMN functions to create the series AA, AB, ZZ with a formula.
Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this func...
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
This video is a tutorial on how to set the screensaver in Windows 7. To start, you need to click on the start menu. Next, click on control panel. Click on the personalization link in the first column. On the next screen, go to the bottom right and click on the box labeled 'screensaver'. It will open up a new window. From that window, you can click on the drop-down menu to select a variety of screensavers. You can see the preview of the screensaver in the animation above the buttons. You can a...
This is another HelpVids.com technology video. This video will teach us how to sort table contents in Microsoft Word 2007. The video starts out with a Word 2007 document with a sample table. When you click on the table, you will see the Table Tools tab appear above the ribbon. Click the Table Tools button, then click Layout and finally the Sort Button. The sort dialog box allows you to choose which column to sort by, which direction you would like to sort, and any secondary sorting you would ...
In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart templates. There are various categories of charts like Line, Pie, Bar in the left hand side. In the right hand side you can see the sample charts available and you can select any of them that you want. Now it transfers you...
Create a table with sales data with this video.
You will learn to create graphs in Illustrator. The best way to visualize data is a graph, and there are several different graph choices in this program. He chooses a column graph to show how he creates his graphs. Holding the left mouse button and dragging, he creates a rectangle which will be our graph. This brings up an input screen beside the rectangle for the graph; he puts information into the screen which shows up on the graph when he is finished.
In this three-part tutorial, learn how to create a web page layout in Dreamweaver CS4 with DIVs. In Dreamweaver CS4, this Dreamweaver expert uses DIV containers with margins and floats to create web page layouts. A demonstration of a basic CSS reset rule is also included.
This software tutorial demonstrates how to build with primitives in 3DS Max for Papervision3D. This first part demonstrates 3D Studio Max basics and how to build a column base using primitives. This second part demonstrates how to use the Shift clone tool.
Puzzles include multiple pieces each with a designated pattern so that when a user regroups the pieces, a picture or a particular image is presented, which provides practice to the coordination of the user's concept to space and structural relationship between pieces. However, no matter how large the quantity of the pieces is, puzzles only provide user's spatial concept in two dimensions. To enhance spatial concept and increase entertainment to the user, building blocks are promoted so that u...
One of the ultimate goals in hacking is the ability to obtain shells in order to run system commands and own a target or network. SQL injection is typically only associated with databases and their data, but it can actually be used as a vector to gain a command shell. As a lesson, we'll be exploiting a simple SQL injection flaw to execute commands and ultimately get a reverse shell on the server.
Since it was released last fall, Super Mario Maker has offered us a glimpse into the minds of some of the most evil people on the planet. The game, for Nintendo Wii U, lets players create their own Super Mario levels using a deep list of objects, enemies, and green pipes, which can then be uploaded for anyone to play.
For minor adjustments and color-correction, the Photos app is extremely useful, but its capabilities are limited to just the basics. Now, with Mac OS X El Capitan, Apple is opening the door for third-party extensions, meaning we can utilize additional, unique tools when editing pictures in Photos.
