Access

How to save your Access SharePoint password

Recently, someone posted a comment on IT Impact Inc.’s blog asking how to get SharePoint to remember his password when he logged in via Access.  He wanted to avoid having to log in every time. Ben Clothier, a Senior Access Developer at IT Impact, knew the answer. He wrote a detailed blog post (with plenty of screenshots) that we’d like to share with you.  ITImpact has been building custom databases with…

Excel

Yes, it is possible to create nice looking spreadsheets

15 Spreadsheet Formatting Tips For the last couple years I’ve been meaning to pull together some of the tips that I’ve learned working on the Excel team about how to make nice looking spreadsheets. Well, last week, Rob Collie (a previous Excel Program Manager, and now CTO at Pivotstream and author of PowerPivotPro.com) beat me to it with his post “In the Browser, Aesthetics Yield a Greater Return.”

Excel

Generate invoice numbers in Excel

If you need a way to create invoices in Excel, you can use one of the many invoice templates on Office.com. While these templates are a great starting point, they don’t automatically generate unique invoice numbers—you need a macro for that. In this video, Excel MVP Bill Jelen shows you how to create a couple of macros to generate invoice numbers. The first macro automatically increments the number and then…

Excel

Last-minute budget tips for those last-minute gifts

At this point in the holiday season if you’re like me, you’re over budget. Yesterday I started worrying about that cashmere sweater I bought for one sister-in-law and the sweatshirt I bought for the other. It’s back to shoping this evening to try to even it out. This time when I’m wandering the aisles, I’ll check my Excel holiday budget on my phone. I saved it on SkyDrive—Microsoft’s free cloud service—so…

Excel

Create smashing mashups with Excel

If you’re a web developer (or even if you’re not), you’ve doubtless heard of mashups—apps or web pages that combine existing functionality from different sources to create something entirely new. It’s now possible to create cool spreadsheet-based mashups by combining features from Excel Web App—specifically, the embedded workbook feature—with existing JavaScript APIs. Read on to see a couple of demo mashups, and learn about our new site for web developers,…