Excel - Removing Pictures for a Worksheet in VBA

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Resize Graphics Outside of Excel

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Setting a Transparent Colour for an Image

Whenever you place a picture in your worksheet, it is rectangular in nature. Sometimes, the image may actually be rather small, but the area occupied by the image is rather large. For instance, you could have a logo that is diagonal in nature, which means that there is a large "background area" on the image. This background area, for all intents and purposes, is wasted space.

Fortunately, Excel allows you to define a particular color in your image as a transparent colour. This means you could select the background area of your image, designate it as transparent, and thereby allow the underlying cells show through. To make a transparent area in your image, follow these steps:

1. Select the image you want to modify.
2. Make sure the Format tab of the ribbon is displayed.
3. In the Adjust group click the Recolor tool or the Colour tool (depending on your version of Excel). Excel displays a series of options.
4. Click Set Transparent Colour. The mouse pointer changes.
5. In the image, click on the colour you want to be transparent.

If you can't select the Set Transparent Colour tool in step 3, then you might not be able to set a transparent color in the image. Excel allows you to set the transparency colour for bitmapped graphics, but not for other types. If you later want to turn off the transparency color, then you need to click the Reset Picture tool in the Adjust group on th Format tab of the ribbon.

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Setting Default Attributes for Lines and Arrows

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel Setting the Default Fill Colour for a Shape to None

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Using WordArt in Excel

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Styles for Lines, Dashes, and Arrows

Excel allows you to place many different types of graphics objects within your worksheets. One common type of graphic object is a line or arrow. When you first insert lines or arrows into your worksheet, Excel places them using a thin line. You may want to change the width of the line used, as well as the style of line or arrow.

You make the desired changes by using the tools available on the Format tab of the ribbon. (This tab is visible only after you select the line you previously placed in the worksheet.) Click the Shape Outline option in the Shape Styles group. You'll see a palette that includes the following options:

• Weight. Use this option to specify a line width.
• Dashes. Use this option to specify a non-solid style for the line
• Arrows. Use this option to indicate how you want the arrowheads to appear.

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Taking a Picture

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Using Graphics to Represent Data Series

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Using the Camera in VBA

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Watermarks in Excel

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Cropping Graphics

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Changing the Size of a Graphic

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Creating an Organization Chart

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Company news 19th February MOS Exam Vouchers and Public Microsoft Course Dates

              Our Exam Vouchers now Include a Retake Voucher

Microsoft MOS Exam Vouchers and Materials Update 19^th February

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

For Further Detail Call : 020 7920 9500

Public open courses £125.00 +VAT

 Latest Announced Courses

Excel Introduction

26^th February and 26^th March

 Excel Intermediate 27^th February and 28^th March

Excel Advanced 28^th march

 Word Intermediate  February and 28^th March

 Excel Dashboards 21^st March

Word Advanced 31^st  March and 30^th April

One to One and Group courses also available

View Scheduled Public Courses

Excel - Adding Drop Shadows

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Changing a Shape

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Changing How Arrows Look

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Changing Line Colour in a Drawing Object

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London