Description
JULY 25, 2023 | 9 AM – 5 PM | SEEDS
FINSYNERGY
TRAINING OUTLINE
Data Analytical Tools
a. Mixed References
b. Conditional Formatting (Customized)
c. Data Validation (including Dependent List)
d. Solver, Data Table (One & Two Variables)
e. Advance Filtering (Customized)
f. Multi-conditional Sum/ Average/ Count/ Max/ Min
g. Dynamic Array Functions
Pivot Tables
a. Applying Functions (Calculated Fields, Calculated Items)
b. Slicer Connections
c. Pivot Charts
d. Get Pivot Data; Charts: Formatting
e. Change Chart Type
f. Adding/ Deleting Series
g. Secondary Axis
h. Sub-chart
i. Dynamic Title
Contact Details
M. Faisal Shafi
Associate Member of
ICMAP, ICSP, PIPFA
Chief Internal Auditor
Thardeep Microfinance Foundation
TAKE AWAYS
Certificate
Study Material
Lunch
Tea
Networking
For Futher Information or Registration
www.finsynergy.com.pk | info@finsynergy.com.pk
0341-2315048/0332-2459242