n light of the huge amount of data that organizations need to manage and analyze, it has become necessary for today's organizations to master the basic skills necessary to deal with Microsoft Excel as a flexible tool in dealing with equations and statistics professionally. It is considered one of the most important pillars of the work of accountants, data analysts and administrators alike. This training program is designed to provide participants with the knowledge and skills they need to comprehend organizational intelligence through the ability to deal with functions, analyzing vast amounts of data, extracting accurate, actionable information, and presenting that to decision makers.
At the end of the training program, the participant should be able to:
1 Define Cell Ranges and Reference Them in Formulas
2 Perform Conditional Calculations
3 Carry Out Logical and Specialized Functions
4 Work with Date and Time Functions
5 Understand and Execute Text Functions
1 Sort and Filter Data
2 Learn the Capabilities of Database Functions
3 Query Data with Database Functions
4 Outline and Subtotal Data
1 Build and Modify Tables
2 Create Formatting Rules
3 Apply Conditional Formatting to Alter Groups of Cells
1 Organize and Represent Data with Charts
2 Modify and Format Charts
3 Search for and Replace Data.
4 Discover and Implement Advanced Chart Features
1 Create a Pivot Table
2 Analyze Pivot Table Data
3 Present Data with Pivot Charts
4 Filter Data Using Timelines and Slicers
Availability of a computer for practical application.
.
Familiar with navigating the Windows interface.
.
Basic knowledge of Excel 2016 including: formulas, functions, workbooks, and worksheet formatting.
.
Names of the training programs that are integrated (enriched) with the training program:
Names of the training programs that after the training program:
Not Available
Add Comment