Excel 365 - Intermediate

<p>This course has been designed for users who already use Microsoft Excel and wish to explore the application further. A detailed list of what is covered is provided later on. </p>

<p>Delegates need to assess their own level before choosing the Beginners, Intermediate or Advanced course. The list below gives a good indication of the content of this Intermediate course. </p>

<p><strong>Review  </strong></p>

<p>• Basic formulae: +, -, *, /  </p>

<p>• Displaying formulas  </p>

<p>• Autosum and autofill  </p>

<p>• Creating and formatting charts  </p>

<p>• Exporting worksheets and charts into other applications  </p>

<p>• Freeze panes  </p>

<p>• Printing options  </p>

<p><strong>Functions  </strong></p>

<p>• Min, max and average  </p>

<p>• Count, counta, countblank  </p>

<p>• Countif and sumif  </p>

<p><strong>Other Formulae  </strong></p>

<p>• % Calculations  </p>

<p>• Date and text functions  </p>

<p>• Absolute cells  </p>

<p>• Watch window  </p>

<p><strong>Named Ranges  </strong></p>

<p>• Creating a named range  </p>

<p>• Using a named ranges in a formula  </p>

<p>• Managing named ranges  </p>

<p>• Displaying / paste list  </p>

<p><strong>Conditional Formatting  </strong></p>

<p>• Types of conditional formatting  </p>

<p>• Creating your own rules  </p>

<p><strong>Working with Worksheets  </strong></p>

<p>• Inserting worksheets  </p>

<p>• Renaming worksheets  </p>

<p>• Deleting, moving, and copying worksheets</p>

<p>• Grouping worksheets  </p>

<p>• Creating calculations between worksheets</p>

<p>• Creating calculations across workbooks  </p>

<p><strong>Data Lists  </strong></p>

<p>• Sorting  </p>

<p>• Filtering data  </p>

<p>• Subtotals</p>

<p>•  Removing duplicates  </p>

<p>• Tables  </p>

<p><strong>Other Useful Tools  </strong></p>

<p>• Quick analysis  </p>

<p>• Flashfill  </p>

<p>• Sparklines  </p>

<p>• Comments and Noes  </p>

<p>• Autosum for subtotals and grand totals  </p>

<p>• Applying and using auto outline </p>

<p>This two-session course is not examined and does not result in a qualification. It is designed for the busy employee who wishes to increase their skill level within a compact time frame. </p>

<p>There are no formal qualifications required to access this course. However, the use of formulae and so on means this would suit delegates with a basic mathematical competence and who are familiar with computer use. Most learners will have previously taken our Excel 365 Beginners course. Learners with no previous experience should instead choose ICT for Beginners A. </p>

<p>Delegates might want to bring a notebook and pen to write down key points and it would be helpful to have some form of computer at home or at work to practice on</p>

<p>Delegates could progress to our Excel 365 Advanced course. </p><p>Need support planning your next steps? Our experienced Careers Advisors at Skills &amp; Learning can offer personalised guidance on choosing the right course, exploring career paths, developing interview skills, updating your CV and much more. Book a FREE appointment today and get the support you need to achieve your goals. Visit: <a href="https://www.skillsandlearningace.com/learning-with-us/next-steps/" target="_blank">https://www.skillsandlearningace.com/learning-with-us/next-steps/</a>. Call us at 01202 123444 for more information.</p>

<p><strong>English, maths and computing skills:</strong> all of our courses support the development of relevant English, maths and computing skills.<br />
<strong>Refunds:</strong> please see details of our cancellation policy in our Terms and Conditions on our website <a href="https://www.skillsandlearningace.com/policies/terms-and-conditions/">www.skillsandlearningace.com/policies/terms-and-conditions</a> or in our brochure.<br />
<strong>Attendance:</strong> before enrolling you should ensure that you can attend all classes offered as far as possible.<br />
<strong>Places on courses:</strong> many of our courses are in high demand. If you have been offered a place but no longer require it, please advise us immediately as you may be preventing another learner from taking the place. Where learners do not attend the first session, without having given prior notice, Skills &amp; Learning reserve the right to offer the place on the course to another learner; you will not be eligible for a refund it it is outside of the terms outlined in our cancellation policy.<br />
<strong>Fully funded learners:</strong> if you have been offered a fully funded place on a course and no longer require it, you must advise us before the course starts so that your place can be offered to someone else. We reserve the right to withdraw future offers of fully funded places if you regularly do not start or complete funded courses.<br />
<strong>Home study:</strong> you will&nbsp;be required to do significant&nbsp;study at home between sessions to assist with your learning and progress.<br />
<strong>Qualification Levels:</strong> there is further information about qualification levels on our website.<br />
<strong>Proof of identity:</strong> please bring photographic ID and your National Insurance number with you to your first session. You will also need to provide it for any external examinations you take.<br />
<strong>Off-site activities:</strong> with some courses, there may be the opportunity for off-site enrichment activities at additional cost, for example: gallery, museum or exhibition visits. Where this is an integral part of the course, your tutor will discuss the arrangements with you during your induction.<br />
<strong>Parking at centres:</strong> parking at centres may be limited; please be prepared to use on street parking or pay and display car parks. For information regarding each centre, please visit the venue section of our website <a href="https://www.skillsandlearningace.com/our-centres/">www.skillsandlearningace.com/our-centres/</a>.<br />
<strong>Refreshments:</strong> tea/coffee or vending machine(s) are available at some venues. Further information can be found in the venue section of our website <a href="https://www.skillsandlearningace.com/our-centres/">www.skillsandlearningace.com/our-centres/</a>.<br />
<strong>Unspent Criminal Convictions</strong> we require learners to disclose any unspent criminal convictions. Please refer to <a href="https://www.skillsandlearningace.com/policies/disclosure-of-unspent-convictions/">www.skillsandlearningace.com/policies/disclosure-of-unspent-convictions</a>.<br />
If you have any <strong>accessibility or disability issues</strong> that we need to accommodate or if you think you may need any other support to complete your chosen course, please contact: 01202 123444 or e-mail <a href="mailto:enquiries@salbcp.com">enquiries@salbcp.com</a>. All enquiries are treated in confidence.</p>