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
24 January 2020
Duration
1 day
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
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.
Currently Employed
1125
Job opportunities
835
Average Wage
£32635
