Follow us:

Excel from Beginner to Professional in Project Management

Excel from Beginner to Professional in Project Management

In this workshop we provide detailed explanation on how to use Microsoft Excel in project management. The workshop consists of small videos; each video discusses a specific concept.

(0 reviews)
EGP 250
image

Description

Benefits of attending this Workshop:

  • Work comfortably with Microsoft Excel for project management

  • Develop Professional Reports and Dashboards

  • Save time and effort to do planning tasks

  • Be qualified to start learning Primavera and other tools for planning


Who should attend this workshop

  • All engineers who are aiming to improve their skills in excel.

  • Project management engineers who are aiming to improve their knowledge to save time in work.


Workshop Prerequisites

  • None

Workshop Strategy

  • Providing detailed elaboration of each concept.

  • Providing tips and tricks of excel during the sessions.
            

  • Providing assignments in each session to ensure regular assessment and to provide a practical experience.

image

Hit the Point

  • sections: 0
  • Feature: Yes
  • Duration: 9 Hours
  • Category: Project Management
  • Quizzes: Yes
  • Language: Arabic
  • Certificate: Yes

Course Syllabus

  • 1. Introduction

  • 2. Interface

  • 3. Formatting

  • 4. Formulas

  • 5. Sort and Filter

  • 6. If Conditions

  • 7. Sum if and Count if

  • 8. Conditional Format

  • 9. Edate and Weekday

  • 10. Concatenate

  • 11. How to make a barchart on excel

  • 12. Charts on Excel

  • 13. Barchart with Charts

  • 14. Vlookup and Hlookup

  • 15. PivotTables

  • 16. Pivot Charts

  • 17. Printing

  • 18. Procurement Sheets

  • 19. Dynamic Dashboards

  • 20. Integration between Excel and Primavera P6

Register now