The bad news is that this is a critical skill. You need to be able to easily work with $ signs in Excel formula so that when you create the formula it will correctly copy and paste to other areas.
This skill is the difference between building one formula and copying it a thousand times or building the formula a thousand times.
We cover it in detail in the Excel Essentials free course with examples. Below a video clips on ways to think through the $ signs.
To see the full course contents click here.