The training is addressed to those who would like to be acquainted with OpenOffice Calc spreadsheet to such an extent which enables to use the program competently for professional purposes.
During the training the participants will be familiarized with Calc document structure designed for creating computational databases of any kind, attractive-looking and clear reports and analyses.
There are also discussed the methods of saving Calc documents so they can be opened in MS Excel spreadsheet.
The trainees perform simple calculations in sample lists and apply basic computational formulas. Exercises are done on simple tables with the use of different forms of number formatting as well as simple conditional formatting. Data sorting and filtering have been implemented to the course, which allows to work on larger data sets.
OpenOffice Calc spreadsheet is a perfect tool, which provides an alternative for MS Excel. This application is user-friendly. A highly appealing feature of the program is the possibility of opening and saving files compatible with other formats. Calc reads and saves files, for instance, as .xls format. With this solution, the issue of having multiple applications for different file formats does not exist.
The training is delivered in the form of computer workshops. Each participant, at their own computer station, performs exercises according to the lecturer’s tips. The training topics are presented in the form of practical exercises. In order to improve the effectiveness of knowledge acquisition, the system of combining the lecture part and exercises has been introduced.
The training participants receive training materials in the form of:
- Script prepared by the AkKom specialists,
- Practical exercises in the area of using OpenOffice Calc spreadsheet.
At the end of the course, the trainees will be given certificates which confirm the participation and gaining knowledge on the use of OpenOffice Calc spreadsheet
After completing the course, each participant can contact the lecturer in order to solve issues which bother them. The contact with the trainer is free-of-charge exclusively for our participants.
Introduction to the program
- Calc user interface
- Similarities and differences between MS Excel and Calc
- Basic functions on the toolbars
Basic terms
- Cell
- Addressing
- Document navigation methods
Basic operations
- Creating a new workbook
- Saving the workbook
- Opening a previously saved workbook
- Saving the workbook as .xls and .xlsx format
- Export to .pdf format
Working with Calc spreadsheet
- Selecting different cell ranges
- Entering data
- Data format (numbers, dates, percentages, text)
- Inserting new columns and rows
- Deleting columns and rows
- Changing column width and row height
- Cell merging
- Copying, cutting and pasting cell contents
- Transferring cell contents
- Using the undo and redo tools
Series
- Number series
- Series with other types of data
- Filling the cells with date series
- Filling the cells with custom lists
Calculations
- The definition of formula
- Creating simple formulas
- Basic functions (SUM, AVERAGE, MIN, MAX, ROUND)
Simple conditional formatting
Creating and formatting simple tables
- Table format
- Merging and splitting cells in a table
- Adding calculations in tables
Simple data sorting and filtering
Printing Calc sheets
Zapisz się na interesujący Cię termin szkolenia
There are currently no training dates
