Ms Excel Intermediate

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.

Register Now

Course Details

  • 🕒 Schedule: Twice a week, evenings only

  • ⏱️ Duration: This course is 45 hours,18 sessions,each session is 2.5 hours

  • 💶 Price: €300

  • 👨‍🏫 Format: Instructor-led, hands-on training

  • 📦 Includes: This course includes a project coded by the students and the instructor.

Course Requirements

  • 📈 Level: Intermediate

  • 🧠 Prerequisites: Basic knowledge of Microsoft Excel is required

  • 👨‍🎓 Recommended for: Recommended for students, graduated students, business analytics and anyone aiming to become an expert in using MS Excel.

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

 

 

Back to Course List

Outcomes

Graduates of this course will be able to:

  • Build complete data models using Power BI

  • Analyze and visualize data for business decision-making

  • Automate data transformation tasks

Prepare for a career as a Data Scientist

Start by understanding the core topics:

  • Statistics: to analyze data properly

  • Data analysis: how to clean and explore data

  • Machine learning: to make predictions from data

Jeni gati të filloni?

Get in touch, or create an account

Kontakt