MS Advance course

Image

MS Advance course

4 Days

Course Overview

Excel is one of the most important programs, financial versions, settings, human resources, production, purchasing, sales, management, commercial marketing and e-commerce.

This training course is acquired by the trainees at the advance level of the Excel program. It is also considered the stage of starting skills towards training. Where the trainee will be able to raise his efficiency in the mechanisms of building solutions to equations and developing reports on the data level. Through the use of data and data of actual companies, the application is supported by information from the daily work of the trainee.

Where Excel is used in sections as follows:

Departments: Through the Excel program, the department can read and analyze the results, study the mechanisms of work development, and determine the key performance indicators (KPI's).

Human Resources Department: The company’s performance is managed and analyzed through Excel, and the development mechanisms for employees are studied to reach the best possible performance within the work for employees.

Sales: One of the most important programs that a marketing employee must master is the Excel program, to enable him to analyze the labor market, determine market requirements, and study business objectives to reach the best results. And increase the number of customers based on well-thought-out plans.

Marketing: Excel is used to analyze sales of previous years and study the mechanisms of determining marketing goals for the coming years, whereby marketing staff can view analyzes related to data in several forms, such as: graphs and results of reports related to sales.

Management of the Information Technology (IT) Department: The department is able to identify key performance indicators (KPI’s), such as managing information security risks through studying and analyzing daily events within the department, which enables it to determine the department’s future plans and budget.

Financial departments: The financial departments can determine the financial position of the company, study the financial plans for the coming years, and determine ways to manage expenses and increase profits.


Location

Al Azaiba South, Muscat


Date


Fees

Per participant - 80 OMR (Fees + VAT as applicable)


Course Outline

COURSE OBJECTIVES

   1- Advanced basic skills for Excel, and dealing with equations.

   2- Formatting within Excel, formatting tables and conditional formatting.

   3- Building reports within the Excel program, and how to develop them.

   4- Use the ready-made report tools within the Excel program.

   5- Advanced functions in the Excel program, and how to employ them in practice.

   6- Dealing with charts in Excel, and how to create many charts.

COURSE MODULES 

   1) Use Formatting Functions

   2) Working with Data

   3) Analyzing Data

   4) Working with Data Tools

   5) Sharing Workbooks

   6) Macros

COURSE METHODOLOGY

4 Day Course- 4 hours Each day

Total:16 hours 

COURSE PREREQUISITES 

Understanding of the basics of Excel  

TARGET AUDIENCE

Employees of Al Tasnim Enterprises LLC


Teacher Profile