Scribd
Upload
57 views3 pages

Excel Formulas For Project Control

The document lists frequently used Excel formulas for project control, including VLOOKUP, HLOOKUP, and various counting and summation functions. It suggests using Excel Helper and provides resources such as YouTube and exceljet.net for further learning. Additionally, it mentions tools like Pivot Tables and Conditional Formatting to enhance data analysis.

Uploaded by

Muhammad Irfan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
57 views3 pages

Excel Formulas For Project Control

The document lists frequently used Excel formulas for project control, including VLOOKUP, HLOOKUP, and various counting and summation functions. It suggests using Excel Helper and provides resources such as YouTube and exceljet.net for further learning. Additionally, it mentions tools like Pivot Tables and Conditional Formatting to enhance data analysis.

Uploaded by

Muhammad Irfan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Most frequently used formulas in Project Control

Use Excel Helper as shown belo


Conditional Formatting

VLOOKUP

HLOOKUP

Pivot Tables

Pivot Charts

Combo Charts

SUMPRODUCT You can also search Youtube if needed and y


TRIM

IF Or visit exceljet.net
IFS

COUNT

COUNT IF

COUNT IFS

COUNTBLANK

COUNTA

SUM

SUM IF

SUM IFS

AVERAGE

RANK

TOTAL

SUBTOTAL

MID

TRANSPOSE

TEXT TO COLUMN
ISBLANK

COUNTBLANK

ROUND
as shown below to understand each formula

ube if needed and you will find plenty of resources

You might also like