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 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 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.
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:
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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the 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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.
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 308th installment in their series of digital spreadsheet video tutorials, you'll learn how to extract data to a new workbook by array formula. Functions used include IF, ROWS, INDEX, TEXT, ROW and SUMPRODUCT.
Whether you love Nancy Ann Grace or hate her, you can't deny that her eye makeup is always amazing. Watch Princess Pinkcat in this tutorial video about creating her Nancy Grace makeup look. She didn't curl her hair for this video, just tucked it under to make it look more like Grace's hair length.
Free Math Tutoring teaches you in this video how to calculate the area of a triangle using a basic formula. The area of a triangle is (b times h)/2. B is the base of the triangle and h is the height. This formula works for all kinds of triangles. Sometimes you won't have the height in the triangle, so you need to draw a line from one angle to the base opposite that, at a 90 degree angle. Measure that and you have your height. It might seem difficult at first, but practice helps you understand...
String instruments make up a large part of many orchestras and include the violins, violas, cellos and double bass. Learn all about the characteristics and history of string instruments with tips from a composer in this free music video series.
Church organs are big, ungainly, expensive instruments. The MicroKorg is comparatively tiny and cheap. Why not use the synthesizer to simulate the organ? Watch this video to learn how to program a patch for a realistic church organ sound on a MicroKorg synth.
The Roland TR-808 drum machine is one of the most important modern instruments, forming the backbone of both hip-hop and electronic music percussion. If you have gotten your hands on one, you're a lucky devil, but you have a long way to go before you can unlock it's true potential. Watch this video to learn how to program an 808 all the way up to a 64-step beat!
Interested in playing Sir Elton John's "Candle in the Wind" on a piano or other keyboard instrument? Let this free video music lesson be your guide. While this tutorial is best suited for intermediate or advanced piano players, players of all skill levels can play along. Watch this tutorial to get started playing "Candle in the Wind"!
In this video tutorial, you'll learn how to play John Lennon's "Oh My Love" on piano or other keyboard instrument. While this tutorial is best suited for intermediate or advanced piano players, players of all skill levels can play along. Watch this tutorial to get started playing "Oh My Love"!
The Moog synthesizer is the most intimidating instrument ever made from a playing standpoint. Sitting down at one, it is possible that without prior knowledge you would be unable to make any sort of sound with one. Fortunately, this video for analog synth beginners will show you how the basics of making sounds using a Moog. Many of these techniques work on other old analog synths as well.
In this clip, you'll learn how to string up a uke with a standard tie-style bridge. If you want to get really good at playing the ukulele, it stands to reason that your instrument will need strings on it. Happily, the Internet is awash in high-quality video lessons like this one from the folks at Hawaii Music Supply. For more information, including a step-by-step overview, watch this free video ukulele tutorial.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Break Your Heart" by Taio Cruz on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Baby" by the king of online video himself Justin Bieber on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "My Boo" by Ghost Town DJ's on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Watcha' Say" by Jason Derulo on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "I Invented Sex" by Trey Songz on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Just a Friend" by Mario on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Best I Ever Had" by Drake on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "No Air" by Chris Brown ft. Jordan Sparks on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Replay" by Sean Kingston on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "I Gotta Feeling" by the Black Eyed Peas on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "You Remind Me" by Usher on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Easy" by The Commodores (with a young Lionel Ritchie on vocals) on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Green Light" by John Legend ft. Andre 3000 on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit R&B song "Bed" by J. Holiday on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Birthday Sex" by Jeremih on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the YouTube ukelele original "The Breakup Song" on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how barrring, pressing, and chord variations work, and how they can improve your ukelele playing.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Say My Name" by Destiny's Child on ukelele.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Cater 2 You" by Destiny's Child on ukelele.
The Ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? If you're learning the Ukelele, watch this video. It will give you tips of chucking, teach you how to read Ukelele tabs, and how to strum properly. This is all essential information for any beginning Ukelele player.
The Travie / Travis McCoy ft. Bruno Mars song "Billionaire" is a wonderful summer song, and there is no instrument more summery than the Ukelele. This video will help you to combine the two by teaching you how to play the song on the Ukelele. It sounds great, and is really one of the better pop songs to come out lately for Ukelele covering.
When you've chosen a sound to use with your USB or Midi keyboard, you'll want to record a performance. This new track is easily edited in GarageBand.
