Lesson 50 – How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

In this lesson, I’m going to be showing you how to:

  1. Add up cells from a different workbook in Excel
  2. Link data cells across multiple different workbooks in Excel

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered anything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 51 – How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than

Or go back to:

Lesson 49 – How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

Lesson 48 – How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

Lesson 47 – How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

Lesson 46 – Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel

Lesson 45 – How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel

Lesson 44 – Use the IF function to work out if you are over BUDGET or not in Excel

Lesson 43 – How to change a DATE to different FORMATS in Excel

Lesson 42 – How to set and print rows & titles automatically at the top of each page in Excel

Lesson 41 – How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

Lesson 40 – How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel

Lesson 39 – How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Lesson 38 – How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Lesson 37 – How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel

Lesson 36 – Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!

Lesson 35 – How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

Lesson 34 – What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Lesson 33 – How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30 – Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29 – Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24 – How to SORT data in ASCENDING order in Excel

Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22 – How to RENAME a worksheet in Excel

Lesson 21 – How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20 – How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18 – What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

42 thoughts on “Lesson 50 – How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel”

  1. Very nice and easy to follow lesson. It is not always easy to get around in Excel. Thanks that you are making a bit easier for people who are not advanced yet. I found it much easier now to link data and up cells from a different excel sheets. I haven’t thought it is such an easy one. Cheers.

    Reply
    • Thank you for your lovely feedback and comment. Glad you found my lessons useful and easy to follow. Keep dropping by on our website and YouTube channel for more upcoming videos.

      All the best

      Habib (ICT Tutor)

      Reply
  2. Hi Habib Ali,
    U have worked really hard in producing these wonderful videos. Thank u for the help. I am a teacher and i was stuck with excel problems. I now see that u have a storehouse of knowledge on Excel here.
    Thanks.
    Aps

    Reply
  3. Thank you for sharing this post with us, I really like reading this one too. I’ll go and see you video on Youtube for sharing

    Lyne

    Reply
  4. Hello Habib, you’re a great teacher. Your video was just the right pace, you spoke clearly, you were easy to follow and to understand. Don’t you love Excel?

    I don’t use Excel much for work, but rather for my own use for budgeting and my own analytical spreadsheets. In my past work, I was considered an “expert” level, but so many of the common uses are overlooked in training, and the basics are crucial to every day needs.

    Keep up the great work, and yes, I learned something from your video, specifically, how to fill cells within a range of spreadsheets within a different file.

    Thank you, Joanie

    Reply
    • Hello Joanie,

      First of all, many thanks for your compliments, they are very humbling! It’s so good to know that you are learning something new from my video tutorials on Excel. There is always more than one way of doing things in Excel, so there are always new learning.

      Yes, I do like the Microsoft Excel. 🙂

      Habib (ICT Tutor)

      Reply
    • Thank you Francis and yes we have more and more students joining in, to complete my lessons. Our fans and subscribers on my YouTube channel are increasing on a daily basis, and I’m getting very positive feedback from the lessons.

      Sorry, I don’t provide any completion certificate as these are FREE and informal courses I’m offering as great VALUE to our visitors on our website and YouTube channel. However, you will get very comprehensive knowledge and skills, once you have completed all the lessons, and with all that great knowledge you will be able to sit and pass any examination that comes your way. All the best Francis.

      Habib (ICT tutor)

      Reply
  5. Great explanation!

    I would love to share this article Lesson 50 – How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel with my friend that uses excel alot.

    Thanks for sharing!

    Reply
  6. Thanks for the post. I must admit that i don’t use Excel but when i will use it this is the website with all the details that’s so good and simple.
    Thank you Habib for such an informative posts.

    Reply
  7. Hey Habib, thank you so much for your helpful video lesson. I’ve learned quite a few tips and tricks about excel spreadsheets. Such as linking data across different spreadsheets, and the formulas and links between them.
    I think it’s very cool how you present your lessons. Everything is on point. Easy to follow, and you express yourself clearly.

    Thanks again, keep up the amazing work.

    Reply
    • Hey Michael,

      Fantastic! This is great news that you have learnt to link data across different spreadsheets and also the formulas and links between then. Thank you for your feedback on the quality of my lessons on Excel. It’s humbling and motivating at the same time.

      Keep visiting our site and YouTube channel for more such contents.

      Best wishes
      Habib (ICT Tutor)

      Reply
  8. Habib,

    Again, excellent video! Excel is a powerful tool. I’ll have to try this for one of my projects. Combining the North, South, and Midland profits seems straightforward on the video. But the true test is doing it myself on a project I’m doing. I appreciate your video! It’s very well-done, and I’m grateful for your effort.

    Reply
    • Hi Robert,

      If you are not sure about the combining profits, you can watch the video over and over until you have understood, and also make notes. I’m sure you will be able to do it. Just keep going.

      Best of luck
      Habib (ICT Tutor)

      Reply
  9. Linking data and adding up cells from a different workbook is something that I knew nothing about before today’s lesson.

    The more videos of yours that I watch, the more I realize how powerful Excel is.

    Thank you for another excellent lesson!

    Michael

    Reply
    • That’s great to know Michael.

      Please keep an eye out for many more useful videos on our YouTube channel and well as here on our website.

      Best wishes

      Habib (ICT Tutor)

      Reply
  10. Hi Habib. Thank you for this lesson. Now I have learn the shorter way with the help of sum function to add up the data from all the tabs! It’s so much easy, no need to go through the tab one by one 🙂

    Reply
  11. Thanks for sharing this information. I found the tutorial very clear and straightforward. I have recently started a new job and discovered my excel skills do not match the level of my colleagues skills so will look through your other tutorials to help me catch up!

    Thanks Again
    Madeleine

    Reply
    • You are welcome. I’m humbled to know my video will help you learn new Excel skills to match up with your new job. Please let me know if there is anything else you would like to learn and I will try to make videos around it if possible.

      Best of luck

      Habib (ICT Tutor)

      Reply
    • Hi,

      You are welcome! I want others to benefit from my knowledge and expertise. Please start watching the training from lesson one to maximize the benefit. I continue to make many more video tutorial. So, keep visiting my site and YouTube channel.

      Wishing you all the best

      Habib (ICT Tutor)

      Reply
  12. Hi Habib,

    It is an excellent lesson. I really love your recent tutorials because I could learn more and more advanced techniques. I always wonder how to consolidate data from different Excel files. I get the answer now from your video. Thank you for sharing.

    All the best,

    Alex

    Reply
    • Hi Alex,

      I’m glad to hear my video tutorials have been useful for you.
      Please keep visiting our site and YouTube channel for many more exciting tutorials.

      All the best

      Habib (ICT Tutor)

      Reply
  13. Thank you for your post. I found it’s really helpful and useful, especially for me to improve how to use excel function in full. Before I knew Excel is a calculator and also good for data, but didn’t know how it works in deep like you taught, and always messed it up at the end.
    Now I known more, and how to link data in different workbooks. Like the last lesson 49, I need to watch few times. Thanks again for the training, I’m looking forward to watch more of your trainings in future!

    Reply
    • That’s great to know Ling. I’m so glad to hear my video tutorials on Excel are helping you learn lots of different techniques. There is always more than one way of doing things in Excel, and there are so many different functions you can use on Microsoft Excel.

      The Microsoft Excel videos are uploaded regularly on our website and YouTube channel.

      All the best

      Habib (ICT Tutor)

      Reply
  14. I am inclined to say don’t give everything away 🙂
    Quite an impressive list of informational posts and videos, Habib. Thank you so much for all this effort and education!

    Reply
  15. Well I watched lesson 50, very good. I immediately saw how I might need to learn about this stuff and how it might be a good idea to start at lesson 1.
    I’ve done a fair bit of teaching myself.
    This is a really good website.
    I’ll be back.
    Garry.

    Reply
    • Hi Garry,

      Thank you for your feedback. Yes, definitely it’s a good idea to start from lesson one. Let us know if there is anything I haven’t covered yet.

      Best wishes
      Habib (ICT Tutor)

      Reply
  16. I never knew that you can link data cells in Excel. Every single one of videos teach me so many new things and features that you can use in Excel. Thanks for sharing!

    Reply
  17. Great tip in today’s lesson. I really liked that second method rather then first. I only was using the first one as I thought that’s the only option. The second one feels much quicker.

    Reply
  18. How to link data and add up cells from a diffrent workbook in excel is extremely useful and interesting to know, you have a natural way of making using Excel easy and simple. I have tried learning from videos and books this program, but I have learned more from your website than any videos or books I have ever used

    Many thanks
    Jeff

    Reply
    • Dear Jeff,

      Thank your for your amazing feedback. Please keep visiting our site and YouTube channel for more videos.

      Best wishes

      Habib (ICT Tutor)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap