Course Outline
Introduction
- Basic information about the program
- Construction of the main window
- Operations on workbooks (notebooks) and sheets
Entering and modifying data in worksheet cells
Formatting data
- Determining how to display different types of data and calculation results (eg, dates, amounts, percentages or fractions)
- Determining the edge of the cell and the background
- Formatting row and column titles
- Using Styles
Navigation
- Moving up in extensive sheets
- Concurrent work on multiple worksheets / workbooks
Copying and moving data
- Select areas (cell ranges)
- Moving data
- special insert
- Autofill sections (series) of data (for example, ordinals and dates of the next working day)
Formula, addresses and cell names
- Create, modify and copy formulas
- circular references
- Conditional formatting
- The address types and their use
- References to other worksheets and workbooks
- Using cell names
Functions
- General rules for using the function
- Frequently used functions
- Nested functions
- Using the conditional
- The Function creator
Graphics in spreadsheets
- AutoShapes and WordArt
- static and dynamic data images
Charts
- The main chart types and their applications
- General principles for creating compelling charts
- Creating charts
- Components of graphs and their modification
- Create owns chart types
Hiding and Data Protection
- Hiding sheets, columns, and rows
- Hide formulas and cell entries
- Protect worksheet and workbook from changes
- Protecting workbooks before opening
- Printing sheets and areas of discontinuous
- Printing charts
Requirements
Knowledge of Windows
Testimonials
The atmosphere, the knowledge of the trainer, skills of the manager
Beata Perzanowska
usefulness of exercises
- NBP
exercises
- NBP
The fact that the training was a workshop, not a "dry" lecture.
Katarzyna Borychowska - NBP
The trainer conducts the classes very easily. You can not get bored with them.
- NBP
knowledge and method of providing information by the teacher
- Pol -Assur Spółka z ograniczoną odpowiedzialnością
everything
anna ciesielska - Pol -Assur Spółka z ograniczoną odpowiedzialnością
examples
- Pol -Assur Spółka z ograniczoną odpowiedzialnością
transfer of information
- Pol -Assur Spółka z ograniczoną odpowiedzialnością
practical exercises