Excel for Work
This course requires you to follow an application process.
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
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
Fees and concessions
total fee for this course: £30.00.
the full tuition fee for this course: £30.00 (concessions free) .
What this is about
<p><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-family:"Helvetica",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>