Course Outline
Word
Introduction to the use of text editors
- Possibilities of computer text processing.
- Creating and saving documents
- Quick and precise navigation through the document
Style
- The importance of style for easy maintenance of consistency, transparency and aesthetics document
- Style groups and their applications
- Quickly change the basic text formatting
- Format titles and typographical resources used to distinguish them
- General rules for obtaining clarity and aesthetic texts
Letters - bullet points and lists
- Use bullet points and calculations
- Maintaining a consistent look throughout the document lists
- Quickly change the appearance of a letter
- Rearranging or level for the list item
The construction and use of tables
- Inserting tables
- Aesthetics and transparency tables (such as changing font sizes, font size and edges, internal margins and background color of the cells)
- Modifying tables (such as adding and removing columns and rows, and create headers common to several columns)
Headers and footers to pages
- The use of
- Setting a separate header / footer for the first page of the document
- Using automatic page numbering (including numbers such as "Number next page / number of pages in the document")
- Insert information on all pages of the document metrics (eg title, author, or date of update)
- Change the font and size of letters for numbers (independently from the rest of the contents of the header / footer)
Excel
Introduction
- Basic information about the program
- Construction of the main window
- Operations on workbooks (notebooks) and sheets
Entering and modifying data in spreadsheet cells
Formatting data
- Determining how to display different types of data and calculation results (eg, dates, amounts, percentages or fractions)
- Determining the edge and the background of the cells
- Formatting row and column titles
- Using Styles
Navigation
- Moving up in large sheets
- Parallel work on multiple spreadsheets / workbooks
Copying and moving data
- Select areas (cell ranges)
- Moving data
- Paste Special
- Autofill cell strings (series) of data (for example, order numbers 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
- Nesting functions
- Using the conditional
- The Function Wizard
Charts
- The main chart types and their use
- General principles for creating compelling charts
- Creating Charts.
- Components of graphs and their modification
- Create your own chart types
Testimonials (14)
Spokojne tempo, trener ma wiedzę i jasno ją przekazuje.
Edyta Gotfryd
Course - MS Word Basic
Dobre tempo zajęć. Jasne i praktyczne tłumaczenie poszczególnych zagadnień.
Mariusz Szpringer - NBP
Course - Word dla zaawansowanych
Tworzenie tabel i kalkulacja ich danych.
Katarzyna Ciunajcis
Course - Working with spreadsheet in Microsoft Excel
exhaustion of topics
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
Showing examples, pictorial way of translating
Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
Very accurate translation, paying attention to what the students are doing. A wide range of issues related to the topic. Very useful training!
Magdalena - DataConsult S.A.
Course - Microsoft Office Excel - working effectively with the spreadsheet
Machine Translated
Trainer flexibility. Comprehensive answers to every question.
Krystyna Szpala - Sogecap SA Branch in Poland
Course - Visual Basic for Applications (VBA) for Analysts
Machine Translated
Zdobycie nowych umiejętności w programie Excel oraz poznanie języka VBA który mam nadzieję pomoże mi w dalszej pracy.
Sylwia Śliwka
Course - Microsoft Office Excel i Visual Basic for Applications (VBA) dla kontrolerów finansowych i audytorów
Podstawowe informacje pozwalajae na samodzielne rozpoczęcie pracy i uwagi dot. optymalizacji podejścia
Robert Kaźmierczak
Course - Microsoft Office Excel - moduł Business Intelligence
'Fun facts' - how to achieve the same the other way around.
Paulina - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Interesting exercises
Kacper - LKQ Polska Sp. z o. o.
Course - Excel Advanced
I learned new things so that is a good point
Daria - LKQ Polska Sp. z o. o.
Course - Analysing Financial Data in Excel
perfect adaptation of materials to the group, detailed discussion of issues, very high competence, very good contact with the group, high ability to transfer knowledge,
Malgorzata - LKQ Polska Sp. z o. o.
Course - Excel Basics
Machine Translated
I liked the large number of tasks and the friendly atmosphere.
Paulina - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
Machine Translated