Free Online Course Advanced Excel Skills
Excel is one of the most important programs used by departments and departments of finance, human resources, production, procurement, sales, marketing and IT management. Excel enables you to use many features that facilitate your daily work, and arrange financial and administrative matters in a better and easier way to access.
This training course is to consolidate the knowledge that the trainees have acquired at the beginner level of the Excel program, and is a starting point towards the advanced skills of the program. Where the trainee will be able to raise his efficiency in the mechanisms of building solutions by using equations and developing simple reports on the data. By using examples and data of actual companies, so that the application is supported with skills from the daily work of the trainee.
Departments: Through the Excel program, the administration can read the results, analyze them, study the mechanisms of work development and determine the basic performance indicators (KPI’s).
Human Resources Department: Through Excel, the company’s performance is managed and analyzed, 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 thoughtful plans.
Marketing: Excel is used in the analysis of sales of previous years and the study of mechanisms for determining marketing goals for the coming years. Marketing personnel can see analyzes related to data in several forms such as: charts and the results of reports related to sales.
Information Technology Department (IT) Department: The department is able to define basic performance indicators (KPI’s), such as managing risks related to information security by 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.
You will learn in this course:
Advanced basic skills for Excel program, and dealing with equations.
Formatting within Excel, table formatting and conditional formatting.
Building reports within the Excel program, and how to develop them.
Use ready-made report tools inside the Excel program.
Advanced Excel functions, and how to use them in a practical way.
Dealing with charts in Excel, and how to create many charts.
The first unit: advanced basic skills for the Excel program, and dealing with equations.
The second unit: the formats within the excel program, and the coordination of tables and conditional formatting.
The third unit: Building reports within the Excel program, and how to develop them.
The fourth unit: Using ready-made report tools inside the Excel program.
The fifth unit: advanced functions in the Excel program, and how to use them in a practical manner.
Module 6: Dealing with diagrams in the Excel program, and how to create many diagrams.