Hi i am SEM,
how can i help you

Semos Education Semos Education
  • Monday - Friday 9:00 AM - 10:00 PM CET
  • Call us now +44 7487633466
  • Keep in touch info@semosedu.com
EN / МК / RS
Кошничка
reserve a seat
  • Description
  • Content
  • Target Audience
  • Benefits
  • Certificates

This course shows learners the advanced options of the MS Excel 2016 application and gives way for more perfected, easier, and faster performance, as well as an approach to solve any type of a business problem. 

  • Insert of data 
  • Fast insert of data using AutoComplete 
  • Creation of working tables 
  • Modification of working tables 
  • Manipulation with working sheets 
  • Format of table 
  • Advanced format with all options of Format Cells 
  • Cell reference 
  • Work with formulas 
  • Use of Advanced Built-In functions in Excel (Sum, Average, Max, Min, Count, Count blank, Counta, Product, Round, If….) 
  • Functions: COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, SUMIF, SUMIFS, IF и Nested IF, VLOOKUP, INDEX, MATCH, DATE, TEXT, LEFT, MID, RIGHT, UPPER, LOWER, DCOUNT, DSUM 
  • Prevent invalid data entry in a worksheet – Data Validation 
  • Conditional Formatting 
  • Work with Table as a database 
  • Task 
  • Visual presentation of data 
  • Advanced use of charts 
  • Organize and analyze data 
  • Grouping of data 
  • Filter: AutoFilter, Custom Filter, Advanced Filter 
  • Work with large tables 
  • Freeze rows and columns 
  • Work with Pivot Table 
  • Work with Macros 
  • Data protection with Protect Document 
  • Print preview and print 
  • Analysis tools: What – if 
  • Final task 

This course is aimed at:

 

  • Anyone who wants to upgrade their basic tools for table calculations, statistical data, financial analysis, and visual representation using graphs.

By the end of this course, students will be able to:

 

  • Work with linked Excel documents  
  • Use advanced Excel functions 
  • Validate data 
  • Use Paste Special command 
  • Analyze data 
  • Know conditional formatting 
  • Use pivot tables 
  • Take the Microsoft Office Specialist for Excel exam, which is not included in the price.

 

 

The Microsoft Office Specialist Certificate (MOS) is one of the world’s leading IT certificates. This globallyaccepted certificate is a qualification based on the standards for assessing the knowledge and skills for productive use of Microsoft Word.

Course attendance certificate issued by Semos Education

 

By passing the exam, you acquire an internationally recognized certificate – Microsoft Office Specialist for the corresponding Microsoft Office application.

 

 

The Microsoft Office Specialist (MOS) certification is one of the most sought after leading IT certifications in the world.

 

The certificate is accepted globally and represents a qualification based on standards for evaluating knowledge and skills for productive use of Microsoft Office Excel.

Description

This course shows learners the advanced options of the MS Excel 2016 application and gives way for more perfected, easier, and faster performance, as well as an approach to solve any type of a business problem. 

Content
  • Insert of data 
  • Fast insert of data using AutoComplete 
  • Creation of working tables 
  • Modification of working tables 
  • Manipulation with working sheets 
  • Format of table 
  • Advanced format with all options of Format Cells 
  • Cell reference 
  • Work with formulas 
  • Use of Advanced Built-In functions in Excel (Sum, Average, Max, Min, Count, Count blank, Counta, Product, Round, If….) 
  • Functions: COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, SUMIF, SUMIFS, IF и Nested IF, VLOOKUP, INDEX, MATCH, DATE, TEXT, LEFT, MID, RIGHT, UPPER, LOWER, DCOUNT, DSUM 
  • Prevent invalid data entry in a worksheet – Data Validation 
  • Conditional Formatting 
  • Work with Table as a database 
  • Task 
  • Visual presentation of data 
  • Advanced use of charts 
  • Organize and analyze data 
  • Grouping of data 
  • Filter: AutoFilter, Custom Filter, Advanced Filter 
  • Work with large tables 
  • Freeze rows and columns 
  • Work with Pivot Table 
  • Work with Macros 
  • Data protection with Protect Document 
  • Print preview and print 
  • Analysis tools: What – if 
  • Final task 
Target Audience

This course is aimed at:

 

  • Anyone who wants to upgrade their basic tools for table calculations, statistical data, financial analysis, and visual representation using graphs.
Benefits

By the end of this course, students will be able to:

 

  • Work with linked Excel documents  
  • Use advanced Excel functions 
  • Validate data 
  • Use Paste Special command 
  • Analyze data 
  • Know conditional formatting 
  • Use pivot tables 
  • Take the Microsoft Office Specialist for Excel exam, which is not included in the price.

 

 

The Microsoft Office Specialist Certificate (MOS) is one of the world’s leading IT certificates. This globallyaccepted certificate is a qualification based on the standards for assessing the knowledge and skills for productive use of Microsoft Word.

Certificates

Course attendance certificate issued by Semos Education

 

By passing the exam, you acquire an internationally recognized certificate – Microsoft Office Specialist for the corresponding Microsoft Office application.

 

 

The Microsoft Office Specialist (MOS) certification is one of the most sought after leading IT certifications in the world.

 

The certificate is accepted globally and represents a qualification based on standards for evaluating knowledge and skills for productive use of Microsoft Office Excel.

Past experiences

What people say about us

  • - Angela Petreska Accredited Academy for Interior Design

    The three things that left the biggest impression on me are the excellent communication with the entire team at Semos Education, the experienced instructors who possess vast knowledge and convey it to us in a fun and professional manner, and of course, the camaraderie within our group.

  • - Nikolina Petrovska Student

    I chose Semos Education because it is the number 1 educational center where everyone can enhance, share, and realize their knowledge and skills

  • - Ivana Ikonomova Accredited Academy for Human Resources

    I would like to contribute and show them how, through creative and practical solutions, they can fulfill their personal potentials, as well as the goals of the company they work for.

  • - Viktorija Georgieva Summer Mentorship Program for Python Develope

    The reputation of Semos Education for quality training and the opportunity to learn from experienced instructors played an additional significant role in my decision.

  • - Borche Peltekovski Accredited Academy for Graphic Design

    After completing my studies at Semos Education, I envision myself working in a technology company, such as Samsung, Apple, or a company of similar caliber.

Meet the instructors

  • Blagica Blazheska  

    Microsoft Office Trainer

    @Semos Education

     

    22+ years of experience

  • Gorica Miceva  

    Informatics teacher

    @“Dimkata A.Gaberot”

     

    13+ years of experience

Contact