Home > Excel Help Portal > Using Excel Formulas

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

Using Excel Formulas

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to use Microsoft
Excel formulas.

101. Populate Dialog
102. Help using Excel spreadsheet functions - If, Rank and Errors
103. How to create Functions to Calculate Light Years in Excel 2000
104. Excel functions for calculating loan repayments
105. How to Add Data to a DropDown or List Box
106. How to Implement Application.AutomationSecurity
107. Produce Color Chart
108. Protection, Worksheet
109. SumIf with 2 conditions
110. Use the Operation choices in Paste Special
111. Multi-Line Ascii Report
112. Visual Basic Code to Use Instead of DIRECTORIES()
113. Method to Determine Whether a Year Is a Leap Year
114. How to use the INDEX and LINEST Functions to Solve for New XValues in Excel 2000
115. How to Use INDEX and MATCH Worksheet Functions with Multiple Criteria
116. How to Calculate Interest Paid for Multiple Periods
117. Registry Keys That Control the File Repair Feature
118. Excel Hall of Fame
119. Build A Formula
120. How to use NETWORKDAYS with Multiple Holidays in Excel 2000
121. Testing your spreadsheets - tips on good design
122. Linked Files with Lookup Functions Updated Much More Slowly Than in Earlier Versions of Excel
123. Sample UserDefined Function to Hide Formula Errors
124. Excel dynamic graphs using Names, Series and Offset
125. Excel -- Data Validation
126. How to turn Off the Message for pdating Links in a Workbook in Excel
127. Protecting cells, sheets, workbooks, and files
128. Unsigned Macros May Be Trusted When Macro Security Setting Is High
129. Share your spreadsheets on the Web
130. How to Create Functions to Calculate Light Years
131. How to change the Assembly Name or the Assembly Namespace for Your Office Managed Code Extension
132. How to Manually Recalculate a Single Cell or Range
133. Cell Related Coding
134. How to Create a Conditional Format to Hide Errors
135. RTD Servers Used with Embedded Excel Workbooks May Be Problematic
136. Word Stops Responding When You Use "Open Clip In" to Open a WMF File
137. How to count Unique Elements in a Cell Range in Excel
138. How to Programmatically Suppress an Error Value Returned by a Formula
139. How to Count Cells That Contain Formulas, Text, or Numbers
140. How to Use a Logical AND or OR in a SUM+IF Statement in Excel
141. How to Determine the Number of Unique Items in a List
142. How to Use the INDIRECT Function to Create References
143. Excel -- Conditional Formatting -- Examples
144. How to Use Data Validation to Prevent Duplicate Entries
145. How to Count the Occurrences of a Number or Text in a Range
146. Alternatives to Nested IF Functions
147. Count Occurences of a Digit
148. Help using Excel spreadsheet functions - Using Array formulae
149. Naming a Worksheet as the value of a target cell
150. Excel -- Data Validation -- Hide Previous Selections

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