Certificate from Academy M22
The training for computer programs for office work includes the MS Office package. Apart from the fact that you can attend the full training and get certified, if you already have knowledge, we offer you the opportunity to test yourself and get a certificate according to the results shown.
MS OFFICE-WORD
MODULE 1-INTRODUCTION
- Presentation of the learning program
- getting to know the computer as a modern work tool
- realizing the benefits of using information technology
- Familiarity with WINDOWS
MODULE 2-BASIC ELEMENTS AND CONCEPTS IN WINDOWS
- Basic elements and concepts in Windows
- Creating folders
- Practice/create
MODULE 3- INTRODUCTION TO MICROSOFT WORD
- Toolbars/status bar and information
- Using basic tools in Word
- Contents of the menus and their use
- Using the toolbars – standard toolbar
- Microsoft Office Word window
- Movement through the document
- Method of displaying the document
- Page setup and preview
MODULE 4-SITE SETUP
- Setting page margins
- Creating an outline view (Outline)
- Text selection
- Exercises
- Spell check
- Setting up a new page
- Throwing in a specific location of the violation or deleting it
- Zooming, placing columns in text
MODULE 5-ADDING HEADER AND FOOTER PAGES
- Setting different headers and footers on the page
- What is pagination (page numbering)?
- Exercises
MODULE 6- DOCUMENT FORMATTING (TEXT)
- Highlighting and underlining the text
- Change the color of the text
- Determining the characteristics of letters
- Text alignment
- Paragraph indentation (Indent)
- Spacing between lines
- Using and adjusting the tab
- Setting the distance between characters
- Exercises
MODULE 7-USING EXISTING STYLES
- Style creation and change
- Enumeration setup
- Turning off the display of the text
- Exercises
MODULE 8-DOCUMENT LAYOUT IMPROVEMENTS
- DTP effects
- Background effect, watermark
- What is a framework?
- Coloring the page
MODULE 9-PUTTING TEXT IN COLUMNS
- Text wrapping around an object
- Work with text frames
- Exercises
MODULE 10-CREATION AND THROWING OF CONSTRUCTIVE ELEMENTS
- creating different styles and editing the page
- Exercises
MODULE 11-TABLE
- Table formatting
- Calculations in the table
- Exercises
MODULE 12-ENVELOPE ADDRESSING AND LABELS
- Envelope addressing and labels
- Exercises
MODULE 13-CREATION OF A CIRCULAR LETTER
- Creation of labels
- Content creation
- Exercises
MODULE 14-SETTING INDEX
- Creating captions for illustrations
- Creating a list of images
- Exercises
MODULE 15-FOOTNOTES
- Bookmark creation
- Cross reference
- Exercises
MODULE 16-COMPARING AND MERGER OF DOCUMENTS
- Comparing and merging documents
- Exercises
MODULE 17-OBSERVATION OF CHANGES IN THE DOCUMENT
- Monitoring changes in the document
- Exercises
MODULE 18-COMMENT
- inserting comments and notes in documents
- exercises
MODULE 19-COVER PAGE
- insert cover page
- cover page styles
- colors
- exercises
MODULE 20- SECURITY IN WORD
- word document protection
- saving a document
- Document printing and printing options
- Preview a document before printing
- Exercise
MS OFFICE-EXCEL
MODULE 1 – INTRODUCTION
MODULE 2- BASIC ELEMENTS AND CONCEPTS IN EXCEL
- Start Microsoft Excel
- Microsoft Excel window
- Familiarity with toolbars/status bar and information in Excel
- Practice/create
MODULE 3- INTRODUCTION TO MICROSOFT EXCEL
- Getting started, familiarizing yourself with the work environment and closing Excel
- Opening a workbook
- Recording workbook
- Recording a workbook to a specific location on the hard drive
- Saving a workbook under a different name
- Recording a workbook in another format
- Recording workbook during operation
- Closing a workbook
- Movement through the workbook during operation
- Closing workbook
- Exercise
MODULE 4- BASIC ELEMENTS
- Selection
- Movement through a work page
- Data entry
- Entering numbers
- Date and time entry
- Types of filtering
- Exercises
MODULE 5 – MOVING THROUGH THE WORKSHEET
- Worksheet
- Moving through the worksheet
- Naming worksheets
- Adding and repositioning worksheets
- Copying and moving worksheets
MODULE 6- MOVING THROUGH THE WORKSHEET AND ENTERING DATA
- Entering text
- Changing the contents of the cell
- Data entry with AutoComplete
- Data entry via PickList
- Entering data into a cell
- Entering text data (Label)
- Insert symbols
- Entering numerical data
- Entering numerical data and worksheets
- Exercises
MODULE 7- EDITING THE CONTENT OF CELLS
- Edit the contents of the cells
- Copying and moving the contents of cells
- Undo-Redo commands
- Searching and replacing data
- Using Find and Replace tool
- Editing a worksheet
- Inserting and deleting cells
- Merge cells and center text
- “Freezing” row and column headers
- Addition, subtraction, multiplication and division of values in cells
- Exercises
MODULE 8- WORKING WITH FORMULAS
- Entering formulas, debugging formulas
- Quickly enter values using the AutoFill command
- Automatic filling (creating an AutoFill list)
- Deleting the contents of cells
- Rows, columns and cells
- Deleting rows, columns and cells
- Operations with work pages
- Exercises
MODULE 9- WORKSTATIONS
- Toggle the desktop display on and off
- Toggle the display of columns and rows on and off
- Setting column width and row height
- Freezing and dividing the work page into panels
- Disconnecting and connecting elements of the workbook
MODULE 10- WORKING WITH NAMES AND FORMULAS
- Automatic range name determination
- Assigning a name to cells or a range with a dialog box
- Entering range names using commands
- Working with names
- Using ranges in formulas
- Using functions
- Revision of the work page
MODULE 11- FUNCTIONS
- Working with nested functions
- Working with text functions
- Working with search and referencing functions
- Collecting data using subtotals
- Working with functions (SUM, SUMIF, AVERAGE, MIN, MAX, COUNT, IF)
- Exercises
MODULE 12- WORKING WITH TABLES AND CALCULATIONS
- Conversion of text into columns
- Table creation
- Table formatting
- Calculations in the table
- Exercises
MODULE 13- CREATING STYLES AND DESIGNING A WORKSTATION IN EXCEL
- Designing the worksheet in Excel
- Creating styles
- Designing table elements
- Sorting in a table
- Selecting elements in a table
- Exercises
MODULE 14- FORMATTING
- Using conditional formatting
- Defining alignment
- Formatting of worksheet titles and background
MODULE 15- FOOTNOTES
- Creating a frame (Border)
- Exercises
MODULE 16- DESKTOP SETTING AND ADDING A HEADER AND FOOTER
- Setting the dimension of the working page
- Adding a header and footer to the page
- Page violation
MODULE 17- COMMENTS AND NOTES
- inserting comments and notes in documents
- Data sorting
- Using tables
MODULE 18- COVER PAGE
- Converting tables to ranges
- Setting up the printing of the working pages
- Document printing and printing options
- Preview a document before printing
- Exercise
MODULE 19- WORKING WITH PIVOT TABLES
- preparing data and working with pivot tables
MODULE 20- SECURITY IN WORD
- protection of an excel document
- saving a document
- transferring a table from excel to word
MODULE 21- REVIEW AND PREPARATION FOR THE FINAL EXAM
- Repetition of the studied material
MS OFFICE – POWER POINT
MODULE 1- INTRODUCTION
MODULE 2- BASIC ELEMENTS AND CONCEPTS IN MICROSOFT POWERPOINT
- First steps in creating a presentation (starting Power Point)
- Microsoft Power Point window
- Familiarity with toolbars/status line and information in Power Point
MODULE 3- INTRODUCTION TO MICROSOFT POWERPOINT
- Practice/create
- Starting, familiarizing yourself with the working environment and closing PowerPoint
- Viewing the presentation
- Presentation of slides in Power Point
- Creating a presentation
- Recording the presentation to a specific location on the hard disk
- Recording the presentation under a different name
- Recording the presentation in another format
- Recording of the presentation during the operation
- Closing the presentation
- Movement through the presentation during operation
- Exercise
MODULE 4- WORKING WITH BASIC ELEMENTS AND OBJECTS AND MOVING THROUGH
THE WORKSHEET
- Throwing in a summary view and its development
- Adding and repositioning objects
- Copy and move objects and images
- Moving and copying the object
- Creation of a duplicate of the slide
MODULE 5- INSERT TEXT
- Enter and edit text, Change text size, Change text direction
- Text alignment, Creating text columns, Adjusting the distance between lines of text
- Change the font throughout the presentation
- Changing the type of letters
- Move and indent text
- Connecting and disconnecting the ruler
- Exercises
MODULE 6- OPERATION AND ADJUSTMENT OF NUMERICAL DATA
- Tab setting
- Changing numbered lists and enumeration lists
- Change of enumeration symbols and numbers
- Exercises
MODULE 7- WORKING WITH SLIDES
- Work with slides
- Using slides from other presentations
- Achieving a consistent presentation look
- Modification of reserved fields
- Defining the slide background using a master
- Defining the master slide background style
- Exercises
MODULE 8- WORKING WITH TABLES, INSERTING AND EDITING TABLES
- Inserting a table into the slide
- Edit the table
- Table formatting
- Applying quick styles to the table format
- Creating and formatting the text box field
- Exercises
MODULE 9- PRESENTATION OF THE PRESENTATION
- Presenting the presentation
- Site setup
- Adding animation
- Work with specialized animations
- Start the presentation
- Exercises
MODULE 10- ADDING VISUAL AND SOUND EFFECTS TO THE PRESENTATION
- Coordinating the animation
- Recording of ongoing speech
- Throwing in sound and video materials
- Setting the display of video and audio content
- Setting up the presentation
- User defined presentation
MODULE 11- FINALIZE A PRESENTATION
- Adding notes to the presentation by modifying the pointer option
- Finalization and packaging of the CD presentation
- Recording of the presentation in the form of a Slide Show
- Exercises
MODULE 12- PREPARATION OF REVIEW PAGES
- Preparation of review pages
- Preparation of auxiliary notes-Notes
- Adding header and footer
- Insert sequential numbers of slides, notes pages and overview pages
- inserting comments and notes in a presentation
- Exercises
MODULE 13- PREPARATION BEFORE PRINTING
- Setting up printing of working pages
- Document printing and printing options
- Preview a document before printing
- Exercise
MODULE 14- SECURITY IN EXCEL
- presentation protection
- saving a presentation
- Exercises
MODULE 15- SLIDE MASTER CONCEPT
- Changing and shaping the content
- Redefining the appearance
- Background graphics
- Insert Panel
- Microsoft Clip Art
- Figure in Microsoft PowerPoint
- Microsoft PowerPoint – ClipArt Online!
- AutoShapes
- Word Art
- Text Box
- Exercises
MODULE 16- MAKING LINKS (HYPERLINK, REFERENCE LINK
- Methods and time of slides
- Palette for graphic editing of slides
- Transitions and slide management
- Import and manage audio files
- Import and manage video files
- Transition from one slide to another
- Exercises
MODULE 17- CONNECTING POWER POINT PRESENTATION WITH OTHER MS OFFICE
PROGRAMS
- Connection to Excel and Word
- Management of tables and graphs
- Inserting vector shapes
- Dynamic elements
- Timing adjustment
MODULE 18- REVIEW AND PREPARATION FOR THE FINAL EXAM
- Repetition of the studied material