The idea is to view, edit, add, and even delete data directly within your familiar Excel experience. It also lets you ask questions to the database using a special language called SQL (Structured ...

Saving your Microsoft Excel worksheet as a Web page makes it easy for anyone with an Internet browser to view your data. If you want to see how your table will look as a Web page before publishing ...

How to create a temporary view in Excel When others are viewing and working in the workbook, you’ll see a small icon with their Microsoft account information (or organizational information).

While Word 2007 and Excel 2007 retain the Full Screen views of their predecessors (press Alt-V, U), you can't access the main menus (File, Edit, etc.) the way you can in Office 2003 apps, nor is ...

Learn to use Excel's GROUPBY function for real-time data analysis, dynamic summaries, ... providing a tailored and accurate view of the data. How to GROUPBY in Excel with Dynamic Drill Down.

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

The query gets just the information you want from Oracle -- customer lists, stock numbers or sales records -- and prepares an Excel spreadsheet file from the data. Click the "Start" button.