Manage Course - ALTAWAIL

عنوان الصفحة في الموقع*

URL*

موضوع الدورة التدريبية*

اختر اسم الدورة التدريبية من القائمة المنسدلة*

ملف الدورة التدريبية*

أهداف الدورة التدريبية ( معلومات الدورة التدريبية)*

الفئة المستهدفة*

محاور الدورة التدريبة*

Excel interface

<ul dir="ltr" style="text-align: left">
 	<li>Excel interface in a glance</li>
 	<li>Create something</li>
 	<li>Search for recent files</li>
 	<li>keep connected</li>
 	<li>Discover contextual tools</li>
 	<li>Manage data using Excel tables</li>
 	<li>Share work with others</li>
 	<li>Insert functions and create formulas</li>
 	<li>Find anything you want</li>
 	<li>Find related information</li>
</ul>
Learn about the user interface and command bar

<ul dir="ltr" style="text-align: left">
 	<li>File tab</li>
 	<li>Quick Access Toolbar</li>
 	<li>The ribbon</li>
 	<li>The worksheet area</li>
 	<li>Status bar</li>
</ul>
Workbook and worksheet

<ul dir="ltr" style="text-align: left">
 	<li>Create a workbook</li>
 	<li>Close Excel</li>
 	<li>Close an Excel workbook</li>
 	<li>Save an Excel workbook</li>
</ul>
Design workbooks

<ul dir="ltr" style="text-align: left">
 	<li>Show and hide columns and rows</li>
 	<li>Hide columns</li>
 	<li>Show hidden columns</li>
 	<li>Freeze columns and rows</li>
 	<li>Unfreeze</li>
 	<li>Worksheets Create and rename worksheets</li>
 	<li>Move the worksheet inside the workbook</li>
</ul>
The basics of entering data into a worksheet

<ul dir="ltr" style="text-align: left">
 	<li>Move between worksheet cells</li>
 	<li>Cycle through worksheets in the same workbook</li>
 	<li>Enter data in the cell</li>
 	<li>Enter text or number in a cell</li>
 	<li>Enter a fixed-decimal number</li>
 	<li>Enter a date or time in a cell</li>
 	<li>Enter the same data in multiple cells simultaneously</li>
 	<li>Enter the same data on multiple worksheets simultaneously</li>
 	<li>Better show your work (format worksheet)</li>
 	<li>Align data within a cell</li>
 	<li>Merge cells, rotate and wrap text</li>
 	<li>Change the height and width of the cell</li>
 	<li>Number format</li>
 	<li>Format numbers as text</li>
 	<li>Wrap text in a cell</li>
 	<li>Enable text wrapping automatically</li>
</ul>
Tables

<ul dir="ltr" style="text-align: left">
 	<li>Create and format tables</li>
 	<li>Sort table data</li>
 	<li>Steps to sort the table</li>
 	<li>Filter data</li>
 	<li>Data filtering</li>
 	<li>Custom filter form</li>
 	<li>Filter data using slicer</li>
</ul>
Charts

<ul dir="ltr" style="text-align: left">
 	<li>Create a chart</li>
 	<li>Delete the chart</li>
 	<li>Add a title and layout for the chart</li>
 	<li>Change the layout of the chart</li>
 	<li>Change the appearance of the chart (style)</li>
 	<li>Add striking layout to your chart</li>
 	<li>Reuse charts by creating charts templates</li>
</ul>
Add, edit, find and delete rows using a data form

<ul dir="ltr" style="text-align: left">
 	<li>Learn about data forms</li>
 	<li>Add a form button to the bar</li>
 	<li>Use a data template</li>
 	<li>Add a new row of data</li>
 	<li>Search for a row by navigating</li>
 	<li>Search for a row by entering search criteria</li>
 	<li>Change the data in a row</li>
 	<li>Delete a row</li>
 	<li>Close a data form</li>
</ul>
Formulas and functions in Excel

<ul dir="ltr" style="text-align: left">
 	<li style="direction: ltr">Basic Mathematics in Excel</li>
 	<li>Addition</li>
 	<li>Subtraction</li>
 	<li>Multiplication and division</li>
 	<li>Using Functions</li>
 	<li>Addition function</li>
 	<li>Multiplication function</li>
 	<li>Sequence of arithmetic operations (priorities of arithmetic operations)</li>
 	<li>An overview of advanced formulas</li>
</ul>
Printing in excel

<ul dir="ltr" style="text-align: left">
 	<li>To print your business on excel</li>
 	<li>Select your printer type</li>
 	<li>Select what you want to print</li>
 	<li>Choose the page orientation</li>
 	<li>Select the paper size</li>
 	<li>How many copies do you want to print</li>
 	<li>Adjust page margins</li>
</ul>

منهجية الدورة*

الجدارة المستهدفة*

الجهة العالمية

PMI ILM atd PECB

معلومات الجهة العالمية*

اختر الفئة*

بيانات الدورة التدريبية