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 364th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the INDEX, MATCH & NOT functions that will return cell content from the first non-blank cell in a row.
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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER 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 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.
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 220th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month for a given range of dates.
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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.
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...
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...
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
This video illustrates the quick and easy method to Dual boot Windows XP & Vista . The process is comprised of the following steps:Step 1: Install Windows XP OS on your PC. Run it and see if it works fine.Step 2: By using the Windows Vista OS setup , start the installation process and choose "Custom Installation" as the installation method.Step 3: Make sure you install Windows Vista on a Local Disk different from the one where Windows XP or any other Windows OS is installed as this may result...
This video shows how to use optimization methods in calculus. Optimization means finding the maximum or minimum values of a quantity or finding when the maximum or minimum occurs.What quantities are optimized in economics?we want to minimize costs or maximize revenue.First steps in any optimization problem1.Identify the quantity to be optimized i.e., read the problem exactly what is exactly maximized or minimized.2.Identified the feasible domain. This is important because the math we can opti...
The guy first gives the definition of differential equations. He explains that a differential equation is an equation that contains the derivatives of an unknown function. He then gives some examples of differential equation and explains what the equation's order means. After that he gives an example on how to solve a simple equation. He calculates it and gives examples of graphs. Then he explains what a general solution is and how to narrow down the number of solutions using data from the pr...
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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA 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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD 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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, 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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT 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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
How to Make Anything demonstrates how to use a three prong XLR mic with your camcorder. The XLR plug on the mic is not going to fit into the 1/8 inch plug on your camcorder so you will need an adapter. You can find an XLR to 1/8 inch adapter for about 10 dollars. Try to get an adapter with as short of a cord as possible to reduce noise and radio interference. You can also get an XLR box which is an interface which goes between your camera and the microphone. The XLR box will be about 180 doll...
Create a table with sales data with this video.
Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT() functions to pull text from Microsoft Excel 2007 cells & assign them to different columns.
In this video David Rivers shows that the conversation look of Excel 2010 has greatly improved. Tracking and managing related emails, saves your inbox space to enable you to manage large number of emails effectively. By default, the conversations are arranged by date. Email interactions will have an arrow displayed. You can easily expand and collapse the conversation. The major improvement is the function of ignoring or clearing up conversation with just a few clicks. The future conversations...
Gus Russel explains how storyboarding can be used to illustrate what a movie might be like. He has been given the task of drawing a frame for each page of a 130 page movie script. Story boarding gives the author a general idea of how the movie will come together, how the characters will look, etc. Russel shows the audience how to quickly draw a quality sketch, and how to shade it properly. The sketches do not function to show exactly what will happen in each scene, but rather what "might" hap...
If you aren't familiar with Illustrator software it is very similar to the photo-editing software Photo Shop. This video is a guide on how you can make a paper scroll by using Illustrator. You can follow along with the video and make the basic shapes and then re-size the pieces to look almost exactly like an ancient paper scroll. This would be something really neat to make if you needed a background for an old-timey looking photo or if you needed to make up invitations for a church function.
This how-to video is about how to enable the commenting tools in the free Adobe Reader using Acrobat 9 Pro and Acrobat 9 Pro Extended.
TyingItAllTogether explains that, "Pagoda is the English language term for a tiered tower with multiple eaves. Common throughout eastern Asia, most pagodas were built to serve a religious function. The Pagoda Knot was created in admiration of this sacred architecture." In this video, learn how to tie a decorative pagoda knot. Working with a single piece of string, follow along as the string is transformed into a work of art. Begin by making a series of four loops. Cross the tails, then weave ...
Bruce Dorn from Canon breaks down the exposure and Speedlite controls on the Canon 5D Mark II. His explanations are especially helpful as he gives certain shooting scenarios in which tweaking these settings will improve your overall image quality.
The replace color command is a nifty tool in Photoshop that enables you to change a color in an imagine very quickly and effectively. The tool requires that you make a copy of the original layer, as the replace color command is a destructive function. It requires parts that you want replacing to be selected first, to change the color of the desired areas. The result is a very realistically edited image, that is extremely fast and easy to accomplish.
Get to know how to use Logic Pro's arrange page in this short tutorial. Use the arrange area to work with the audio of your song. Change the timeline by choosing a time and beat. Use the toolbar area to do some functions. Use the icons to easily open up media and list areas. Use the bin to store your audio. Use the browser to look for your audio songs. Use the event list editor to edit your MIDI information. Use the inspector to view the channel strips of your track. Use the editors in the bo...
This tutorial video, from tasktutorial demonstrates how to create animation using the motion guide function in Flash. You will learn how to create an object, in this case, a ball, and create an animation that makes it appear to bounce. The guide shows you, how to add a motion guide by selecting a key frame and drawing it in. Then you will learn how to snap the object to your guide line, and add motion to it by selecting another key frame between the first and last frames, and snapping the obj...
In this video tutorial the instructor shows how to perform basic lighting corrections in Adobe Photoshop. The levels tool is the Photoshop's most used command which has many features to it. Its most basic function is as a lighting correction tool. In this video open an image and work on its adjustment layer so that you do not damage the original picture. Now choose the levels option by right clicking and it shows a pop up window which contains a histogram which shows the population of the col...
This video makes you understand Flash Cookies and teaches "How to remove them" to keep your privacy.
Illustrator is a great tool for creating individual artwork. Creative and clever, it has many functions, one of which is mosaic. If you want to make your illustration or design appear to have a myriad of tiny 'squares' like a Roman mosaic, this guy can help you do it. The short clip explains clearly how to bring the chosen effect to your design. You can see on screen exactly how to do it, so you're not left in the dark, searching every menu for the right tool.
This video is all about the keyboard shortcuts that are used in Microsoft Excel of the latest version. If you really need speed and efficiency then watch this video for its shortcut keyboard buttons. After typing all the data, if you need to see the page setup with the help of the mouse than it will take a pretty long time. By opting for keyboard shortcuts you can save much of your time and can invest it in another work. If you press 'alt' button then it will show keyboard shortcuts on the sc...
If you want to be serious about using Adobe Illustrator, then learning how to use type is an essential part of your skill set. Type can help you with a wide range of assignments, from designing logos to image building and much more. There are a number of settings and functions when using Type, so it's important to know all of the options that are available to you. This video tutorial will teach you how to use the area type tool in Illustrator.
Most people don't use their cameras to make movies (really bad quality and a sort of user-generated content feel are probably the culprits) but cameras with a record function are great for those impromptu memory-making moments when your dog tries to do a handstand or your grandma unloads the biggest belch ever.
Hacker Defender is one of the most widely deployed rootkits in the world. It is a user-mode rootkit that modifies several Windows and Native API functions, which allows it to hide information (files, processes, etc.) from other applications. In addition, Hacker Defender implements a backdoor and port redirector that operates through TCP ports opened by existing services. This means it is not possible to find the hidden backdoor through traditional means, like launching a remote port scan agai...
While printers are not normally considered to be at the leading edge of computer technology, these devices have evolved at a lightning pace over the years. Before today's low cost, high-quality inkjet and color laser printers, we used low-quality dot matrix printers and slow laser printers where quality and performance of printing was often questionable. Additionally, documents that looked correct on screen often came out looking differently on paper, due to differences between what the scree...
Cosmo Crow and Mark Hannah take you on a tour of the Sony DSR cameras in these how-to videos. The first video segment deals more with setting up the camera tripod. Then, Mark and Cosmo continue their tour of the Sony Camera with an in depth explanation of the Lens and all its functions. Finish up with the final installment, which will teach you how to operate the switches on the main body of the Sony Camera. Watch this video tutorial and learn how to set up and use the Sony Camera.
A side bang finds that perfect balance between function - it keeps the hair out of your face - and aesthetic value. Unlike a ponytail, which is sassy and cute but a wee bit too plain, a side braid adds feminine flair to your hairstyle.
