Excel for Work

This course requires you to follow an application process.

Registered before?  sign in to start your application
Not registered yet?  click here to start your application

Course code: LW2425

Covers everyday formulas and techniques for summarising and sorting data to produce reports. This course builds on essential skills that you will need using Excel in the workplace. (please read the course details before applying to check that this course is suitable)

when
From 24 Feb 2025 to 31 Mar 2025
Mon 10:15-12:156 weeks
Date
24 Feb 2025
Time
10:15 to 12:15
Date
03 Mar 2025
Time
10:15 to 12:15
Date
10 Mar 2025
Time
10:15 to 12:15
Date
17 Mar 2025
Time
10:15 to 12:15
Date
24 Mar 2025
Time
10:15 to 12:15
Date
31 Mar 2025
Time
10:15 to 12:15
where
Wokingham library 

Carnival Hub, Wellington Road
Wokingham
RG40 2AF


fees
full fee for this course £30.00  (concessions free)
who

Wokingham Borough Council Adult Education

adulteducation@wokingham.gov.uk

What this is about

<p><span style="font-size:12pt"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif"><span style="color:black">Learn to use Excel to create a range of data tables, sort and filter data, use pivot tables and Lookups to analyse data.</span></span></span></span></span></p>

<p><span style="font-size:12pt"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif"><span style="color:black">What will be covered:</span></span></span></span></span></p>

<ul>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Creating a Data Table and applying formatting</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Sort and Filter Data</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Use Pivot Tables</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Use Lookups</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Data Validation and Conditional Formatting</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">More on Charts</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">More on Headers and Footers</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Working with multiple Workbooks</span></span></span></span></span></li>
</ul>

Previous experience, knowledge or qualifications

<p><span style="font-size:12pt"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif"><span style="color:black">This course is designed to build on the skills and knowledge taught on Excel For Beginners, so learners need to be confident in the following skills to proceed confidently on this course.</span></span></span></span></span></p>

<ul>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Excel Jargon and Terminology</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Navigating around the workbook</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Creating a data set and applying formatting</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Using Mathematical Operators (+, -, *, /) to perform calculations</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Use basic Functions =SUM, =MIN, =MAX, =AVERAGE, =COUNT</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Insert a recommended Chart</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Working with multiple Worksheets in a Workbook</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Change Page Setup and Orientation</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Insert Headers and Footers</span></span></span></span></span></li>
<li><span style="font-size:12pt"><span style="color:black"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Freeze Panes</span></span></span></span></span></li>
</ul>

Equipment Required

<p><span style="font-size:12pt"><span style="font-family:Aptos,sans-serif"><span style="font-size:11.0pt"><span style="font-family:&#34;Calibri&#34;,sans-serif">Ideally you should have a personal device on which to be able to practice the tasks learned in class at home. Alternatively, be able to make time between sessions to use the library computers.  </span></span></span></span></p>

<p>We provide a laptop for you to work on during lessons.</p>