Excel

PhantomWiki 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.

• Create an Excel VBA article
• Create an Excel formula article

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.