Home > Excel Help Portal > Excel Databases

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

Excel Databases

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

101. Excel Filters -- Advanced Filter -- Complex Criteria
102. How to Find and Replace Tildes and Wildcard Characters
103. How to Use Advanced Filter to Exclude Records
104. How to use Wildcard Characters in Microsoft Excel 2000 Parameter Queries
105. Excel -- Sorting Data
106. Processor Spikes at 100 Percent When You Click AutoFilter Arrow
107. Help using Excel database functions
108. How to Count Rows Displayed After Data Has Been Filtered
109. How to Remove Smart Tags from a Workbook
110. How to sort Cells Without Sorting Linked Cells in Excel 2000
111. Error Message: This Operation Is Attempting to Change a Filtered Range on Your Worksheet and Cannot Be Completed
112. Excel Uses Microsoft OLE DB Provider for OLAP Services 8.0 for All OLAP Queries
113. How to Configure Excel 2003 to Use Microsoft OLE DB Provider for OLAP Services 7.0
114. How to Use Wildcards in Parameter Queries
115. How to use RAND() to Generate Randomly Distributed Integers in Excel 2000
116. Paste Rows
117. How to Set the Descriptive Name of an Addin File
118. How to Extract an Exact Match of Text from a Database
119. How to Sort Cells Without Sorting Linked Cells
120. Displaying AutoFilter criteria
121. How to Remove Duplicate Records or Create List of Unique Records
122. Errors Quitting Office Apps with IntranetWare Network
123. Locking cells to protect critical data
124. Shortcut keys
125. Elapsed Time Counting Techniques
126. "Syntax Error (Missing Operator)..." Error Performing Query with a Date
127. How to Use Excel to Generate Reports for Mailbox Resources
128. Excel -- Data Validation -- Custom Validation Criteria Examples
129. Multiply Hours by Rate
130. Rational Databases in Excel
131. Spreadsheet Programs
132. Worksheet Protection after Sorting
133. Excel select Random numbers from a column
134. Formulas Calculate Incorrectly After Changing Worksheet Name
135. Ranking without repetitive ranks
136. Duplicate repeated entries in a list
137. Pivot Table Multiple Consolidation Example
138. Dialog Box to Filter Data
139. Count AutoFiltered rows
140. Importing a text file into a worksheet
141. Advanced VBA Tutorial
142. PivotTables With Accounting Data
143. Comparison of Three Sort Methods
144. How to filter out duplicate data
145. Color Cells based on Criteria
146. Four Methods of Adding Totals to a List
147. Increase the number of rows or columns?
148. Compare 3 Lists Conditionally
149. Delete Duplicates
150. Inserting Automatic Page Breaks

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