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...
Category: Advanced
Interactive Chart Example – 3
Here is another interactive chart example. This time I’ve made a chart that shows data as you click. Great for presentations.
Removing Personal Information From Workbooks
Excel stores user information on your workbooks in the background. This information consists of author info, creation date, change log and anything else that...
Excel Task Manager
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...
Data Analysis With Pivot Table Part – 2/2
(This is the second part of Data Analysis With Pivot Table Part – 1/2 post) You can also customize your pivot tables with custom...
Data Analysis With Pivot Table Part – 1/2
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...
