Learn how to use Absolute Cell References in Microsoft Excel in this week’s Happy Computers Summer School time saving two minute video!
Absolute Cell References, or adding in dollar signs ($) to your formulas, are absolutely essential when copying across formulas. It ensures that a formula will always refer to the same cell each time, rather than changing to another cell each time, for example when doing a multiplication that requires a fixed figure (such as VAT or conversion rates).
This tip is guaranteed save you time when working with Excel spreadsheets!
Want to learn more?
It’s essential that you are confident with Absolute Cell References before you attend our Excel Core Level 2 course.
If you are comfortable with Absolute Cell References following this video, check out our upcoming Excel Core Level 2 course dates below:
- Excel 2013/2016 Core Level 2: 22nd August, 6th September, 23rd September
- Excel 2007/2010 Core Level 2: 25th August, 14th September, 15th September
If you are a total beginner to Excel and using formulae, the Core Level 1 course will probably more suitable for you. This covers all the basics, including saving and opening a spreadsheet, filtering data, and using basic charts and graphs. View our Excel Core Level 1 dates on our Excel page here.