Remote Course for Advanced MS Excel 2019

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 globally–accepted 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

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.

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.

Our students for 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