Excel

Excel Services content refresh is live

If you’re a developer, you may have been wondering…”When are they EVER going to revise the Excel Services JavaScript Object Model (JSOM) documentation for SharePoint Server 2010?” Well, I’m glad you asked! The SharePoint Server 2010 Software Development Kit (SDK) online documentation has been refreshed, and I’m happy to announce that as part of that refresh, the Excel Services JSOM documentation was also updated–in fact, it’s been completely revised. Keep reading…

Excel

Free training: Take the next steps in growing your Excel skills

In early May, we told you about the new video series Excel Skills Builder in our post “Take the first step in growing your Excel skills.” In that post, we announced the launch of lesson 1. Well, we’ve finally finished the rest of the lessons, and wanted to share this great resource with you!   As a reminder, the skills builder is a video series that comprises short (typically under 5 minutes…

Excel

Take the first step in growing your Excel skills

It’s hard to find time to learn new skills. We’re all busy, and as much as we might want to become more proficient at something, we seldom have the extra time required to learn. That’s one of the reasons I’m excited about the new video series called the Excel skills builder. In a nutshell, the skills builder is a video series that comprises short (typically under 5 minutes each) videos that give…

Excel

Learn the ins and outs of dates and formulas in this free training course

Have you ever wanted to subtract one date from another? Or find out how many workdays until vacation? Or maybe you need to figure out a project end date. You can do all of this and more by using date functions in Excel formulas. As long as you type a date in a format that Excel recognizes: 8/22/2011, 22-August-2011, or August 22, 2011, for example, Excel will interpret the date…

Excel

Add the date, time, file name, and page numbers to Excel headers or footers (video)

So it turns out that Excel 2010 users have something in common with Word users after all. While researching the top search terms and phrases on the Office.com web site, I discovered that just like Word users, many people who use Excel 2010 want to add page numbers, the date and time, a file name, and other text to the header or footer of all worksheets in a workbook. So…

Excel

Wedding budget planner template: From good to great in under 5 minutes (video)

Planning a wedding can be really fun or really stressful. OK, to be honest, it’s usually a little of both. Figuring out where to seat Aunt Mildred at the reception and how to convince all your bridesmaids that yellow taffeta really does look pretty can be hard enough. Now imagine trying to coordinate and keep track of your expenses and overall wedding budget. While it can’t really help you with…