Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Word
Introduction to the Use of Text Editors for Government
- 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 in government documents.
- 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 for government use.
Bullet Points and Lists
- Use bullet points and numbering.
- Maintaining a consistent look throughout the document lists.
- Quickly change the appearance of text in lists.
- Rearranging or adjusting the level for list items.
The Construction and Use of Tables
- Inserting tables.
- Aesthetics and transparency in tables (such as changing font sizes, borders, internal margins, and background color of cells).
- Modifying tables (such as adding and removing columns and rows, and creating headers common to several columns).
- The use of headers and footers.
- Setting a separate header/footer for the first page of the document.
- Using automatic page numbering (including numbers such as "Number next page / total number of pages in the document").
- Inserting information on all pages of the document, such as title, author, or date of update.
- Changing the font and size of text for page 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 (e.g., dates, amounts, percentages, or fractions).
- Determining the borders and background of cells.
- Formatting row and column titles.
- Using styles for government documents.
Navigation
- Moving efficiently in large spreadsheets.
- Parallel work on multiple spreadsheets/workbooks.
Copying and Moving Data
- Selecting areas (cell ranges).
- Moving data.
- Paste Special options.
- Autofill cell series of data (e.g., order numbers and dates of the next working day).
Formulas, Addresses, and Cell Names
- Creating, modifying, and copying formulas.
- Circular references.
- Conditional formatting.
- The types of addresses and their use.
- References to other worksheets and workbooks.
- Using cell names in government documents.
Functions
- General rules for using functions in government applications.
- Frequently used functions.
- Nesting functions.
- Using conditional functions.
- The Function Wizard for efficient data management.
Charts
- The main chart types and their use in government reports.
- General principles for creating compelling charts.
- Creating charts.
- Components of graphs and their modification.
- Creating custom chart types for specific government needs.
14 Hours
Testimonials (5)
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Word dla zaawansowanych
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - MS Word - poziom podstawowy
I was recently struggling with some pivot table issues and the course gave me the knowledge to work with pivot tables quicker, smarter and more efficiently.
Arina Moayed-Dzenisa - Universal-Investment-Gesellschaft mbH Branch Poland Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
