How to Calculate Percentile?

If you have written any competitive exams, you might be familiar with the term percentile. Most of today's competitive entrance exams publish the results of the applicants based on percentiles. You might be familiar with the term percent. But, it is not the same as percentile. Do not confuse these terms. As we all know, percentage is a number defined as a fraction of 100. So, if a person says that he scored 60% marks in his GMAT exam, then it means that if total score is 100, he scored 60 marks. Obviously, if the total score is 50, the person has got 30 marks in the exam.

Read more ...

Charts

• Charts 101
• 3 axis Chart
• 3D Chart
• 4 axis Chart
• Age Population Pyramid
• Area Chart
• Bar Chart
• BCG Matrix
• Box Plot
• Bridge Chart
• Bubble Chart
• Bullet Chart
• Bump Chart
• Butterfly Chart
• Chart from csv
• Chart from right to left
• Chart that Ignores N/A! Errors and Empty Values
• Chart with a baseline
• Chart with a break Y axis
• Chart with a goal line
• Chart with a lot of data
• Chart with a single x-axis but two different ranges
• Chart with Arrows
• Chart with average line
• Chart with Checkboxes
• Chart with combo box
• Chart with confidence intervals
• Chart with filtered data
• Chart with floating bars
• Chart with grouped data
• Chart with horizontal bands
• Chart with Hours
• Chart with if statement
• Chart with multiple series
• Chart with negative values
• Chart with non-numeric data
• Chart with number and percentage
• Chart with option buttons
• Chart with scrollbar
• Chart with subcategories
• Chart with two trendlines
• Chart with upper and lower control limits
• Column Chart
• Correlation chart
• Difference chart
• Doughnut Chart
• Dynamic Chart
• Ethereum network-difficulty chart
• Flow Chart
• Funnel Chart
• Gantt Chart
• Gauss Chart
• Histogram
• Ishikawa Diagram
• Kite Chart
• Line Chart
• Logarithmic scale
• Min/Average/Max column Chart
• Multi Level Pie Chart
• Multiple Overlay Charts
• Ogive Chart
• Panel Chart
• Pareto Chart
• Petal Chart
• Pie Chart
• Pie of Pie Chart
• Pivot Chart
• Polar Chart
• Probability Chart
• Progress Chart
• Quality dashboard
• Quarterly Chart
• Radar Chart
• Scatter Chart
• Sine wave plot
• Slope Graph
• Sparklines
• Speedometer Chart
• Statistical process control chart
• Stiff Diagram
• Stock Chart
• Surface Chart
• Thermometer Chart
• Timeline Chart
• Time Series Graph
• Tornado Chart
• Trendlines
• Two chart types in one chart
• Venn diagram
• Volatility Chart
• Waffle Chart
• Waterfall Chart
• Wind Rose
• Wireframe contour chart
• XY Chart

How to quickly go to the last row?

In this article I will guide you, how to go to the last row of Excel quickly in different ways.

Read more ...

Chart with upper and lower control limits

In this Excel tutorial you will teach yourself how to create a chart with upper and lower control limits.

Read more ...

How to Count Unique Values?

It is quite easy for you to get unique value where there are so many duplicates, especially if you would like to paste them in a new location. We are going to count unique values together.

Read more ...