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

Course Syllabus:

1. Introduction to Excel:

• Overview of the Excel Interface
  • Familiarize yourself with the Ribbon, Workbook, and Worksheet.
  • Navigate worksheets and workbooks effortlessly.
  • Learn how to create and save a new workbook.
• Basic Excel Terminology
  • Understand essential terms like cell, range, and formula.

2. Entering and Formatting Data:

• Entering Data
  • Input text, numbers, and dates accurately.
• Data Formatting
  • Apply basic formatting such as font, color, and alignment.
  • Utilize the Format Painter to copy formatting.
• Sorting and Filtering Data
  • Organize your data effectively using sorting and filtering tools.
• Introduction to Data Validation
  • Learn the basics of data validation for error-free data entry.

3. Working with Formulas and Functions:

• Understanding Formulas
  • Master the syntax and operators used in Excel formulas.
  • Perform basic arithmetic operations.
  • Differentiate between relative and absolute cell references.
• Common Formulas
  • Learn to use essential formulas like SUM, AVERAGE, MIN, and MAX.

4. Functions in Excel:

• Introduction to Functions
  • Get familiar with built-in functions to simplify complex calculations.
• Using Common Functions
  • Apply functions like IF, COUNTIF, and VLOOKUP.
• Nesting Functions
  • Combine multiple functions for more advanced formulas.
• Error Handling
  • Use functions like IFERROR to manage errors in your calculations.

5. Data Visualization:

• Introduction to Data Visualization
  • Understand the basics of representing data visually.
• Creating Charts
  • Build various chart types such as bar, line, and pie charts.
• Customizing Charts
  • Adjust chart elements like titles, labels, and colors.
• Using Sparklines
  • Add mini-charts to quickly visualize trends within a cell.

6. Conditional Formatting:

• Introduction to Conditional Formatting
  • Learn how to apply formatting rules based on cell values.
• Highlighting Cells
  • Use conditional formatting to make your data stand out.
• Data Bars, Color Scales, and Icon Sets
  • Explore different ways to visualize data using conditional formatting.
• Practical Applications
  • Apply conditional formatting techniques to real-world examples.

7. Advanced Features and Final Project:

• Introduction to PivotTables
  • Learn how to summarize large data sets using PivotTables.
• Creating and Modifying PivotTables
  • Master PivotTable customization for in-depth analysis.
• Using Slicers and Filters
  • Enhance your PivotTables with slicers and filters.
• Basic Data Analysis Tools
  • Get an introduction to Excel’s data analysis tools like What-If Analysis and Goal Seek.