A clear start with VBA and Python - You will see how VBA and Python differ and when to use each one, so you can choose the right tool for office tasks, spreadsheet work, and basic data analysis.
Create your own macros - You will learn how to record, edit, and run Excel macros, which will help you automate repetitive tasks much faster instead of performing the same manual steps every day.
Write simple scripts - You will master core VBA and Python syntax, including variables, conditions, loops, and functions, so you can build simple automations on your own without ready-made templates.
Work with Excel data better - You will learn how to read, enter, copy, filter, and sort data in worksheets and create simple reports, making your everyday work with Excel files more structured and efficient.
Confident first steps in Python - You will go through environment setup and Python basics, so you can start working without confusion and understand how to write clear scripts for practical office tasks.
Clean data with pandas - You will learn how to load CSV and Excel files into pandas, select rows and columns, filter records, and group data, so you can prepare summaries and analyses much faster.
Clear charts and outputs - You will learn the basics of creating line, bar, and scatter charts and saving them to files, so you can present analysis results to colleagues in a clearer and more useful way.
Connect Excel and Python - You will understand how to combine data preparation in Excel with analysis in Python and when to choose VBA or Python, so you can build simpler and more effective reporting flows.
Basic Excel skills - You should be comfortable moving around a worksheet, entering data, saving files, and using simple Excel functions, so you can focus on automation rather than basic navigation.
Basic file handling - You should know how to open, save, and find files and folders on your computer, because during the course you will work with Excel files, CSV files, and simple scripts.
Logical thinking - You should understand simple if-this-then-that relationships, because this way of thinking will help you when working with conditions, loops, and automated process steps.
Readiness to use tools - You should be ready to install and configure simple tools and work in the VBA editor and a Python environment, so you can complete the hands-on exercises without trouble.
