Excel Training UK

From first time Excel users to advanced VBA experts, we offer Excel training courses to suit all abilities. Our popular Excel beginners courses are ideal for learning the basics of Microsoft's flagship spreadsheet application but we also offer advanced & tailored courses as well as a VBA for Excel course.

How to Print From Excel

Printing from Excel can be a confusing task, especially when you have a large spreadsheet that needs to be easily read when printed. How many times have you hit the ‘print’ button before remembering that you don’t need the whole thing, or need it to all fit on one page?

print preview in ExcelThe first thing to remember is that Print Preview is your friend. It’s a good idea to get into the habit of always previewing before you print – this will save you a lot of paper and time!

We cover the issue of printing from Excel in our Excel training course. We also offer Advanced Excel training and VBA for Excel.

To get you started, here are some tips for things to consider before hitting that ‘print’ button!

How to specify how many pages you want your document to be

You can put a limit on how many pages you want your document to be when printed.

If you use this option then you lose any manual page breaks (but see the next tip for how to get around this). Read the rest of “How to Print From Excel”

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”

What To Expect From Microsoft Office 15

Microsoft Office 15 is likely to be released late in 2012, or early 2013, with a public beta likely to show its face this summer. Its official name is likely to be determined by the year of release (let’s hope for Microsoft Office 2012 then!).

microsoft-office-15-previewThe current technical Preview beta version is private, and users have to sign a non-disclosure agreement. Bits and pieces have slipped out – even screenshots – suggesting very exciting changes indeed.

Paul Thurrott’s extensive screenshots and descriptions give you a thorough feel of the new developments – here are our top takeaways.

Look and Feel

The suggestion is that the Office 15 user experience will be a cleaner and more personal one.

As expected, Windows 8 design and concepts run through Office 15. Leaked versions run on the traditional desktop with a heavy influence from the new Windows Metro touch-screen style. A stepping stone, presumably.

The Ribbon

Love it or hate it, the ribbon (the one-touch UI of options, designed to avoid having to navigate through menus and toolbars) is still there – but hidden as default.

(Old version with ribbon)

Microsoft Office with Ribbon

 

 

(New version with hidden ribbon)

Hidden ribbon in Microsoft Office 2012 version 15

 

Integrated Design Options

Another first for Office version 15 is the introduction of a brand new tab for Design. This allows users to easily create and configure themes, borders, background colours and watermarks.

It’s likely that there will be extended video features for editing and broadcasting.

Cloud Integration

Microsoft Office 15 will automatically sign users into their Microsoft ID, including services such as Flickr, Windows Live Hotmail, Windows Live Messenger and SkyDrive. You can also set it to automatically connect to LinkedIn, SharePoint and Office 365.

When you select “Save As”, the top option will be to save the document to SkyDrive, followed by normal computer locations.

Microsoft Office 15 new features

Tablet users

Tablet users will benefit from the new full-screen mode which allows more viewing space beyond the part of your screen that contains the keyboard.

There’s also a specific ‘touch mode’ that increases the size of some buttons to make them easier to navigate by touch.

Power

Microsoft Office 2012 will use less memory and processing resources – which will certainly make it more accessible to tablet and notebook users.

Individual Applications

The majority of leaked updates and screenshots are focused on most people’s first stop – Microsoft Word.

The specific changes to the features of individual applications are, for the most part, yet to be seen. We’ll have to wait for the public Beta to be released in the summer to find out more!

(Images of Microsoft Office version 15 from winsupersite.com.)

Page 2 of 1312345...10...Last »