Microsoft Office Word Course
Our Microsoft Office Word course gives comprehensive knowledge to people who want to get the most out of their Word processor. After learning the basic concepts, they will learn how to use the program through practical examples, and they will be able to create from general documents to circular documents.
ApplyMicrosoft Office Word Course - Participants
We recommend the Word course to people, who are confident in their computer skills and want to learn about editing.
Microsoft Office Word Course - Preconditions
Basic understanding of using computer and the Internet.
Microsoft Office Word Course - Purpose
The Word course participants can create perfectly formatted documents, confidently handle the Word application, create circular documents, and embed tables in the context.
Microsoft Office Word Course - Exam
Participants will take the exam of the Testing course in the last class of the course, and receive the certification after that.
Microsoft Office Word Course - Topics
Word Interface
- Quick Access Toolbar
- Toolbar Customization
- System Palette
- Migrate a previous version custom toolbar
- Properties, custom properties
- Views
Basic Knowledge for Quick Word Management
- Quick Access Toolbar
- Toolbar Customization
- System Palette
- Migrate a previous version custom toolbar
- Properties, custom properties
- Views
Create Small and Medium Documents
- Simple documments without styling
- Styles
- Styling documents
- Styles display options
- Applying Styles
- Changing Styles
- Create a new style
- Create shortcuts to Styles
- Insert document properties
- Date, time, etc. Insert
- Insert a cover, make a new cover module
- Header, footer based on pattern, custom header, footer creation, save as module
- Using other modules
- Document creation based on templates
Tables
- Word and Excel
- Insert or fill in a table
- Sizes of tables
- Changing the structure of a table
- Merging and dividing cells
- Border
- Table properties
- Styling tables
- Modification
- Create a new style for tables
Themes in Word
- Using styles to easily switch themes
- Using, creating, modifying a style
- Using color schemes, letter and effect schemes
- Using themes, creating a new theme
Create Large Documents
- Sections in Word
- Using sketch view
- Caption, Reference, Insert Footnote and Endnote
- Creating contents, figures, references
- Styling Reference
- Using Document Map
- Making headers and footers
- Manage multi-page documents
Images and Drawing
- Insert, modify, format images
- Image borders and effects
- Textbox
- Drawing, modifying simple shapes
- Gridlines, alignment, distribution, order
- Grouping
Create a Circular Document
- Circular document types
- Letter
- Envelope
- Label
- Using an external data source
- Record selection
- Printing
Document Operations
- Watermark
- Proofing, protection
- Collation and merging of documents
- Page settings
- Printing
Microsoft Office Power Point Course
The primary goal of the Power Point course is to introduce to the Power Point Presentation Program to paticipants, which help us to provide a unique and outstanding presentation and report. For example, we will be able to create a product presentation that can be powered by graphics and sounds.
ApplyMicrosoft Office Power Point Course - Participants
We recommend the Power Point course to people who are already confident in Microsoft Office Word and are interested in presenting.
Microsoft Office Power Point Course - Preconditions
Basic understanding of using computer and the Internet.
Microsoft Office Power Point Course - Purpose
Participants will be introduced spectacular solutions for presentations, and will be able to create presentations with diagrams, videos, and effects.
Microsoft Office Power Point Course - Exam
Participants will take the exam of the Testing course in the last class of the course, and receive the certification after that.
Microsoft Office Power Point Course - Topics
Getting to Know the Power Point Application
- File management
- Using Help
- Power Point - Getting Started
- Import content
- Installation
- Layout
- Organize and format slides
- Publish your presentation
- Save and print
- Security and privacy
- Spelling and grammar, synonym dictionary
- Using patterns
- Using themes
- Videos
- Updates
- Working in another language
- Using animations
- Using diagrams
- Using clip art
- Using hyperlinks and action buttons
- Using movies
- Using images
- Using shapes
- Using SmartArt Graphics
- Using sounds
- Using tables
- Work with text
- Using WordArt Elements
- Using effects
- Extensions
- Accessibility
- Review and add comments
- Using templates
- Activating Power Point
- Joint work
- Create photo albums
- Create support materials
- Customizing Power Point
- Presentation of the presentation
Microsoft Office Excel Course
By completing the Excel course, you will be able to complete more serious office tasks, which can save you a lot of time and energy. In addition to creating tables, there are many excel functions in the materials that make our work simpler. By creating charts, you can create comprehensive and easy-to-understand statistics and profit and loss statements.
ApplyMicrosoft Office Excel Course - Participants
By completing the Excel course, you will be able to complete more serious office tasks, which can save you a lot of time and energy. In addition to creating tables, there are many excel functions in the materials that make our work simpler. By creating charts, you can create comprehensive and easy-to-understand statistics and profit and loss statements.
Microsoft Office Excel Course - Preconditions
Basic understanding of using computer. (Keyboard and mouse use shouldn't be a problem. Be able to create a folder, file operations – copy, paste, cut, delete, open, save - should be a routine for candidates.)
Microsoft Office Excel Course - Purpose
After completing the Excel course, it will take you less time and efforts to handle more difficult and complicated office tasks. Apart from guidance on creating tables, a number of excel function will be included in the curriculum, that can make our work more simple. Because of the comprehensive understanding of charts, gained in this course, Learner can figure statistics and financial reports out more easily and perfectly.
Microsoft Office Excel Course - Exam
Participants will take the exam of the Excel course in the last lesson of the course, and receive the certification after that.
Microsoft Office Excel Course - Topics
Getting to Know the Excel Interface
- File Formats
- Excel configuration options
- Quick Access Toolbar
- Customize Toolbar
- System Palette
- Migrate the previous version custom toolbar
- Local menus, local toolbars
Basic Knowledge for Quickly Managing Excel
- File Formats
- Excel configuration options
- Quick Access Toolbar
- Customize Toolbar
- System Palette
- Migrate the previous version custom toolbar
- Local menus, local toolbars
Changes in Formatting Tables
- Custom number formats
- Format Numbers in Thousands (e.g.: 25000 -> 25 000)
- Format Numbers in Thousands with any decimal and unit display (e.g.: 25,000 kg)
- Formatting codes
- Different formats for positive, negative, and 0 value
- Customize dates (e.g. Monday, Tuesday, Wednesday, etc. by date)
- Cell styles
- Using conditional formats
Basic Calculations
- Special options for filling in a formula
- Fill column in large table
- Fill in quickly without breaking the format
- Fill in a function that returns multiple values
- References in formulas
- One variable Data Table
- One variable Data Table
- Reference to another worksheet, workbook
- Reference array
Key Functions and Usage
- Use the Formulas tab
- Entering functions more conveniently by typing
- Simple Functions (some examples):
- Round function
- Date function
- Array formula
- Reference to a data table
- Other Simple Functions (SUM; COUNT; COUNT 2; COUNTBLANK; AVERAGE; AVERAGEA; MIN; MIN2; MAX; MAX2)
- Conditional Functions (SUMIF; COUNTIF)
Filtering Data in a Table
- Types of filters
- Options for applying filters
- Using a unified format
- Filtering options, text, number, color filtering
- Filter your data range
Changes in Charting
- Chart types
- Steps for creating charts
- Select source data
- Select chart format
- Modify chart properties
- Primary and secondary axes
- Show outstanding values on the chart
Advanced Functions and Worksheet Management
- Introduction to Search Functions
- VLOOKUP; HLOOKUP
- INDIRECT; INDEX; MATCH
- Function in function - Write complex functions easily
- Define areas
- Page setup
- Page setup in the new print layout
- Printing