Excel Formulas Part 5: Reference Sheets and Another Workbook

Learn how to reference other sheets and workbooks in your Excel formulas. In this video we look at how to sum values from multiple worksheets on a summary sheet. We see this in a couple of different ways. We then create a reference to another workbook in a formula. Enroll in the complete Excel Formulas course and become an expert in formulas in just a few hours. Over 100 formula examples - https://www.udemy.com/excel-formulas-made-easy/?couponCode=FormulasYouTube This video is the fifth in our series to learn Excel formulas. It is aimed at beginners to Excel formulas to get to an intermediate level quickly and easily. Previous video - Basic Excel functions - https://youtu.be/jpvBmelSBjg Next video - Calculate the difference between two dates including working days only - https://youtu.be/hZCsyHyDpw8 Download the FREE eBook of '27 Excel Hacks to make you a Superstar' - http://www.computergaga.com/27-excel-hacks-to-make-you-a-superstar.html Find more great free tutorials at; http://www.computergaga.com Connect with us!