- القسم 1
- 29 Lessons
- 10 أسابيع
قم بتوسيع جميع الأقسامCollapse all sections
- أساسيات Microsoft Excel للمبتدئين29
- 1.1Introduction to the Excel Interface
- 1.2Difference Between Workbook and Worksheet
- 1.3Data Types Text – Number – Date
- 1.4File Navigation and Basic Shortcuts
- 1.5Data Entry and Editing
- 1.6Cell Formatting Font, Color, Borders
- 1.7Rows and Columns Control
- 1.8AutoFit
- 1.9Basic Formulas SUM
- 1.10AVERAGE Function
- 1.11Data Filtering
- 1.12Data Sorting
- 1.13IF Function
- 1.14Logical Functions
- 1.15VLOOKUP
- 1.16HLOOKUP
- 1.17COUNTIF COUNTIFS
- 1.18SUMIF SUMIFS
- 1.19Text Functions
- 1.20Date and Time
- 1.21Conditional Formatting
- 1.22Data Validation
- 1.23Pivot Tables
- 1.24Practical questions on pivot tables in sales
- 1.25Advanced pivot tables
- 1.26Power Query
- 1.27Power Query MERGE
- 1.28Index & Match
- 1.29Power Pivot
This content is protected, please تسجيل الدخول and إلتحاق in the course to view this content!