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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.
If you're starting to use your digital SLR for the first time, it can be quite confusing to determine what all its functions mean as well as where to find them and how to use them.
In order to prevent accidental CAP LOCKS, you can use a number of new, innovative and free software solutions. With your Windows 7, there are functions available to assist you.
This quick Blender 2.5 video tip demonstrates how to replicate objects with an array modifier in the same way that the Spin Duplicates function works. This techniques maintains the objects edit-ability even after spinning. a while back i posted about having a nasal voice that needs taming (i sound a bit like bob geldolf). 2 suggestions were the beyer m500 and the EV re20. i borrowed a friends re20 and found it very dull sounding. so dull i immediately threw in the towel. duller then my sm57 o...
This Cinema 4D tutorial offers a lesson in creating a very fast and easy comedy title sequence using MoGraph, MoGraph Spline Effector and a bit of compositing in After Effects. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, watch this 3D modeler's guide.
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 617th installment in their series of digital spreadsheet magic tricks, you'll learn how see a SUMIFS and SUMPRODUCT functions formula to sum the fiscal year's sales when the year does not end on December 31st. Also see a formula for year-over-year percentage change.
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.
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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.
Want to use an Illustrator CS5 illustration in a Microsoft PowerPoint presentation or Word document? This video clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, wat...
Need help figuring out how to save PDF-compatible AI files from Illustrator CS5. This clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video guide.
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 613th installment in their series of digital spreadsheet magic tricks, you'll learn 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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).
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 606th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that can look up two 2 lookup values using the INDEX & MATCH functions and concatenated (joined) columns for the lookup value and lookup table.
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 ...
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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:
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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Beauty of Excel" series of free video lessons, you'll learn how to set up the input/assumption area for formulas so that subsequent formulas, functions and charts update beautifully. Learn how to build Excel spread...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 41st installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate deviations, variance and standard deviation for a sample and a population using Excel tables and the VAR, S...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 10th installment in his "Excel Statistics" series of free video lessons, you'll learn how about data sets and the nominal, ordinal, interval and ration scales/levels of measurement and see two Pivot Tables that...
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this video, we learn how to retweet in Twitter with Stephanie. There is a new layout on Twitter which may look confusing, but is very user friendly. First, log into your Twitter account and go to your home screen. On the right hand side you will see a button that says "retweets". Click on this and you will see three selections. Click on "your tweets, retweeted" and you will see which users have retweeted something that you wrote! From here, you can also go and thank those people for retwee...
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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM 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 558th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See also how to add a concatenated column and concatenate lookup_value in 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 255th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a two-variable data table in Excel for what-if analysis. See the PMT function and learn about the formula equivalent to a data table.
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 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OFFSET function and defined names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.
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 583rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF & IFERROR functions with absolute and mixed cell references to create a large table of conditional average calculations (averaging with criteria).
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 351st installment in their series of digital spreadsheet magic tricks, you'll learn how to create an area chart for x and f(x) data as well as how to use the IF function to show a second data set plotted to show a specific area section.
In this Electronics video tutorial you will learn how to build and use a tinyCylon kit. The kit contains a battery pack, a PCB, LEDs, resistor, a momentary switch and a screw. The long end of the LEDs will go into the square shaped contacts. Don’t push the LEDs right up to the board. Instead, use some poster putty to hold the LEDs standing upright so that they can be bent later on. Fix all the LEDs in this manner and solder them on the other side. Then solder the leads of the battery pack. ...
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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.
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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, SMALL and VLOOKUP functions to create a gradebook (or grade book) based on a total score minus the two lowest scores.
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 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.
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 190th installment in their series of digital spreadsheet magic tricks, you'll learn how to rearrange three parts in a text string (e.g., last, first, middle name) using the RIGHT, FIND, LEN, & LEFT functions in one 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 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 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 183rd installment in their series of digital spreadsheet magic tricks, you'll learn how to sum revenue from a table of data by year and month using the SUMPRODUCT, TEXT, SUM, IF & LEFT functions in an array formula.
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...
This video explains how tree growth rings function and what they can tell us.The growth rings are formed in 2 (sometimes 3) layers of wood that are the spring growth and the summer growth. Ring width can vary depending on the specie of the tree, the environment in which it has grown and the amount of water it has used. By counting the rings you can tell the age of the tree.By analyzing the growth rings, you can see the years in which there was a drought where the tree once stood, because the ...
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...
