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
- Navigating through documents quickly and accurately
Styles
- The significance of styles in maintaining consistency, clarity, and aesthetic appeal in documents
- Understanding style groups and their applications
- Quickly altering basic text formatting
- Formatting titles and using typographical elements to distinguish them
- General guidelines for achieving clear and aesthetically pleasing texts
Lists - Bullets and Numbering
- Utilizing bullets and numbering
- Maintaining a consistent appearance across list items throughout the document
- Quickly changing the appearance of list items
- Rearranging or adjusting the hierarchy of list items
Creating and Using Tables
- Inserting tables
- Enhancing table aesthetics and clarity (e.g., adjusting font sizes, cell borders, internal padding, and background colors)
- Modifying tables (such as adding or removing columns and rows, and creating headers that span multiple columns)
Headers and Footers
- Utilizing headers and footers
- Setting a unique header or footer for the first page
- Using automatic page numbering (including formats like "Page next / Total pages in document")
- Inserting metadata on all pages (e.g., document title, author, or update date)
- Changing font and size for page numbers independently from the rest of the header or footer content
Excel
Introduction
- Overview of the program
- Structure of the main window
- Working with workbooks and sheets
Entering and Modifying Data in Spreadsheet Cells
Data Formatting
- Specifying how different data types and calculation results are displayed (e.g., dates, currency amounts, percentages, or fractions)
- Defining cell borders and background colors
- Formatting row and column headings
- Applying Styles
Navigation
- Efficiently moving within large spreadsheets
- Working simultaneously on multiple spreadsheets or workbooks
Copying and Moving Data
- Selecting areas (ranges of cells)
- Moving data
- Paste Special operations
- Auto-filling cell sequences (e.g., order numbers and dates for the next working day)
Formulas, Addresses, and Cell Names
- Creating, modifying, and copying formulas
- Handling circular references
- Applying conditional formatting
- Understanding address types and their applications
- Referencing other worksheets and workbooks
- Using named cells
Functions
- General rules for using functions
- Frequently used functions
- Nesting functions
- Utilizing conditional logic
- Using the Function Wizard
Charts
- Primary chart types and their uses
- General principles for creating compelling charts
- Creating charts
- Modifying components of charts
- 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
