<table class="altawail-two-col" width="100%"> <tbody> <tr><!-- Column 1 --></p> <td width="47%"><strong>What will I benefit?</strong></p> <p><strong> </strong>Provide the necessary knowledge and skills to deal with 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>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 conditional coordination skill</li> <li style="text-align: right">Master the data validation skill and data filtering</li> <li style="text-align: right">Deal professionally with logical, Statistical and search and functions</li> <li style="text-align: right">Use references options</li> <li style="text-align: right">Design charts</li> <li style="text-align: right">Take advantage of the tables</li> <li style="text-align: right">Use Macro</li> <li style="text-align: right">Protect data</li> </ul> <p><strong><strong>Target Audience: </strong></strong></p> <p>Individuals who need to use advanced functions in Microsoft Excel, use automated tools (Macro) and protect data</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">Use advanced functions (logical and lookup)</li> <li style="text-align: right">Use advanced filtering, sorting, and conditional formatting</li> <li style="text-align: right">Work with data validation tools</li> <li style="text-align: right">Use cell references in a formulas</li> <li style="text-align: right">Create tables and charts</li> <li style="text-align: right">Working with Macros</li> <li style="text-align: right">Protect data</li> </ul> <p><strong>Course Methodology</strong><strong>:</strong></p> <p style="text-align: right">This training course will be held in a computer lab where every participant will have his own computer to be able to learn and implement the different skills, where the trainer will perform the skill and the participants will follow by performing the same skill in their computers. </p> </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 formula-based)</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> </ul> <p style="text-align: right"><strong>Advanced data sorting and filtering</strong></p> <ul style="text-align: right"> <li>Examples</li> <li>Advanced filtering</li> </ul> <p style="text-align: right"><strong>Reference types in the formula</strong></p> <ul style="text-align: right"> <li>Create Range</li> <li>Relative reference</li> <li>Mixed reference</li> <li>Absolute reference</li> <li>3D references</li> </ul> <p style="text-align: right"><strong>Logical functions</strong></p> <ul style="text-align: right"> <li>IF function</li> <li>IFS function</li> <li>IFERROR function</li> <li>AND function</li> <li>OR function</li> </ul> <p style="text-align: right"><strong>Lookup functions</strong></p> <ul style="text-align: right"> <li>VLOOKUP function</li> <li>XLOOKUP function</li> </ul> </td> <!-- GAP Column --> <td width="6%"></td> <!-- Column 2 --> <td width="47%"> <p style="text-align: right"><strong>Charts</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>Sparklines</li> </ul> <p style="text-align: right"><strong>Tables</strong></p> <ul style="text-align: right"> <li>Examples</li> <li>Exercises</li> <li>Rename table name</li> <li>Format table</li> <li>Create formula in a new column</li> <li>Remove duplicate row</li> </ul> <p style="text-align: right"><strong>Automate processes with macros</strong></p> <ul style="text-align: right"> <li>Steps to create a micro</li> <li>How to put a button for the micro in the taskbar</li> <li>Use relative cell references when recording a micro</li> <li>Examples</li> </ul> <strong>Use form control buttons to create interactive worksheets</strong> <ul> <li style="text-align: right">Add a worksheet control</li> <li style="text-align: right">Examples</li> <li style="text-align: right">Exercises</li> </ul> <strong>Protect data</strong> <ul> <li style="text-align: right">Protect sheet</li> <li style="text-align: right">Protect workbook</li> </ul> </td> </tr> </tbody> </table>