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 (7)
Introduction to macros and presentation of rarely used pivot table options
Piotr Bleszynski - Solutions30 Mobile Sp. z o.o.
Course - Working with spreadsheet in Microsoft Excel
Machine Translated
Reviewing the formula
Monika Zaremba - Solutions30 Mobile Sp. z o.o.
Course - Working with spreadsheet in Microsoft Excel
Machine Translated
Pivot tables and discovering knowledge I previously didn't have.
Grzegorz Tyborowicz - Solutions30 Mobile Sp. z o.o.
Course - Working with spreadsheet in Microsoft Excel
Machine Translated
The content is excellent.
Izabela Medtzyk - Solutions30 Mobile Sp. z o.o.
Course - Working with spreadsheet in Microsoft Excel
Machine Translated
the trainer's manner of conducting, understanding and calmness, knowledge!!
Arkadiusz Baran - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
Machine Translated
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
Creating tables and calculating their data.
Katarzyna Ciunajcis
Machine Translated
