Improving Your Skills in MS Excel
This course requires you to follow an application process.
Course code: 27449
- when
-
From 15 Jan 2027
to 12 Feb 2027
Friday 09:30-12:00 5 weeks- Date
- 15 Jan 2027
- Time
- 09:30 to 12:00
- Date
- 22 Jan 2027
- Time
- 09:30 to 12:00
- Date
- 29 Jan 2027
- Time
- 09:30 to 12:00
- Date
- 05 Feb 2027
- Time
- 09:30 to 12:00
- Date
- 12 Feb 2027
- Time
- 09:30 to 12:00
- who
-
Direct Delivery
What is this course about?
<p><span style="font-size:16px">Ready to take your Excel skills to the next level? This intermediate course is designed to help you build confidence, work more efficiently, and unlock powerful tools within Microsoft Excel.</span></p>
<p><span style="font-size:16px">Over five weeks, you’ll develop practical skills that you can immediately apply to real-life tasks—whether at work, at home, or in further study.</span></p>
<p> </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">1. Freeze/unfreeze rows and columns. Split a worksheet. </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">2. Filter data. Apply multiple filters. Filter data with search. Apply advanced text/number/data filter. Use find and replace.</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">3. Create a conditional formatting. Sorting data. Custom sorting. Add multiple levels to any sort. </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">4. Group and ungroup worksheets. Make a drop downs. </span></span></span></span><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">Modify tables. Functions and formulas.</span></span></span></span></p>
<p><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">5. Create more complex formulas. Relative and absolute cell references.</span></span></p>
Who is the course for?
<p><span style="font-size:14px">This course is perfect for you if you already understand the basics of Excel and want to build on your skills.</span></p>
<p><span style="font-size:14px">If you’re looking to improve your efficiency, boost your confidence, or prepare for work or further study—this course is for you.</span></p>
Any previous experience/qualifications you need to do the course
<p><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. You must also have a basic level of Excel and computer skills</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 wifi 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, 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:14px">To build your confidence, you’ll be encouraged to practise your new skills between sessions.</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 other courses/workshops such as</span></span></span></span></p>
<p><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, Introduction to MS PowerPoint and Improve Your Skills in MS PowerPoint.</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><span style="font-size:12.0pt"><span style="font-family:"Source Sans Pro",sans-serif">.</span></span></p>