Results for:
Excel

• Oprah's—I mean Crabby's—favorite things: Excel 2010

  15 Jun 2011

  But even so, an old hat (like the Hogwart's sorting hat ) can discover new tricks that it didn't know were possible. Excel 2010 has some really great new additions as well as improvements (I probably shouldn't use that word-- improvements-- but everything and everybody can fashion some room within themselves...
• New Excel macro training videos for beginners

  16 May 2011

  Today's post was written by Angela Chu-Hatoun, a senior programmer writer on our big Office team who's, frankly, much more technical than I am and is good at exploring the deep underbelly of programming, how it works, and how YOU can do it too. This post originally appeared last Friday, May 13, on the...
• Four hot text tips from Crabby

  27 Apr 2011

  Over the years, I've often been asked—by friends, by family, by Crabby readers—what some of my best Office tips and shortcuts are. Honestly, it's hard to just spout, off the top of my head (which would be rather gruesome anyway), the miscellaneous tricks that I've discovered, unearthed, and...
• Excel poses file name problem; man seeks and finds answers

  18 Apr 2011

  Today's post is a little more... technical than I'm used to doing and I must say, right up front, that I did not come up with the answer on my own . Nope. Keep reading. A reader named Tim from New York had an issue that, while wasn't a work stoppage issue, exactly, was driving him nuts nonetheless. The...
• Gardening with Office, not so foolish...

  1 Apr 2011

  Yes, today is April 1st, and this post is a light-hearted attempt to get you gardeners excited about using various Office programs to plan, plot, and perfect your garden. Really! When spring has sprung and you've finally flung all your sweaters and boots into storage, When the buds on the trees make...
• The ribbon: Who's a fan of the bread and butter of Office?

  4 Mar 2011

  If anyone is passionate about Office, it's Steven Sinofsky . Don't know who Steven is? Although now he's president of the Windows division here at Microsoft, he spent years in the Office division as head of product development. But it's as an Office customer that Steven is so excited about many of the...
• Updated! Interactive Excel files on web pages: An Excel PM explains

  25 Feb 2011

  Update: See near the end of this post for the latest Office how-tos on embedding Excel and PowerPoint files. Hi everyone, My name is Larry Waldman and I'm a program manager on the Excel team. This week, the Crabby Office Lady was nice enough to let me combine a couple of Office's cool features to highlight...
• Excel sorting, filtering & formulas explained

  9 Feb 2011

  Excel is up to bat this week. I like Excel. It's a versatile program—straightforward, no-nonsense, and linear(ish)—and one that many people use. With Excel you know what you're getting (whereas in Visio or in Publisher, you sometimes feel like you're in a large hardware or fabric store with...
• You create your own freedom: Go get your ribbon roadmap

  27 Dec 2010

  When Office 2007 first came out, what everyone noticed first was the new interface, namely, the ribbon. This ribbon replaced the menus and toolbars—yes, the self-same menus and toolbars that you constantly griped about and yet were suddenly so enamored of (you cannot imagine how much whiny feedback...
• Baby, I've filled the bottle of collaboration for you—now go drink

  15 Dec 2010

  I've previously written posts about collaboration tools and techniques in Office; I've covered Communicator , PowerPoint , SharePoint Workspace , Outlook calendars and Word . I want to take today's post to comment on why collaboration is such a hot button topic these days and why you really should consider...
• Pretty darn fancy, those PDFs

  22 Nov 2010

  Sometimes the Word documents, Excel spreadsheets, PowerPoint presentations or other things you've created using Office 2010 or 2007 cannot be viewed by others, inviting bad blood and general crabbiness. There are a couple of reasons why these folks cannot look at the files you worked so hard on: Your...
• Celebrate International Scroll Lock Day

  8 Nov 2010

  I had this little problem the other day and it was driving me nuts. I wanted to move from cell to cell In Excel using my arrow keys. Is that asking too much? Apparently so because when I pressed the DOWN arrow, the entire page scrolled down. Using the UP arrow made the entire page scroll up. It was just...
• Dear Crabby: Sit with me side by side...not on my shoulders

  5 Nov 2010

  For this week's Dear Crabby post, I picked an issue that several readers commented on and wrote emails about this past month. My tenet is that if one or two people report a problem, chances are many others are experiencing the same thing. And so, Gentle Readers, let us cut a wide swath through this week...
• PivotCharts: Your data with a view

  3 Nov 2010

  Take a look at the image below— it's a PivotTable AND a PivotChart (which gives your data graphical representation). Steve, a salon owner (and manager of my tresses), wanted to see how much his salon made off me during the months of January, February, and March this year. He took his spreadsheet...
• Updated! Embed PowerPoint or Excel into web pages

  5 Oct 2010

  Update: See the end of this post for the newest how-to-embed info. What better way to explain how something works than by actually showing how it works? Below is a self-fulfilling prophecy: An embedded presentation showing exactly how to ...embed a presentation using Office Web Apps. Pretty nifty, eh...
• Crabby's Monday tip: Change where the cursor moves after entering data in Excel

  27 Sep 2010

  So...Kathy wants to know how to change the cursor direction in Excel when she presses Enter. Turns out it's a simple little setting: Excel 2010 Click File > Options > Advanced > Editing Options . Now, below the heading Editing Options you'll see After pressing Enter, move selection and below...
• Be a part of something: Enter the Template Idol Contest

  9 Sep 2010

  Today I'm proud to announce that our yearly Template Contest has come 'round again and this year we want your very best 2010 or 2007 Word, PowerPoint, Excel, or Publisher calendars. You can enter as many as you like, and entries will be accepted through September 30th and winners will be announced October...
• Dear Crabby: Pouring info into Excel more efficiently

  3 Sep 2010

  Linda in Washington State wrote to me with juicy problem involving combining data from two different Excel 2007 files that have different columns but a common key. Right off-hand (and even later, on-hand) I don't have the answer to this. I told her I'd forward her issue along to a couple of Excel experts...
• Crabby's Monday favorite: Using the right program for the job

  30 Aug 2010

  Excel and Access have a lot in common when it comes to managing data. However, there are some key differences that you need to know. Let's say you're planning a massive family reunion (a job for the family's well-organized masochist). Figuring out who can sit next to whom (thus avoiding last year's scandals...
• Crabby's Monday favorite: Sparklines (this time they get the whole post)

  23 Aug 2010

  Sparklines for Excel 2010 are almost like these little strings of light, illuminating your data. They can can help you to discover patterns or trends in your data (making it more useful for you and the people you're going to share the data with, too). I mean, displaying data in rows and columns is great...