Book Online Tickets for Advanced Excel and VBA Programming Train, Hyderabad. Replay Sports Cafe (www.replaysportscafe.com) is organizing 30-hour Advanced Excel hands-on training for those who wants to use excel for advanced analytics.
Syllabus:
Intermediate Excel: Focus in real scenarios of Reporting/Data management/Automatio

Advanced Excel and VBA Programming Training

 

Invite friends

Contact Us

Page Views : 22

About The Event

Replay Sports Cafe (www.replaysportscafe.com) is organizing 30-hour Advanced Excel hands-on training for those who wants to use excel for advanced analytics.

Syllabus:

Intermediate Excel: Focus in real scenarios of Reporting/Data management/Automation, Excel settings, Advanced Formulas, Name Manager, Absolute and Relative fields, Goal seek/Scenario, Managing lists, Cross reference

Advance Excel: Conditional formatting, user settings for excel application Level, Data Management and Analysis, Reporting Techniques, Pivot table, Macros, VBA concepts, Excel data handling with VBA, use of SQL Queries, Userform, Listbox, Combobox, Buttons, etc, Application design

Data Formatting: Understanding different data types, data type formatting, importing and accessing different file types in excel

Advance Excel Security

MIS Technique with the help of excel VBA Programming

Using charts, graphs, Pivots

Setting data source

 

Fees: Rs 6,500 (group discount available)

About the faculty: 15+ yr experience in data handling and analytics using Excel.

Venue Map