Beatexcel is one year old
Hello everybody! This is one year anniversary of beatexcel. Beatexcel is one year old !
Tagged: excel tutuorial
How to Block Data Validation Override
You can setup a data validation list to limit entry to certain cells. But you will realize at some point that your data validation can...
Finding 2nd Matching Value with Vlookup
There can be times that you need to look up for a value but not necessarily want the first matching value. Vlookup function cannot help...
Pivot Table Row Labels In the Same Line
It is a common issue for users to place multiple pivot table row labels in the same line. You may need to summarize data in...
Save Workspace
If you are working with same multiple workbooks frequently, you can arrange layout of your workbooks on screen and save workspace. This way you can...
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...
