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 (10)
Tworzenie tabel i kalkulacja ich danych.
Katarzyna Ciunajcis
Course - Working with spreadsheet in Microsoft Excel
Znakomity kontakt trenera z uczestnikami. Bardzo uważnie, Pani Dominika reagowała natychmiast na wszelkie zapytania, empatycznie podchodziła do uczestników.
Andrzej Znamirowski - P.W. FAST SP. Z O.O.
Course - Working with spreadsheet in Microsoft Excel
sposób prowadzenia szkolenia przez prowadzącego
Renata Nenycz - P.W. FAST SP. Z O.O.
Course - Working with spreadsheet in Microsoft Excel
duża wiedza, spory zakres zagadnień
MALINOWSKA ANETA - P.W. FAST SP. Z O.O.
Course - Working with spreadsheet in Microsoft Excel
odpowiednie tempo, dobrze dobrany materiał do nauki
Anna Krutelewicz - P.W. FAST SP. Z O.O.
Course - Working with spreadsheet in Microsoft Excel
Sposób prowadzenia, zaangażowanie i spokój prowadzącej
Renata Skorżepo - P.W. FAST SP. Z O.O.
Course - Working with spreadsheet in Microsoft Excel
Wiedza i podejście szkoleniowca
Renata Czulak - P.W. FAST SP. Z O.O.
Course - Working with spreadsheet in Microsoft Excel
Podejście do szkolenia. profesjonalizm.
Natalia Zamojska - P.W. FAST SP. Z O.O.
Course - Working with spreadsheet in Microsoft Excel
spokój prowadzącej
Maciej Nowacki - P.W. FAST SP. Z O.O.
Course - Working with spreadsheet in Microsoft Excel
Wiedza wykladowcy