Excel, Intermediate - Tutor withdrawn (HE06U07E)
A course for those who have used Excel before and wish to improve formatting, organise data, highlight key information, and create formulas/links between sheets. This course will also include Pivot Tables and Macros.
Course overview
This course builds on the Introduction to Spreadsheets course content using Excel to perform more advanced formatting, organise data, highlight key information, create formulas/links between sheets and will include Pivot Tables and Macros.
Where Sixth Form Centre, Heathfield Community College, Cade St. Old Heathfield, East Sussex, TN21 8RJ.
When
Saturday, 10:00am - 4:00pm on 14th May 2022 for 1 day.
Cost
The full fee is £58.00.
What you already need to know
You will need to be familiar with the basics of Excel or spreadsheets or have a working knowledge and be able to create simple worksheets, enter and format data and run simple calculations.
What you will learn
How to use multiple worksheets
- Navigate between sheets
- Move and copy sheets
- Link worksheets
- Enter date functions
- TODAY function
- NOW function
- Date and time formats
- Use dates in formulas
Conditional Formulas and Formatting
- The IF function
- Conditional formatting
- Create named ranges
- Use named ranges in formulas
- COUNTIF(s), SUMIF(s), AVERAGEIF(s)
List Management
- Work with lists
- Create dynamic ranges
- Sort and filter lists
- Sort by multiple columns
- Use AutoFilter
- Tables
Working with Lookups
- The VLOOKUP function
- The HLOOKUP function
- The XLOOKUP function (365)
- INDEX & MATCH
PivotTables and PivotCharts
- Create and rearrange PivotTables
- Use the PivotTable toolbar
- Create PivotCharts
- Use Slicers to manipulate PivotTables
Macros
- Create macros
- Use the macro recorder
- View and edit macro VBA code
How you will learn it
The session will be broken down into "small chunks", which will consist of step-by-step tutor instruction and demonstration, followed by you practising and applying these skills to create and format spreadsheets, all carried out in a relaxed and friendly environment.
Bring to the first session
- Handouts will be supplied, but pen and paper to make your own notes would be advisable.
- Desktops computers with Excel will be available during the course, but you are welcome to bring your own laptop. Please let ACRES staff know if you intend to use your own device at enrollment. No tablets, please.
** Please bring a packed lunch as food is not provided at the venue.** Tea, coffee and biscuits are available for purchase during breaks.**
Special notice regarding equipment
By enrolling on this course, you agree to take responsibility for your own equipment's safety, security, and insurance. ACRES does not accept liability for any damage or loss caused by accident or through the downloading or viewing of any malicious or illegal software or content whilst using the Internet, email, transferring of files to and from your device, laptop and/or desktop computer or any other activity undertaken whilst on this course. If you have any questions regarding this, please speak to your tutor or contact the ACRES office on 01825 761820.
Extra study or practice
This is a one day workshop.
How to enrol
You can enrol by phoning ACRES' House on
01825 761820 on Monday to Friday between 9:30 am and 4 pm. Alternatively, to register your interest in a course please email
adultlearning@acres.org.uk with the course title and your contact details and a member of the team will call you back to enrol you on your chosen course.
Additional Course Information
- Concessionary/reduced fees, are available to students in receipt of certain means-tested benefits on some courses.
- Course fees over £133, can be paid in one single payment at enrolment or in instalments by Standing Order where applicable.
- Fees and payment options: See the Financial Support page.
- Other course related information: See the Policies & Procedures page, or contact the ACRES office.
Specific Covid Considerations:
In the event of restrictions being reintroduced and if the class is remaining in the venue, you will be informed of further safety measures. If the lessons cannot take place because the tutor has to isolate or in the event of government-imposed restrictions or lockdowns, every effort will be made to reschedule the missed classes. If it is not possible to continue the course in the venue it will be continued online. If this is not possible we will refund the outstanding lessons.
To ensure Safe Practice during practical sessions:
- Class numbers are reduced to allow students to space apart.
- Students should work at separate tables or desks.
- Hand sanitiser will be available in all classrooms.
- You are responsible for sanitising your own workspace before and after each lesson, anti-bacterial wipes or spray will be provided by the tutor.
- Wearing a mask is a personal choice. Please respect the choices of your tutor and fellow students.
- Windows and doors left open to allow for room ventilation should not be adjusted by students.
- Sharing of equipment is discouraged, but if it is essential, please use the wipes / spray provided to clean between handling.
- Please make yourself aware of local guidance, particularly in community venues.
You must not attend the class if you show signs or symptoms of Covid-19, are awaiting results of a PCR Covid test, have been in close contact with a Covid-19 patient within 14 days or anyone who has been advised to self isolate for any reason. Please inform the ACRES' office, who will advise the tutor.
All tutors, students and visitors are encouraged to participate in rapid lateral flow testing in the interest of everybody's safety, however, this is not a mandatory requirement. Test kits are readily available locally or from the
gov website.
Next steps within this subject with ACRES
Please check the ACRES website for up to date details of upcoming computer skill courses.
Future steps beyond ACRES
Find out about other courses with the
National Careers Service for opportunities to extend your skills and knowledge.