# Formulas and filters

EPPlus has a built-in formula calculation engine that evaluates formulas entirely in .NET, without Excel. This section covers formula calculation, references to other workbooks, and the filters and slicers you can add to ranges, tables and pivot tables.

- [Formula Calculation](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/index.md>) - Calculate formulas on the workbook, worksheet or range level. The engine supports more than 470 functions, dynamic and legacy array formulas, LAMBDA and LET, and custom functions.
- [Working with filters](<https://epplussoftware.com/docs/formulas-and-filters/working-with-filters/index.md>) - Add and apply value, date group, custom, top 10 and dynamic filters, as an autofilter on the worksheet or in a table.
- [Working with slicers](<https://epplussoftware.com/docs/formulas-and-filters/working-with-slicers/index.md>) - Add, change and remove slicers that filter tables and pivot tables.
- [Working with External Workbooks](<https://epplussoftware.com/docs/formulas-and-filters/external-links/index.md>) - Use references to other workbooks, in formulas and in calculation, and add, update or break such links.

### See also

- [Referencing tables in formulas](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/referencing-tables-in-formulas/index.md>)
- [Supported Functions](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/supported-functions/index.md>)
- [Table filters and slicers](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/table-filters-and-slicers/index.md>)
- [Pivot table filters and slicers](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-filters-and-slicers/index.md>)