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.