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 (9)
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction
I learned new things so that is a good point
Daria - LKQ Polska Sp. z o. o.
Course - Analysing Financial Data in Excel
Lecturer's openness
Natalia - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
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
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
Course - Visual Basic for Applications (VBA) in Excel - Advanced
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
Reliable preparation of the trainer for training. Interesting examples.
Sandra - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
Machine Translated