Search

# All articles with 'data processing' Tag

## Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

Excel pivot tables are very useful and powerful feature of MS Excel. They are used to summarize, analyze, explore and present your data. In plain English, it means, you can take the sales data with columns like salesman, region and product-wise revenues and use pivot tables to quickly find out how products are performing in each region.

In this tutorial, we will learn what is a pivot table and how to make a pivot table using excel.

Continue »

## Introduction to Excel SUMIFS Formula

Published on May 25, 2018 in Learn Excel

Excel SUMIFS function is used to calculate the sum of values that meet any criteria. For example, you can calculate the total sales in east zone for product Pod Gun using SUMIFS formula.

• What is SUMIFS function and how to use it?
• Syntax for SUMIFS
• Using SUMIFS() with tables and structural references
• SUMIFS examples – simple, wild card
• Using SUMIFS() with date & time values
• Free sample file for SUMIFS formula
• More formulas for data analysis
Continue »

## CP050: Fifty Excel Tips to make you awesome

Published on Dec 3, 2015 in Chandoo.org Podcast Sessions

This is going to be epic!!! In the 50th session of Chandoo.org podcastwe have 50 Excel tips to make you awesome.

What is in this session?

In this podcast,

• Thank you message
• Fifty tips in 5 buckets
• Shortcuts & Productivity
• Formulas
• Managing Data
• Charts
• Using Excel better
Continue »

## Flu Trends Chart in Excel [Yes, we can edition]

Published on Jan 22, 2010 in Charts and Graphs, Featured

Last week I have reviewed Google’s flu trends chart and told you that is it is very well made. Out of curiosity I made a similar chart in Excel. In this post, I am going to share the experience and results with you. Interested? Read on…

Continue »

## Make a Pivot Table in Excel [15 Second Tutorial]

Published on Aug 25, 2009 in Excel Howtos

Last week we have posted a simple to understand excel pivot table tutorial here. Today I am going to supplement the tutorial with a 15 second video tutorial on Making excel pivot tables.

Continue »

## Incell Dot Plots in Microsoft Excel

Published on Jun 10, 2009 in Charts and Graphs, Learn Excel

Dot plots are a very popular and effective charts. According to wikipedia “Dot plots are one of the simplest plots available, and are suitable for small to moderate sized data sets. They are useful for highlighting clusters and gaps, as well as outliers.”

Today we will learn about creating in-cell dot plots using excel. We will see how we can create a dot plot using 3 data series of some fictitious data.

Continue »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.