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: WaitListExcelWork

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: We plan Excel courses at various times during the year, this is an enquiry placeholder entry. If there are no courses advertised, or none that suit your availability, you can register your interest by applying here.

where

location to be advised

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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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:"Calibri",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>