Tutor : Mary Reed

DESCRIPTION:

Looking to update your knowledge of spreadsheets, This NEW workshop is for you!

Using Microsoft Excel software recap skills and experiment with different formats; formulae; graphs and charts. The workshop will be of  a practical nature,  tutor led with quick reference guides, Tutor demonstration, Quiz and hints &  tips.

This course can be aimed at and topics could include:-

Beginner :- New to compiling and working with spreadsheet application – Enter data, format, simple graphs, simple formulae, printing techniques hints & tips BODMAS, replication of data.

Intermediate :- Use of logic functions,  graphs & charts, conditional formatting, sorting data, filters, more functions

Advanced – Lookups, Pivot Tables, scenarios, database function, linking workbooks, macros, sub totals data analysis, financial functions. Validation. Even more functions

This will probably be a mixed ability workshop attendees should be advised that exercises will be supplied individually to current level of expertise in the subject. It is a large topic impossible to cover all functions and facilities in one session; the aim is to improve on your current knowledge.

• assistance where time allows

MATERIALS SUPPLIED BY TUTOR:

Workbooks & Quick reference guides

ANY MATERIALS/EQUIPMENT REQUIRED BY STUDENTS:

USB storage device, pen & paper

Meet the Tutor: Mary Reed

I have been teaching ICT for some years! I obtained my computing qualification in Cardiff University and teaching certificate in Caerleon. I have kept up to date by obtaining my digital literacy teaching qualification. I have attended many courses led by Cannon UK and completed an Open University course on the topic of understanding genealogy.

I teach beginners computing up to level 3 “A” level standard; introducing learners to the digital world using their own devices including digital cameras. My new venture last year was the world of family history and genealogy. This year I am developing courses based around cloud storage and applications.

I enjoy imparting knowledge and sharing student success in their achievements.