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.

Share this:

Leave a Reply