Discover how Excel can boost your analytical skills, help you get more done within a limited time and improve the outcome of your data analysis.
This training conducted by 2 IT Engineers and Excel specialists, will revolutionize the way you collect, analyze and display data!
3 evaluative modules of 9 hours each to provide the future engineers, managers and entrepreneurs you will become with a set of skills which are a must have In today's business world.
This course opens the right to a certificate in each level
The program:
Basic Level: 14-15-16 Feb 2021
- Excel environment
- Add, Fill, Split, Transpose
- Sort, Filter, Tables, Drop-Downs
- Analyze, Charts, Date & Time
- Min-Max, Average, Sum
-
Advanced Level: 21-22-23 Feb 2021
- Pivot Tables
- If statements
- Vlookup, Hlookup
- Conditional Functions
- Formula Erros
- SumIF, Dcount, SumIf, CountIf
-
Expert Level: 28 Feb -01-02 March 2021
- Dynamic LOV, Power-Pivot
- Advanced Pivot Tables, Pivot Chart
- Macro and Routine Programming
- Running Macro using Form
- VBA
- AutoSum in a single sheet
-
- * Bundle Subscription price applies when you purchase 2 or 3 Levels
- LIVE VIRTUAL
TRAINING
Certified trainers
3 modules of 3 days each
7:30 PM to 10:30 PM
IROLYS certificate
IROLYS GROUP
Infinite Range of Opportunities
for Business & Operations Excellence
for more information: cen-ptu@pnu.edu.sa