Home > Excel Help Portal > Excel Databases

<<  (Page 4)  Previous              Next  (Page 2)  >>

Excel Databases

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses using Microsoft Excel
databases.

1. How to use Addresses from an Excel 2002 Worksheet to Create Labels in Word 2002 You can use the Mail Merge feature in Word to create and print labels for a mass mailing by using data from an Excel Worksheet. This article contains instructions that you can use to create such a list. When you use the Word 2002 mail merge... KB#318117. Keywords: Criteria, Query, Sorting, Microsoft Access, Sales, Fonts, Format, Symbol, Errors, Printing, Toolbar, Web, Validation, Window

 
2. How to create a Form Letter by Using Information from an Excel 2002 Worksheet in Word 2002 This article explains how to use the Mail Merge feature in Microsoft Word to create and print form letters by using data from a Microsoft Excel worksheet. When you use the Word 2002 Mail Merge feature, Word merges a main document with a recipient... KB#318118. Keywords: Criteria, Query, Sorting, Microsoft Access, Third-Party, Sales, Fonts, Format, Symbol, Errors, Printing, Templates, Toolbar, Web, Validation, Window

 
3. How to Use Microsoft Excel Data Tables to Analyze Information in a Database This article describes how to use Microsoft Excel tables to analyze information contained in a... KB#282851. Keywords: Criteria, Days, Format, Formulas, DSUM, MONTH, DCOUNT, DMAX

 
4. Search Page for "My Excel Pages" Related (#related) VBA to invoke a Google search or a dictionary search from within an Excel spreadsheet, creates and invokes a hyperlink via FollowHyperlink. Set up a Search shortcut in your Start Menu for a search of your hard drive (#fnd) You can search your hard drive for a word or a phrase... Keywords: Rank, Sorting, Wildcard, Dates, Months, Statistics, Format, Errors, Links, Printing, VBA, Files, Registry, Toolbar, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window

 
5. SYMBOLS for HTML and Excel Use Font Tables as Rendered by your browser (fonts.htm -- CODE, Hex, CHAR, bold, symbol, webdings, wingdings, wingdings 2, wingdings 3) Unicode (new page), and Unicode through 16000 as a zipfile. See newsgroup thread SYMBOLS for HTML and Excel use (this page) Excel characters as seen in the US... Keywords: Add-In, Charts, AutoCorrect, Sorting, Colors, Fonts, Format, Symbol, Formulas, Printing, VBA, Macro, Toolbar, HTML, Links, Web, Comments, CODE

 
6. WorksheetProtection Options Overview This article describes the enhanced worksheet-protection options available in Microsoft Excel... KB#289269. Keywords: AutoFilter, Criteria, Sorting, Format, Password, Defined Name, PivotTables, Object, VBA, Files, Menu Command, Toolbar, Hyperlinks, Internet Explorer, Scenarios

 
7. Fullfile version update may request Office source files Describes an issue where you may be prompted to provide the Office source files when you install a full file version of an Office hotfix or... KB#840169. Keywords: Criteria, Dates, Download, CD-ROM, File Name, Files, Registry, Templates, Web

 
8. How to Use MS Query to Merge Two Excel Files for a Mail Merge Data Source The information in this article describes how to use Microsoft Query to merge two Excel 97 files. You may want to do this so that you can combine related information into a single file and use it in a mail... KB#180599. Keywords: Query, Sorting, Format, Setup, Files, Toolbar, Links, Window

 
9. How to Analyze Questionnaire or Survey with a PivotTable PivotTables are analysis tools that you may find helpful in summarizing data from a questionnaire or survey. If you create a table of survey results in Microsoft Excel, a PivotTable is useful when the answers are Yes, No, and Undecided. This is... KB#151551. Keywords: Data Table, Format, PivotTables, ROW, COLUMN

 
10. How to Display a Custom Office Assistant Balloon You can use the Office Assistant to display a custom message (balloon) with the options you specify. The Assistant can display a simple message with buttons or check boxes. You can display several types of buttons (OK, Cancel, Retry, and so on) at... KB#162079. Keywords: Sales, Arrays, Printing, VBA, Macro, Object, Toolbar, Web

 
11. How to Programmatically Perform a Web Query A Web query is a feature in Excel that allows you to retrieve data stored on an intranet, the Internet, or the World Wide Web. A Web query can use static parameters, dynamic parameters, or a combination of both. Queries with static parameters send... KB#213730. Keywords: Query, VBA, Macro, Object, Web

 
12. How to analyze a Questionnaire or Survey with a PivotTable in Excel 2000 This step-by-step article shows you how to analyze a questionnaire or survey with a PivotTable. PivotTables are analysis tools that you may find helpful in summarizing data from a questionnaire or survey. If you create a table of survey results... KB#213920. Keywords: Data Table, Format, PivotTables, PivotChart, ROW, COLUMN

 
13. How to Create Web Query (.iqy) Files This article explains how to create Web query (.iqy) files for use with Microsoft Excel... KB#157482. Keywords: Query, Format, Symbol, Files, Text Files, Web

 
14. Excel Statistical Functions: Representing Ties by Using RANK This article discusses how to use RANK to give an average rank value to tied... KB#828678. Keywords: Rank, Format, Arrays

 
15. How to customize the My Places Bar in the "Open" and "Save As" Dialog Boxes This article describes how to customize the My Places bar in Microsoft Office XP. The My Places bar appears in the left pane of the Open and Save As dialog boxes in Office XP programs. The following customizations are available for the My Places... KB#282087. Keywords: Sorting, Export, File Name, Registry, TYPE

 
16. How to Customize the Places Bar This article explains how to add user-defined entries to the Places Bar in the Office 2000 Save As and Open dialog boxes. If you want to do this, you must modify or add the registry keys and entries described below. Office 2000 applications... KB#205041. Keywords: Sorting, Format, CD-ROM, Registry, Web

 
17. How to Customize the My Places Bar in Both the Open and the Save As Dialog Boxes in Office 2003 This article describes how to customize the My Places bar in Microsoft Office 2003. The My Places bar appears in the left pane of both the Open and the Save As dialog boxes in Microsoft Office programs. The following customizations are available... KB#826214. Keywords: Sorting, Export, File Name, Registry

 
18. How to Specify Dynamic Web Query Parameters A Web query is a new feature in Microsoft Excel 97 that allows you to retrieve data stored on your intranet, the Internet, or the World Wide Web. A Web query can use static parameters, dynamic parameters, or a combination of both. Queries with... KB#162051. Keywords: Query, Third-Party, Symbol, Files, Web

 
19. How to Use the PivotTable AutoShow Feature In Microsoft Excel 97, you can use a new PivotTable feature called AutoShow to quickly analyze a large set of data to find specific results. For example, you can use the AutoShow feature to find the top ten salespeople per region based on... KB#162386. Keywords: Sorting, Sales, PivotTables

 
20. Macro to Sort Data in Multiple Columns as One Column Microsoft Excel does not have a built-in method to sort a newspaper (snaking) column of data. This article contains a sample macro to sort data that is in a newspaper column... KB#247311. Keywords: SERIES, Sorting, Format, Styles, VBA, Macro, Web

 
21. Excel Filters -- Advanced Filter Introduction 1. Set up the database For a workbook with sample data and criteria, click here. 2. Set up the Criteria Range (optional) In the criteria range, you can set the rules for the data that should remain visible after the filter is applied. You can use one criterion, or several. After the... Keywords: Advanced Filter, Criteria, Wildcard

 
22. How to specify Dynamic Web Query Parameters in Excel 2000 This step-by-step article shows you how to specify dynamic Web query parameters in Excel 2000. A Web query allows you to retrieve data stored on your intranet, the Internet, or the World Wide Web. A Web query can use static parameters,... KB#211926. Keywords: Query, Symbol, Web

 
23. How to optimize PivotTable Performance in Excel 2000 This step-by-step article describes the options in steps 1 and 3 of the PivotTable Wizard, and explains how they affect memory usage, speed, and file size. When you create a PivotTable, Microsoft Excel creates a hidden copy (cache) of the source... KB#273583. Keywords: Query, PivotChart, PivotTables

 
24. How to consolidate Multiple Worksheets to a Single Sheet in Excel 2000 This step-by-step article describes how to consolidate multiple worksheets to a single sheet in Excel 2000. You can summarize data from one or more source areas by consolidating it and creating a consolidation table. These source areas can be on... KB#214270. Keywords: SERIES, Consolidate, Links, PivotTables, Templates

 
25. How To Retrieve the Results of a Parameter Query Using DAO In the versions of Microsoft Excel listed at the beginning of this article, you can use data access objects (DAO) in Microsoft Visual Basic for Applications to retrieve the results of a Parameter QueryDef from Microsoft Access. This... KB#146607. Keywords: Criteria, Query, Years, DAO, Microsoft Access, Sales, Fonts, VBA, Macro, Object, Toolbar, Web

 
26. How to Use the GetOpenFilename Method This article provide instructions and examples on using the GetOpenFilename method in a Visual Basic for Applications... KB#161930. Keywords: Add-In, Query, Wildcard, Errors, VBA, Macro, File Name, Files, Text Files, Web

 
27. How to Copy One of Each Record Type to Another Worksheet Using Microsoft Visual Basic for Applications in Microsoft Excel, you can copy a single instance of a record type to another... KB#151344. Keywords: Clipboard, VBA, Macro, Toolbar, Web

 
28. How to Use a Visual Basic Macro to Sort Arrays in Excel In Microsoft Excel 2000, there is no direct method for sorting an array of values with a Microsoft Visual Basic for Applications macro or procedure. This article discusses two different algorithms that you can use to sort arrays: the Selection... KB#213818. Keywords: Sorting, Arrays, VBA, Macro, Web

 
29. Using a Visual Basic Macro to Sort Arrays in Microsoft Excel In Microsoft Excel, there is no direct method for sorting an array of values with a Microsoft Visual Basic for Applications macro or procedure. This article discusses two different algorithms that you can use to sort arrays: Selection Sort and... KB#133135. Keywords: Sorting, Arrays, VBA, Macro, Web

 
30. Smart Tag Functionality in Excel This article describes the functionality of the smart tags feature in Microsoft... KB#289148. Keywords: AutoCorrect, Sorting, Format, Symbol, PivotTables, Clipboard, Smart Tag, Internet Explorer, Web

 
31. How to Display Top 10 Records with a Macro In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. For example, if you have a list of salespeople that has a column of names and a column containing each person's total sales for the month, you can... KB#141771. Keywords: AutoFilter, Criteria, Sales, VBA, Macro, Web

 
32. How to Display Top 10 Records with a Macro In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. For example, if you have a list of salespeople that has a column of names and a column containing each person's total sales for the month, you can... KB#213627. Keywords: AutoFilter, Criteria, Sales, VBA, Macro, Web

 
33. How to Consolidate Multiple Worksheets to a Single Sheet You can summarize data from one or more source areas by consolidating it and creating a consolidation table. These source areas can be on the same worksheet as the consolidation table, on different sheets in the same workbook, or in... KB#141577. Keywords: SERIES, Consolidate, Links, PivotTables, Templates

 
34. How to Send Form Mail That Uses Excel Data This article contains a Microsoft Visual Basic for Applications macro for Excel that uses Microsoft Outlook 2000 to generate and send a form e-mail to individuals that are listed in an Excel... KB#241498. Keywords: Sorting, Errors, VBA, Macro, Object, Web

 
35. How to Use VLOOKUP or HLOOKUP to Find an Exact Match The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table. NOTE : It is not necessary to sort the lookup table if you use the... KB#181213. Keywords: Sorting, Colors, Arrays, Errors, Formulas, VLOOKUP, HLOOKUP

 
36. Macro Examples to Delete Duplicate Items in a List In Microsoft Excel, you can create a macro to delete duplicate items in a list. You can also create a macro to compare two lists, and delete items in the second list that are also in the first (master) list. This is helpful if you want to merge... KB#240077. Keywords: Sorting, VBA, Macro, Web

 
37. How To Retrieve a QueryDef from MS Access Using DAO In Microsoft Excel versions 97 and 7.0, you can use data access objects (DAO) in Visual Basic for Applications to retrieve the results of QueryDef from Microsoft Access. This article demonstrates how to do... KB#147739. Keywords: Criteria, Query, DAO, Microsoft Access, Fonts, VBA, Object, Toolbar, Web

 
38. How to Retrieve Records into Specific Columns Using DAO In earlier versions of Microsoft Excel, you can use SQLBIND to specify where the results of a query are placed. However, if you use Data Access Objects (DAO), and you use the CopyFromRecordset method, data is always returned to a contiguous section... KB#147779. Keywords: Query, DAO, Errors, VBA, Iteration, Object, Toolbar, Web, DB

 
39. How to Check Number of Records Returned in an AutoFilter When you apply an AutoFilter, Microsoft Excel displays the number of records that are filtered in the lower-left corner of the status bar. This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that... KB#152215. Keywords: AutoFilter, Criteria, VBA, Macro, Web, SUBTOTAL

 
40. Excel: Converting XML and Excel files The following methods are only intended to be examples - very little explanation is offered and so it should be viewed in conjunction with an XML and XSL tutorial such as that offered by W3C schools. I am only illustrating the display of tables of data, not individual records. If you wish to copy... Keywords: SERIES, Criteria, Sorting, XML, Format, Styles, Class, VBA, Files, Text Files, HTML, Links, Web

 
41. Using Server Page Fields in PivotTables This article describes how to use server page fields to reduce the amount of data returned from an external data source to a PivotTable. This is useful when creating PivotTables from very large databases. NOTE : This article does not apply to... KB#211515. Keywords: Query, Third-Party, PivotChart, PivotTables

 
42. How to Display Custom Function in Function Wizard Step 2 In Microsoft Excel 97 for Windows, you can create a custom Microsoft Visual Basic for Applications function to perform calculations. By default, this custom function will appear in the Function Wizard under the function category called User... KB#189165. Keywords: Formulas, VBA, Macro, Toolbar, Web

 
43. Sample Macro to Sort List Based on Custom Sort Order In Microsoft Excel, you can create your own custom sort lists and you can use these lists to specify sort orders when you sort a list of information. This article describes the procedures for creating a custom sort list and includes a sample... KB#213625. Keywords: Sorting, VBA, Macro, Web

 
44. Using VBA Code to Make a Spinner Display Noninteger Values A spinner control only uses integer values. This article shows how to use Microsoft Visual Basic for Applications code to make a spinner control display noninteger values in an edit... KB#151498. Keywords: Format, VBA, Macro, Object, Toolbar, Web

 
45. How to Remove Individual AutoFilter DropDown Lists In Microsoft Excel 97, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the AutoFilter method in Microsoft Visual Basic for Applications. This article includes an example... KB#162049. Keywords: AutoFilter, Criteria, VBA, Macro, Object, Toolbar, Web

 
46. How to Obtain the SQL Statement for a PivotTable When you are working with a Microsoft Excel PivotTable, you may want to determine its data source. To do this, use the SourceData property in Microsoft Visual Basic for Applications... KB#131331. Keywords: Criteria, Query, SQL, Arrays, PivotTables, VBA, Macro, Object, Web

 
47. How to Place a Check Mark Next to a Custom Menu Item When you create custom menus, you may want to add a check mark next to a particular menu item to show that the item is selected. For example, when you point to Filter on the Data menu and then click AutoFilter , a check mark is placed next... KB#213735. Keywords: AutoFilter, VBA, Macro, Object, Toolbar, Web

 
48. How to Remove Individual AutoFilter DropDown Lists In Microsoft Excel 2000, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the Visual Basic for Applications AutoFilter method. This article includes a sample Visual Basic macro... KB#213733. Keywords: AutoFilter, Criteria, VBA, Macro, Object, Web

 
49. How to Obtain the SQL Statement for a PivotTable When you are working with a Microsoft Excel PivotTable, you may want to determine its data source. To do this, use the SourceData property in Microsoft Visual Basic for... KB#213418. Keywords: Criteria, Query, SQL, Arrays, PivotTables, VBA, Macro, Object, Web

 
50. How to Create an Auto_Open Macro to Show Data Form Dialog Box The following example uses an Auto_Open macro to select a specific sheet in a workbook and automatically display the data form dialog box. NOTE: A macro named auto_open will be run each time you manually open the workbook that contains that... KB#142113. Keywords: Criteria, VBA, Macro, Files, Web

 

<< (Page 4)  Previous              Next  (Page 2) >>