Making a Dynamic Dashboard in Excel [Part 2 of 4]
In part 2 of Excel Dynamic Dashboard Tutorial, we will learn how to set up various dynamic charts that are part of the dashboard. We start with a simple dynamic pie chart that shows the sales distributions and then move on to sales trend line charts. These charts use various excel formulas to pull in the information based on user selection.
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…,
Quarterly & Half-Yearly Profit Loss Reports [Part 5 of 6]
This is continuation of our earlier post Exploring Pivot Table P&L Reports.
We have learned how to change our P&L report on various data elements. We have seen how the P&L report can be changed with just few clicks.
In this post we will be learning some grouping tricks in PivotTables. We will cover grouping of dates, text fields and numeric fields. You will need to start with Monthly P&L report prepared in previous post. We will also learn some really clever tricks and hacks on how to group data in Pivot Tables. So read on…,
How to Convert Text to Dates [Data Cleanup]
Sometimes when we import data from another source in to excel, the dates are not imported properly. This can be due to any number of reasons. In this post, we will learn some tricks and ideas you can use to quickly convert text to dates.
Excel Links – Back to India Edition
As some of you know almost 10 days back I left Denmark and came back to India. I had to come back because of visa and personal issues. For the next 6 months PHDs will be based out of India and working from home. While this gives me a lot more time, I will be […]
31 Excel Tutorials – Learn and Be Awesome in Excel
In October 2008, I have started an ambitious series of posts on this blog called – Spreadcheats. These are little tricks, nuggets, tutorials on using Excel that would make anyone a spreadsheet guru.
The spreadcheats series has been wildly successful. I am compiling all this useful information and articles in to one big post so that anyone can follow the links and become good in Excel. Read on,
[Note: This is not for beginners. If you know what a formula is, you would enjoy this 31 articles]
Exploring Profit & Loss Reports [Part 4 of 6]
This is part 4 of 6 on Profit & Loss Reporting using Excel series, written by Yogesh Data sheet structure for Preparing P&L using Pivot Tables Preparing Pivot Table P&L using Data sheet Adding Calculated Fields to Pivot Table P&L Exploring Pivot Table P&L Reports Quarterly and Half yearly Profit Loss Reports in Excel Budget […]