Excel – Stage 2
The second stage covers the more advanced features - goal seeking, 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 this course for
Those who need to use Excel spreadsheet skills in a more advanced way, for work or business. Student need previous experience of Excel and in Windows and File Management. This is not suitable for 'beginners' to Excel.
What does this course 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.
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 an advanced spreadsheet, input and edit data, save and open files
' Use formulas and functions to an advanced level
' Format a work sheet to an 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
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 you 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 this course could lead to
PowerPoint, Ms Project, Word, Office Essentials.
There is detailed information in Reception about all our courses at the Mary Ward Centre.
Information about other learning opportunities can be obtained from Learn Direct: www.learndirect.co.uk and from the following websites: www.floodlight.co.uk; www.hotcourses.com; www.citylit.ac.uk; www.wmcollege.ac.uk; www.morleycollege.ac.uk
I've been to many Centres to study in London and the Mary Ward Centre is one of the nicest I've studied in.MWC student
This course has concessions available for people who meet certain criteria
Got a Question about this Course?
Contact The Departmental Administrator.
Why come to Mary Ward Centre?
Mary Ward Centre is the adult education centre with a difference. We provide a wide range of subjects for people at all levels and run courses during the day, evening or weekend to suit your timetable.
Get inspired and enjoy excellent teaching in an environment where each individual’s learning experience is valued. That’s what makes Mary Ward Centre ‘the friendly place to learn.’