Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel for Project Data Analysis and Reporting
6 students

Microsoft Excel for Project Data Analysis and Reporting

Master Excel using real-world project databases, reporting techniques, Pivot Tables, VLOOKUP, SUMIF, COUNTIF
Created byHesamoddin Kheirbakhsh
Last updated 6/2026
English

What you'll learn

  • Work with real project databases in Excel
  • Analyze and compare project data professionally
  • Create reports using practical Excel formulas
  • Use IF, IFS, VLOOKUP, SUMIF, SUMIFS, and COUNTIFS in projects
  • Analyze project data with Pivot Tables and Conditional Formatting
  • Build dynamic lists and project forms in Excel
  • Clean and organize project data efficiently
  • Apply Excel skills on real-world project examples

Course content

4 sections • 28 lectures • 4h 24m total length

  • Professional and Fast Data Selection and Navigation in Excel5:49
  • Fast Data Entry and Editing in Excel6:57
  • Managing and Selecting Data in Project Databases7:08
  • Customizing the Excel Environment for Working with Project Databases12:20
  • Professional Data Selection with Go To Special and Random Number Generation11:20
  • Introduction to the Course Database and Data Filtering11:12

Requirements

  • A computer with Microsoft Excel installed
  • Interest in project data analysis and reporting
  • Willingness to practice using real project-based examples

Description

Have you ever worked with large amounts of project data in Excel and struggled to organize, compare, analyze, or report the information efficiently?

This course is designed to help you work confidently with project databases in Excel using practical and real-world examples.

Throughout the course, you will learn how to organize, analyze, compare, and report project data using essential Excel tools and functions. Instead of learning formulas separately, you will apply them directly to a real project database containing information from multiple projects.

In this course, you will work with practical Excel tools and functions such as:

  • IF & IFS

  • SUMIF & SUMIFS

  • COUNTIF & COUNTIFS

  • VLOOKUP

  • INDEX & MATCH & CHOOSE

  • Pivot Tables

  • Conditional Formatting

  • Data Validation

  • Flash Fill

  • Text to Columns

This course focuses on practical application rather than advanced or highly technical concepts, making it suitable for students, engineers, planners, and project teams.

By the end of this course, you will be able to analyze project information, create reports, compare project data, and work confidently with project databases in Excel. You will also learn practical data cleaning and preparation techniques.

Feel free to ask me any questions during the course — I’m here to guide you and help you fully understand each concept and practical example.


Who this course is for:

  • Engineers working with project data in Excel
  • Project managers and project teams
  • Planners and project control engineers
  • Students who want practical Excel skills for projects
  • Anyone interested in analyzing and reporting project data in Excel

Report abuse