|
| Course Goals |
The goal of the Advanced Excel Training is to equip participants with the skills to efficiently analyse data, build complex formulas, automate tasks, and create clear visualisations. By the end of the course, learners will be able to apply advanced Excel tools such as PivotTables, macros, and scenario analysis to solve real-world problems, improve productivity, and support effective decision-making. |
| Prerequisite(s) |
None |
| Corequisite(s) |
None |
| Special Requisite(s) |
None |
| Instructor(s) |
Professor Mehmet Özer |
| Course Assistant(s) |
None |
| Schedule |
Thursday, 13:00, CATS Virtual Classroom |
| Office Hour(s) |
Friday, 11:00 – 12:00, İncirli 1A03 |
| Teaching Methods and Techniques |
- Lecture and practice. |
| Principle Sources |
- Lecture notes. |
| Other Sources |
- Relevant web pages will be shared. |
|
| Course Schedules |
| Week |
Contents |
Learning Methods |
| 1. Week |
Introduction (Essential Information) |
Presentation and practice |
| 2. Week |
Logical Functions (IF – AND – OR) |
Presentation and practice |
| 3. Week |
SUMIF – COUNTIF – AVERAGEIF Functions |
Presentation and practice |
| 4. Week |
Mathematical Functions |
Presentation and practice |
| 5. Week |
VLOOKUP and Other Lookup Functions |
Presentation and practice |
| 6. Week |
Sorting and Filtering |
Presentation and practice |
| 7. Week |
Conditional Formatting |
Presentation and practice |
| 8. Week |
Midterm exam, in person. |
Midterm exam, in person. |
| 9. Week |
Data Visualisation and Charts |
Presentation and practice |
| 10. Week |
PivotTables and PivotCharts |
Presentation and practice |
| 11. Week |
Data Cleaning 1 |
Presentation and practice |
| 12. Week |
Data Cleaning 2 |
Presentation and practice |
| 13. Week |
Data Analysis 1 |
Presentation and practice |
| 14. Week |
Data Analysis 2 |
Presentation and practice |
| 15. Week |
Final exam, in person. |
Final exam, in person. |
| 16. Week |
|
|
| 17. Week |
|
|
