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.
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”
Sometimes, you just need to know how to do one thing in Excel and tutorial such as this is just what you need. However, if you find yourself always looking up how to do things and spending longer looking for solutions than actually using them then you should consider a Microsoft Excel Training course. Our courses are tailored for all ability levels; we run public Beginner Excel training and Advanced Excel training but can also tailor a course specifically to your requirements. Call us on 01273 622272 to discuss the level of training suitable for you.
Using a drop down list in Excel can make data input a lot easier – after all, you don’t want to waste time typing in the same thing again and again!
Preparing Your Excel Drop Down List Data
To start with, let’s make a list. Writing it out in alphabetical order can help, as the cell order is the order in which they will appear in the drop down list (the drop down list won’t automatically reorder itself). In this example, we’ll be using a list of flowers.
First, we write out our flower names in cells A1-A7:
Creating the drop down list
Read the rest of “How to Create Drop Down Lists in Microsoft Excel”
Pivot Tables are covered in detail on our Advanced Excel Training course. However, for some basic pivot table tips, read How to Create a Pivot Table and How to Change the Function of a Pivot Table. If pivot tables are a bit advanced for you and you’re looking to start afresh then our beginners Excel Training might be perfect for you. Click the link to read the full course description.
Pivot Table Slicers Tutorial
In a Pivot Table you can apply filters to your data, using the report filter and by filtering within the row or column fields. When using the multiple items in a report filter it is not obvious which criteria you have specified and likewise with the row and column filters.
So what can you do? The answer is to use Slicers in Excel 2010 and this is how to do it: Read the rest of “Excel 2010 Tutorial – Pivot Table Slicers”