Excel
This section brings together Excel formulas, VBA macros, workbook procedures and practical notes. Articles explain what each solution does, how to use it and any requirements or limitations.
Browse Excel articles
| Article type | Contents | Pages |
|---|---|---|
| Excel VBA macros | Macros and procedures for automating tasks, processing data and working with workbooks and worksheets. | 0 |
| Excel formulas | Worksheet formulas for calculations, lookups, text handling and data analysis. | 0 |
Browse all Excel articles.
Create a new article
Use the appropriate form to create an article with the standard layout and fields.
See the Excel style guide for guidance on naming, formatting, examples and documentation.
Using the examples
Before using a formula or macro:
- Check which Excel version it requires.
- Review any workbook names, worksheet names, cell references or file paths that need changing.
- Test it on a copy of your workbook, especially if a macro changes or deletes data.
- Read the article’s notes for any limitations or additional setup.
Writing and maintaining articles
Each article should explain its purpose, provide the complete formula or code, and include clear instructions and an example where useful.
Record any version requirements or dependencies, and update the article’s status and last-reviewed date when checking or changing the solution.