- 1 Section
- 29 Lessons
- 10 Weeks
Expand all sectionsCollapse 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
Difference Between Workbook and Worksheet
Next