Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    Excel From Zero

    Uploaded by

    nadaelghar

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Excel From Zero

    Uploaded by

    nadaelghar
    6 views5 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    6 views5 pages

    Excel From Zero

    Uploaded by

    nadaelghar

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 5

    Training proposal

    Excel

    Course Name & Duration


    • Excel Course (From basic to Advanced)
    ‫الإكسيل من البداية و حتى الإحتراف‬

    Course Venue
    • Company venue, 10th of Ramadan City25 ‫فى مقر الشركة بالعاشر من رمضان محاوره‬
    • Interactive Online Zoom Sessions ‫متاح اون لاين محاضلرات تفاعلية ببرنامج زووم‬

    Course Objectives
    • Build a solid understanding on the Basics of Microsoft Excel
    • Learn the most common Excel functions used in the Office
    • Harness the full power of Microsoft Excel by automating your day to day tasks
    • Maintain large sets of Excel data in a list or table
    • Create dynamic reports by mastering one of the most popular tools, PivotTables
    • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX,
    MATCH functions and many more
    • Connect & Load your data from different extension sources
    • Transform data using power query
    • Modeling data
    • Visualize your data using Power Bi

    Course Content
    1. Data Quality 2. Excel interface
    3. Types of References 4. Handle Fill
    5. Formatting 6. Filter – find – replace – Conditional Formats
    7. Shortcuts 8. Basic Formulas
    9. Most Common used Functions 10. Counts
    11. Logical test & Functions 12. Define Names & drop List
    13. Look up Formulas 14. Goal Seek
    15. Sum Ifs – Counts Ifs
    ita
    EDUCATION - TRAINING
    ENGINEERING

    Target Audience
    • All employees and Managers/Directors (All Disciplines)
    ‫متاح لكل العاملين و حديثى التخرج و المديرين و الإداريين و كل من ليس له خبره او معرف ببرنامج‬
    ‫الإكسيل‬

    Course Language
    • Arabic but most terminology is in English. ‫بالعربى و لكن بعض مصطلحات البرنامج‬
    ‫بالانجليزى‬
    • Training can be presented in English only based on request. ‫يمكن الشرح بالانجليزى كاملة‬
    ‫بناًءا على طلب المتدربيين‬

    Course Methodology
    Training methods and techniques are almost infinite in their variety. They can be used on
    their own or in creative combination. However, they should be chosen carefully to fit the
    activity, the nature of participants, the cultural milieu and the facilities available for using
    them.
    We use different methodologies in training to ensure good communication of information
    to all trainees - but not limited to the following:

    • Lectures and PowerPoint Presentation


    • Case Studies, Self-Questioner and Real-World Scenarios
    • Visual Aid (Videos Simulation)
    • Brainstorming (Perception Activity)
    • Gamification (Puzzles)

    Hands-On Simulations

    Few things are better remembered and understood which can be touched and used in
    training classroom.

    Course Prerequisites
    • Laptops should provide with each participants ‫يجب الحضور باللاب توب الشخصى‬
    ‫للمتدرب‬

    Course Duration
    • 7 Days (21-hours) ‫ ايام‬7 ‫ ساعه مقسمة على‬21
    First Session 3 hours N/D
    Second Session 3 hours N/D
    Third Session 3 hours N/D
    Fourth Session 3 hours N/D
    Fifth Session 3 hours N/D
    Sixth session 3 hours N/D
    Seven session 3 hours N/D

    • The course could be delivered in AM on Friday/Saturday timing to fit all your


    organization crews.
    • Exact dates will be determined later upon your approval on monthly basis.
    • Snacks & drinks will be serve for all participants each session at Venue
    Participants
    • Maximum number is 10 participants- Interactive classroom ( Face To face )
    • Interactive Online session ( ZOOM ) 15 Participants-All session will recorded &
    uploaded

    Course Assessment & Certification


    • This course is assessed by 30 Minutes multiple-choice open-book assessment by the
    end of the second training day AND Final project on Excel spreadsheet
    • Trainees will receive A4 Certificate and course transcript from ita.co (R.N: 12909)
    Course Materials
    • Each participant will receive soft Copies for Excel
    Course Instructor
    Eng-Hossam Allam

    Petroleum engineer specializing in drilling – Suez Canal university


    I gained many experiences and skills in my work in this field of strong and
    distinctive nature
    With more than 12 years of experience in teaching and training in various fields
    such as:
    - Petroleum engineers and technicians
    - Remote sensing Using Erdas Imagine software
    - GIS trainees
    - Basic and advanced Excel
    - Data analysis Using Excel & Power Bi
    I have trained and taught more than 2000 trainees in the fields mentioned above
    using the available modern methods in an environment full of competition and
    challenges.
    Influential and effective, and has the ability to integrate theoretical lectures with applications and
    case studies, and to create an effective and distinctive curriculum that is linked to practical life.
    ita
    EDUCATION - TRAINING
    ENGINEERING

    Course Fees
    • 1200 EGP for the whole round (7 Sessions) Face to face at Company Venue (Nb25 -
    10th of Ramadan city) Maxim 15 Participants
    ) ‫ متدربيين‬15 ‫ جنية مصرى حضور شخصى ( اقصى عدد‬1200 : ‫سعر الكورس‬
    • 1000 EGP for the whole round ( 7 Sessions) with maximum number of participants 20
    On-line using Zoom and all lectures will be recorded and uploaded
    ) ‫ متدرب‬20 ‫ جنية مصرى حضور شخصى ( اقصى عدد‬1000: ‫سعر الكورس‬
    • The fees are including soft color copy handouts, Notepad, pens and gifts for the highest
    engagement participant.

    Payments
    • 50% will be paid to register
    • 50% after session number 3

    You might also like