Microsoft Excel - Basic Course (Internet Course)
2600-ME-OG
Detailed course topics:
- Excel interface,
- events in workbooks,
- sheet events,
- entering and editing data,
- selecting, copying, data cutting,
- cell formatting,
- row and column formatting,
- formulas in Excel,
- references in Excel,
- functions in Excel,
- data analysis,
- pivot tables,
- diagrams,
- data filtering,
- sheet protection.
As part of the course, participants receive a set of course materials with solutions.
Type of course
general courses
Mode
Remote learning
Prerequisites (description)
No previous experience with Excel is required to participate in the class.
E-learning course, 30 hours.
Course coordinators
Learning outcomes
Thanks to the course, participants will:
- efficiently operate the Excel interface,
- enter, load, edit and format source data,
- prepare simple analyses in tabular form,
- conduct basic calculations using formulas and functions.
Assessment criteria
The final grade consists of:
- homework for 10 points (final design using the presented tools),
- activity during classes.
Punctation:
Score Points
[0-5) 2
[5-6) 3
[6-7) 3,5
[7-8) 4
[8-9) 4,5
[9-10] 5
above 10 5!
Bibliography
- Own materials,
- Michael Alexander, Richard Kusleika, John Walkenbach, 2019, Excel 2019 PL. Biblia, Helion, Warszawa,
John Walkenbach, 2014, Excel 2013. 101 porad i sztuczek, które oszczędzą Twój czas, Helion, Warszawa.
Notes
|
Term 2023Z:
Access to a computer with Microsoft Excel software (in any version, on any operating system: Windows, Mac OS). Classes on the course will be conducted in the Microsoft Office 2021 software version.
Dates of classes:
Group 1:
1. 2.10.2023 18:00-20:15 synchronous meeting
2. 9.10.2023 18:00-20:15 own works (asynchronously)
3. 16.10.2023 18:00-20:15 own works (asynchronously)
4. 23.10.2023 18:00-20:15 own works (asynchronously)
5. 30.10.2023 18:00-20:15 own works (asynchronously)
6. 6.11.2023 18:00-20:15 own works (asynchronously)
7. 13.11.2023 18:00-20:15 own works (asynchronously)
8. 20.11.2023 18:00-20:15 own works (asynchronously)
9. 27.11.2023 18:00-20:15 own works (asynchronously)
10. 4.12.2023 18:00-20:15 own works (asynchronously)
Group 2:
1. 5.10.2023 18:00-20:15 synchronous meeting
2. 12.10.2023 18:00-20:15 own works (asynchronously)
3. 19.10.2023 18:00-20:15 own works (asynchronously)
4. 26.10.2023 18:00-20:15 own works (asynchronously)
5. 9.11.2023 18:00-20:15 own works (asynchronously)
6. 16.11.2023 18:00-20:15 own works (asynchronously)
7. 23.11.2023 18:00-20:15 own works (asynchronously)
8. 30.11.2023 18:00-20:15 own works (asynchronously)
9. 7.12.2023 18:00-20:15 own works (asynchronously)
10. 14.12.2023 18:00-20:15 own works (asynchronously)
Group 3:
1. 7.10.2023 18:00-20:15 synchronous meeting
2. 14.10.2023 18:00-20:15 own works (asynchronously)
3. 21.10.2023 18:00-20:15 own works (asynchronously)
4. 28.10.2023 18:00-20:15 own works (asynchronously)
5. 4.11.2023 18:00-20:15 own works (asynchronously)
6. 18.11.2023 18:00-20:15 own works (asynchronously)
7. 25.11.2023 18:00-20:15 own works (asynchronously)
8. 2.12.2023 18:00-20:15 own works (asynchronously)
9. 9.12.2023 18:00-20:15 own works (asynchronously)
10. 16.12.2023 18:00-20:15 own works (asynchronously)
Group 4:
1. 8.10.2023 18:00-20:15 synchronous meeting
2. 15.10.2023 18:00-20:15 own works (asynchronously)
3. 22.10.2023 18:00-20:15 own works (asynchronously)
4. 29.10.2023 18:00-20:15 own works (asynchronously)
5. 5.11.2023 18:00-20:15 own works (asynchronously)
6. 19.11.2023 18:00-20:15 own works (asynchronously)
7. 26.11.2023 18:00-20:15 own works (asynchronously)
8. 3.12.2023 18:00-20:15 own works (asynchronously)
9. 10.12.2023 18:00-20:15 own works (asynchronously)
10. 17.12.2023 18:00-20:15 own works (asynchronously)
10 meetings of 3 teaching hours, including 1 synchronous meeting (3 teaching hours in total) and 9 asynchronous meetings (27 teaching hours in total).
|
Term 2023L:
Access to a computer with Microsoft Excel software (in any version, on any operating system: Windows, Mac OS). Classes on the course will be conducted in the Microsoft Office 2021 software version.
Dates of classes:
Group 1:
1. 19.02.2024 18:00-20:15 synchronous meeting
2. 26.02.2024 18:00-20:15 own works (asynchronously)
3. 4.03.2024 18:00-20:15 own works (asynchronously)
4. 11.03.2024 18:00-20:15 own works (asynchronously)
5. 18.03.2024 18:00-20:15 own works (asynchronously)
6. 25.03.2024 18:00-20:15 own works (asynchronously)
7. 8.04.2024 18:00-20:15 own works (asynchronously)
8. 15.04.2024 18:00-20:15 own works (asynchronously)
9. 22.04.2024 18:00-20:15 own works (asynchronously)
10. 29.04.2024 18:00-20:15 own works (asynchronously)
Group 2:
1. 22.02.2024 18:00-20:15 synchronous meeting
2. 29.02.2024 18:00-20:15 own works (asynchronously)
3. 7.03.2024 18:00-20:15 own works (asynchronously)
4. 14.03.2024 18:00-20:15 own works (asynchronously)
5. 21.03.2024 18:00-20:15 own works (asynchronously)
6. 28.03.2024 18:00-20:15 own works (asynchronously)
7. 4.04.2024 18:00-20:15 own works (asynchronously)
8. 11.04.2024 18:00-20:15 own works (asynchronously)
9. 18.04.2024 18:00-20:15 own works (asynchronously)
10. 25.04.2024 18:00-20:15 own works (asynchronously)
Group 3:
1. 23.02.2024 18:00-20:15 synchronous meeting
2. 1.03.2024 18:00-20:15 own works (asynchronously)
3. 8.03.2024 18:00-20:15 own works (asynchronously)
4. 15.03.2024 18:00-20:15 own works (asynchronously)
5. 22.03.2024 18:00-20:15 own works (asynchronously)
6. 5.04.2024 18:00-20:15 own works (asynchronously)
7. 12.04.2024 18:00-20:15 own works (asynchronously)
8. 16.04.2024 18:00-20:15 own works (asynchronously)
9. 19.04.2024 18:00-20:15 own works (asynchronously)
10. 26.04.2024 18:00-20:15 own works (asynchronously)
Group 4:
1. 24.02.2024 18:00-20:15 synchronous meeting
2. 2.03.2024 18:00-20:15 own works (asynchronously)
3. 9.03.2024 18:00-20:15 own works (asynchronously)
4. 16.03.2024 18:00-20:15 own works (asynchronously)
5. 23.03.2024 18:00-20:15 own works (asynchronously)
6. 6.04.2024 18:00-20:15 own works (asynchronously)
7. 9.04.2024 18:00-20:15 own works (asynchronously)
8. 13.04.2024 18:00-20:15 own works (asynchronously)
9. 20.04.2024 18:00-20:15 own works (asynchronously)
10. 27.04.2024 18:00-20:15 own works (asynchronously)
10 meetings of 3 teaching hours, including 1 synchronous meeting (3 teaching hours in total) and 9 asynchronous meetings (27 teaching hours in total).
|
Term 2024Z:
Access to a computer with Microsoft Excel software (in any version, on any operating system: Windows, Mac OS). Classes on the course will be conducted in the Microsoft Office 2021 software version.
Dates of classes:
Group 1:
1. 1.10.2024 18:00-20:15 synchronous meeting
2. 8.10.2024 18:00-20:15 own works (asynchronously)
3. 15.10.2024 18:00-20:15 own works (asynchronously)
4. 22.10.2024 18:00-20:15 own works (asynchronously)
5. 29.10.2024 18:00-20:15 own works (asynchronously)
6. 5.11.2024 18:00-20:15 own works (asynchronously)
7. 12.11.2024 18:00-20:15 own works (asynchronously)
8. 19.11.2024 18:00-20:15 own works (asynchronously)
9. 26.11.2024 18:00-20:15 own works (asynchronously)
10. 3.12.2024 18:00-20:15 own works (asynchronously)
Group 2:
1. 3.10.2024 18:00-20:15 synchronous meeting
2. 10.10.2024 18:00-20:15 own works (asynchronously)
3. 17.10.2024 18:00-20:15 own works (asynchronously)
4. 24.10.2024 18:00-20:15 own works (asynchronously)
5. 31.10.2024 18:00-20:15 own works (asynchronously)
6. 7.11.2024 18:00-20:15 own works (asynchronously)
7. 14.11.2024 18:00-20:15 own works (asynchronously)
8. 21.11.2024 18:00-20:15 own works (asynchronously)
9. 28.11.2024 18:00-20:15 own works (asynchronously)
10. 5.12.2024 18:00-20:15 own works (asynchronously)
Group 3:
1. 4.10.2024 18:00-20:15 synchronous meeting
2. 11.10.2024 18:00-20:15 own works (asynchronously)
3. 18.10.2024 18:00-20:15 own works (asynchronously)
4. 25.10.2024 18:00-20:15 own works (asynchronously)
5. 2.11.2024 15:00-17:15 own works (asynchronously)
6. 8.11.2024 18:00-20:15 own works (asynchronously)
7. 15.11.2024 18:00-20:15 own works (asynchronously)
8. 22.11.2024 18:00-20:15 own works (asynchronously)
9. 29.11.2024 18:00-20:15 own works (asynchronously)
10. 6.12.2024 18:00-20:15 own works (asynchronously)
Group 4:
1. 5.10.2024 18:00-20:15 synchronous meeting
2. 12.10.2024 18:00-20:15 own works (asynchronously)
3. 19.10.2024 18:00-20:15 own works (asynchronously)
4. 26.10.2024 18:00-20:15 own works (asynchronously)
5. 2.11.2024 18:00-20:15 own works (asynchronously)
6. 9.11.2024 18:00-20:15 own works (asynchronously)
7. 16.11.2024 18:00-20:15 own works (asynchronously)
8. 23.11.2024 18:00-20:15 own works (asynchronously)
9. 30.11.2024 18:00-20:15 own works (asynchronously)
10. 7.12.2024 18:00-20:15 own works (asynchronously)
Group 5:
1. 2.10.2024 18:00-20:15 synchronous meeting
2. 9.10.2024 18:00-20:15 own works (asynchronously)
3. 16.10.2024 18:00-20:15 own works (asynchronously)
4. 23.10.2024 18:00-20:15 own works (asynchronously)
5. 30.10.2024 18:00-20:15 own works (asynchronously)
6. 6.11.2024 18:00-20:15 own works (asynchronously)
7. 13.11.2024 18:00-20:15 own works (asynchronously)
8. 20.11.2024 18:00-20:15 own works (asynchronously)
9. 27.11.2024 18:00-20:15 own works (asynchronously)
10. 4.12.2024 18:00-20:15 own works (asynchronously)
10 meetings of 3 teaching hours, including 1 synchronous meeting (3 teaching hours in total) and 9 asynchronous meetings (27 teaching hours in total).
|
Term 2024L:
Access to a computer with Microsoft Excel software (in any version, on any operating system: Windows, Mac OS). Classes on the course will be conducted in the Microsoft Office 2021 software version.
Dates of classes:
Group 1:
1. 17.02.2025 18:00-20:15 synchronous meeting
2. 24.02.2025 18:00-20:15 own works (asynchronously)
3. 3.03.2025 18:00-20:15 own works (asynchronously)
4. 10.03.2025 18:00-20:15 own works (asynchronously)
5. 17.03.2025 18:00-20:15 own works (asynchronously)
6. 24.03.2025 18:00-20:15 own works (asynchronously)
7. 31.03.2025 18:00-20:15 own works (asynchronously)
8. 7.04.2025 18:00-20:15 own works (asynchronously)
9. 14.04.2025 18:00-20:15 own works (asynchronously)
10. 28.04.2025 18:00-20:15 own works (asynchronously)
Group 2:
1. 18.02.2025 18:00-20:15 synchronous meeting
2. 25.02.2025 18:00-20:15 own works (asynchronously)
3. 4.03.2025 18:00-20:15 own works (asynchronously)
4. 11.03.2025 18:00-20:15 own works (asynchronously)
5. 18.03.2025 18:00-20:15 own works (asynchronously)
6. 25.03.2025 18:00-20:15 own works (asynchronously)
7. 1.04.2025 18:00-20:15 own works (asynchronously)
8. 8.04.2025 18:00-20:15 own works (asynchronously)
9. 15.04.2025 18:00-20:15 own works (asynchronously)
10. 29.04.2025 18:00-20:15 own works (asynchronously)
Group 3:
1. 20.02.2025 18:00-20:15 synchronous meeting
2. 27.02.2025 18:00-20:15 own works (asynchronously)
3. 6.03.2025 18:00-20:15 own works (asynchronously)
4. 13.03.2025 18:00-20:15 own works (asynchronously)
5. 20.03.2025 15:00-17:15 own works (asynchronously)
6. 27.03.2025 18:00-20:15 own works (asynchronously)
7. 3.04.2025 18:00-20:15 own works (asynchronously)
8. 10.04.2025 18:00-20:15 own works (asynchronously)
9. 24.04.2025 18:00-20:15 own works (asynchronously)
10. 8.05.2025 18:00-20:15 own works (asynchronously)
Group 4:
1. 22.02.2025 18:00-20:15 synchronous meeting
2. 1.03.2025 18:00-20:15 own works (asynchronously)
3. 8.03.2025 18:00-20:15 own works (asynchronously)
4. 15.03.2025 18:00-20:15 own works (asynchronously)
5. 22.03.2025 18:00-20:15 own works (asynchronously)
6. 29.03.2025 18:00-20:15 own works (asynchronously)
7. 5.04.2025 18:00-20:15 own works (asynchronously)
8. 12.04.2025 18:00-20:15 own works (asynchronously)
9. 26.04.2025 18:00-20:15 own works (asynchronously)
10. 11.05.2025 18:00-20:15 own works (asynchronously)
Group 5:
1. 23.02.2025 18:00-20:15 synchronous meeting
2. 2.03.2025 18:00-20:15 own works (asynchronously)
3. 9.03.2025 18:00-20:15 own works (asynchronously)
4. 16.03.2025 18:00-20:15 own works (asynchronously)
5. 23.03.2025 18:00-20:15 own works (asynchronously)
6. 30.03.2025 18:00-20:15 own works (asynchronously)
7. 6.04.2025 18:00-20:15 own works (asynchronously)
8. 13.04.2025 18:00-20:15 own works (asynchronously)
9. 27.04.2025 18:00-20:15 own works (asynchronously)
10. 4.05.2025 18:00-20:15 own works (asynchronously)
|
Additional information
Information on level of this course, year of study and semester when the course
unit is delivered, types and amount of class hours - can be found in course structure
diagrams of apropriate study programmes. This course is related to
the following study programmes:
- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
Additional information (registration calendar, class conductors,
localization and schedules of classes), might be available in the USOSweb system: