Dear Crabby: Pouring info into Excel more efficiently

Bulldog with a headacheThis week's Friday Dear Crabby letter is about Excel 2007. Working with data and keys and multiple spreadsheets from multiple sources can give even the most expert Excel user a whopping headache. That's apparently what's going on with this week's Dear Crabby email letter writer.

See, Linda's figured out a way around the issue (an issue I'll explain in the full post) but it takes longer than need be, and frankly, it's just inefficient and clumsy (no offense Linda; my hat is off to you for figuring out a workaround).

As I told Linda when I wrote her to say that she was this week's lucky Dear Crabby winner/writer/victim, sometimes the answer is just right in front of usin the form of other people who use Excel and who may have experienced the same issues.

Who among you has the hidden answer to Linda's conundrum? Hmmm???

...(read more)
Posted in Excel, tips | Leave a comment

Dear Crabby: Pouring info into Excel more efficiently

Bulldog with a headacheThis week's Friday Dear Crabby letter is about Excel 2007. Working with data and keys and multiple spreadsheets from multiple sources can give even the most expert Excel user a whopping headache. That's apparently what's going on with this week's Dear Crabby email letter writer.

See, Linda's figured out a way around the issue (an issue I'll explain in the full post) but it takes longer than need be, and frankly, it's just inefficient and clumsy (no offense Linda; my hat is off to you for figuring out a workaround).

As I told Linda when I wrote her to say that she was this week's lucky Dear Crabby winner/writer/victim, sometimes the answer is just right in front of usin the form of other people who use Excel and who may have experienced the same issues.

Who among you has the hidden answer to Linda's conundrum? Hmmm???

...(read more)
Posted in Excel, tips | Leave a comment

Cloud Computing a Catalyst for Server Growth?

In an interesting piece by Ryan Nichols at Computerworld yesterday: Cloud computing by the numbers: What do all the statistics mean, Nichols summarizes some recent research findings on the market potential of cloud computing, quoting impressive market forecasts from sources such as Gartner ($150 billion by 2013), Merrill Lynch ($160 billion by 2011),and AMI Partners (SMB spend to approach $100 Billion By 2014).

As part of his analysis, he gives a nod to some of the reasons for this growth, with the need for business agility and the proliferation of mobile and social computing being front and center. At the same time, he identifies a couple of "head scratchers," raising the question: "if virtualization is growing and cloud computing is growing, how can the market for private enterprise servers also be growing?"

It's a great question, and one that we hear frequently given that we are the only company to provide both a server platform, Windows Server, and a cloud services platform, the Windows Azure platform. How can both markets possibly grow at the same time? And growing they are. As Ryan points out, IDC is seeing strong growth in the server market. Just last week the analyst firm issued its Worldwide Quarterly Server Tracker, which showed that "server unit shipments increased 23.8% year over year in 2Q10... representing the fastest year-over-year quarterly server shipment growth in more than five years."

While it may seem contradictory at first blush, there are a number of reasons for this and it is actually pretty straight forward. When we talk to customers, the vast majority of them are thinking about cloud computing and looking at how to bring cloud-like capabilities and benefits (cost savings, elastic scalability, self-service, etc.) into their organization. However, they are all in different stages of the process, with very disparate infrastructure and business needs. And for many organizations, a wholesale move to a public cloud service isn't particularly realistic in the short term, whether it's due to regulatory requirements, geographic concerns, or the nature of the workloads and data they are hosting. 

In addition, there are other organizations that will want to take advantage of the benefits of cloud computing, but also may want to preserve existing infrastructure investments and maintain a level of versatility that can't be met by public clouds Enter the notion of "private clouds" and again, enter Windows Server. We continue to make enhancements to Windows Server to make it easy for customers and partners to use it to build private (and public) cloud services, such as the recent release of System Center Virtual Machine Manager Self-Service Portal 2.0.

Both of these scenarios continue to drive heavy demand for our Windows Server platform. In that same IDC report from last week, Microsoft is highlighted as the server market leader, "with hardware revenue increasing 36.6% and unit shipments increasing 28.2% year over year."" Those are big growth numbers, even with more than 10,000 customers signing up to our Windows Azure platform this year.

So is there still room for enterprise servers in a cloud computing era? Absolutely. The numbers and customers don't lie. Offering both a server and a services platform with onramps to the cloud is at the heart of our business strategy and a reason why we are seeing such success in both areas. For those organizations that want a highly optimized, scalable environment where we prescribe the hardware and normalize the cost of operations, there's our services platform, the Windows Azure platform. For those that want the versatility to enable environments of any scale, or need custom hardware configurations and operating models, there's our server platform, built on Windows Server. And, of course, we have a common application development, identity and management model spanning the two platforms, which doesn't hurt either.

Curious what others think on this topic? What do you think are the reasons for ongoing growth in the server market?

Posted in Cloud Computing, Virtualization, Windows Server 2008 R2 | Leave a comment

Update not so Tweet for you

It's very important your computer, software and browser are running with the latest updates, but it's equally important to be discerning about where your updates are coming from.

A perfect example of the latest update scam: Recently, we observed malware writers using compromised Twitter accounts to post the fake tweets about the 'latest TweetDeck update' as mentioned on the TweetDeck Support portal. The tweet contains a URL that points to the fake TweetDeck update file called 'tweetdeck-08302010-update.exe', a small executable file 95KB in size. When the file is run, nothing appears to happen, but in the background, malware will infect the computer.      

Microsoft anti-malware solutions protect against this threat, detected as Trojan:Win32/Alureon.CT.

The lesson here: Don't respond to alarmist demands to update or else! Verify where your update is coming from; make sure you are getting updates from a reputable vendor.   

Happy tweeting!!!

- Hil Gradascevic & Jasmine Sesso

Posted in Uncategorized | Leave a comment

Use this: Say it, don’t spray it (using the Bcc line)!

Computer wormToday's "Use this!" tip is a bit of a lecture. I'm begging you, once again, to refrain from sending out rumors, jokes, links to adorable kitten videos, and hoaxes (even those that you don't yet know are hoaxes but most definitely are) without hiding the names of the 137 recipients who simply MUST know about whatever it is you're sending.

And what do I mean when I talk about hiding the addresses of all your recipients from one another? Am I telling you this to encourage you to be sneaky? Not really. What I'm doing is saving your email receivers from possible spam and computer viruses and worms (and other nasty stuff).

I recently became a beneficiary of a certain type of virus sent to me by some creepy spammer who got my email address from a certain acquaintance of mine who shall remain nameless because I like to have friends.

So! Let's talk about making use of the lonely, underused Bcc line.

...(read more)
Posted in Outlook, e-mail, tips | Leave a comment

Crabby’s Monday favorite: Using the right program for the job

Woman who has painted herself into a cornerEver feel stuck in a rut, using the same program over and over but not getting the results you want (or getting them but at the expense of everything, including family time and your sanity) ? If so, it's time to open your eyes to what else is out there—expand your horizons, step outside your comfort zone, think outside the box (and perhaps get some new clichés).

Listen, I know that when you get comfortable with one program, you tend to use it as much as possible. Little kids are notorious for wanting to wear the same outfit every day of the week (and this often means a Superman cape or a ballerina tutu), but people, it's time to put away childish tendencies. A tutu is made for dancing; it's not so useful for soccer. And a cape, well, I suppose one could make the case that a cape is good for just about anything, but if it were my kid, and bike riding were involved, the cape would have to go.

Yes, Office programs can be pretty flexible. But if one program could handle every task, there wouldn't be the need to offer 10+ different ones. For today's tip, I'm going to give a few examples of tasks you might have to undertake and then compare whether to use Access or Excel to accomplish them. 

...(read more)
Posted in Access, Excel, database, holidays, tips | Leave a comment

Dear Crabby: Celebrating the control freak in all of us

Teddy bear in a car seatSecurity is a pretty loaded word. When I was a kid, it meant my blankie—period. Now it's something totally different; it could have to do with money, relationships, my job, and my computer. I just asked my 8-year-old and she gave me a one word answer, "Safe."

"Safe." We all want to feel it, and we want others we love to feel it too. As you can imagine, safety and security are at the forefront of priorities when talking about computers. In one way or another, computing has become so widespread that whether or not you have a computer, have access to one, or have even used one, you are impacted daily by computers. A few examples: Your bank, the stores you shop at, street lights, and utilities all use computers to keep them going. 

(As an aside, just this week, Intel, the chip maker ["chips" being, essentially, the tiny little engines that make computers run] is buying one of the leading security software maker companies, McAfee. I personally think this is an exciting prospect. Soon our hardware—not just the software we've chosen to install on our computers—will be the one dealing with the more and more sophisticated threats coming our way.)

But okay! Let's lighten up! Security in computers can also mean just securing a document, a spreadsheet, a Visio drawing, a presentation. You've made one and you don't want anyone changing it. Is that so wrong? No it isn't, and this week's "Dear Crabby" letter comes from someone who is thinking about just that. 

...(read more)
Posted in Office 2003, Office 2007, Office 2010, PowerPoint, security, templates, tips | Leave a comment

Crabby’s Thursday tip: I know what I mean! (AutoCorrect)

Plumber under the sink; see more "repair" images at office.com/imagesSome things we just can't do without in life: love, friendship, a bathroom door that locks. With Office, the same is true: Some features should not be overlooked.

One of the complaints we get around here is that some of the Office programs have so many features that you can't figure out which ones would be the most useful for you. This week I'll clue you into one of my longtime favorites: AutoCorrect.

...(read more)
Posted in Office 2003, Office 2007, Office 2010, tips | Leave a comment

Visions & concepts: Forgotten attachment detector

Get more ELEPHANT or FORGETTING images from office.com/images

Back in June, I wrote a post about a free Outlook add-in called the Missing Attachment Power Toy, a little program that reminds you, before you send your email, that you've forgotten the file or photo or whatever you promised you'd be sending along. Smart, huh? The company that makes this program, Fortis Software, is a Microsoft Office Marketplace Partner (see the Browse Office Marketplace heading halfway down that page) and I'd spent that entire week in June introducing you to some of the free services and programs that our partners offer.

Well! Someone named Vaibhav told me in a comment on that post that Office Labs (Microsoft's internal "sandbox" of sorts where smart people explore, experiement, and research new things) has something called Forgotten Attachment Detector that does the same thing as the Missing Attachment Power Toy, AND it's free too, AND it works with Office 2010 (while the Fortis program does not).

And so, today's post is all about OUR free attachment reminder program, something I'm guessing many of you could really use.

...(read more)
Posted in Outlook, downloads, e-mail, tips | Leave a comment

How to install the Outlook Social Connector

The installation of Outlook Social Connector is different than most downloads. Besides downloading Outlook Social Connector (for Outlook 2007 and Outlook 2003; it’s included in Outlook 2010), you must download provider files for each social network you want to connect to. Watch this short video to see how and see the important links plus an overview of the Outlook Social Connector below.

Get Microsoft Silverlight

Note: To use Facebook in the Outlook Social Connector, you must allow a third party application (which is the default setting). If you have edited these settings in Facebook, you may need edit them at http://www.facebook.com/editapps.

For more help, ask question at Microsoft Answers.

--Doug Thomas

...(read more)
Posted in Facebook, Outlook, email | Leave a comment