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 Editors
- Capabilities of computer-based text processing.
- Creating and saving documents.
- Fast and precise navigation within a document.
Styles
- The importance of styles for maintaining consistency, clarity, and aesthetic appeal.
- Style groups and their applications.
- Quickly changing basic text formatting.
- Formatting titles and using typographic features to distinguish them.
- General guidelines for achieving clarity and aesthetic quality in texts.
Lists - Bullets and Numbering
- Using bullet points and numbering.
- Maintaining a consistent appearance across list items throughout the document.
- Quickly altering the appearance of list items.
- Rearranging items or changing their indentation levels.
Creating and Using Tables
- Inserting tables.
- Enhancing table aesthetics and readability (e.g., adjusting font sizes, cell borders, internal padding, and background colors).
- Modifying tables (e.g., adding or removing rows and columns, creating header rows that span multiple columns).
Headers and Footers for Pages
- Utilizing headers and footers.
- Setting a unique header or footer for the first page of the document.
- Implementing automatic page numbering (including formats like "Page number / Total pages").
- Inserting document metadata (e.g., title, author, or last update date) on all pages.
- Changing the font and size of text for numbering independently from the rest of the header or footer content.
Excel
Introduction
- Basic information about the program.
- Overview of the main window layout.
- Operations on workbooks and worksheets.
Entering and Modifying Data in Cells
Formatting Data
- Configuring display formats for various data types and calculation results (e.g., dates, currency amounts, percentages, or fractions).
- Setting cell borders and background colors.
- Formatting row and column headers.
- Applying Styles.
Navigation
- Moving efficiently within large worksheets.
- Working in parallel on multiple spreadsheets or workbooks.
Copying and Moving Data
- Selecting ranges of cells.
- Moving data.
- Using Paste Special options.
- Auto-filling data series (e.g., sequential order numbers or dates for subsequent working days).
Formulas, Cell References, and Names
- Creating, modifying, and copying formulas.
- Understanding and handling circular references.
- Applying Conditional Formatting.
- Understanding reference types and their uses.
- Referencing other worksheets and workbooks.
- Using named cells for easier reference.
Functions
- General rules for using functions.
- Frequently used functions.
- Nesting functions.
- Using IF conditions.
- Utilizing the Function Wizard.
Charts
- Key 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
