أنشئ حسابًا

التسجيل المبكر مفتوح

مبتدئ · الإنجليزية

Data Analysis with Excel

You leave with an organised Excel file that turns training data into a summary and results you can interpret.

تحت إشراف ⁨Sultan Al-Mutairi⁩Presented by Maha, Ali and Khlood, ZERAX’s virtual trainers

٢٧٠٣٩٠

للمتدرب الواحد

توفّر ١٢٠ ر.س (٣٠٪)

  • احجز بسعر التسجيل المبكر بدون ما تدفع شيء اليوم، ونتواصل معك أول ما يفتح التدريب.

عن التدريب

The training takes you from an unorganised spreadsheet to a simple analytical report. You apply cleaning steps, functions and PivotTables, then show what the numbers mean and what cannot be concluded from them.

ماذا ستتعلّم

بعد هذا التدريب تستطيع أن:

  1. ١

    Clean data that has duplicates, missing values and inconsistent dates.

  2. ٢

    Use conditional and aggregate functions to analyse specific questions.

  3. ٣

    Build a PivotTable and a chart suited to comparison.

  4. ٤

    Check the report's totals and explain three findings grounded in the data.

البرنامج

Five units of two hours each. Suggested pace: five meetings or learning sessions of two hours each, over one to two weeks, as the learner's schedule allows.

المستوى
مبتدئ
اللغة
الإنجليزية
الإيقاع المقترح
10 training hours including activities and assessment
  1. ١

    Preparing the data

    • Table structure and data types٣٠ دقيقة
    • Sorting, filtering and removing duplicates٣٠ دقيقة
    • Application and comprehension check: cleaning a training registration fileساعة واحدة

    ساعتان

  2. ٢

    Basic functions

    • Relative and absolute references and aggregate functions٣٠ دقيقة
    • IF, SUMIF, COUNTIF and handling errors٣٠ دقيقة
    • Application and comprehension check: calculating a summary by a given categoryساعة واحدة

    ساعتان

  3. ٣

    Analysis with PivotTables

    • Building PivotTables and grouping data٣٠ دقيقة
    • Changing levels of analysis and checking totals٣٠ دقيقة
    • Application and comprehension check: analysing participation by college and periodساعة واحدة

    ساعتان

  4. ٤

    Presenting the results

    • Choosing the right chart and formatting the report٣٠ دقيقة
    • Interpreting results and avoiding misleading comparisons٣٠ دقيقة
    • Application and comprehension check: preparing a summary with three findingsساعة واحدة

    ساعتان

  5. ٥

    The applied project

    • Building a report from a raw file٣٠ دقيقة
    • Testing formulas and reviewing report quality٣٠ دقيقة
    • Application and comprehension check: submitting the analysis file and recommendationsساعة واحدة

    ساعتان

ما يميّز هذا التدريب

  • (٠١)أكاديمية زيركس

    10 hours

    Of training, activities and assessment

    Suggested self-paced content on ZERAX, with virtual trainer support and feedback on activities

  • (٠٢)أكاديمية زيركس

    5 units

    Each unit lasts two hours

    Short activities tied to situations at university and at the start of work

  • (٠٣)أكاديمية زيركس

    Project

    Project submitted against a checklist

    A defined project that can be added to the learner's portfolio after review

المشروع ومخرجات الإتمام

An Excel file with cleaned data, functions, a PivotTable, a chart and three documented findings.

Suggested completion method: finishing the lessons and activities and submitting the project against a checklist covering the accuracy, completeness and clarity of its presentation. ZERAX approves the assessment policy and the issuing of the completion certificate before launch.

لمن هذا التدريب

Basic knowledge of cells and rows, and a computer with Excel. Basic, widely compatible functions are used, allowing for differences in interface language.

  • Students of management, finance, engineering and other disciplines that work with spreadsheets.
  • Those heading into a training placement that requires reports and indicator tracking.

لمن لا يناسب

  • Anyone who needs advanced financial models or VBA programming.

قبل أن تبدأ

Do I need to be advanced in Excel?

No, knowing how to enter data and move between cells is enough; the training starts from the analytical basics.

How much time do I need?

The training totals ten hours, including the lessons, the application work and the project; they can be spread over five sessions of two hours each.

Can it be offered to a university group?

A proposed offer can be prepared for the group; delivery, support and cost arrangements are agreed with ZERAX.

Register now and start at the early-registration price when the training opens

احجز مكانك بسعر الخصم المبكر (الدفع لاحقاً)، وراح نراسلك أول ما نبدأ.

٢٧٠ ٣٩٠
توفّر ١٢٠ ر.س (٣٠٪)

ZERAX

تدريبات قصيرة يكتبها أهل الميدان، بالعربية، تنتهي بشهادة باسمك.

© ٢٠٢٦ زيركس