Top 10 Excel Functionality/ Features
| # | Functionality / Feature | Benefits |
| 1 | Table | Formula management
Audit efficiency, training / onboarding Efficiently analyze with Slicers, Pivot Tables / Charts |
| 2 | Defined Names | Formula management
Audit efficiency, training / onboarding |
| 3 | Analysis (Slicer, Pivot Table / Chart, Quick Analysis) | Reports / analyses |
| 4 | Dynamic Array | Reports / analyses |
| 5 | Formula Auditing | Troubleshooting
Audit efficiency, training / onboarding |
| 6 | Conditional Formatting | Status / Duplicate identification
Priority / Risk Classification Duplicate identification |
| 7 | Data Validation | Input control
Reports / analyses |
| 8 | Navigation (Go To, Hyperlinks) | Efficiency, especially in files with several tabs (worksheets) |
| 9 | Data Sourcing / Transformation (Go To Special, Power Query) | Data cleaning / wrangling
No macros
|
| 10 | Conditional Functions | Reports / analyses |
Author:
Srikanth (Sri) Amudhan is a seasoned and designated finance leader and project management professional with over 20 years of progressive and diverse experience, primarily in financial services. His experience includes finance transformation, project management, process design/improvement, and data/business analysis. Sri collaborates across organization functions and leverages his strong business/technology acumen and growth mindset. During his consulting engagement with Intact Insurance, he successfully led the design & development of an Excel-based tactical solution to handle certain complex IFRS17-related accounting and analysis requirements. The solution was user-friendly and did not require incremental technology cost.