All articles with 'Learn Excel' Tag
Excel pivot tables are very useful and powerful feature of MS Excel. They can be 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 »
This is a quick, fun and elegant way to make impressive charts. You can easily create info-graphic style charts in Excel using shape fill technique. Something like this:Continue »
Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.Continue »
For every column chart that is done right, there are a dozen that get messed up. That is why lets talk about 5 simple rules for making awesome column charts.
Tip: Same rules apply for bar charts too.Continue »
So you have built that excel report your boss wanted. And you were all eager to use the spreadsheet in your presentation. But in the last minute, your boss asked you to change average sales to total sales figures. You also want to grab an espresso before rushing to the meeting. Now what?Continue »
We all change minds. Heck, I just did it with the leading line. I thought something else, but went with what you just read. So why must Excel charts be set in stone? Let’s say you made some charts and want to quickly second guess your selection. How to change Excel chart easily? Sure, you […]Continue »
The other day while I was in lift (elevator), it made an alarm like sound and won’t close the doors. Turns out there are one too many people in the lift for it to operate safely. As soon as a couple of people volunteered and stepped out, it started fighting gravity and took us upstairs. […]Continue »
Learn to how perform Maths on Tables of Numbers in Microsoft Word.Continue »
Obviously, everywhere you look this week, you find advice on how to do better this year.
Well, you don’t have to wait for a new year to become awesome at your work, any day is new year for the rest of your life.
So, today I want to share 12 steps to learn Excel and becoming awesome. But first I have a secret to confess…,
I think becoming awesome in Excel useless.
What we really want is, to become awesome in our work. Since we spend a lot of time using Excel (and other office software), knowing how to use these better can have a huge impact on how we do our work.
In that spirit, lets look at 12 steps to learn Excel so you become awesome in your work.Continue »
Would you like to spend next 5 minutes learning how to create an mutual fund tracker excel sheet?
Make a live, updatable mutual fund portfolio tracker for Indian markets to keep track of your investments using this example.Continue »
FIFA world cup 2018 is around the corner. I love soccer, I love Excel, Let’s marry them. Here is an awesome, free FIFA world cup Excel Tracker to help you follow this year’s games in Russia.
What you can do with this FIFA world cup Tracker Excel?
You can use this tracker to,
- View schedules in your local time for group and knockout stages
- View summary and detailed points table
- Refresh live points table. When you refresh, the tracker show updated points based on latest results (You need Excel 2016, Office 365 or older versions of Excel with Power Query)
- View knockout stage matches as a bracket
- See timeline of the matches
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
Once in a while everyone is bound to come across this problem. You type a formula in a cell, then you press ENTER. Bam! nothing happens. You check if a donut chunk went in to the key board and some how jammed the ENTER key. So press it again, this time harder. But nothing. Excel […]Continue »
Ever wanted to count distinct values in your pivot tables? Something like above:
Let’s say you have store sales data. Several products are sold on each day. When you make a pivot table from this data and add product count, Excel counts all products. But we want to see just the distinct count (ie if there is a duplicate product in a day, we want to count it just once).
Here is a simple trick to add distinct count to Excel pivot tables easily.Continue »
Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.
So today let me share with you 35 shortcuts, productivity hacks and tricks to help you be even more awesome.Continue »