Excel 2013: Mixed References - Absolute and Relative
124 views · Published 17 July 2017 · 7:00 · Indexed 8 November 2026
Channel: Kirt Kershaw · 2017 · Education
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
-
5:42
Windows 7: Basic Overview
-
6:27
Excel 2010 Print Rows Top Each Page - Repeat Column Headers Training Video
-
4:14
Excel 2010 Evaluate and Watch Formulas Training Video
-
5:04
Word 2010 Document Views Training Video
-
0:30
PowerPoint 2010 Introduction Training Video
-
2:56
Project 2013 Reschedule Task Training Video
-
9:51
Excel 2013 Essential and Basic Training Video
-
4:33
Excel 2013 Evaluate and Watch Formulas Training Video