In This Topic
This section comprises the features available in DsExcel.
- Worksheet
- Work with cells, range and basic worksheet operations.
- Workbook
- Work with basic workbook operations.
- Comments
- Add or delete comments, show or hide comments, set rich text, comment layout or author of a comment.
- Hyperlinks
- Add, configure or delete hyperlinks.
- Sort
- Apply sorting and its various types.
- Filter
- Apply filtering and its several types.
- Group
- Apply grouping over data in rows or columns.
- Conditional Formatting
- Apply conditional formatting in a cell or range of cells.
- Data Validations
- Add, modify and delete data validations.
- Data Binding
- Bind data to sheet, cell or table columns.
- Formulas
- Use formulas to carry complex calculations.
- Custom Functions
- Create custom functions to implement custom arithmetic logic.
- Shapes and Pictures
- Work with shapes and pictures in a worksheet.
- Styles
- Set styles to format cell appearance.
- Theme
- Apply built-in or custom themes to change the workbook appearance.
- Chart
- Work with charts to display data graphically.
- Table
- Use tables to organize large amount of data efficiently.
- Pivot Table
- Use pivot table to perform analysis of complex information and summarize data.
- Sparkline
- Use sparklines to insert graphical illustration of trends in data.
- Slicer
- Use slicers to perform quick filtration of data in tables and pivot tables.
- Print Settings
- Configure print settings to manage printing options.
- Defined Names
- Name the tables or ranges within workbook or worksheet scope.