Target Audience
You should be comfortable with the Excel basics and/or be using Excel regularly including formulas/functions/sort and filtering/charts.
Outline
The course will take place on Zoom over 4 sessions as per details below. Homework will be assigned between sessions. Resources and links will be stored on a platform called GiraffePad. Please note these will sessions will be recorded and shared with the attendees only. Full instructions and links will be given after registration.
Session One (90 minutes) 19 Feb starting at 3.15pm
- Revision of basics: formulas/functions/fixing cells/lists
Session Two (90 minutes) 26 Feb starting at 3.15pm
- Vlookup function: What it is, what you use it for, use in same workbook and with different workbooks.
Session Three (90 minutes) 05 March starting at 3.15pm
- Introduction to Pivot Tables
Session Four (90 minutes) 12 March starting at 3.15pm
- If functions & Introduction to Conditional Formatting
- Final Q&A
Methodology
- Delivered virtually via Zoom.
- GiraffePad will be the platform used to hold the Zoom links/training materials.
- Homework will be assigned between sessions.
Target Audience
Board Members, Chairpersons and CEOs of non-profit organisations.
Outline
- Roles and responsibilities – Board, CEO, Chair
- Communication between CEO and Chair (Board)
- HR sub-committee (CEO Selection, Review, Remuneration, Succession Planning)
- CEO role in relation to the Board
- CEO performance appraisals – how to conduct appropriately
- Board only sessions
- Board evaluation (its value and purpose)
- Success factors for effective relationships
- Common problems/pitfalls with relationships and boundaries
- Culture / code of conduct / differences of opinion / behaviour
Methodology
Delivered virtually via Zoom.
Target Audience
Are you a Board member of a voluntary or community group? Are you unsure of what is expected of you? Do you want to ensure your organisation is governed in accordance with good practice?
Outline
This session will demystify Board members’ roles and responsibilities and give you tools to enhance your contribution and the effectiveness of your Board. It outlines the purpose of the board as a whole in relation to governance and management. We then examine the specific roles of individual board members and in particular, their legal responsibilities and duties under the Charities Act (2009) and the Companies Act (2014). The workshop will finish with a discussion on typical problems arising within boards and some practical solutions to deal with them.
Methodology
Delivered virtually via Zoom.
Target Audience
Trustees, Chairs, CEOs, and those responsible for governance in their Charity.
Outline
The Charities Governance Code explains the minimum standards you should meet to effectively manage and control your charity. This workshop will walk you through the requirements of the code including actions and evidence needed to demonstrate compliance.
Methodology
Delivered virtually via Zoom.
Please note this course will take place again, starting 13th May
Target Audience
People with little or no knowledge, or experience of using Microsoft Excel.
Outline
The course will take place on Zoom over 4 sessions as per details below. Homework will be assigned between sessions. Resources and links will be stored on a platform called GiraffePad. Full instructions and links will be given after registration. Please note, these sessions will be recorded and shared with attendees only. Details of dates and topics are below:
Session One (90 minutes) Wed 15 Jan starting at 3.15pm
- Open A New Spreadsheet
- Identify Data Types
- Use Autofill
- Enter Data / Text
- Select Data / Text
- Format Data / Text
- Use Basic Formulae
- Copy Formulae
- Homework
Session Two (90 minutes) Wed 22 Jan starting at 3.15pm
- Review of homework
- Use Absolute Cell Reference
- Use built in functions: Sum, Average, Max, Min, Count, CountA
- Start on preparing lists
- Add/Delete Rows/Columns
- Sorting and Filtering
- Homework
Session Three (90 minutes) Wed 29 Jan starting at 3.15pm
- Review of homework
- Continue Sorting and filtering
- Printing
- Introduction to chart
- Homework
Session Four (90 minutes) Wed 05 Feb starting at 3.15pm
- Review of homework
- Worksheets-Housekeeping: Add, delete, rename, move/copy, hide
- Worksheets – Formulas – adding up entries across sheets.
- Final Q&A
Methodology
- Delivered virtually via Zoom.
- GiraffePad will be the platform used to hold the Zoom links/training materials/recordings.
- Homework will be assigned between sessions.
Target Audience
Middle and Senior Managers, Board Members.
Outline
A strategy is about how an organisation best positions itself whilst remaining relevant. A good strategy is clear and succinct. It boldly sets out your organisation’s ambitions, sets a clear focus aimed at achieving your mission, and it is embedded in reality.
This Strategic Planning workshop will guide you through core elements of strategy: challenge, cohesion and commitment. It will look at approaches and models in conducting strategic analysis, examining options, building in agility and how to monitor implementation.
Step-by-step, you will learn what a strategic planning process involves, what tools and techniques can help you along the way, what the end result should look like, and how to get everyone on board.
Methodology
Delivered virtually via Zoom.
Target Audience
Trustees, Chairs, CEOs, and those responsible for governance in their Charity.
Outline
The Charities Governance Code explains the minimum standards you should meet to effectively manage and control your charity. This workshop will walk you through the requirements of the code including actions and evidence needed to demonstrate compliance.
Methodology
Delivered virtually via Zoom.
Target Audience
Trustees, Chairs, CEOs, and those responsible for governance in their Charity.
Outline
The Charities Governance Code explains the minimum standards you should meet to effectively manage and control your charity. This workshop will walk you through the requirements of the code including actions and evidence needed to demonstrate compliance.
Methodology
Delivered virtually via Zoom.
Target Audience
Are you a Board member of a voluntary or community group? Are you unsure of what is expected of you? Do you want to ensure your organisation is governed in accordance with good practice?
Outline
This session will demystify Board members’ roles and responsibilities and give you tools to enhance your contribution and the effectiveness of your Board. It outlines the purpose of the board as a whole in relation to governance and management. We then examine the specific roles of individual board members and in particular, their legal responsibilities and duties under the Charities Act (2009) and the Companies Act (2014). The workshop will finish with a discussion on typical problems arising within boards and some practical solutions to deal with them.
Methodology
Delivered virtually via Zoom.
Target Audience
CEOs, senior managers or staff from non-profits/charities who’d like to learn how to improve their Microsoft PowerPoint presentations. Prior experience of using Microsoft PPT is essential.
Outline
- Slide Theory – what to think about before opening PowerPoint
- PowerPoint Fundamentals – time-saving tools to help you create professional slides
- Present with Confidence – tools to help you feel in control when you deliver your presentation
Methodology
Delivered via Microsoft Teams.