Excel Skills: Mastering Pivot Tables
This course is available for enrolments.
Course code: 26890
- when
-
From 26 Feb 2026
to 26 Mar 2026
Thu 09:15-11:45 5 weeks- Date
- 26 Feb 2026
- Time
- 09:15 to 11:45
- Date
- 05 Mar 2026
- Time
- 09:15 to 11:45
- Date
- 12 Mar 2026
- Time
- 09:15 to 11:45
- Date
- 19 Mar 2026
- Time
- 09:15 to 11:45
- Date
- 26 Mar 2026
- Time
- 09:15 to 11:45
- who
-
Direct Delivery
What is this course about?
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">This 5-week course is designed to help learners develop a strong understanding of Pivot Tables in Microsoft Excel. Pivot Tables are powerful tools for summarising, analysing, exploring, and presenting data. Through hands-on practice and real-world examples, learners will gain the skills to confidently use Pivot Tables for data analysis and reporting.</span></span></span></span></p>
Who is the course for?
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">Anyone looking to enhance their Excel proficiency for personal or professional use.</span></span></span></span></p>
Any previous experience/qualifications you need to do the course
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">A basic level of conversational and written English is needed to complete this course.</span></span></span></span></p>
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">Basic computer skills.</span></span></span></span></p>
<p><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">Be comfortable with basic Excel functions such as formatting, sorting, filtering, and using formulas like SUM and AVERAGE</span></span></p>
What you need to bring with you
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">Learners must have access to Microsoft Excel and a laptop or desktop with good Wi-Fi and a webcam (if online).</span></span></span></span></p>
<p><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">If the course is face -to-face the laptop will need to be brought to the venue. </span></span></p>
How you will be assessed
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">Question & Answer, Discussions, activities and observations. You will also be asked to complete Learner reflections.</span></span></span></span></p>
How much studying will I need to do outside the lesson?
<p><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">It will be advised to use the skills learnt in the classes and practise on your own Excel documents and devices.</span></span></p>
The next steps....
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">During this course we will talk to you about your next steps which could include attending workshops/courses in </span></span></span></span></p>
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">Introduction to MS Word, Improve your skills in MS Word, Improve your skills in MS Excel, Introduction to PowerPoint and Improve Your Skills in MS PowerPoint, AI in the Workplace. </span></span></span></span><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">Employability courses are available if you are looking to get into work or change your career. </span></span></p>
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">Please </span></span><a href="https://events.hertfordshire.gov.uk/step2skills?nodeId=2d35542d-138b-41f0-b4b0-2e541ba9446b&entryId=e1f192dd-054b-4d97-90ed-4dcd88611ec1" style="color:#0563c1; text-decoration:underline"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">click here</span></span></a><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif"> to see the full range of courses we offer. </span></span></span></span></p>
<p><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">We have programmes that can support you with your next steps in skills and employment. For further information </span></span><span style="font-size:11.0pt"><span style="font-family:"Calibri",sans-serif"><a href="https://www.hertfordshire.gov.uk/microsites/adult-learning/our-services/information-advice-and-guidance.aspx" style="color:#0563c1; text-decoration:underline"><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">please see our information, advice and guidance page</span></span></a></span></span></p>