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

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

where

location to be advised

fees

Fees and concessions

total  fee  for  this  course: £30.00.

the full tuition 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:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-family:&#34;Helvetica&#34;,sans-serif"><span style="color:black">Know how to create everyday formulas. Learn techniques for summarising and sorting data to produce reports. This course builds on the essential skills that you will need for using Excel in the workplace.</span></span></span></span></p>

<ul>
<li><span style="font-size:11pt"><span style="color:black"><span style="font-family:Calibri,sans-serif">Create a Data Table and apply formatting. </span></span></span></li>
<li><span style="font-size:11pt"><span style="color:black"><span style="font-family:Calibri,sans-serif">Use formulas and Functions to analyse data. </span></span></span></li>
<li><span style="font-size:11pt"><span style="color:black"><span style="font-family:Calibri,sans-serif">Sort and Filter data </span></span></span></li>
<li><span style="font-size:11pt"><span style="color:black"><span style="font-family:Calibri,sans-serif">Use Charts to present data. </span></span></span></li>
<li><span style="font-size:11pt"><span style="color:black"><span style="font-family:Calibri,sans-serif">Working with multiple worksheets and using AutoFill and Built in lists. </span></span></span></li>
</ul>

Previous experience, knowledge or qualifications

<p>This course is designed as a follow on from our Excel for beginners course. Some prior knowledge or experience using Excel is required so if you already understand most of the basics of using Excel listed below then this course may also be suitable:</p>

<ul>
<li>Basic Excel jargon and terminology such as rows, columns, cells</li>
<li>create a simple Data Table and apply basic formatting. </li>
<li>create basic formula using mathematical operators (Add, Subtract, Multiply, Divide). </li>
<li>Use basic functions to produce a formula using =SUM, =MIN, =MAX, =AVERAGE, =COUNT. </li>
<li>Inserting a Recommended Chart. </li>
<li>Change Page Setup and Orientation</li>
<li>altering headers and footers</li>
<li>freezing panes</li>
</ul>

Equipment Required

<p>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.  </p>