- الفروع الأُخرى: البرشاء - دبي
- مدة الدورة التدريبية: 12 ساعة
- مواعيد الدورة: Flexible
تفاصيل الدورة
Microsoft Excel Intermediate1. Performing Calculations
- Naming groups of Data using Named Ranges
- Creating Formulas to Calculate Values
- Summarizing data meets specific condition
- using If function
- Formula Auditing
- Adding a watch Window o Tracing Formula Errors
- Changing workbook appearance
- Defining Styles
- Making Numbers easier to read
- Transposing data
- Changing Cell Orientation and Merging Cells
- Change appearance of data based on its value
- Focusing on specific data by using filters
- Inserting Filters
- Sort A to Z using Filters o Number Filters
o Advanced Filtering (Criteria Range) o Summarizing worksheets with hidden
and filtered rows (subtotal and aggregate functions)
- Data Validation
- Sort Data
- Custom Lists
- Organizing data into levels using subtotals
- Creating an outline
- Lookup Functions
- Using Excel’s Built-in Templates
- Using workbooks as templates for other workbooks
- Linking to data in other workbooks
- Consolidating data
- Saving workbooks as a workspace
- Comments in cells and workbooks
- Viewing Comments in a worksheet
- Adding and Removing comments
- Adding comments to a workbook
- Protection
- Password protect a worksheet and workbook
- Unlock cells and protecting part of a worksheet
- Track Changes
- Mark a workbook as final
تحديث بتاريخ 30 September, 2024
المتطلبات
Basic knowladge of computer and internet
وظائف مناسبة لهذه الدورة
Services Sales Manager , Business Development Leader , Senior Sales Professionalالموقع
Microsoft Excel أسئلة ذات صلة
استفسر عن هذه الدورة
يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.