Advanced Excel course

About Trainer

Mostafa Fouad .. Certified trainer with 16 educational institutions.
He has experience in the Excel and has worked in this field for 14 years.
He started his training journey in 2014 with governmental and
private institutions inside and outside Jordan.

Course Information

The course is offered by WIOH & ASDC

Level	Advance
Specialization	Computer Science (Microsoft Excel)
Language	Arabic
Duration	18 Hours
Location	Online by Zoom platform
Final test	Yes
Certificate	Accredited by the Warsaw University of Life Sciences
Trainer	MOUSTAFA FOUAD

About the course

The goal of this course is to provide trainees with :

Theoretical and practical concepts in the uses of Microsoft Office and the importance of their application in the business environment.
Fundamentals and principles of electronic trading uses Microsoft Excel.
Practical applications of Microsoft Excel and electronic spreadsheet management and their applications in the business environment.

Course Content :

Starting the training process

Discuss the training agenda.
Brainstorming of the trainees.

Processing of electronic tables: MS Excel

Tables, drawings and other object:

Using tables in Excel.
Add other elements in Excel.
Cases and practical applications.

Text processing:

Printing documents.
Merging correspondences.
Formulas and connotations.
Cases and practical applications.

Cell coordination and worksheets:

Preparing a working paper.
Alignment and boundaries.
Number format.
Cell contents format.
Charts and diagrams.
Use of charts and graphs.
Cases and practical applications.

Preparing the output:

Preparing a working paper.
Print a worksheet.
Cases and practical applications.

Using Excel:

Start working with Excel.
Modify the basic settings.
First steps with worksheets.
Cases and practical applications.
Entering and editing data.
Data inclusion.
Data selection.
Data sorting.
Fill in data.
Editing of data.
Search and replace.
Rows and columns.
Verification of entering values.
Duplicate, transfer and delete cell contents.
Cases and practical applications.
Use advanced formulas to create a summary of databases.

Working papers:

Transfer work papers.
Insert a new working paper.
Change the name of the worksheet.
Delete and copy the worksheet.
Cases and practical applications

Microsoft Excel applications in the business environment:

Organize the pages:

The concept of Excel in action.
The importance of Excel at work.
Components of the Excel software in action.
Dealing with the data file at work.
Manage the pages on the excel program.
Organizing the pages on the excel program.

Graph the data ( Charts )

Data representation steps
Criteria for choosing the appropriate representation of the data.

Formulas and functions:

Financial functions.
Logical functions.
Other functions.
Statistical functions.
Search functions.
Verify the formula of the functions.
Business model Solver.
Create the sample table (Table Perfect).
Setting the goal.

Data management:

Filter & Advanced Filter.
Pivot table.
Create a DashBoard dashboard.
Microphone recording and activation.

Advanced Excel Skills:

Using search formulas and linking them to databases.
Mechanism for the preparation of the automated coordinates.
Using the automatically defined menus.
The use of statistical equations in a simple and complex way.
Create pivot tables and learn to control them.
Create conditional data formats in a simplified, then advanced, conditional formatting.
Hide and protect equations and file protection.
Using the advanced mechanisms of Excel for the purpose of analyzing financial data.
The mechanism of dealing with days in the environment of Axel.

Practical applications on Excel:

Practical cases in the accounting fields.
Practical cases in the financial fields.
Practical cases from an administrative point of view.