MS Word Excel PowerPoint Course

MS Word Excel PowerPoint Course

Number of lessons 10

Time spent on a lesson 1:30h

Number of lessons: 10 lessons

Lesson Duration: 1h 30 min

Course Format։ Face-to-face learning

Number of participants։ 10 person

Course Fee։ 35․000 AMD (Group)

Venue։ IBT Educational Center, Citadel Business Center, 105/1 Teryan, Yerevan

Who is the course intended for?

The Word Excel PowerPoint course is designed for office workers, trainers, marketers, as well as those who want to deepen their knowledge of Word Excel PowerPoint. At the end of the course, the participating student will gain basic and intermediate knowledge of Word Excel PowerPoint software, study tools, formulas that will allow him/her to create documents, spreadsheets, make presentations and automate the calculations.

Course benefits

• The course includes practical tasks, theoretical materials, video lessons,
• Basic + intermediate level training
• Free consultation on your work files,
• Small groups, maximum 10 person,
• Individual approach to each participant
• Each student is provided with a computer,
• Course participation: online and offline formats,
• Day and evening groups,
• Catch up the missed classes with the next group,
• There is no age restriction and no prior knowledge is required for the participation in the course. 

Course Content

Lesson 1.

• MS Word interface, elements
• Text settings and formatting
• View Modes
• Data Numbering/Bullets
• Data Sorting
•  Data Find&Replace
•  Table Creation

Lesson  2.

• Picture Importing  
• Insert Figures (Shapes)
• Creating Graphic Images (SmartArt)
• Insert Diagrams, Types, Formatting (Chart)
• Header և Footer Creation
• Page Numbering
• Symbol Insertion
• Automatic content creation (Table of Content)

Lesson 3.

• Page layout (Watermark, Page Color, Borders and Shading)
• Adjust page margins, position and size  (Page Setup)
• Compose text in columns (Columns)
• Insert footnotes in the text
• New Comments

Lesson 4.

• MS PowerPoint Interface, Elements 
• Creation of slides and insertion of the required elements
• Picture Importing  
• Music Installation
• Slide formatting
• Selection of the general slide and individual image animations
• Page Numbering
• Header and Footer Creation
• Presentation
• Photo album creation

Lesson 5.

• MS Excel interface, elements, its regulation
• Workbook structure and elements
• Insertion of formulas (functions)
• Percentage and share calculation
• Formatting of cells, ranges, and tables
• Relative and absolute links, links to the other newspapers and other files

Lesson 6.

• Data types and formats in Excel (Cells format)
• Data Filtering and Sorting
• Data Find&Replace
• Tabel Transpose
• Copy-Paste Special Types

Lesson 7.

• Data analysis Pivot Table
• Search and hyperlink functions: Vlookup, Hlookup
• Duplicates removal
• Insert Diagrams, Types, Data Source (Chart)

Lesson 8.

• Logical functions: If, Or, And
• Spreadsheets printing, additional settings (Print)
• Strengthening and loosening of rows, columns, sections
• View Modes

Lesson 9.

• Mathematical functions: Sum, Sumif, Sumifs
• Statistical functions: Count, Counta, Countblank, Countif, Countifs, Max, Min, Average, Averageif
• Lists Comparison

Lesson 10.

• Drop Down List (Data Validation)
• Word and Excel program combination
• Link insertion types with the Hyperlink tool  
• Cell and workbook protection
• Text to columns
• Google Sheets Application
• Тesting
• Summary