Anadolu Info Package Anadolu Info Package
  • Info on the Institution
  • Info on Degree Programmes
  • Info for Students
  • Turkish
    • Turkish Turkish
    • English English
Profile of the Programme Specific Admission Requirements Qualification Requirements and Regulations Recognition of Prior Learning Educational Staff Programme Director & ECTS Coord. Field Qualifications Key Learning Outcomes Course Structure Diagram with Credits Matrix of Program Outcomes&Field Qualifications Matrix of Course& Program Qualifications Examination Regulations, Assessment and Grading Graduation Requirements Access to Further Studies Occupational Profiles of Graduates
  • Eskişehir Vocational School
  • Dep. Of Office Management and Secretarial Training
  • Program in Bureau Administration and Admin.Ass.
  • Course Structure Diagram with Credits
  • Spreadsheets
  • Content
  • Description
  • Content
  • Learning Outcomes
  • Learning Activities and Teaching Methods
  • Course's Contribution to Prog.
  • Assessment Methods

Weeks Topics
Week - 1 Excel workspace, interface introduction; Title bar - Tabs - Address bar - Formula Bar - Scroll bars - Gridlines - Status Bar
Week - 2 Workbook operations; Create New Workbook, save, close, open saved workbook, add sheet, name sheet, delete sheet
Week - 3 Data operations in Excel; Changing data, different selection techniques, Data and Cell Deletion, Row and Column Operations; Add Row and Column, Delete Row and Column, Hide Row and Column, Move and Copy, Paste Special, AutoFill, AutoFill, Month, Day and Date Fill, Custom Lists, Annotate, Find/Replace/Go to
Week - 4 Formatting operations in Excel; Format Cells, Quick Format, Format Painter, Font Format, Align, Format Numbers, Border Format, Cell Styles, Table AutoFormat, Conditional Formatting, Conditional Format Using First/Last Rules, Conditional Formatting Using Data Bars, Conditional Formatting Using Color Scales , Conditional Formatting Using Symbol Sets, Clearing Conditional Format, Defining New Rule, Managing Rules
Week - 5 Page settings and printing; Print Preview. themes, Header and Footer, Page Orientation, Adjusting Margins, Specifying Print Area, Printing Headers, Fitting Data to Page, Window Settings, Splitting and Freezing Windows, Docking and Hiding Windows, Print Settings
Week - 6 Formulas in Excel; Formula Input, Calculation Operators, Copying Formulas, Cell and Range Naming, Absolute Reference, Error Checking in Formulas.
Week - 7 Midterm
Week - 8 Functions in Excel; Mathematical Functions: Add, Product, Sum, Max, Min. Statistical functions, Text functions, Date functions, If, Search and Reference functions, Information functions.
Week - 9 Graphic operations; Creating charts, Chart types, Chart options, Chart formatting
Week - 10 Data analysis in Excel; Sort, Sort by Multiple Fields, Filter, Subtotal, Validate data, Pivot table, Group the Pivot table, Create a pivot table by more than 3 fields, create a pivot chart, Group data, Convert text to columns, Import external data, Scenarios, Target search.
Week - 11 Data/Situation Analysis and Data/Target Search studies
Week - 12 Pivot analysis explanation and sample applications in Excel.
Week - 13 Customize window and menu layout in Excel; Customizing Quick Access Toolbar, Sending Files by E-Mail, Receiving addresses created in Excel for mail merge in Word.
Week - 14 Final exams

  • 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 Associations