How To Limit Scroll Area In Excel (2 ways)
November 11, 2020
Background Often times we would like to restrict users from getting access to certain range in Excel for different reasons. This can be easily done by Restricting Scroll Area. How to limit scroll area in Excel? How to restrict user’s
How To Center Cells Across Multiple Columns?
November 9, 2020
This article is to show you how to center cells over multiple columns in Excel without leading to the problems of merging cells using center across selection.
Day 1 as an Excel professional
November 5, 2020
We know what it’s like staring at an empty void of blank white table called “Excel spreadsheet” with no idea what is going on. To make something special, you just have to believe in special. Kung Fu Pandas (2008) Don’t
Partner Guide
October 6, 2020
Welcome to Dollar Excel Partners! We are more than glad to see you around and can’t wait to see your first Excel product available! To deliver a seamless experience for our customers, we adopt a set of publishing guidelines that
Installation Guide (5-min)
October 5, 2020
The article teaches you how to install our product to increase your Excel proficiency in 3 minutes. Follow the below instructions to install your newly acquired productivity tool!
Lacking confidence means that you are closer to becoming a guru
October 1, 2020
Have you heard about the Dunning-Kruger Effect. It has been my motivation towards learning for years. When I am first start to learn Excel back in ancient time, I felt really helpless like I am never going to figure how
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
