Eine Veranstaltung des Weiterbildungszentrums.
MS Excel is a powerful program for calculation and display of various data. The application possibilities are varied, the program very extensive. Excel allows you to perform calculations with formulas and functions, for office applications, scientific analyzes, statistical evaluations, date functions, etc. The results of calculations can be evaluated with the help of sorting, grouping and filter functions and can be displayed in graphs. Tables or parts thereof may be protected against layout or content changes. The seminar provides basic knowledge about MS Excel.
In this course you are right, if you have not worked with MS Excel so far and you are looking for a comprehensive entry-level course that will introduce you to the basic functions of MS Excel and will give you inspiration about different application possibilities.
The participants are familiar with the basic work techniques for creating tables and computations of various data with MS Excel 2016 and can apply them practically. They are able to use functions and formulas, format data and create easy PivotTables and Charts.
Creating, Opening, Saving and Sharing Workbooks / Modifying Columns, Rows and Cells / Understanding Number Formats / Using "Find & Replace" / Page Layout and Printing / Creating Formulas / Using Relative and Absolute Cell References / Sorting and Filtering Data / Using Charts / Tables and Conditional Formatting / Intro to Pivot-Tables
The didactic content is enhanced with a very short Front-loading didactic. The most time of the course you will work in small groups or by your own to solve various exercises.
The course has been created for Excel-Newbies and is conducted in English. The cource is using an English version of Excel 2016. Users of other English Excel-Versions are also welcome.
Those who are looking for an easy-to-understand introduction to working with MS Excel.
149,- € (employees of FU Berlin ), 189,- € (member of Max-Planck-society, FU-observers), 298,- € (externals).
Important note for FU-employees:
In accordance with the "Service Agreement for Continuing Education" (§ 2), the department / institution assumes the costs, provided that the attendance of this course is carried out in a predominantly official interest.
Tuesday and Wednesday, July 10 and 11, 2018, 9 a.m. - 4 p.m.
10.07.2018 | 09:00 - 16:00
Center for further education of FU Berlin, room 216, upstairs, Otto-von-Simson-Str. 13, 14195 Berlin