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.
Course coordinators
Type of course
Mode
Prerequisites (description)
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: Group 2: Group 3: Group 4: 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: Group 2: Group 3: Group 4: 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: Group 2: Group 3: Group 4: Group 5: 10 meetings of 3 teaching hours, including 1 synchronous meeting (3 teaching hours in total) and 9 asynchronous meetings (27 teaching hours in total). |