In this lesson, I’m going to be showing you how to:
- Add up cells from a different workbook in Excel
- 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 everything 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 🙂
Thanks for watching!
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, Date, Percentages and apply Decimal Places to numbers in Excel
Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit
Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells
Lesson 10: How to use the INSERT FUNCTION command in Excel
Lesson 9: Simple Subtraction Formula in Excel
Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data
Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel
Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel
Lesson 5: Average Function in Excel | What does Average mean
Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel
Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive
Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons
Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor