Your SEO optimized title page contents

Tag: Excel tutorials

Pareto chart

Pareto chart: The Pareto chart provides a graphic depiction of the Pareto principle, a theory maintaining that 80% of the output in a given situation or system is produced by 20% of the input. When to use a Pareto Chart: It is mainly used in...


Column chart

Column chart: Column charts are used to compare values across categories by using vertical bars. Column charts display vertical bars going across the chart horizontally, with the values axis being displayed on the left side of the chart.  ...


Pie Chart

Pie Chart: Pie chart definition is – a circular chart cut by radii into segments illustrating relative magnitudes or frequencies   When to use a Pie Chart? There are some simple criteria that you can use to determine whether a pie...


Area Graph

Area Graph: An area chart represents the change in one or more quantities over time. It is similar to a line graph. In both area charts and line graphs, data points are plotted and then connected by line segments to show the value of a quantity...


How to use VLOOKUP

How to use the VLOOKUP The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in...


How to use Hlookup

How to use Hlookup in excel The Excel HLOOKUP function is designed for horizontal lookup. More specifically, it searches for a certain value in the first row of the table and returns another value in the same column from a row that you specify...