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,…

OneNote

OneNote for iOS gets new features, arrives in new markets worldwide

If you’ve been using OneNote on your iPhone for a while, you already know how useful it is for keeping tabs on all of your busy life’s tasks, commitments, ideas, and decisions. Today, just in time for the holidays, we’re releasing OneNote 1.3 for iOS that further expands on the full OneNote experience with brand-new mobile features — including a version that’s tailored for the iPad. Today also marks the app’s…

Excel

Tracking small projects in Excel

It goes without saying that Microsoft Project is THE program to use if you need to manage large projects. But what if you manage smaller projects? Can you do that in Excel? Sure, but life will be easier if you start with a template that is specifically designed to facilitate project management. With that in mind, PowerPoint expert Glenna Shaw created a free project plan template for tracking projects in Excel. You can use this template to…

Excel

When a macro won’t cut it, try a VBA script

This post written by Daniel Ferry, an Excel MVP, chronicles how he and Beth Melton, a fellow MVP, designed a Gradebook template in Excel that makes teachers’ lives a whole lot easier. Several teachers, however, wanted to make the template even more useful. They asked us whether the template could print all student progress reports at once. To tackle this task, Daniel knew recording a new macro wouldn’t cut it. He needed to write a…

Excel

Data’s got a brand new bag: PowerPivot for Excel (video)

There’s lots of data out there: LOTS. The digital universe is about eight hundred thousand petabytes (that’s eight hundred million gigabytes). Your business is no doubt contriubting to that number and needs a way to work with it. PowerPivot is a free add-in for Excel that can link multiple spreadsheets or even link to databases. That means you can work with millions–emphasis on the “s”–of lines of data. Excel also…