Excel Fundamentals

Basic Level

By: Mr. Mamdouh Gouda

Duration: 2h / 9 lessons

level

Level: General

Course Language: Arabic

30-Days Money Back Guarantee

By the end of this course, you will be able to:

Understand the Excel interface, basic layout, and commonly used terminology.

Create, open, save, and organize Excel workbooks and worksheets.

Enter, edit, and format data efficiently within Excel cells.

Apply different formatting techniques to create clear and professional spreadsheets.

Use basic formulas and functions to perform calculations accurately.

Understand cell references and use relative, absolute, and mixed references effectively.

Sort, filter, and organize data using Excel's built-in data tools.

Use Tables, Range Names, and Data Validation to manage and control data efficiently.

Create and customize charts and visualizations to present data clearly.

Use basic Excel functions to analyze and work with data effectively.

Create professional reports using PivotTables and PivotCharts.

Apply basic Excel shortcuts and productivity techniques to work more efficiently.

Prerequisites:

  • A laptop or PC running Windows 10 or higher.
  • Basic familiarity with computers. [Optional but recommended.].
  • Microsoft Excel 2016 or higher is recommended, including Microsoft 365.

Syllabus:

  • Module 1: Excel Basics, Interface & Data Entry..
  • Module 2:- Formatting, Formulas & Basic Functions.
  • Module 3:- Data Management, Sorting, Filtering & Validation.
  • Module 4:- Data Management, Sorting, Filtering & Validation.

Support

Whatsaap