Excel 365 - Advanced

<p>This course has been designed for regular Excel users who would like a better understanding of the analysis tools available and some advanced functions. Many delegates taking this course will first have taken our Excel 365 Intermediate course. </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 Advanced course. </p>

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

<p>• Conditional formatting  </p>

<p>• Absolute references  </p>

<p>• Named ranges  </p>

<p>• Statistical functions  </p>

<p>• Using the function wizard</p>

<p>• Adding buttons to the Quick Access Toolbar  </p>

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

<p>• Basic If functions / Ifs  </p>

<p>• Nested If functions  </p>

<p>• And, or, not functions Lookup Functions  </p>

<p>• Vlookup / Hlookup  </p>

<p>• Xlookup  </p>

<p><strong>Data Validation  </strong></p>

<p>• Setting up validation for inputs  </p>

<p>• Using data validation  </p>

<p>• Using data validation to test existing data  </p>

<p>• Creating a drop-down list  </p>

<p><strong>Pivot Tables  </strong></p>

<p>• Creating and using pivot tables  </p>

<p>• Formatting pivot tables  </p>

<p>• Editing / Refreshing  </p>

<p>• Slicers  </p>

<p>• Timelines  </p>

<p>• Pivot charts  </p>

<p>• Recommended pivot tables  </p>

<p><strong>Templates  </strong></p>

<p>• Creating a template  </p>

<p>• Where to store a template  </p>

<p>• How to access a template  </p>

<p>• Editing and deleting templates Macros  </p>

<p>• Creating a basic macro  </p>

<p>• Storing a macro  </p>

<p>• Running macros from toolbar buttons  </p>

<p>• Relative vs absolute macros  </p>

<p>• Managing Macros  </p>

<p>• Managing the personal macro workbook </p>

<p> </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 level of this course means that delegates are likely to be graduates albeit not necessarily in a digital subject. Most learners will have previously taken our Excel 365 Intermediate course.  </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 Level 2 Digital and IT Skills course which results in formal qualification. </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>