Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Transpose in Excel: Paste Special, TRANSPOSE Function and Power Query

Transposing in Excel means turning rows into columns or columns into rows. You need it when a table arrives in the wrong orientation, when a chart expects data in the other direction or when you copy a list from a report and want it laid out sideways. Excel offers three main ways to do it:

Standard

How to Calculate Percentage Increase in Excel (Formula and Examples)

To calculate a percentage increase in Excel, subtract the old value from the new value, divide by the old value and format the result as a percentage. The formula is short, but the details cause most of the trouble: the order of the cells, zero values, negative numbers, the percentage format and how to increase

Standard

How to Calculate a Weighted Average: Formula, Examples and Excel

A weighted average gives each value a different level of importance. A plain average treats every number equally, but in real life some numbers count more: a final exam is worth more than a homework assignment, and a large purchase affects your average cost more than a small one. The calculation is easy once you