Team Upskilling Programme

Overview of the Excel screen and navigating around worksheets. Examining different mouse pointer shapes and what they mean.

Using Standard Calculations:

Use standard formulas for basic calculations. Calculating row and column totals. Use a range of basic functions to average and return highest and lowest values.

Copy formulas using relative references.

Using Brackets in Calculations:

Understand the sequence of calculations, spreadsheet mathematics.

Working With Rows and Columns:

Adjusting column widths and row heights. Inserting and deleting rows and columns.

Hiding data in rows and columns. Using Freeze Panes on large worksheets.

Working With Worksheets:

Adding new worksheets. Moving worksheets, copying worksheets to another file

Renaming worksheets and use tab colours.

Enhancing The Appearance of Worksheets:

Apply a range of formatting techniques. Changing text style, size, colour and alignment. Applying a range of borders and shading and merging cells. Use text wrapping option. Using decimal places and percentage formats. Inserting images onto worksheets.

Creating Charts and Graphs:

Create a range of charts for data analysis both embedded with the data or displayed on separate worksheets. Apply a range of enhancements to charts to see information and trends clearly.

Preparing Worksheets for Printing or Email:

Use print preview to view worksheets. Make changes to the orientation and scaling to view and print data correctly. Use page break preview to view and print large worksheets and see all information correctly. Use Print Titles across multiple pages.

Overview of the Word screen and examining the options available on the ribbons.

Examining different word processing views, scroll bars and zoom controls. Open documents.

Working within a document

Navigating around a multi-page document. Techniques for selecting text in a document. Use a range of editing techniques to change or delete text. Moving and copying text and paragraphs.

Formatting a document

Make changes to text style, size and colour. Changing line spacing. Applying text alignments. Using bullets and numbering.

Structuring document layout

Inserting page breaks into a document. Inserting page numbering. Using headers and footers in documents. Changing page orientation. Adjust margins in documents.

Inserting images into documents

Inserting images from the computer/laptop. Inserting images from the Internet. Controlling the position of images within a document and text wrapping.

Creating and formatting a table

Insert a table into a document. Adding text and adjusting column widths. Adjusting row heights within the table. Apply formatting to a table.

Document accuracy

Using the built-in spelling and grammar checkers. Quickly correcting misspelt words.

Ensure document grammar is correct.

Printing options

Viewing a document in print preview. Printing out specific pages. Using page setup to make adjustments.

Overview of the PowerPoint screen and navigating around options on the ribbon tabs. Examining different ways of viewing a presentation.

Creating a Presentation

Create a range of slides using different types of slide layout, Title slide, Bulleted slide, Blank slide Table slide, SmartArt graphic slide etc.

Using Design Ideas and Templates

Applying a range of design templates. Use a range of options with Design Ideas.

Making changes to adjust template layouts.

Inserting Images onto Slides

Inserting images from your computer/laptop. Inserting images from the Internet. Moving and sizing images to suit needs. Using Design Ideas image layouts.

Applying a range of enhancements to text.

Changing Font Styles, Size and Colour. Applying different effects to text. Using text alignment options. Inserting text boxes onto slides.

Using Drawing Techniques

Drawing a range of different shapes. Moving and sizing shapes to meet needs.

Applying Transitions and Animation Effects

Applying transitional styles to slides. Apply a range of animation effects to different objects on slides.

Preparing your Presentation to meet the needs of the audience

Preparing to run a slide show. Reordering slides in a presentation. Printing slides and audience handouts. Making changes so that the content is clearly visible to the audience.