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 Text Editing
- Capabilities of computer-based text processing.
- Creating and saving documents.
- Navigating quickly and accurately through documents.
Styles
- The importance of styles in maintaining consistency, clarity, and aesthetic appeal in documents.
- Style groups and their applications.
- Rapidly changing basic text formatting.
- Formatting headings and utilising typographical resources to distinguish them.
- General principles for achieving clear and aesthetically pleasing texts.
Bullet Points and Lists
- Utilising bullet points and lists.
- Maintaining a consistent appearance across document lists.
- Quickly modifying the appearance of list items.
- Reordering or adjusting the level of list items.
Creating and Using Tables
- Inserting tables.
- Enhancing the aesthetics and clarity of tables (e.g., adjusting font sizes, borders, cell padding, and background colours).
- Modifying tables (such as adding or removing columns and rows, and creating headers that span multiple columns).
Headers and Footers for Pages
- Utilising headers and footers.
- Configuring a distinct header or footer for the first page of the document.
- Using automatic page numbering (including formats such as 'Next page number / Total page number in the document').
- Inserting metadata on all pages (e.g., title, author, or update date).
- Changing the font and size of text or numbers within headers/footers independently from the rest of the content.
Excel
Introduction
- Overview of the program.
- Structure of the main window.
- Managing workbooks and sheets.
Entering and Modifying Data in Spreadsheet Cells
Data Formatting
- Setting display formats for different data types and calculation results (e.g., dates, currency, percentages, or fractions).
- Configuring cell borders and background colours.
- Formatting row and column headers.
- Applying Styles.
Navigation
- Navigating large sheets efficiently.
- Working on multiple spreadsheets or workbooks simultaneously.
Copying and Moving Data
- Selecting areas (cell ranges).
- Moving data.
- Pasting special content.
- Autofilling cell series (e.g., sequential order numbers or dates for the next working day).
Formulas, Addresses, and Cell Names
- Creating, modifying, and copying formulas.
- Understanding circular references.
- Applying conditional formatting.
- Types of cell addresses and their uses.
- References to other worksheets and workbooks.
- Using named cells.
Functions
- General rules for using functions.
- Commonly used functions.
- Nesting functions.
- Utilising conditional logic.
- The Function Wizard.
Charts
- Main chart types and their applications.
- General principles for creating effective charts.
- Creating charts.
- Modifying chart components.
- Creating custom chart types.
14 Hours
Testimonials (3)
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
peace of mind of the person presenting
Anna Szper - Sad Rejonowy w Krosnie Odrzanskim
Course - MS Word - poziom podstawowy
well-prepared training, interesting topics
