Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Calculate Average in Excel: AVERAGE, AVERAGEIF, Weighted and Moving Average

The average, also called the mean, is the sum of the values divided by the number of values. It is the most common way to summarize a list of numbers, such as test scores, daily sales or monthly costs. In Excel you can calculate it with the AVERAGE function in one step, and you can

Standard

How to Make a Bar Graph in Excel: Column, Bar, Clustered and Stacked Charts

A bar graph uses rectangles to compare values across categories, such as sales by region, scores by student or costs by department. The length of each bar shows the value, so the reader can compare the categories at a glance. In Excel, vertical bars are called column charts and horizontal bars are called bar charts,

Standard

How to Calculate Percentage of Total in Excel: Formula, PivotTable and Examples

A percentage of total shows how big each part is compared with the whole. It answers questions such as what share of sales each product made, what part of the budget goes to rent, or how many of the tasks are finished. In Excel you calculate it by dividing each value by the total and

Standard

How to Calculate Age in Excel: DATEDIF, YEARFRAC and Years Months Days

To calculate age in Excel, subtract the date of birth from today and convert the result to years. The most reliable way is the DATEDIF function, which counts complete years between two dates. You can also get the age in years, months and days, the age on a particular date, the days until the next