Learn Microsoft Excel

Scale your Excel spreadsheet to fit your screen

If you work with large Excel spreadsheets, you'll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn't always give you the result you want. Often, it will make your spreadsheet too small or not small enough.

Scale your spreadsheet to fit when printing from Excel

Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.

You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Not only that, but Excel ignores any manual page breaks you've entered.

Using VLOOKUP

Posted Sun, 02/08/2009 - 07:29 by millionleaves
0
Your rating: None

VLOOKUP() is one of the most useful functions in Excel outside the basic functions such as SUM(). VLOOKUP allows you to look up a value in a table and return another value based on that first value. For example, you want to look up a price of a product based on the number of items being ordered.

Scenario: 

You have a value in a cell and need to calculate the value of another cell based on that first value. The result of the calculation will depend on the value in the first cell.

Calculate the sum of a column of numbers

Posted Fri, 02/06/2009 - 06:24 by millionleaves
0
Your rating: None

One of the most basic features of Excel is its ability to add up a column or row of numbers using the SUM() function.

Scenario: 

You have a series of numbers in a column that you need to find the total for. You'd like the total to be recalculated whenever you change one of the numbers in the column.

Working with data ranges

Posted Thu, 02/05/2009 - 06:16 by millionleaves
0
Your rating: None

Excel is a powerful tool for manipulating large amounts of data. Make sure you know the rules Excel uses when setting up a data spreadsheet.

Scenario: 

You want to use Excel to work with a block of data

About Us

Fiveminutelessons.com is a website dedicated to providing free training on a range of subjects. We're starting with lessons on Microsoft Word, Excel and PowerPoint but have plans to add other subjects over time such as Adobe Photoshop and Microsoft Project as well as non-software subjects.

We're based in Tauranga, New Zealand but have years of experience in the UK, USA and Ireland working in the training industry with a range of clients from small businesses to blue chip corporates.

To find out more, why not get in touch?

Commercial Services

As well as the free training you get at www.fiveminutelessons.com, we also offer a range of commercial services to help you with your training and online learning requirements including:

  • Private labelling
  • Courseware development
  • e-learning development
  • Corporate subscriptions
  • Learning consultancy services
  • Documentation and user guide development
  • Development of innovative corporate learning environments

We offer these services for Microsoft Word, Excel and PowerPoint, as well as a range of other popular software applications. We can also assist with documentation and courseware development for custom or in-house software packages.
Contact us now to find out more about our learning consultancy and courseware development services