Why did Microsoft hide the Excel Options Button?
You can find it by clicking the Microsoft button in the upper left corner of Excel, then clicking on “Excel Options” in the bottom right.
One click to change Sentence Case in Microsoft 2007
July 2, 2009 – 12:04 am
A command that I use all the time is toggling sentence case. Generally someone will send me a document in all caps, and rather than retype it, I use Microsoft’s command to convert all text to Sentence case.
Microsoft Word 2007 now has a button on the ribbon that makes this command super easy. Just click the Aa button and you can easily toggle to Sentence Case, lowercase, UPPERCASE, Capitalize Each Word, or tOGGLE cASE.
How to remove just the dashes in a text string in Excel
July 1, 2009 – 12:27 am
Brian sent the following question.
If I have a field that has a number (can change the format to “text” if needed) such as “03-506-46” and I want to take the dashes out so it looks like “0350646” is there a function that does this? Or, do you have to “F2” and manually edit each one?
Excel can be tricky, especially if you want to leave the leading zero. However, with 2 quick steps you can accomplish your goal.
Step 1 - Type Ctrl+H to bring up the Find/Replace menu. Type “-” in the Find what box and leave the Replace with box blank. Click Replace All.
Step 2 - Add the zero back to the front of the string with this formula in column B =“0”&A1
Your result is in column B:
How to Keep Your Group Memberships Private on Facebook
June 30, 2009 – 12:10 am
You’ve joined Facebook, but you don’t want people to see that you are a member of the Chicago Cubs Group. Not that anyone would be embarrassed by that …
To keep your Group Memberships Private, click Application Settings, from the Settings menu in the upper left corner of Facebook.
Then, click “Edit Settings” next to Groups
Your privacy settings determines who can view your groups:
Keep your Friend’s Private on Facebook
June 29, 2009 – 12:41 am
While it’s fun to be popular, some of your friends might prefer to stay private. It seems strange to me that individuals can’t choose whether or not their photo shows up under their Friends’ Friend Box … but with Facebook’s settings, protecting your Friends’ privacy is up to you.
To modify the visibility of your friends, visit the Profile Privacy page.
Once you’ve created your groups, you can edit your privacy settings. Look in the upper right corner of Facebook, hover over Settings, then click Privacy Settings.
When you click on your profile:
This menu appears:
Navigate down to the setting which says “Friends” and then modify the setting to whatever is right for you. To exclude everyone from seeing your friends, you will need to create a Friend group that contains all of your Friends, and add that group to the “Except These People” box.
Credit Cards … from the Merchant’s Perspective
June 26, 2009 – 12:58 am
Being able to accept credit cards online and in person is a necessity in doing consumer business. It is also highly desirable when dealing with small businesses.
When decided whether or not to accept credit cards, you need to determine whether your sales will increase enough and bad debt will go down enough to cover the additional costs that you will be required to pay to a processing company.
The MerchantWarehouse.com is a vendor that provdes credit card machines and everything that you need to accept credit cards, debit transactions and checks. They guarantee that their prices are lowest on credit card machines, credit card software and all other credit card equipment. They advertise that if you should happen to find a lower price on credit card machines, from a verifiable competitor, for any of the equipment of software offered on our website, we will match that price and give you an additional $10 off your purchase. That gives some comfort when making a buying decision.
What I really like about MerchantWarehouse.com is the customer testimonials about their credit card machines and service. You can tell when a company has the right attitude. For example:
“I would like to thank Merchant Warehouse and Patric Caya for getting us up and running so quickly. I can’t begin to tell you what a pleasure it was to get set up with you guys. Patric was informative, efficient, easy to work with, pleasant to speak to, and incredibly helpful in getting us up and running quickly. Thanks!” from All Things Engineering
or
“I just wanted to let you know that the reason I opened another account with Merchant Warehouse is because we have 2 businesses and Brian Cox has made this process fun and informative. We had a lot of questions, but he has such excellent customer service skills that we decided to establish our other merchant account through your company as well. Thanks again, Brian!” Gravity Glass
There’s one place you shouldn’t skimp
June 26, 2009 – 12:52 am
Where?
Life insurance
Why?
Because you never know when disaster might strike. You could get lucky like my grandmother and live to 98. Or you might die young like Michael Jackson. The one thing you can control is how your family is taken care of after your gone.
But there are so many life insurance choices that it can be daunting …
- Term Life Insurance
- Whole Life Insurance
- Universal Life Insurance
- Key Man
- Second to die
- Group Policies
- Mortgage
- Smokers
Advantage Term Life offers a one stop shop to compare rates for all types of life insurance. They have a quick online form for Life Insurance Rate Quotes and they make a BIG promise:
Get a low rate insurance quote from our company. We provide the best competitive affordable term rates for family & couples across the united states from all major companies. Lower your costs and get the cheapest insurance for life available anywhere online.
They collect quotes from over 25 of the largest Insurance Companies in the United States and deliver the bids instantly. You don’t have to talk to a salesman! (Nothing against salesmen)
Fluorotherm is the hot company delivering fluoropolymers
June 26, 2009 – 12:12 am
Looking for fluoropolymers?
The commercially available fluoropolymers are as follows:
- PTFE (Poly tetra-fluoro ethylene) is a fully fluorinated polymer. PTFE is processed by compacting the powder under pressure at ambient or slightly higher than ambient temperatures. Methods of forming products include paste extrusion, ram extrusion, molding and calendaring between rolls.
PTFE is not melt pressable. The following polymers are:
- FEP (Fluorinated ethylene propylene) is a fully fluorinated copolymer
- PFA, MFA – Perfluoroalkoxy, fully fluorinated copolymers
- ETFE - Ethylene tetra-fluoro ethylene, partially fluorinated polymer containing hydrogen. ETFE has the ability to withstand exposure to high temperature withour rapid embrittlement
- ECTFE - Ethylene chloro tri-fluoro ethylene, a copolymer of ethylene and chlorotrifluoroethylene
- PCTFE - Poly chloro tri-fluoro ethylene, copolymer containing chlorine
- PVDF - Poly vinyledene fluoride, partially fluorinated polymer containing carbon to carbon double bond (which is weaker than single bonds of fully fluorinated polymers)
The hot fluoropolymer producer is Fluorotherm. The company has been a a specialty manufacturer of fluoropolymer since 1992. They’re R&D team has a strong background in fluoropolymers, gained from experience working for DuPont.
They recently announced a new addition of PVDF frame Immersion Heat Exchanger coils to their family of Immersion coil products, broadening the performance range of low temperature Polypropylene frame (to 150° F) and high temperature, premium PTFE frames. The standard tubing coils of the heat exchangers still consist of either FEP (to steam pressures of 2 bar / 30 psig) or PFA tubing (4 bar or 60 psig).
PVDV frame heat exchangers, now in place for two years at selected customer sites are superior in performance to Polypropylene frames, in cases where the tank or bath temperatures exceed 150° F, and can operate up to temperatures of 210° F. PTFE frame temperatures are recommended for temperatures above 210° F.
Fluorotherm has successfully developed and installed multiple fluoropolymer coil shell and tube heat exchangers with significant increase in the heat transfer surface area from 12 sq.ft (1.1 sq.mt) to 55 sq.ft (5.1 sq.mt). Tubing is available in FEP, PFA, High Purity PFA and PTFE materials. Popular shell side materials are PVC and CPVC., although stainless steel is also available for special high temperature shell side fluid applications.
What happens when you Post to a Friend’s Wall in Facebook?
June 26, 2009 – 12:05 am
In Facebook, the person who owns the wall own’s how the message is delivered.
If your Friend lets EVERYONE view their wall, then your Wall post can be viewed by EVERYONE. Writing on a wall should be viewed as public information. Depending on your Friend’s settings, wall posts show up in Newsfeeds. So if you make a crazy comment via a wall post, it may be broadcast to mutual friends and friends of friends, etc. Just like comments on blog posts, once you’ve posted, you can’t take it back.
If you want to tell a friend that they did a great job on a project, posting on a wall is a fabulous way to get the message across. If you want to share private information, your best bet is to use a private message rather than writing on someone’s wall.
Create Facebook Friend Lists and Edit Privacy Settings
June 25, 2009 – 12:50 am
With the sudden surge in new facebook friends at Zayo, I will be publishing a series of blogs that offer a few tips on how to better use Facebook. Rule #1 - do not tag my high school pictures with my name. HORROR! Yes, I went to school in the 80’s. Neon colors, feathered hair, acid washed jeans, fringe, spandex, white ankle boots and spike heals were the rage. For example, this look would have been standard attire for my graduating class:
But I digress, lesson one to save you and your Facebook friends any anxiety … make sure to Use Your Friend Lists.
Friend lists allow you to create private groupings of friends based on your personal preferences. For example, you can create a Friend List for your high school friends, your business associates, your current co-workers, your charity groups, etc. This allows you to easily view friends by type and send messages to your lists.
- You can add each friend to more than one friend group
- Friend Lists can have specific privacy policies applied to them
Just click on the friends tab on Facebook:
Then click +Create:
Once you’ve created your groups, you can edit your privacy settings. Look in the upper right corner of Facebook, hover over Settings, then click Privacy Settings.
When you click on your profile:
This menu appears:
Some of the menus have a Customize option:
For example, if you really want to post crazy things on your wall, you can restrict who can view your wall … and exclude your mother and your co-worker’s friends list. Those listed in “except” will NOT be able to see Wall Posts in this example.
BlogoSquare