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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.
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 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
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 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:
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...
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.
The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...
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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
This video demonstrates that just because a shoe feels loose doesn't mean it's the wrong fit. Many shoes have a back eyelet that rarely gets used, but if you put your laces through it before tightening, it will raise the fabric of the shoe to give more support to the heel. If your shoe doesn't have this extra eyelet, you can create false eyelets by creating loops with your laces on the top two eyelets of the shoe, then lacing them through those fake eyelets before tightening. Both of these me...
Black Widow Mask In this video, the talented Angie teaches us to apply a Black Widow Mask for Halloween using make-up products that most women will already have in their collection. She uses detailed explanations and shows us exactly what she is doing and why, such as explaining that she's applying black eyeliner to camouflage the false eyelashes she will later be applying. Her application is easy to follow and results in a stunning finishing effect. By following her advice, you too can have ...
Learn how to play the Delta Blues with this great guitar lesson. You'll see how to play the blues song "Walking Blues", two different versions, in the style of both Muddy Waters and Son House.
Get ready for a delta blues good time. If you want to learn the delta blues, a good place to start is with this video lesson where you'll learn how to play Tommy Johnson's "Canned Heat Blues" on your guitar.
Everybody loves Tommy Johnson's music, that is, everyone who loves the blues. And in this video lesson, you'll learn how to play Johnson's song "Big Road Blues" on your blues guitar. If you want to learn the delta blues, this is a good starting place.
Check out this blues guitar video that will teach you the basics of Mississippi John Hurt's song "Monday Morning Blues". If you're a fan of John Hurt (not the actor), and a you own a nice guitar, then you can't miss this blues lesson.
A tutorial video on how to apply retro pin-up model makeup, just like a real a pin-up model. Start by applying the foundation and add some eyeshadow primer to make the makeup last longer. Curl your lashes cause you'll be using false eyelashes later. Apply the eyeshadow, make sure to blend to emphasize the shape of the eye. Create a wing at the outer end of the lashes and apply the mascara. After applying the makeup, use a lip liner over the lip line and apply the red lipstick. Follow these si...
In this video you'll learn exactly how to play the "jeopardy" card trick. This is a great trick to try on the whole family or your friends.
Popularized by artists like Son House and Skip James, Delta blues is not only one of the oldest forms of blues music, it is among the most stylistically distinct and technically rewarding to play. In this one-two video guitar lesson from YouTube user deltabluestips, you'll learn the basics of Delta-style strumming and picking. While this lesson is geared more toward intermediate and advanced guitarists, this means beginning players merely have all the more to learn. Get started using Delta Bl...
In order to create a dramatic Alice in Wonderland Cheshire Cat inspired makeup look, you will need the following: a shocking pink base, a neon pink shadow, a deep purple eye shadow, light brow bone color, white eyeliner, lip liner, lipstick, pink blush, lip gloss, pink shadow, liquid liner, mascara, and false eyelashes.
Create amazing fairy eyes using silver eyeshadow in easy steps! Start with a base all over your lid and eye area. Now add a little to your lower lash line. You will then apply a highlight with brush to your brow bone With a new smaller brush use a light shimmery silver to apply to the inner part of your eyelid. Apply about 1/3 of the way in. Apply a light lavender color to the rest of your eyelid. Using a darker purple apply to the outer corner of your lid, also pulling it into the crease are...
When it comes to dressing up your face for the holidays, your LBD of makeup looks is without a doubt the classic neutral eye and red lip combo. Beautiful since the days of Marilyn Monroe, this look is timelessly feminine and sultry.
In this tutorial, we learn how to apply Jennifer Lopez inspired smoky eyes. First, apply a light beige glitter all over the eye. From here, apply a white ice color all over the eyelid and into the crease of the eye. Get the color a little wet to make it stick and show more on the eyelid. Next, take a black eyeliner and draw inside the bottom of the eye and on top of the eye as well. After this, apply mascara or false lashes and you will have a beautiful Jennifer Lopez makeup look! Just top it...
In this tutorial we learn four tricks to make your eyes look bigger. The first tip is to layer on a shimmery light shadow to the eyes and then add on a darker color to the crease of the eye. Curl the lashes and then apply mascara to the eyes after clamping and working up the eye. Next, take some false lashes and apply these to the outer edge of the eye. The lashes will give you a thick and luxurious look. Later when you go to take these off you just need to use simple eye makeup remover. Any ...
On Halloween lots of revelers go all out with their costumes, donning full body makeup to look like Neytiri from "Avatar" come to life or slipping on a bladed glove like Freddy Krueger.
Fall is now in full swing, which means that the vibrant, colorchanging leaves on all the trees in your neighborhood are taking center stage in the fall scenery. In lush hues of orange, red, sienna, and emerald green, leaves are the most colorful and multidimensional seasonal treats.
Katy Perry and retro makeup go together like the Old Spice guy and sheer awesomeness. So if you're a fan of how Katy looks (and who isn't?) then check out this makeup tutorial to learn how to create a Katy Perry look with intense, long false lashes, a bronzy eye, and her signature bold lips.
Want to look like a living doll? That's the goal of thousands of Japanese girls in the Harajuku district of Japan, where all fashion trends start. No matter what style of dress, the dolly look seems to be pretty pervasive, espcially when it comes to makeup.
In this tutorial, we learn how to create a double winged eyeliner look with Kim K. First, you will need to apply a medium toner color to your eye, then apply a brown to the crease and other edge. From here, use an eyeliner brush to apply liner at the lash line all the way in. Create the winged effect by dragging out the liner brush while it's damp. Apply liner on the bottom of the eye, then smear it with your finger. Use a smaller brush to create the wing from the bottom of the eye going up u...
In this video we learn how to apply a black & white masquerade mask with makeup. Start off by drawing on a white mask around your face with white eyeliner, filling it in. Then, apply white shadow over this to make it a matte finish. From here, draw lines coming out of the mask with the white eyeliner all around the mask. Color in around the lines with black and then blend them out gently towards the outer area of the face. Then, define the inner mask with black eyeshadow and apply false lashe...
We are officially living the era of the smoky eye. No matter where you go you see girls who all look the same, with bronzy, blended out smoky eyes paired with nude or pale pink lips. Call it the Kim Kardashian effect; call it modern drama, but we're honestly getting sick and tired of it.
When it comes to smokey eyes, is there any starlet more versed in how to apply the look than Kim Kardashian? We can't think of any person more enamored with the sultry femme fatale look than the "Keeping Up With the Kardashians" star.
When it comes to beauty, we try as much as possible to avoid looking fake. By this we mean adding fake pieces of hair to our bodies, like false eyelashes or hair extensions. But let's face it: If your hair is naturally thin like ours, sometimes a well inserted hair extension makes the difference between a dramatic, beautiful hairstyle and a bland, limp one.
In this video, we learn how to get a black and white costume makeup look. First, apply white cream makeup to the eyelid and then underneath the eye. After this, line your crease with black eyeliner and end it with a tail. Then, line your lower lid doing the same thing as you did on the top of the eye. Blend black eyeshadow in with the liner after this on the top and bottom to make the line thicker. Now, apply a white powder makeup over the white and connect them together in the crease of the ...
In this video, we learn how to get the Daisy of Love inspired makeup look. First, apply primer to the eyes, followed by a shimmer purple shadow. Pat this on so there is a lot of shadow on the eye. Now, blend this upwards and out so you reach the crease of the eye. Now, take a black shadow and define the outer v of the eye, blending in the colors. Add in more purple after this, then apply eyeliner to the top and bottom of the eye. Apply a light highlight underneath the eyebrow, then apply fals...
In this video, we learn how to get a vintage glam makeup look. First, apply a base to the eye, then apply a white shimmery shadow to the entire eye. After this, apply a brown shadow on the outer part of the eye to the crease of the eye. Blend this upwards, then apply a vanilla colored eyeshadow underneath the eyebrow and blend. Next, take an eyeliner pencil and smudge it into the lashes on the upper lash line, winging it at the outer end. When finished, smudge the color out to the edge of the...
In order to create a Hilary Duff inspired makeup look for $10, you will need the following: Maybelline's natural quad four smoke eye shadow, liquid eyeliner, face powder, terra cotta, fake eyelashes, mascara, and eyeliner.
In this video, we learn how to get a chic and sophisticated look with light makeup. First, you want to prime your face and then spray brush on a foundation that matches your skin tone or is slightly darker. Next, set your face with a powder and lightly dust your entire face. Define your brow after this, using light strokes and a pointed brush. Next, apply a matte brown shadow into the crease of the eye using light motions and blending with the other eyeshadow colors. Now take a light shimmer ...
In this video, we learn how to get a spring makeup look with greens and whites. Start by applying a highlight underneath the eyebrow, brushing it on slowly, then blending down. Next, apply a white eyeshadow to the inner corner of the eye, into the middle of the eyelid. Follow this by applying a neon yellow color to the middle of the eyelid, then slightly blending the two colors together on the edges. After this, apply a dark green shadow to the outer edge of the eyelid and blend with the neon...
In this video, we learn how to apply ice princess pink shades with your makeup. First, apply a white cream pencil to the inner eyelid and underneath the eyebrow, then blend in. Next, take a white cream color and brush it on the inside of the lid and around the entire eyelid. Now, take a glitter pink shadow and brush it onto the middle of the eyelid. After this, take a bright pink shadow and brush it on the outer corner of the eye, blending it in with the middle pink. Now, take a lavender eyes...
Everything is fine in a relationship and then, BAM! False accusations, name calling (and we're not talking about honeybunny), and general discontent slowly tear everything you built apart. And then, for many couples, comes the breakup.
Many schools of makeup teach that one should use makeup only sparingly, flattering her face with neutral tones that enhance without obscuring. But one school teaches that, like Oscar Wilde, one should paint the body with diamonds and exude raw flamboyance.
