Categories
Excel Training

Applying a background to an Excel worksheet

This is a quick function to try out and can add a bit of fun to a worksheet.

I’m creating a worksheet listing different forms of marine life for a quiz for some children visiting the local aquarium.

It will make the screen look more inviting if I have a photo behind the worksheet to go with the theme.

I create a new file, and go to the Page Layout tab, and select background.

page-layout-tab-excel-courses
The Page Layout tab has the Background button…

I can select one of Microsoft Pictures Library to make this super-quick (the kids are waiting…)…brilliant, I’ve found a jellyfish.

jellyfish-excel-courses
Jumping jellyfish – that looks fun!

The background is quite dark, so I will change my font colour to silver using the Home tab 

font-colour-excel-courses
Use the Home tab to change the font colour

The children may be a tad young to come along to Excel courses, but we can still help them learn about marine life by using Excel with our helpful little jellyfish. https://www.stl-training.co.uk/microsoft/excel-training-london.php

 

 

 

Categories
Excel Training

Copying information from Excel into Word

This is quick to do and a useful way to add financial information from Excel to a Word document.  This is an effective way to add a snapshot of financial data without the need for Excel’s tools.

Tip: The Excel data will appear as a table in Word.  It will show the figures but you won’t have Excel’s functionality, so you won’t have access to the formulas.

For example, I want to put some budget information in a Word document so I can hand this out at a meeting.  I don’t want to have to type the data in a Word table, because I can save myself time by copying the information from Excel directly into my Word document.

To do this, I open a new blank document in Word.

In Excel, I copy the cells I want, and use Control and C to select them.

I go back to my Word document and put my cursor where I want to add the Excel information.  And then use Control and V to paste it into the document.

excel-in-word-excel-courses-London
Excel information will appear as a table in Word.

This is a quick way to add Excel data to Word. Working across programs in Microsoft Office is a fantastic way to boost your productivity at work.  For more information about our Excel Courses in London and other training formats, take a look at what more Excel has to offer https://www.stl-training.co.uk/microsoft/excel-training-london.php