Excel 2013: Mixed References - Absolute and Relative

124 views · Published 17 July 2017 · 7:00 · Indexed 8 November 2026

Channel: Kirt Kershaw · 2017 · Education

Watch on YouTube

Excel 2013 tutorial on cell references that contain both an absolute and relative reference are known as mixed references.  An absolute reference is when a formula remains the same when it has been copied to other cells, and a relative reference is where the formula changes when copied to another cell; and when a formula contains both it is known as a mixed reference as shown in this Excel 2013 training video.

All 157 of my Excel 2013 training videos contain everything you need to help pass both the Excel 2013 Core (77-420) and Expert Part 1 (77-427) and Part 2 (77-428) Exams and become certified!

PATREON: Kirt Kershaw & Dream Force, LLC invite you to subscribe for the $2 monthly option which includes ALL Microsoft Office training tutorials 2016, 2013, 2010 and 2007.  New videos will be constantly uploaded to Patreon so you will get new content.  Visit and sign up at: https://www.patreon.com/KirtKershaw 

DVD & DOWNLOAD AVAILABLE: 
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET'S CONNECT!
-- http://www.facebook.com/KirtKershaw 
 
-- http://www.linkedin.com/in/kirt-kershaw-33874410
-- https://www.instagram.com/kirtkershaw

More from this channel