Excel: Relative vs. Absolute Cell Reference

There are two types of cell references: relative and absolute.

Relative and Absolute references behave differently when copied into other cells.

Relative references change (relatively) when a formula is copied to another cell. In other words, they change based on the formula. So, if you copy a formula referencing Cell A1 and copy the formula to Row 2, the "A1" reference will change to "A2" since you copied the formula down a row.

Absolute references, on the other hand, remain constant no matter where they are copied. In other words, they will NOT change when you copy a formula to other rows or columns. This type of cell reference is useful when budgeting, for example. You can see what happens if revenues increase by a specific percentage. When formulas are based on the percentage cell, you can change the percentage using a single cell and all other formulas referencing this cell will update automatically according to the new number in that cell.

Watch this brief tutorial to see exactly what I mean.

Excel Formulas: Sum and Percentages

I just updated my most popular YouTube Video Course - Excel Formulas: Sum and Percentages.

If it's been a while since you've viewed it, it's worth the few minutes.

If you haven't viewed it and need assistance with the Sum and Percentage Formulas in Excel, please enjoy watching it.

Thanks,

Debbie

Organize Your Communications

Are people often confused by your Emails? Do people not read your Emails? If you write poorly, it can confuse readers and they often won't read them.

Organizing the key points for your communication is helpful in two ways: it helps you put key points in a logical order for your readers and reduces your writing time because you can keep focused on your key points. Two strategies that you can use to organize your key points are ranking and planning worksheets.

This brief tutorial teaches you how to use Ranking and Planning Worksheets to organize your communications.

For more tips like this plus MUCH more, check out my course on Udemy, now only $12 (87% off!) Full course includes 1+ hour of content and downloadable resources, 1-on-1 instructor support and a 100% money-back guarantee. Sign up today!

Go Ask Debbie now available on Udemy

I published my Written Communications course on an online learning site called Udemy. The site makes it really easy and fun to learn new things, and there’s even a mobile app for my course, so you can watch it on the go.

Definitely take a minute and check out my course trailer video here: Written Communications Course and see if you think it’s something you’d want to take in your free time. You can use that same link using the Promo Code "SEPT12" to get an 87% discount on the course if you’re ready to dive in. That's just $12 for the entire course! And of course, feel free to share with your friends who would be excited about a lesson in Written Communications. Hope you like it! Regards, Debbie

Udemy Written Communications course $12 coupon rate

Excel Styles and Themes

In Excel, it is easy to just type numbers for a boring looking spreadsheet. But, did you know you can apply styles and themes similar to PowerPoint?

Here's a brief tutorial how to do just that.