<table class="altawail-two-col" width="100%"> <tbody> <tr><!-- Column 1 --></p> <td width="47%"><strong>What will I benefit?</strong></p> <p>Provide the necessary knowledge and skills to deal with and analyze advanced numbers, formulas, functions and graphs, using Microsoft Excel, so that you can take advantage of the capabilities and features of the program to perform your business and daily tasks efficiently and effectively </p> <p><strong> </strong><strong>Course Objectives:</strong></p> <p style="text-align: right"><strong>At the end of this course, the participants should be able to</strong></p> <ul> <li style="text-align: right">Master the data validation skill and data filtering</li> <li style="text-align: right">Deal professionally with logical, Statistical, search and reference, text functions</li> <li style="text-align: right"> Use data cleaning tools</li> <li style="text-align: right">Professional graphic design</li> <li style="text-align: right"> Take advantage of the capabilities of pivot tables and charts</li> <li style="text-align: right"> Create dashboard</li> <li style="text-align: right">Create interactive worksheets and analyze data using what-if</li> </ul> <p><strong><strong>Target Audience: </strong></strong></p> <p>Individuals who need to use Pivot Tables and Pivot chars and more advanced functions to analysis a data in Excel.</td> <p><!-- GAP Column --></p> <td width="6%"></td> <p><!-- Column 2 --></p> <td width="47%"><strong><strong>Target Competencies </strong></strong></p> <ul> <li style="text-align: right"> Analyze Data Using Advanced Functions in Excel</li> <li style="text-align: right">Working with Data</li> <li style="text-align: right">Creating and Working with PivotTables and Pivot charts</li> <li style="text-align: right">Creating Dashboard</li> <li style="text-align: right">Using data Analysis Tools</li> </ul> <p><strong>Course Methodology</strong><strong>:</strong></p> <p style="text-align: right"><strong>This training course will be carried out through the use of best practices and the right combination of engaging and purposeful tools such as:</strong></p> <ul> <li style="text-align: right">Practical, relevant case studies</li> <li style="text-align: right"> Group activities and workshops</li> <li style="text-align: right"> Related role plays</li> <li style="text-align: right">Experiential learning</li> <li style="text-align: right"> Brainstorming</li> <li style="text-align: right"> Stimulating mental activities</li> </ul> </td> </tr> </tbody> </table>

<table class="altawail-two-col" width="100%"> <tbody> <tr><!-- Column 1 --> <td width="47%"> <p style="text-align: right"><strong> Conditional formatting (Advanced)</strong></p> <ul style="text-align: right"> <li>Examples</li> <li>Exercises</li> </ul> <p style="text-align: right"><strong> Data Validation</strong></p> <ul style="text-align: right"> <li>Examples</li> <li>Exercises</li> <li>Create dependent drop-down list</li> </ul> <p style="text-align: right"><strong> Text to Column</strong></p> <ul style="text-align: right"> <li>Examples</li> <li>Exercises</li> </ul> <p style="text-align: right"><strong>Logical functions </strong></p> <ul style="text-align: right"> <li>IF function</li> </ul> <p style="text-align: right"><strong> Statistical functions</strong></p> <ul style="text-align: right"> <li>SUMIFS function</li> <li>AVERAGEIFS function</li> <li>COUNTIFS function</li> </ul> <p style="text-align: right"><strong>Text functions</strong></p> <ul style="text-align: right"> <li>TRIM function</li> <li>LEFT function</li> <li>RIGHT function</li> <li>MID function</li> </ul> <p style="text-align: right"><strong>Advanced search and reference functions</strong></p> <ul style="text-align: right"> <li>VLOOKUP function</li> <li>XLOOKUP function</li> </ul> <p style="text-align: right"><strong>Advanced graphics</strong></p> <ul style="text-align: right"> <li>Create a chart at a glance</li> <li>Create a stacked vertical bar</li> <li>Working with pie charts</li> <li>Mixed charts</li> <li>Create progress charts toward the goal</li> <li>Save charts as templates</li> <li>Freezing schemes</li> <li>Sparklines</li> </ul> </td> <!-- GAP Column --> <td width="6%"></td> <!-- Column 2 --> <td width="47%"> <p style="text-align: right"> <strong>Tables</strong></p> <ul style="text-align: right"> <li>Create table</li> <li>Exercises</li> <li>Rename table name</li> <li>Add columns and rows</li> <li>Filter data</li> <li>Create formula</li> <li>Use total row</li> <li>Remove duplicate row</li> </ul> <p style="text-align: right"><strong> Pivot tables and charts</strong></p> <ul style="text-align: right"> <li>Examples</li> <li>Exercises</li> <li>Rename the pivot table</li> <li>Some operations on pivot tables</li> <li>Combine pivot tables</li> <li>Calculated fields and items</li> <li>Using Slicer</li> <li>Refreshing Data</li> <li>Pivot charts</li> </ul> <p style="text-align: right"><strong>Dashboard</strong></p> <ul style="text-align: right"> <li>What is dashboard</li> <li>Create dashboard</li> <li>Format dashboard</li> </ul> <p style="text-align: right"><strong>Data analysis using What-if analysis?</strong></p> <ul> <li style="text-align: right">Analyze data with targeting</li> <li style="text-align: right">Analyze data using scenarios</li> <li style="text-align: right">Analyze data with Solver</li> </ul> </td> </tr> </tbody> </table>