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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
Have you always dreamed about quitting your day job to pursue your true passion in writing about tips on how to bake your famous cupcake pops? Stop dreaming and start doing! Thanks to the prevalence of the internet, blog writing is more popular than ever, and successful bloggers actually make quite a hefty chunk of change doing what they love.
In this clip, learn how to be a real coupon diva! This episode of coupon divas focuses on Walgreens drug stores and will show you how to combine things like register rewards, coupons, sales and other deals to walk out of the store with a full cart for virtually no money! Get your coupons to outnumber the cost of the items and go home with a bunch of free goodies. Kitty will show you the basics and how to stay organized with these strategies.
Can't decide between two new nail colors you snagged at a Sephora sale on Essie nail lacquers? We understand it's sometimes difficult to choose a color when both look so tempting.
Since the Nintendo Wii was first released, it has become one of the most popular gaming consoles in the video game industry. In terms of sales, the Wii has destroyed its competitors, the PS3 and Xbox 360. So there's no denying that the Wii is a pretty popular console. So in this tutorial, the great people at cnet, will show you how to replace your Wii sensor bar. It's really easy to do and will have you back in the game in no time. Enjoy!
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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.
In this Microsoft Excel 2007 for Dummies video the instructor shows how to record a Macro. Macros let you create a shortcut to perform a sequence of commands all at once. For example you can create a macro to quickly build a sales report template that you frequently use. When ever you run that macro the Word will automatically build the template for you based on the recorded commands. To write macros you need to have the developer tab enabled. To enable it click on the office button and at th...
Don't throw away that old keyboard! You can make a sweet wallet with the circuit sheets inside! Inspired by this Instructables project. Hack together your own cool wallet with this mod video.
Are your shoes a little too tight? Don't toss them away, there's hope for them yet, and it involves one of the most basic elements on Earth— water. By packing your high-heeled shoes with plastic ziplock bags filled with water, then storing your shoes in the freezer, you'll have newly revived footwear that will accommodate your large feet— just kidding. Sometimes you just can't pass up a good shoe sale, and if they don't have your size, this is your fix.
We never thought this would happen. A cherry pie AND cupcake in one? We have officially died and gone to foodie heaven. Make sure you take a closer inspection of these cherry pie/cupcake hybrids, however: These are actually cupcakes decorated to resemble cherry pies using frosting.
In this tutorial, we learn how to fit a backpack for long distance hiking. For scouts, look for a backpack with an adjustable torso so the pack can grow with you. After this, have the sales staff help you adjust your pack correctly, and measure how long the pack is on your back. You want the pack to fit you perfectly so you don't have back problems later. Try the pack on both on the hip section and shoulder to see how it feels on you. Tighten any adjustments to make it more secure, then you w...
The best wines will set you back almost as much as a pair of Blahniks on sale, so why not cut expenses and just make your own wine? Watch this beer brewing tutorial to see how to brew hard apple cider which has a wine-like taste.
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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.
In this video tutorial, viewers learn how to create a web 2.0 style badge using Adobe Illustrator. Adobe Illustrator is a vector graphics editor. Viewers will learn how to manipulate the Star Tool in Adobe Illustrator, how to apply a custom radial gradient to that shape and how you can create, save, and open custom swatches. This video will benefit those viewers who design websites. These web badges can be used on a website to promote a product, announce a sale, or simply draw attention.
This video shows you how to make a sweet no bake coconut dessert bar. This dessert has a very high sugar count so you wouldn't want to do this very often, but it's a nice thing for kid's birthday parties or a bake sale. David "The one pot chef" shows the viewer how to prepare a simple and easy treat. The recipe includes sweetened condensed milk and coconut and as he puts in all the ingredients it becomes a very thick paste which he presses into a pan then pops the pan into the fridge to let i...
See how to make some cool gift / party favor bags for any occasion. They are made with envelopes. You can make them from nearly any size and type. The ones in the video are made with some surplus greeting card envelopes. Sometimes you can purchase "leftovers" from an office supply or drug store (any store that sells greeting cards). "Left-overs" mean that the cards get damaged or lost but the envelope is left. Just ask the manager if you can purchase them.
Learning to code is difficult, particularly if you're doing it alone. While coding may be among the most valued job skills in many markets, the education is sometimes inaccessible.
Keeping the books in order is one of the great challenges every business owner faces. Having a great product or service is one thing, but managing the minutia of invoicing can trip up a lot of small- and medium-sized businesses.
Every state has begun reopening in some capacity. While there are important steps for everyone to get back to work and begin socializing, precautions will be in place for some time, especially with an expected second wave coming this fall. The virus is not over.
It's no secret that the vast majority of Null Byte readers range from beginner to seasoned coding pros and developers. Regardless of whether you're interested primarily in building websites or creating best-selling apps and games, working with a wide variety of programming languages remains one of the best ways to make serious money in an increasingly app-driven world.
Tax season is always stressful, especially for entrepreneurs and small business owners. Rather than wait until March to get your finances in order every year, learning how to keep track of your expenses is a valuable skill that saves you and your business time, money, and plenty of anxiety.
After North cut the base price of its Focals smartglasses, Vuzix is now testing the waters of a lower price point for its Blade smartglasses.
Beloved toy maker Lego is returning to the realm of augmented reality, this time with an experience that explores supernatural fun.
While the story of augmented reality headset maker Osterhout Design Group has come to an end, the epilogue of its demise continues.
The Magic Leap One: Creator Edition has been teased for months now, and while we still don't know exactly when the sales will begin, it can't be long now because we've discovered a couple of new hints that the device's launch is imminent, hiding in plain sight on the company's website.
The Essential Phone was undoubtedly one of the most underrated phones of 2018. It launched with buggy software and camera problems, but the company worked diligently to push out updates. Many Android enthusiasts were anxiously waiting for the Essential 2 release later this summer. Unfortunately, news today from Bloomberg indicates that Essential will not release a phone in 2018.
Huawei recently announced the Honor 7X, a mid-tier smartphone aimed at budget-conscious consumers. Spearheaded by the Kirin 659 SoC, it offers great performance at a price point where speed is normally an afterthought. Today, Huawei is making this $199 phone even more attractive by announcing a new limited edition color.
Apple is no stranger to lawsuits. They were in a decade-long battle with Samsung that finally came to an end last month, and they've been duking it out in the courtroom with Qualcomm since last year. The more recent case has seen both companies file suits and counter-suits, but now, Qualcomm is claiming that Apple's new iPhone X infringes on patents from a long-deceased mobile operating system.
Augmented reality headset and software maker Meta Company announced today board member Joe Mikhail will serve as the company's chief revenue officer.
While iPhone sales are expected to dip for the first year ever, Apple is reportedly planning to release a souped-up, 4-inch iPhone 5 in hopes of boosting sales for users who prefer a smaller handset.
Sometimes specs aren't everything, especially if you prefer value over the bleeding-edge. Enter the ZTE ZMAX, an Android phone that you can get right now for less than $200—cheaper than even the Nexus 5 or OnePlus One. If you're looking for a cheap high-end phone, it's hard to go wrong with one that sports a 5.7-inch display, expandable storage, and a massive 3400mAh battery that'll easily get you through a full day of use.
Apple Pay is ready for use at over 220,000 outlets across the United States. By using your iPhone 6 or 6 Plus, all you have to do is point your device at any NFC-enabled point-of-sale system compatible with Apple Pay, press your fingerprint on the home button, and voilà—you've just paid for something with your card. As a matter of fact, the store doesn't even need to have Apple Pay compatibility to work with your phone. If their machines have NFC-technology, they'll recognize your device (unl...
After a lengthy video and a series of leaks got us a good look at what we can expect from the new HTC One, codenamed M8, the guys over at GSMArena have brought it full circle.
blockvideos shows how to build a cinderblock compost bin for recycling needs. The builder will need 20 corner blocks, 36 AB York blocks, 12 AB Dublin blocks, 17 wall caps, 5 fifty pound bags of crushed rock, and and 2 tubes of masonry adhesive. To begin, find a location to build the compost bin and lay out the first layer of back wall and side wall blocks, lining them up straight. Check the dimensions of the layout. Once confirmed accurate, use a shovel to mark the grass around the blocks. Re...
Have you tried working out with advance triceps dips? Advance triceps dips are an essential part of body sculpting and strength training. This fitness how-to video demonstrates how to work out the triceps muscle with advanced triceps dips. Learn about arm exercises in this training video.
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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
Ilyce Glink discusses the way to make your house more marketable by improving the look of your bathroom through furnishings and potentially coordinating this with your bedroom. She also proclaims that this can be done with small purchases! She discusses how the bathroom can be an easy sale to a potential buyer but purchases like small decorative soaps or matching towels can go a long way. Matching items like your floor rug and shower curtain can catch an eye. As for your bedroom, adding lamps...
In this video tutorial, viewers learn how to save money on beauty products. In-store cards and frequent buyer programs can save a lot of money. When you scan the CVS Extra Care card at checkout or in-store kiosk, coupons based on your purchase will be printed automatically. It will give good discounts. Web only offers are becoming popular. Private sale sites have also become popular. You simply sign up on the site and take offers that the site has. This video will benefit those viewers who ar...
Want to get more from the raw data you're entering into your Excel worksheets? Now you can create two distinct pivot tables in Excel comparing, for example, monthly and quarterly sales data. Not familiar with the pivot table? Pivot tables summarize spreadsheet input by counting, sorting and totaling data within a list and providing at-a-glance computations within the same sheet. Become an expert on the subject within 5 minutes and 24 seconds by following easy to understand instructions narrat...
This video shows you a delicious recipe and how to make quick and easy brownies, with an Australian twist. This is an old fashioned favorite, perfect for a school bake sale, or just something sweet to impress the family. Also a great way to bound with the family by getting them involved.
