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.
Excel Tables Tutorial & 13 Tips for making you a Data Guru
Excel table is a series of rows and columns with related data that is managed independently. Excel tables, (known as lists in excel 2003) is a very powerful and supercool feature that you must learn if your work involves handling tables of data.
What is an excel table?
Table is your way of telling excel, “look, all this data from A1 to E25 is related. The row 1 has table headers. Right now we just have 24 rows of data. But I can add more later!”
Introduction to Excel SUMIFS Formula
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.
In this article, you will learn:
- 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
Are You Trendy ?
Often you may have a set of data and need to know what an intermediate or future value of that data may be.
This week we will investigate 3 methods of tackling this problem using Excel.
In this post we’ll look at manual forecasting.
A round-up on Circular References
Here is a little experiment to freak out excel.
Go to cell C3 and write =C3 and press Enter. Excel would throw up nasty message saying, “Microsoft did not know what to do. We have a sent a support engineer to your home, but he is stuck at the round-about near your house.”
Well, not really. But what you did when you wrote the formula =C3 in cell C3 was, you created a circular reference.
A circular reference is created when you refer to same cell either directly or indirectly.
See Mona Lisa, in circular reference style.
Learn more about Excel Circular References, how to use them, examples, how to avoid them, how to deal with them in this article.
Take your Excel Baby Steps with 89 Minutes of FREE Online Training
I don’t remember when was the last time both of us (Jo and I) were this excited. And the reason?
Nakshatra and Nishanth have started taking their first steps last week !!!
It is such a joy watching them take one step at a time. Aah, the beauty of parenting 🙂
So I asked myself, “What is a good way to celebrate this without looking like a super-excited dad?” and I got my answer in 72 milli-seconds.
I have created 10 short (<10 min) videos helping you to take baby steps in Excel world. Each video introduces you to one new functionality of Excel and shows you some nice examples. Before jumping straight in to the videos, I want to share a short clip (30 seconds) of our kids taking their baby steps.
How to Check whether a Table is Filtered or not using Formulas
Let us start the week with a simple formula (well, to be fair, let us start the week with a strong cup of coffee, then this formula).
Often when we have large data sets, we apply data filters to select and display only information we want to see.
Some of you know that whenever we apply filters on a dataset, we can look at status bar area to find out if any filter is applied on the current worksheet.
But, what if you need a way to show “filtering” status thru formulas? Like this…,