In the below video, we discuss how to reference multiple worksheets in MS Excel. Our example is to develop a summarized worksheet that has employee total hours assigned in a year as well as the total associated costs. This worksheet is dependent on two other worksheets and we see how to reference these sheets easily by cell referencing across different worksheets.
If you haven't done so, please register to this site so you can receive FREE Project Management templates as well as discounts to my Online Courses of about 80%!!
Also, please see my course MS Excel for Project Managers. With about 5 hours of content, this is the most comprehensive course on how to leverage MS Excel to develop project and financial artifacts that can help you manage projects.
Comments