PragmatiQ Pro

Microsoft Excel Training : Data Analysis & Reporting June 2015

Weekend Class- 20th & 21st June (Saturday ­& Sunday)
Weekday Class- 24th & 25th June (Wednesday­ & Thursday)
Fee - N20,000­
Time: 9am - 4pm daily­ (10.30am on Sunday)

Registration: GTBank 0158823042 (PragmatiQ Pro Systems)

Venue: Community Development Foundation ­
Beside Caleb Intl School ­
CMD Road, Shangisha-Magodo­ Area
Lagos State­

Training Outline (snippets):­
1. Course Introduction­
· Power Shortcuts and Tricks­
2. Range Names­
3. Data & worksheet linking­
· Hyperlink and camera tool­
4. Summarising and subtotalling­
5. Data consolidation­
6. Text-2-Columns­
7. Formula­
· Text formulas, LookUp Formulas, Logi­cal Formulas, Date Formula
8. Formula Auditing Tools­
· Tracing precedents and dependents, er­rors, validation
9. Pivot Tables & Charts ­
10. What-if Analysis ­
11. Grouping and outlining ­
12. Introduction to VBA Macros­
13. Comprehensive Practical Examples­

Powered by­:
PragmatiQ Pros Systems­
08091192785, 07010157070­
BB PIN 7B750CD7­

kindly share with friends and colleagues­