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
Summer 2019
Duration
1 day
Location
Queens Road Campus
Fees
£75 + VAT
For in-company training requirements, eg. group of employees requiring training, please contact us requesting an appointment with our Business Development Manager.
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
We offer a variety of art-related topics with Bridgend Community College, including:
- Drawing
- Drawing from observation
- Painting from acrylics
Latest regional data including Bridgend, Cardiff and Swansea.
[jsoncontentimporter url=https://bridgend.emsicareercoach.com/packets/occupationemploymentdemographics/?OccupationId=2133&x-ResponseType=json&x-Password=01a89fa9afafaa9ee5b1f8b24dddd78d4812bf1ffc4929af7da47a51e9bea5c9]
{CurrentEmployment}
Currently Employed
[/jsoncontentimporter]
[jsoncontentimporter url=https://bridgend.emsicareercoach.com/packets/occupationemploymentsuccinct/?OccupationId=2133&x-ResponseType=json&x-Password=01a89fa9afafaa9ee5b1f8b24dddd78d4812bf1ffc4929af7da47a51e9bea5c9]
{NextYearEmployment}
Job opportunities
[/jsoncontentimporter]
[jsoncontentimporter url=https://bridgend.emsicareercoach.com/packets/occupationearnings/?OccupationId=2133&x-ResponseType=json&x-Password=01a89fa9afafaa9ee5b1f8b24dddd78d4812bf1ffc4929af7da47a51e9bea5c9 basenode=75]
£{Annual}.00
Average Wage
[/jsoncontentimporter]
[jsoncontentimporter url=https://bridgend.emsicareercoach.com/packets/occupationearnings/?OccupationId=2133&x-ResponseType=json&x-Password=01a89fa9afafaa9ee5b1f8b24dddd78d4812bf1ffc4929af7da47a51e9bea5c9 basenode=75]
£{Hourly}
Hourly
[/jsoncontentimporter]
