Anadolu Info Package Anadolu Info Package
  • Info on the Institution
  • Info on Degree Programmes
  • Info for Students
  • TR
About the Programme Academic Staff Program Qualifications Lessons Matrix of Course & Program Qualifications Turkish Qualifications Framework (TQF) TQF & Program Qualifications
  1. Faculty of Computer and Information Sciences
  2. Department of Data Science and Analytics (English)
  3. Course Structure Diagram with Credits
  4. Introduction to Business Spreadsheets
  5. Description
  • Description
  • Learning Outcomes
  • ECTS Credit Load
  • Course's Contribution to Program
  • Learning Outcomes & Program Qualifications
Last Updated: 21/07/2026

Code - Course Title Course Type Laboratory + Practice ECTS
VBA204 - Introduction to Business Spreadsheets IV. SEMESTER 2 +1 6.0
Language of Instruction İngilizce
Course Type Required Courses
Course Instructor(s) ARAŞ. GÖR. DR. ÖNDER DORAK
Mode of Delivery Face to face
Place of Delivery
Used Educational Platforms
Prerequisites
Courses Recomended
Recommended Resources
Work Placement
Aims of the Course

Weeks Learning Outcomes Topics Teaching Methods
Week - 1 Spreadsheet Basics: Navigating the interface
Week - 2 Absolute and relative cell referencing
Week - 3 Basic mathematical and statistical formulas
Week - 4 Advanced Functions: Mastering VLOOKUP and XLOOKUP
Week - 5 Using INDEX/MATCH logic
Week - 6 Implementing logical functions (IF, AND, OR)
Week - 7 Utilizing array formulas
Week - 8 Data Analysis: Constructing dynamic PivotTables
Week - 9 Conducting What-If analysis and Goal seek
Week - 10 Creating interactive data dashboards
Week - 11 Advanced dashboard visualization techniques
Week - 12 Automation and Macros: Recording basic macros
Week - 13 Introduction to VBA scripting
Week - 14 Automating repetitive data cleaning tasks

No content has been provided.

No content has been provided.

No content has been provided.


Assessment Method and Passing Requirements
Quamtity Percentage (%)
Toplam (%)

Info on the Institution

  • Name and Adress
  • Academic Calendar
  • Academic Authorities
  • General Description
  • List of Programmes Offered
  • General Admission Requirements
  • Recognition of Prior Learning
  • Registration Procedures
  • ECTS Credit Allocation
  • Academic Guidance

Info on Degree Programmes

  • Doctorate Degree / Proficieny in Arts
  • Master's Degree
  • Bachelor's Degree
  • Associate Degree
  • Open&Distance Education

Info for Students

  • Cost of living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Special Needs Students
  • Insurance
  • Financial Support for Students
  • Student Affairs Office

Info for Students

  • Learning Facilities
  • International Programmes
  • Practical Information for Mobile Students
  • Language courses
  • Internships
  • Sports and Leisure Facilities
  • Student Clubs