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.
1. Basic formulas & references
2. Data Cleaning & Manipulation
3. Advanced Logic & Analysis
4. Data Management & Reporting
Audience
This course is recommended for anyone working in offices, accounting & finance personel, 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 32-36 hours, 16 sessions, each session lasts 2 – 2.5 hour each. Course is available in English and Albanian. Materials are all included online.
