Microsoft Excel Foundation course with Bridgend College

Microsoft Excel Foundation

About

This course will provide you with the basic skills to use Microsoft Excel. You will understand how to create Excel workbooks and worksheets and navigate around them. You will learn how to use some of Excel’s basic features and learn time-saving exercises such as Autosum and Autofill, how to create simple formulae and format worksheets.

Start
1 October 2021

Duration
1 day

Enquire today

Location
Queens Road Campus

Fees

£75 + VAT

Overview & Modules

The Excel Environment
Copying, Moving and Deleting Information
Copying, Moving, Resizing and Deleting Rows and Columns
Using the Format Painter
Formatting in Excel (Border and Shading, Cell Formatting)
Wrap Text feature
Merge and Centre feature
Text Alignment and Text Formatting
Creating basic formulas using mathematical operators (+,-,/ and *)
Using BODMAS rules to create formulas
Creating Percentage formulas
Absolute Cell Referencing (using Dollar ($ signs) in formulas)
Managing Worksheets (Insert, Delete, Rename,
Move, Copy worksheets and colouring worksheet tabs)
Using and Managing the Autosum feature (Sum and Average feature)
Using Excel Functions:
o Sum Function and Average Function
o Max Function and Min Function
o Count Function

How will I be assessed?

Assessment is by portfolio of work.

Entry requirements

Pre-requisites

Basic IT Skills including saving, opening and closing documents and computer applications i.e. Excel
Good keyboard and mouse skills
Proficient data entry skills
Ability to copy, move and delete information to a basic standard
Basic Excel formatting skills. i.e. changing font colour and font sizes
Aligning information in Excel including left, centre and right alignment
Basic knowledge of Excel calculations , i.e. adding and subtracting

Continue your studies

Progress to the Excel Intermediate and Advanced sessions.