Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets. An Excel ...

How to run a VBA procedure from a data validation control in Microsoft Excel Your email has been sent There are lots of ways to execute a VBA procedure in Microsoft Excel. You can add macro buttons at ...

JavaScript isn't replacing Office macros anytime soon, but the Office Web apps (and the SharePoint-based enterprise equivalents) are improving regularly. For users that means simple but useful ...

Microsoft Excel Slicers are easy-to-use visual controls added to Excel that allows to quickly and easily filter data in an interactive way by selecting values from a list. The slicer feature provides ...

This chapter shows you how to upload and download workbooks to and from the Windows SkyDrive. This chapter will help you get started working on and sharing your Excel files online. For a more in-depth ...

This morning, Microsoft opened the tech preview of its long-anticipated Office Web Apps. Here’s a first look at what the online version of Excel has in store. From the online SkyDrive folders, you can ...

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

Still far and away the most powerful, and now the easiest-to-use, worksheet app. Except for a few scientific and financial-analysis tasks, it's the first and only choice for manipulating numeric data.