Other Services
Close

Excel Complete - Fast-Track

Need to know more about Excel but don't know where to start? This first stage course covers Introductory level topics including worksheets and workbooks, calculations, formatting, printing, charts, functions, formulas, cell references, datalists, introduction to macros and program options. This Stage course will cover the more advanced features of Excel- goal seek, what-if analysis, data tables and filters, conditional formula, pivot tables and advanced use of charts. From macros make use of Visual Basic within Excel to build automated and customised solutions.
  • Who is it for?

    Those who need to use Excel spreadsheet skills. Although the student need have no previous experience of Excel, it is essential that the student has previous experience in Windows and File Management. Suitable for 'beginners' to Excel.

    Experience of working with Windows and File Management is essential.

  • What does it cover?

    Excel is the spreadsheet program that is widely used commercially. This course provides the student with a knowledge of the main features of Excel and is ideal for students who wish to pursue a career in office computing.

    Workbooks/Worksheets; Open/Save Files; Enter Numeric Data & Text; Intro to Formatting; Select/Copy/Name Cells and Ranges; Select/Copy/Move cells; Relative and Absolute Cells; Insert/Delete Column & Row; Intro to Simple Formula; Fill handle; Cell Height & Width; Intro to Printing; Intro to Charts;; Advanced Formatting; Auto format; Protecting Worksheets; Advanced Printing; Page Setup (incl. Headers & Footers, orientation, scaling); Financial /Statistical /Maths Functions and Formulas; Data Lists/Databases; Data Forms.
    It also covers the more advanced and specialised aspects of Excel as well as Visual Basic for Applications
    Goal Seek and 'What if' Analysis; Data Tables; Pivot Tables; Extended Graphics; Data Validation; Functions; SubTotals; Formula Auditing; Conditional Formatting; Visual Basic Macros; Macros and Data Lists; Navigation Keys; Controls (e.g. Command Button); With Statements; Decision Marking Procedures Create Macros - introduction (If, Then etc); Loops; Message Boxes; User Defined Functions; Options
    By the end of the course you should be able to:
    ' Create a spreadsheet, input and edit data, save and open files
    ' Use formulas and functions from simple to advanced level
    ' Format a work sheet from basic formatting to advanced level
    ' Create appropriate charts and graphs to represent different types of data
    ' Use a spreadsheet as a database to use and sort and filter data
    ' Use goal seek and what if analysis
    ' Use and create macros and use VBA code to edit and construct macros

  • What will it be like?

    Demonstration using Smartboard through computer-linked projectors, exposition and discussion. One-to-one and Group work. Through tutor-guidance and hands-on experience, the completion of the course objectives.
    Ongoing monitoring of students' work including questions, observation and tasks. Start and End of class student self-assessment/achievement check box sheet.
    Teaching methods: Visual demonstration and verbal explanation. Written handouts with visual diagrams. One-to-one teaching. Group discussions
    Learning methods: Hands-on practical activities, Reading handouts and following instructions.
    One-to-one and group discussion.
    How students are assessed: Questions and answers during group discussions and one-to-one teaching.
    Record of students' progress and achievement on an assessment sheet as they achieve the course objectives. Practical work produced is evidence of learning.

  • What else do I need to buy or do?

    Materials are supplied free of charge by the Centre. As much practice as possible to reinforce learning. This may be at home or elsewhere or from homework given by the tutor.

  • What could it lead to?

    PowerPoint, Ms Project, Word, Office Essentials.
    There is detailed information in Reception about all our courses at the Mary Ward Centre.

Available Courses

Excel Complete - Fast-Track

Need to know more about Excel but don't know where to start? This first stage course covers Introductory level topics including worksheets and workbooks, calculations, formatting, printing, charts, functions, formulas, cell references, datalists, introduction to macros and program options. This Stage course will cover the more advanced features of Excel- goal seek, what-if analysis, data tables and filters, conditional formula, pivot tables and advanced use of charts. From macros make use of Visual Basic within Excel to build automated and customised solutions.

30 September 2023 – 28 October 2023
Saturday, 10:00 to 17:00
Course Code:2025
£214 / £64
5 Meetings
1 Rushworth St
Enquire

Can't see what you want?

Ms Office Essentials - Stage 1

If you need to be able to make basic use of the MS Office programs Word, Excel, PowerPoint and Outlook, then this course will get you started. You may then choose a full course, perhaps in Excel or PowerPoint to extend your skills.

30 October 2023 – 27 November 2023
Monday, 14:00 to 17:30
Course Code:2017
£129 / £38 / £0
5 Meetings
High Street, Stratford
View Course
08 January 2024 – 05 February 2024
Monday, 14:00 to 17:30
Course Code:2019
£129 / £38 / £0
5 Meetings
High Street, Stratford
View Course

COMPUTERS FOR BEGINNERS

Do you own a computer or laptop and can't use it? Do you need help to get started? This short course is a chance to demystify the computer in a friendly and supportive environment. Learn how to open files, save files, then how to do basic word processing and use the internet. Please come to one of our regular Assessment sessions on a Thursday or Friday morning to join this class.

31 October 2023 – 28 November 2023
Tuesday, 10:30 to 13:30
Course Code:2005
£107 / £32 / £0
5 Meetings
High Street, Stratford
View Course
16 January 2024 – 13 February 2024
Tuesday, 10:30 to 13:30
Course Code:2006
£107 / £32 / £0
5 Meetings
High Street, Stratford
View Course
17 January 2024 – 14 February 2024
Wednesday, 10:30 to 13:30
Course Code:2026
£107 / £32 / £0
5 Meetings
1 Rushworth St
View Course
23 April 2024 – 21 May 2024
Tuesday, 10:30 to 13:30
Course Code:2007
£107 / £32 / £0
5 Meetings
High Street, Stratford
View Course

MS Office Essentials For Work - Stage Two

If you feel you can already effectively use MS Office programs (Word, Excel, PowerPoint and Outlook) but need to hone your skills for employment this is the course for you. It will not cover the basic features of these programs but will include the more complex everyday tasks required in the working environment. Students will need to be sure of their level of computer knowledge before enrolling on this course. Please ask for advice if you are unsure.

12 January 2024 – 15 March 2024
Friday, 18:00 to 21:00
Course Code:2015
£223 / £66 / £0
10 Meetings
Online Course
View Course
26 April 2024 – 28 June 2024
Friday, 18:00 to 21:00
Course Code:2016
£223 / £66 / £0
10 Meetings
Online Course
View Course

Meet The Tutor

For more information contact The Departmental Administrator at admin@marywardcentre.ac.uk

Journey Planner.

See how long it will take you to get to college. Please select the campus of the course you wish to study.

Plan my journey