Back to All Events

Microsoft Excel Training – Introductory - Brecon

Microsoft Excel Training - Level 1 Basic Course, Brecon

Join us for this free 1 day course on Excel.

Course Content:-

An Introduction to the Excel Environment

Accurately distinguish and use various parts of the Excel screen.

Understand cell referencing.

Basic Spreadsheet Skills

Enter spreadsheet data Edit, clear, and remove spreadsheet data.

Insert and remove columns and rows. Adjust column widths and row heights.

Moving and Copying Data

Move and copy the data provided using icons. Move and copy the data provided using the mouse.

Formatting Cells

Correctly apply cell font formatting Correctly apply numeric formatting. Correctly apply advanced cell formats using the Format Cells window

Clear out formats from cells accurately. Copy formatting using the Format Painter

Working with Worksheets

Insert and rename new worksheets efficiently. Delete worksheets.

Move and copy worksheets using the mouse.

Link worksheets to copy data onto multiple sheets.

AutoFill

Quickly copy the contents of a cell by “dragging down.” Automatically enter sequential dates, days, months Create your own numeric sequences.

Using Flash Fill

How get Excel to automatically fill columns with “patterns” of data.

Examples of using Flash fill

Paste Special

Instantly swap rows and columns of data around Link cells into other sheets accurately Paste only the values from cells to remove a formula.

Excel Formulas

Accurately enter an Excel formula.

Adding, Subtracting, Dividing and Multiplying in an Excel spreadsheet

Working with Basic Excel Functions

Accurately enter SUM, MIN, MAX, AVERAGE, COUNTA and TODAY functions

Absolute References

Accurately enter a formula that uses absolute references.

Using Quick Analysis

Entering formulas using the Quick Analysis feature

Freeze Rows and Columns

Keep a part of the sheet visible while the rest of the sheet scrolls.

Sorting and Filtering Data

Sort data into alphabetical or numeric order

Use Custom Sorting to sort to more than one level. Filter data to show only the data you want to see.

Printing

How to use the Print and Print Preview areas How to change margins and paper size

Using Headers and Footers Scaling the page to fit on A4 Using Page Layout View

Print Titles so that your data headings repeat on new pages.

Simple Charts

How to insert a simple chart to show your data accurately.

How to alter a chart

Date: Tuesday 12th November 2024

Venue: Brecon

Time: 9.30am - 4.30pm

Cost: Free

Booking is essential as places are limited. You need to live or work in Powys to be eligible to attend. To reserve your place please book below.

If there are no spots available and you wish to be added to the reserve list in case of cancellation please email sam@mwmg.org

Previous
Previous
November 7

Developing Great Working Relationships - Newtown

Next
Next
November 13

Excel Pivot Tables-AM Session Online