You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Update: See near the end of this post for the latest Office how-tos on embedding Excel and PowerPoint files.
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 one of my favorite little tricks. (Note that this post and these features refer to the Office Web Apps.)
First we've got a feature called Excel embedding that lets you put Excel files—yes, interactive Excel files—into your web pages by using Office Web Apps and SkyDrive. You may have seen Crabby's earlier posts about embedding Excel (or PowerPoint) files into web pages and making sure they ARE interactive. Doug Thomas also did an Office Casual video about the free Office Web Apps and SkyDrive accounts.
Also, I've long been a fan of the file templates we have in Office—that's right, Office.com Templates that you see when you click the File tab and then click New in Office 2007 or 2010. For me, things really come alive when you start with a fully functional (and premade) Excel template, tweak it as you need, and then plop it on your site. An example (and I got my example below straight from the Office.com Templates site) is worth a thousand words.
Using an out-of-the-box template, I've made a mortgage calculator for my site. All I had to do with this particular template was remove data validation, since checking whether the type of data you enter is valid isn't supported with this type of Excel spreadsheet. (You can read more about that here.)
In addition to playing with numbers in the Extra Annual Payment box to see how much quicker I can pay off my mortgage, if I pay a little extra money each month (Payment Interval of 1 means a month), I like to:
I like playing with numbers in the Extra Annual Payment box to see how much quicker I can pay off my mortgage if I pay a little extra money each year. Go ahead and try it out. Afterward, if you like this, you can download this interactive mortgage calculator yourself to see how quickly you can pay off your mortgage.
Thanks, Larry; I was happy to have a day off and also learn from a pro about what's possible these days with Excel and web pages. (And you also got me thinking about how to pay off that monkey—I mean that mortgage—down quicker.)
Crabby's Find of the Week: Think your e-mails are safe from prying eyes because of your oh-so-clever passwords? (DAD?!!?) ? Think again. Is it even possible to ward off email snoops?
Not finding the help you need from the various channels you've tried? Microsoft Answers is where you're most likely to solve your nagging problem.
As a Development Manager, I have always relied on this column to find helpful hints that I can forward to my developers. Seamlessly embedding Excel in a web page saves significant development, QA, and regression testing. Clear, concise explanation with an example that is relevant to most of the readers of this column - easy to hop from there to imagine how it can be used to make powerful user-friendly web pages. Way to go, Larry.
Wow. Wish my name was Larry. (But yeah, Newport Girl: I just concur: This rocks!)
wow cool, excel on the web!
@bwaldman (hmm...name rings familiar): Yes it IS cool. Noe go out there, get your free SkyDrive account and show us what you can do. I'll even link to it if you have another neat-o spreadsheet that Larry did here...
The article is very helpful! Thank you, I'll be sure to use your advice. Personally, I had some problems converting excel files over to PDF. Then I found this program at my work that quickly and painlessly converts my excel documents into pdf so I didn't have to do it manually (which would end up taking aggravating hours upon hours). It provides my business a simple way to make individualized statements for our business associates, taking our invoices and seamlessly placing the information in awesome templates. Check it out <a href=“www.nirvaha.com/free-spreadsheet-templates.html”>here</a>.
Is it possible to embed controls on one of these pages as well? (either Forms controls or ActiveX?)