Microsoft Excel and Advanced Excel Training in Ahmedabad-AFT

Greetings from Academy of Financial Training!

Academy of Financial Training is pleased to announce a One Day workshop on Advanced MS-Excel. The workshop aims to provide practical understanding of advanced features & utilities of MS Excel that reduce your effort and increase efficiency in day to day operations.
Academy of Financial Training (AFT), is planning to launch a new batch of program on 'Excel & Advanced Excel' in Ahmedabad for Students looking forward to Join KPO’s. This is after successfully conducting multiple batches for professionals in Mumbai, Pune, Ahmedabad and Delhi.

Key Learning Areas
• How to 'think' in EXCEL
• How to use Advanced functions like V&H-LOOKUP, OFFSET, CHOOSE, INDEX/MATCH in day-to-day problems
• How to use BOOLEAN logic to shorten your formulas and calculations
• How to do advanced conditional formatting and create triggers in your worksheet
• Learning advanced charting techniques (double axis, bubble charts, dynamic and formula based charts)
• Creating automatic/dynamic dashboards in EXCEL
• Smart features and tools in EXCEL
For Whom : CA, MBA, CFA, FRM, CPA, CFP, MMS, B.E., B.Com, B.Sc., B.B.A., M.Com and Other Students
Excel Introduction
 Introduction to Excel 2007
 Formatting Rows, Columns, Tables and Sheets
 Applying Number Formats
 Using Find and Replace
 Using the Paste Special Box
 Basic Functions: Sum, Count, Average, Max, Min, Large, Small,
 Round, Roundup, Round down, Abs, Upper, Lower and Proper
 Basic Filtering & Sorting
 Formatting Tips & Tricks
 Case Study (Formatting)
Advanced Excel
 Working with Named Ranges
 Creating multi-dimensional formulas with Referencing
 Conditional Operations: Using Sumif, Countif and Averageif
 Conditional Lookup: Using Vlookup & Hlookup
 Multiple Filtering, Multiple Sorting, Generating Subtotals & Formatting
 Pivot Tables: Enabling the 2003 interface, Visualizing the best solution
 Grouping Numbers and Dates, Formatting outputs
 Scenario Analysis: Creating, Showing and Summarizing Scenarios
 Sensitivity Analysis: Using Data Tables to sensitize outputs
 Using Goal Seek to solve Circular Problems
 Charting: 3 Axis, 3D Charts & other popular charts

Trainer Profile: Mr. Ashutosh Prajapati has over 8 years of work experience in financial modeling and advanced MS Excel. He has worked with companies like Morgan Stanley and Edelweiss before co-founding Academy of Financial Training. He has trained more than 1000 students and professionals in financial modeling using excel, advanced excel, VBA macros, advanced presentation skills, financial analysis and risk management. Ashutosh is a rank-holder CA (All India 11th Rank in CA Final exams).

Expertise Academy of Financial Training: Academy of Financial Training is India’s largest training provider for Banking Exams in India. Our guidance is well acknowledged by numerous students and professionals from industry.
Contact Details

Ankur Saxena
| Academy of Financial Training |
| 316,Akshar Complex Near Shiv Ranjani char Rasta.
| Web: www.ftacademy.in | Email: [email protected]
| Phone: 8511002211/40067638