How to Reference Cells from Other Worksheets in a Formula

This tutorial is covered on our Beginners Excel course, if you want to learn some more complex techniques then take a look at our Advanced Excel course outline.

When constructing large spreadsheets it is likely that you will need to cross-reference data from different worksheets.

An example of this could be monthly figures on individual worksheets and a total or yearly worksheet.

You can use a simple formula to automatically update the total figures based on the monthly worksheets but this means referencing cells in multiple worksheets in one formula. So how do you do this?

It is actually very simple. In this example I will show you how to add together two cells from separate worksheets into another worksheet using employee sales figures.

As you can see we have January, February & Total worksheets.

Reference cells  different worksheets in forumula excel tutorial

We want to combine Rachel’s January and February sales figures to give us her total in 2012. Read the rest of “How to Reference Cells from Other Worksheets in a Formula”

Excel Function Keyboard Shortcuts

Two posts into our run down of Microsoft Excel keyboard shortcuts and we’re getting stuck to the nitty gritty of functions, so now you have your navigation keyboard shortcuts and formatting keyboard shortcuts mastered you are prepared to take on some of Excel’s more specialised functionality and more advanced formatting.

Excel Keyboard

Using these key combinations you will be able to quickly summon functions which will hopefully be able to use to formulate, tabulate and graphically represent your data to give it meaning and context. Read the rest of “Excel Function Keyboard Shortcuts”

Microsoft Excel Formatting Keyboard Shortcuts

Excel Keyboard ShortcutsAfter the popularity of our previous Microsoft Excel shortcut tutorial post we have decided to follow it up so you can be introduced to using keys for performing formatting. Hopefully you are now using your mouse far less after using our navigation shortcut guide. If not, be sure to have a run through of it first.

Many of these shortcuts can be used across many programs within the Microsoft Office suite, so they can be invaluable to learn in order to speed up your regular day to day tasks. Read the rest of “Microsoft Excel Formatting Keyboard Shortcuts”

Page 1 of 41234