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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
You can get a real steal at a house foreclosure sale, or you can overpay for a money pit. Here’s how to avoid the latter. With the bad economy, now is a great time to take advantage of real estate bargain sales. Watch this video real estate tutorial and learn how to get a good deal on real estate foreclosures.
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 build a pivot table to calculate year over year sales showing percentage change.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
This is a quirky little how to video that teaches you how to repair and replace that worn out speaker surround you wanted to toss out or just bought at a garage sale for $1. Get to that yard sale and repair those old worn out speakers and make them worth thousands again!
Ready to clean out the clutter in your home and make a little money too? Learn how to organize a tag sale or garage sale and entice people to stop, look, and buy.
With the massive popularity of online clothing brands like Missguided and Fashion Nova, it seems that shopping in-store is a thing of the past. I admit that I love browsing from the comfort of my own bed, but there's something to be said for actually going to a store, speaking to people with similar tastes and penchants for shopping. Fortunately, with Frenzy — Shopify's new app for iOS — you get all of the convenience of online shopping, plus the opportunity to interact with other users in pe...
There's nothing to fear about a trip to the mall—as long as you plan ahead and shop smart. This video demonstrates the best way to budget your money, make the most of your time at the mall, and shop smart, budget conscious. Good instructional video for your upcoming Christmas shopping & holiday sales.
If you or someone you're shopping for has a newer iPhone model or an Android smartphone like the Galaxy Note 9 or Pixel 3, they come with wireless charging capabilities. Problem is, they don't come with wireless chargers. But there's no better time to snag one than on Black Friday, and we've found the best deals out there for 2018's holiday season.
Google has a new smartphone, and if you own a TV or a computer, you've almost certainly heard about it. The ad campaign for the Pixel and Pixel XL is approaching iPhone levels of omnipresence, as Google has reportedly spent over $3.2 million on marketing, with that number expected to skyrocket in the coming months.
The adoption process can be long and taxing. Start off right by learning the basic procedure. Step 1: Learn the requirements
Open-source intelligence researchers and hackers alike love social media for reconnaissance. Websites like Twitter offer vast, searchable databases updated in real time by millions of users, but it can be incredibly time-consuming to sift through manually. Thankfully, tools like Twint can crawl through years of Twitter data to dig up any information with a single terminal command.
Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...
If you have created a product that you want to sell, getting a UPC code for it will allow you to track purchases and give your business a more professional air. This video will explain how you go about getting a UPC code and using it to help your business.
As more companies begin adopting augmented reality in the workplace, providers like Vuzix reap the benefits.
On Tuesday, Apple held a public conference call for its Q2 earnings report. During the call, Steve Milunovich from UBS asked Tim Cook about a recent 451 report, and how it reflects a pause in current iPhone sales. Cook's response was more than interesting, to say the least:
The Drug Enforcement Agency (DEA) has been purchasing spyware from the Milan-based Hacking Team and its US subsidiary Cicom USA since 2012. Public records reveal invoices between Cicom USA and the DEA that have ranged between $22,000 to $575,000 from 2012 to 2015.
This year's Nexus devices are already two of the best bang-for-your-buck smartphones on the market, but with a new sale price from several retailers across the net, they might just be an unbeatable deal.
In this video Andrea Osterkorn demonstrates how to stage your home for sale. It is not a comfortable process to transform your home into a home for sale. The entry way should be inviting because first impressions are important. Closets should be cleaned out. Consider renting different furniture for the living area to make it more open and inviting, and move it around to create an impression of space. Add accessories and let natural light in. Try to depersonalize the room and remove clutter so...
1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a cell in Region and Right click and select Sort A to Z 5. Then click a cell in Region and select Data->OutLine->SubTotal 6. In the SubTotal Window select 1.Each Change in: Region 2.Use function:Sum 3.Add subTotal to:Sales...
We know the method for answering the question "What is the x percent of y" but, what about the answer to the following question "The x percent discounted price of an article is y. Find the original price." This is a reverse percentage problem that can be solved using the method shown in this video. This video contains three reverse percentage problems. The first two problems are essentially of the same type as explained above. A simple and easy to understand method of finding the original pri...
These aren't your mother's bake sale pies. In fact, they're not really pies at all. Rather, these delicious and pretty treats are cupcakes decorated like pies. A simple concept, yes, but these cupcakes make for a divine arrangement. You'll learn how to arrange various colors of jelly jeans to look like food - red for strawberries and blue for blueberries, for instance.
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 613th installment in their series of digital spreadsheet magic tricks, you'll learn how to
Whether you work in sales or want to become more persuasive and better at selling yourself, the art of selling can be transferred to nearly any career path or walk of life. Whether the gains are monetary or interpersonal, being a great salesperson is one of the most invaluable skills you can ever learn.
Bob Harris of decorative concrete institute explains how you can remove your tiled or carpeted flooring for a concrete substitute. He suggests when your removing carpeting that it can be very heavy and advises you to hire someone who can lift and carry it out, or rent a dumpster for easy take away. He states that after the carpet is removed you'll need to remove the adhesive from the floor. You can do this by stripping or grinding, and at other times the use of harsh chemicals may be needed. ...
In this video the instructor shows how to compute percentage problems. Percentage was first used in ancient Rome when the emperor Augusts levied a 1/100 of a tax on goods sold. To solve percentage problems you need to know how to convert between percentages and decimals. When you have a value in decimal, to convert it into percentage, shift the point two decimals to the right. To convert from percentages to decimals, shift the decimal two places to the left. For example to convert .50 to perc...
The top flaps on the cereal box should already be open. Then you must open the flaps on the bottom of the cereal box (the side parallel to the opening) and flatten it. Now use the creases made by the corners of the box and fold them inward; it should be flat again. Fold it length wise thus leaving a little rectangle of the flattened box that is not overlapped by the other half of the flattened box. Tax this tab and insert it into the opening in the adjacent half of the cereal box. Your cereal...
In this video, Derrick Schommer, sales engineer, podcaster and host of Common Man Cocktails shows viewers how to mix up a Blue Mediterranean. This classy gin cocktail is based on Bombay Sapphire gin, teamed with lemon-and-lime Sprite and Blue Curacao for a sophisticated, slightly sweet drink. The Blue Curacao and gin are placed in a high-ball glass with ice, then the drink is topped off with Sprite and a squeeze of fresh lemon juice.
While it's true that few people fax these days, faxing is still really important for things like sending your resume straight to a hiring manager or sending your account tax records. Luckily, you don't need a telephone line to fax. In fact, all you need is the internet.
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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.
Create a table with sales data with this video.
A handful of retailers have put the newest Nexus smartphones on sale again, so you're in luck if you missed out on picking one up during the discount period last month. Actually, you might be better off since some retailers are giving away freebies with some models, too.
Welcome back, my novice hackers! You have probably heard of the Panama Papers hack by now. This was a hack of the servers at Mossack Fonseca, a major law firm in Panama. This law firm specializes in assisting the rich and powerful to hide their wealth from taxes and scrutiny by creating tax havens overseas.
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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).
This video is about staging a home for sale. Bridget Kiene, a real estate broker, describes home staging and its significance. Bridget starts with defining home staging and mentions that 92 percent of people advertise their house for sale on the internet. This video also has some tips on home staging, such as, always stage an empty house, create a neutral color palette, eliminate clutter and modernize your decorations. Bridget clearly explains the basic steps we need to follow to sell a house...
With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Take a look at this instructional video to learn how to show the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of your report. Sort, filter, and summarize your data any way you like. Show the details of any summary value in your report.
Take a look at this instructional video and learn how to analyze how a process or other area is actually performing by connecting data to the shapes in your diagram with Microsoft Visio 2007. You can also add different visual effects based on the data values. For example, you can link sales data from an Excel workbook to the shapes it relates to. When a phase of the sales process takes longer than guidelines recommend, the shape for that phase changes color or shows an icon that alerts you to...
Let's face it, iPhones are expensive. With the latest iPhone XS Max reaching as high as $1,449, our wallets could all use a little support. That's where Black Friday comes in, supplying us with deals and discounts on iPhones of all kinds. If you're looking for a new iPhone this holiday season without having to break the bank, you've come to the right place.
