Home > Excel Help Portal > Excel Databases

<<  (Page 1)  Previous              Next  (Page 3)  >>

Excel Databases

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

51. How to install or Repair Microsoft Excel Features in Excel 2000
52. How to use the AutoCorrect Options buttons in Excel
53. DigDB Addin for Excel allows Power Excel with Ease
54. How to Move Between Custom UserForms with CommandButtons
55. How to Place a Checkmark Next to a Menu Item
56. Macro to Count the Number of Records Returned in an AutoFiltered List
57. How to Control the AutoFilter with a Macro
58. How to Use the "Insert Options" Button in Excel 2002
59. Error Message: ORA00923:FROM Keyword Not Found Where Expected
60. Filter Test, AutoFilter and Hidden Rows/Columns
61. How to create an Auto_Open Macro to Show the Data Form Dialog Box in Excel 2000
62. How to Use the VLOOKUP Function
63. Advanced Pivot Table Operations
64. How to Control the AutoFilter with a Macro
65. How to Programmatically Sum Only the Visible Cells in a Range
66. How to Use a VBA Macro to Sum Only Visible Cells
67. Page Breaks, and Inserting Blank Rows
68. Excel: an advanced filter to extract records
69. How to sort More Than Three Columns in Excel 2000
70. How to Create Yes and No Buttons for a Custom Message Box
71. Programatically find a blank row
72. Types of Formatting and Features Preserved in Workbook Sent as Body of HTML Email Message
73. Excel -- Data Validation
74. How to Use the PivotTable AutoSort Feature
75. Excel Filters -- AutoFilter Programming
76. Using Formulas Tutorial
77. How to hide Records with Duplicate Cell Entries in Excel 2000
78. How to Create an Index with Microsoft Query
79. Scroll Bars in Excel
80. How to use the SUBTOTAL Function with AutoFiltered Lists in Excel 2000
81. How to Hide Records with Duplicate Cell Entries
82. Opening XML Files in Excel
83. Random Numbers
84. How to Use a Logical AND or OR in a SUM+IF Statement in Excel
85. How to Programmatically Select the Current Data Area Without Selecting the First Row
86. Excel Filters -- AutoFilter Basics
87. How to Count the Occurrences of a Number or Text in a Range
88. Index Service Stops Responding When Filtering Japanese Excel File
89. How to Count Rows Displayed After Data Has Been Filtered
90. MSQuery Uses 1900 Date When Two Digits Are Used for Year
91. Cannot Derive Parameter Information When the Parameter Marker Is a Function Argument
92. Cannot Disable ToolTips Directly from Microsoft Query
93. Help using Excel spreadsheet functions - Using Array formulae
94. Office 2000 ODBC Driver Vulnerability Security Update
95. Text to Columns using VBA
96. How to Select the Current Region Minus the First Row
97. Excel: Converting Excel tables into XML files
98. How to use Advanced Filter to Exclude Records in Excel 2000
99. How to use an Excel Worksheet as a Data Source in FrontPage 2000
100. How to Avoid Saving Password in Text File When You Get External Data

<< (Page 1)  Previous              Next  (Page 3) >>