About this course
This course will teach you from basic formulas to the most advanced ones, functions, validations and charts. This way you can be a powerful MS Excel user. This course is designed for specialists aiming at becoming MS Excel advanced users.
Processing and Data Analysis in Excel
- Basic formulas, formating & reference
- Cleaning – Text formula, filters, validation
- Advance – Vlookup, xlookup, index, match
- Report– conditional formating, pivot, graphs
Audience
This course is recommended for students, graduated students, business analytics and anyone aiming to become an expert in using MS Excel.
Price
300 Euro / 30.000 Lek Now only 250 Euro/25.000 Lek
1. Foundational Review
- Basic formulas
- Relative and Absolute cell references in formulas
- Format cells
2. Data Cleaning & Manipulation
- Text Formulas
- Filter and advanced ordering
- Validation
- Paste special + formula editing tips and tricks
3. Advanced Logic & Analysis
- Small and big formulas (referring to functions like LARGE, SMALL)
- VLookup & XLookup formulas
- Index formulas
- Match formulas
4. Data Management & Reporting
- Using Excel tables
- Conditional formatting
- Pivot tables
- Basics of graphics
Basic or very basic MS Excel knowledge.
Course is 40 hours, 16 sessions, each session 2.5 hour. Course is available in English and Albanian. Materials are all included online.
