MS Excel Advanced هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

The MS Excel (Advanced) program is a 35 hour module .

Course Content : 

Formulas and Functions (basic and more complex, including absolute cell referencing), sum ifs and countifs, pivot table and pivot chart, vlook up & hlookup, data validation, goal seek, hyperlink, name manager, advance filter, scenario manager, quick access tool bar, formula auditting, conditional formatting, subtotal,group,ungroup, data table, remove duplicates, consolidation, watch window, text to columns, custom views, comment, paste special, track , sorting and filtering data, data protection. تحديث بتاريخ 19 February, 2018