كورس الاكسل المتقدم

اكسل متقدم Excel Advanced

TOPICS COVERED

Proper data set rules (Excel Golden Rules)

Normal Table vs Excel Table.

Advanced Sort

Cell Reference

Normal IF vs. Nested IF Function

Remove Duplicates

Range Naming

Data Validation

TEXT TO COLUMNS

Filtering data with Advanced Filter

Advanced Filter with Macro

Concatenate

Flash Fill

Charts

Indirect Function

Undocumented DateDif Function

Toady Function

Subtotal

Index and Match

SUMIFS 

COUNTIFS

Linking sheets and workbooks

Protection

VLOOKUP and Match

Pivot Table

Conditional Formatting

Revision

End of course Tes        

Toll

Certificates giving

Evaluation Form