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
where
location to be advised
fees
full fee for this course £25.00  (concessions free)
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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,sans-serif">Modify tables.  Functions and formulas.</span></span></span></span></p>

<p><span style="font-size:12.0pt"><span style="font-family:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,sans-serif">click here</span></span></a><span style="font-size:12.0pt"><span style="font-family:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Calibri&#34;,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:&#34;Source Sans Pro&#34;,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:&#34;Source Sans Pro&#34;,sans-serif">.</span></span></p>