Dynamic Ranges With Offset Function
You can make very professional looking interactive charts by using dynamic ranges. In this post, I’ll show you how to set up dynamic ranges with...
You can make very professional looking interactive charts by using dynamic ranges. In this post, I’ll show you how to set up dynamic ranges with...
Here is another interactive chart example. This time I’ve made a chart that shows data as you click. Great for presentations.
Excel stores user information on your workbooks in the background. This information consists of author info, creation date, change log and anything else that...
Here is a task manager with a progress bar. You can input your daily tasks, give priorities, mark them partially or fully completed and see...
(This is the second part of Data Analysis With Pivot Table Part – 1/2 post) You can also customize your pivot tables with custom...
Pivot table is without a doubt the number one tool for data analysis in excel. Previously I’ve made an introductory post for pivot table. Now...