Knowledgeable Sales Search Results

How To: Add with case-sensitive criteria in Microsoft Excel

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).

How To: Stage your home when selling it

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...

How To: Make a Blue Mediterranean gin cocktail

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.

How To: Analyze product sales with PivotTable report in Excel

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.

How To: Connect data to your Visio diagram

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...

How To: Sell your car on Craigslist

This six minute video shows you how to sell your car on craigslist. First, go to craigslist.com and click on the nearest city (or country). Follow the links to list an ad for a car for sale. You will want to put the kind of car in the posting title because that is used in sorting search results. In the posting description it is important to be as specific as possible - again describing the car, giving some history of the car like if it has ever been in an accident and if you have had any work...

How To: Create collapsible and expandable cell ranges in Excel

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...

How To: Use the filter & sort feature in Excel

In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizontal lines. Now go back to the data set, click on a cell and click ctrl+shift+L and that will add the auto filter. ctrl+shift+L is for Excel 07. For earlier versions, see the commands listed in the video. This is a toggle...

How To: Organize your collection of bras

Chances are that if you've attended any amount of Victoria's Secret's semi-annual sales, you've probably got enough bras to start your own lingerie store. But because you don't have an entire showroom to store those babies, your bras are probably just lying around wherever they fit.

How To: Make cheap apple walnut sticky buns with Sandra Lee

In this clip, Sandra Lee shows you how to do what she does best and make a delicious recipe for very little money. Sandra shows you how to combine homemade ingredients with store bought items so that it tastes like it was made from scratch. Enjoy these sinfully decadent breakfast pastries for your guests, a bake sale or as a treat for yourself! Enjoy!

How To: Create a nested unique list via a pivot table in Excel

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 250th 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 representatives using a pivot table (PivotTable).

How To: Solve the top cross of the Rubik's Cube

Some people get confused about a couple of aspects to solving the Rubik's Cube. Hopefully this video will clear things up. If not, then just don't watch anymore videos. Just put the cube in your closet, or in your yard sale, or smash it against the wall. Just give up.

How To: Make big bucks in sales

Bernard Smalls explains how to make big bucks in sales. If you hate what you are doing, you will not make big bucks. You have to remember that the point of sales to make money.

How To: All the Best Black Friday Electronics & Gadget Deals of 2013

This year, like every year before it, Black Friday sales are starting earlier than ever. A lot of stores will be opening their doors as early as 5pm on Thanksgiving to get a head start on the madness (and it really is madness). As we've discussed in the past, one of the keys to emerging victorious on Black Friday is to plan, plan, plan. So, we've compiled some of the best deals in tech, gadgets and appliances to help you prepare for battle.

How To: Create a 360 view using Flash CS3

360 degree panoramic viewers are a staple of all kinds of websites from real estate to auto sales. This video will teach you how to create a a 360 degree view that will display on your website using Flash CS3 and Actionscript 3. Don't restrict your users to just one photo, let them see all of whatever you're showing them with the tools your learn in this video.

How To: Pitch a tent for a campout as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Prepare and cook your patrol's meal as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Tie two half-hitches knots as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Hike safely during the day and night as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Display, raise, lower and fold the flag as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Identify local poisonous plants as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Save someone from choking as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Show simple first aid knowledge as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Orient a map and use a compass as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Hike five miles with a map and compass as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Safely use a knife, saw and ax as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.