Data analysis

The overall objective of the program:

Providing the trainees with the skills of analyzing and presenting data by collecting and recording data, facts and information related to a particular problem or topic (administrative, technical, legal, medical or political) and other fields within agreed terms and bases, and standards followed in this field, and displaying them clearly and expressive.

The program axes:

• Data analysis techniques and tools
• Mastering reporting data
• Data collection and modeling
• Techniques of imaging and design of charts and graphs
• Tips and tricks

The detailed objectives of the program:

• Create pivot tables
• Number formation techniques
• Designing report forms
• Ascending or descending order and other options
• Filter values ​​and tags
• Expand and summarize reports
• Summarize data by properties: sum, average, minimum, upper bound, sum,average,minimum,maximum,count
• Show the percentage of values ​​%
• Pivot table options
• Entering equations
• data analysis
• Copy pivot tables
• Create pivot charts
• Dynamic Charts Label
• Master the slicer data filter option
• Show report filter pages
• Link pivot tables to graphs and PowerPoint
• Conditional formation of pivot tables
• Design reports using getpivotdata
• Checking for data box modeling with the if property
• Option to model data boxes with the if property
• Scenario Management
• Link excel with text files
• Linking Excel with the database program (Access)
• Connecting Excel with Databases (SQL)
• Connecting Excel to the Internet.
• Use the camera tool
• Dealing with pictorial charts designed from data formats
• Use different fonts
• Add icons and shapes
• Dealing with spark lines
• Create unconventional charts
• Monitor and protect your reports and data files
• data entry form
• Custom Menus
• Advanced Conditional Formatting
• Daily Work Shortcuts

Target Program Category :

• middle management managers
• Employees in information management centers
• Statistical Analysts

  For inquiries through WhatsApp: 00966539103433 -Press here

Registration fees : 1250.00

Early registration fees : 937.00

All fees are inclusive of 15% value added tax.

The Tax number is: 310862967200003