دورة إكسل للمبتدئين والمتقدمين – دروس عملية

المصدر: David Hensley II

• How to Create a Table in Excel مقفل 2 د
• How to Sort and Filter Data in Excel مقفل 2 د
• How to Use SUM and AVERAGE in Excel مقفل 2 د
• Excel Absolute References: How to Lock Cells with $ مقفل 2 د
• How to Create a Drop-Down List in Excel (Data Validation) مقفل 2 د
• How to Use Conditional Formatting in Excel for Beginners مقفل 2 د
• How to Use the IF Function in Excel for Beginners مقفل 2 د
• How to Use SUMIF and COUNTIF in Excel مقفل 3 د
• How to Use XLOOKUP in Excel (Exact Match and Not Found) مقفل 2 د
• How to Create a PivotTable in Excel for Beginners مقفل 2 د
• How to Use SUMIFS and COUNTIFS in Excel مقفل 2 د
• How to Use IF with AND and OR in Excel مقفل 2 د
• How to Use XLOOKUP with Multiple Criteria in Excel مقفل 2 د
• How to Use the FILTER Function in Excel مقفل 2 د
• How to Use UNIQUE and SORT in Excel (Dynamic Lists) مقفل 2 د
• How to Create Dependent Drop-Down Lists in Excel مقفل 3 د
• How to Group Dates by Month and Year in an Excel PivotTable مقفل 2 د
• How to Add Slicers to an Excel PivotTable مقفل 2 د
• Excel Power Query for Beginners: Clean and Refresh Data مقفل 2 د
• How to Create an Interactive Sales Dashboard in Excel مقفل 2 د
• How to Convert Numbers Stored as Text in Excel مقفل 2 د
• How to Remove Duplicates in Excel Using Specific Columns مقفل 2 د
• How to Merge Two Tables in Excel with Power Query مقفل 3 د
• How to Combine Monthly Tables in Excel (Power Query Append) مقفل 2 د
• How to Unpivot Columns in Excel with Power Query مقفل 3 د
• How to Split a Column in Excel (Text to Columns) مقفل 3 د
• Excel Dates Won’t Sort Correctly? Convert Text to Real Dates مقفل 3 د