Excel Advanced
Mastering the use of Microsoft Excel is one of the basic skills that every professional has to know, and the Advanced Excel course is designed to enable participants to learn the practical skills needed to use Excel and to be able to use its various tools, including ways to prepare and build equations, comparisons, pivotal tables and extract data for decision-making, so that they will analyze the data advanced and extract results to make the right and appropriate decision using advanced mathematical formulas and use the necessary options to analyze and review data.
By the end of this program, each participant will be able to:
• Use advanced oxygen software mechanisms for the purpose of financial data analysis.
• Learn about the program's advanced capabilities that help speed up the completion and performance of the work.
• Use advanced equations to form a summary of databases.
• Use the excel program in managing the departments concerned with the processing of numbers.
• Create charts and learn how to link them to a database summary.
• Learn how to link tables electronically.
• Hide and protect equations.
• Use pivot table and Pivot Chart graphs
• Give participants the skills of excel uses in analyzing tables through practical application on the computer.
Course Curriculum
• Use cell references to create a simple formula in Excel.
• Create a complex formula in Excel.
• Relative and absolute cell references and how to use them.
• Functions.
• Track changes.
• Examining and protecting works.
• Pivot Tables cores.
• Pivot Tables properties and settings.
• Analysis of what if.
• Use Excel reference patterns.
• Use the drawing tab.
• Handle icons.
• Practical cases
• Finale
Instructor
Super admin
Administrator
Admin of ejaabi
Trainees Feedback
Reviews