Target Audience
Participants should have either completed the Intermediate course and/or be familiar with the following material from experience:
- Be comfortable with the basic functions of Excel: basic formulas and functions, creating a chart, sorting and filtering, printing and working across worksheets.
- How to create a vlookup()
- How to create a pivot table
- How to create an If() function
- How to do basic conditional formatting
This knowledge will be assumed and will not be covered in this course.
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 sessions will be recorded and recordings will be sent to attendees only. Full instructions and links will be given after registration.
Session One (90 minutes) Wed 08 May starting at 2.30pm
Pivot Tables beyond the basics – learn how to use pivot tables even more effectively:
- Learn how to combine datasets without the use of a vlookup or index/match.
- Learn how to use the GetPivotData() function to extract information from a pivot table to use elsewhere.
- Introduction to PowerPivot to create more complex calculations that currently feasible in standard pivot tables.
Session Two (90 minutes) Wed 15 May starting at 2.30pm
Automate your work:
- Introduction to Macros.
- Learn to create more complex formulas e.g. nested ifs, index/match
Session Three (90 minutes) Wed 22 May starting at 2.30pm
Automate data cleaning with Power Query:
- For regular data cleansing tasks – set them up in Power Query – do them once and that’s it. Speed up those tedious data cleansing tasks.
Session Four (90 minutes) Wed 29 May starting at 2.30pm
Visualising your data with Dashboards:
- Present your data in a more user friendly way by summarizing it in an interactive dashboard.
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
Individuals or organisations interested/involved in setting up and running a small non-profit organisation, or supporting others doing the same.
Outline
This online course will be delivered over 2 weekly Zoom sessions as per the details below. For privacy reasons, these sessions will not be recorded, so please make sure to attend both sessions if possible.
Module 1: (Thurs 23 May 10am – 1pm)
Establishment of a Group
- Setting up a community group
- Deciding on the Legal Structure
- Writing Your Constitution
- Recruiting Volunteers
Running of the Group
- Committee Roles
- Running a Meeting
- Agendas/Minutes
Module 2: (Thurs 30 May 10am – 1pm)
Making Decisions
- Conflict of Interest
- Code of Conduct
- Communication with members of group
Legal Duties
- Regulatory Responsibilities
- Charity/Tax & Bank Accounts
- Succession Planning
Methodology
Delivered virtually via Zoom.
Target Audience
Staff Members of charities and not-for-profits.
Outline
This interactive workshop will provide the participant with an easy-to-understand background on the GDPR as well as a way to identify data breaches and looking at measures on how to appropriately protect personal data, whether it’s on paper or held electronically.
1. Introduction:
• What is data protection and why is it important?
• What is the GDPR and how does it apply to charities and not-for-profits?
• The key principles of the GDPR.
• The benefits of GDPR compliance.
2. Data subject rights
3. Data breaches:
• What is a data breach?
• How to respond to one.
• Some examples of real-world data breaches.
4. Measures to protect personal data
Methodology
Delivered virtually via Google Meet. A copy of the slides will be provided as well as a link to download more detailed guidance on data protection.
BLAH BLAH BLAH
xxxxxxxxxxxxxxxxx
Target Audience
Prior experience of using Microsoft PowerPoint is essential.
Outline
You will learn how to create advanced content that will include:
- advanced photo editing tips
- how to insert and edit video and sound content
- how to animate content
- how to add slide transitions and how they can be used with your content
- an overview of the ‘presenter view’ and how to use this function when presenting
- How to make your presentation interactive with a Live demonstration of Poll Everywhere
Methodology
Delivered virtually via Zoom.
test test test
Test text
Target Audience
Prior experience of using Microsoft PowerPoint is essential.
Outline
You will learn how to create advanced content that will include:
- advanced photo editing tips
- how to insert and edit video and sound content
- how to animate content
- how to add slide transitions and how they can be used with your content
- an overview of the ‘presenter view’ and how to use this function when presenting
- How to make your presentation interactive with a Live demonstration of Poll Everywhere
Methodology
Delivered virtually via Zoom.