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.
- Quick and precise navigation within a document.
Styles
- The importance of styles in maintaining consistency, transparency, and aesthetic appeal in documents.
- Understanding style groups and their applications.
- Rapidly changing basic text formatting.
- Formatting titles and using typographical elements to distinguish them.
- General rules for achieving clarity and aesthetic text presentation.
Bullets, Numbering, and Lists
- Using bullets and numbering.
- Maintaining a consistent look for lists throughout the document.
- Quickly changing the appearance of list items.
- Rearranging or adjusting the indentation level of list items.
Creating and Using Tables
- Inserting tables.
- Enhancing the aesthetics and transparency of tables (such as adjusting font sizes, borders, internal cell margins, and background colors).
- Modifying tables (such as adding or removing columns and rows, and creating headers spanning multiple columns).
Headers and Footers
- Understanding their usage.
- Setting separate headers or footers for the first page of the document.
- Using automatic page numbering (including formats like "Next Page Number / Total Pages").
- Inserting dynamic information on all pages (e.g., title, author, or last update date).
- Changing the font and size of numbers independently from the rest of the header/footer content.
Excel
Introduction
- Basic information about the program.
- Structure of the main window.
- Managing workbooks and sheets.
Entering and Modifying Data in Cells
Data Formatting
- Specifying display formats for different data types and calculation results (e.g., dates, currency, percentages, or fractions).
- Setting cell borders and background colors.
- Formatting row and column headers.
- Utilizing Styles.
Navigation
- Efficient movement within large worksheets.
- Working simultaneously across multiple spreadsheets or workbooks.
Copying and Moving Data
- Selecting areas (cell ranges).
- Moving data.
- Using Paste Special.
- Autofilling cell ranges (series) with data (e.g., sequential order numbers or dates for the next working day).
Formulas, References, and Cell Names
- Creating, modifying, and copying formulas.
- Understanding circular references.
- Applying conditional formatting.
- Types of references and their applications.
- Referencing other worksheets and workbooks.
- Using defined cell names.
Functions
- General rules for using functions.
- Commonly used functions.
- Nesting functions within other functions.
- Using conditional logic.
- Utilizing the Function Wizard.
Charts
- Main chart types and their appropriate uses.
- General principles for creating effective charts.
- Creating charts.
- Components of graphs and how to modify them.
- Customizing your own 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
