Name: Admin, Secretarial & PA - Level 7
Price: 18 GBP
Availability: InStock

<p style="color: rgb(80, 54, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">This course will bring everyday Excel skills up a level to enhance your performance and improve your efficiency. What&#39;s not to like? No more Google searching for the correct shortcut!</p><ul style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><li style="color: rgb(80, 54, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">Entering text, numbers and Autofill</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Navigating Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Selecting and editing</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Using the Sum function</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Basic formulae</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Rows, columns and borders</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Freezing panes</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Printing from Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Custom use</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2 weeks - 2 sessions a week (2hrs live online)</p><ul type="disc" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">25 June , 27 June , 2 July and 4 July</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tuesdays &amp; Thursdays 09:30 - 11:30</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;275+VAT per person</p><h2 style="color: rgb(35, 73, 109); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 73, 109);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This course is also available as in-house training at a fixed cost for up to 8 delegates.&nbsp;</span><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Email us for more information. <a href="mailto:admin@sterlingtraining.org" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">admin@sterlingtraining.org</a>.uk</span></h2>

Sterling Training

Microsoft Excel

Performance and efficiency-enhancing Excel skills for everyday users.

Mastering Excel

General Admission

<p style="color: rgb(80, 54, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">Are you self-taught in Excel? Our "Fundamentals of Excel" course provides you with a good refresher of the tricks of the trade and some quick easy wins. Making time spent on spreadsheets efficient, effective and painless!</p><ul style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><li style="color: rgb(80, 54, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">Entering text, numbers and Autofill</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Navigating Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Selecting and editing</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Using the Sum function</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Basic formulae</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Rows, columns and borders</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Freezing panes</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Printing from Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Custom use</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2 weeks - 2 sessions a week (2hrs live online)</p><ul type="disc" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">11 June , 13 June, 18 June and 20 June</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tuesdays &amp; Thursdays 09:30 - 11:30</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;275+VAT per person</p><h2 style="color: rgb(35, 73, 109); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 73, 109);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This course is also available as in-house training at a fixed cost for up to 8 delegates.&nbsp;</span><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Email us for more information. <a href="mailto:admin@sterlingtraining.org" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">admin@sterlingtraining.org</a>.uk</span></h2>

Learn Excel tricks of the trade and some quick easy wins, to make time spent on spreadsheets efficient, effective and painless!

Fundamentals of Excel

<h2>Industrial Automation Course Overview</h2> <p>Are you looking to begin your CNC programming career or want to develop more advanced skills in CNC programming? Then this automation &amp; applications - industry 4.0 course will set you up with a solid foundation to become a confident software engineer and help you to develop your expertise in CNC programming.</p> <p>This automation &amp; applications - industry 4.0 course is <strong>accredited</strong> by the <strong>CPD UK </strong>&amp;<strong> IPHM</strong>. CPD is <strong>globally recognised</strong> by <strong>employers</strong>, <strong>professional organisations</strong> and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. <strong>CPD certified certificates</strong> are <strong>accepted</strong> by thousands of <strong>professional bodies</strong> and <strong>government regulators</strong> here in the <strong>UK</strong> and <strong>around the world</strong>.</p> <p>Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this automation &amp; applications - industry 4.0 course will set you up with a solid foundation to become a confident software engineer and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a software engineer.</p> <p>The automation &amp; applications - industry 4.0 course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a software engineer.</p> <p>This comprehensive automation &amp; applications - industry 4.0 course is the perfect way to kickstart your career in the field of CNC programming. This automation &amp; applications - industry 4.0 course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.</p> <p>If you're interested in working as a software engineer or want to learn more skills on CNC programming but unsure of where to start, then this automation &amp; applications - industry 4.0 course will set you up with a solid foundation to become a confident software engineer and develop more advanced skills.</p> <p>As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This automation &amp; applications - industry 4.0 course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience.</p> <h3><b>Who should take this course?</b></h3> <p>This comprehensive automation &amp; applications - industry 4.0<strong> </strong>course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of CNC programming.</p> <h3><b>Entry Requirement</b></h3> <ul> <li>There are no academic entry requirements for this automation &amp; applications - industry 4.0<strong> </strong>course, and it is open to students of all academic backgrounds.</li> <li>As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol.</li> </ul> <h3><b>Career path</b></h3> <p>This automation &amp; applications - industry 4.0<strong> </strong>course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry.</p><h2><b>Course Curriculum</b></h2> <div id="la-course-curriculum"> <div> <div>  Introduction <span></span>  <div> <div> <p>Industry 4.0 - The fourth Industrial Revolution</p> <span></span> </div> <div> <p>Classification of Automation</p> <span></span> </div> <div> <p>Types of Control System</p> <span></span> </div> <div> <p>Ethical Dilemma of Automation</p> <span></span> </div> </div> </div> <div>  Robotics <span></span>  <div> <div> <p>Robotics &amp; AI - A Debatable Topic</p> <span></span> </div> <div> <p>Definition of a ROBOT</p> <span></span> </div> <div> <p>Laws of Robotics</p> <span></span> </div> <div> <p>Components of a Robot</p> <span></span> </div> <div> <p>Robot Classification</p> <span></span> </div> <div> <p>DOF - Degree Of Freedom</p> <span></span> </div> <div> <p>Robot Configurations</p> <span></span> </div> <div> <p>White Collar Robots</p> <span></span> </div> </div> </div> <div>  Numerical Control of Machine Tools <span></span>  <div> <div> <p>NC Machines</p> <span></span> </div> <div> <p>CNC - Computer Numerical Control System</p> <span></span> </div> <div> <p>Components of CNCs</p> <span></span> </div> <div> <p>Incremental &amp; Absolute CNC Machines</p> <span></span> </div> <div> <p>Open &amp; Close Control Loop CNC Machines</p> <span></span> </div> <div> <p>2 &amp; 3 Axes CNC Machines</p> <span></span> </div> <div> <p>Importance of Higher Axes Machining</p> <span></span> </div> <div> <p>Programming Format</p> <span></span> </div> <div> <p>A Simple Coding Exercise</p> <span></span> </div> <div> <p>Applications of CNC Machines</p> <span></span> </div> </div> </div> <div>  Additive Manufacturing (3D Printing) <span></span>  <div> <div> <p>General Explanation of 3D Printing</p> <span></span> </div> <div> <p>3D Printing Procedure</p> <span></span> </div> <div> <p>SLA - Stereolithography (SL)</p> <span></span> </div> <div> <p>DLP - Digital Light Processing</p> <span></span> </div> <div> <p>Laser Sintering</p> <span></span> </div> <div> <p>Extrusion / FDM / FFF</p> <span></span> </div> <div> <p>Inkjet - Binder Jetting</p> <span></span> </div> <div> <p>Inkjet - Material Jetting</p> <span></span> </div> <div> <p>Selective Deposition Lamination (SDL)</p> <span></span> </div> <div> <p>EBM - Electron Beam Melting</p> <span></span> </div> <div> <p>3D Printing Materials</p> <span></span> </div> <div> <p>3D Printing Applications</p> <span></span> </div> </div> </div> </div> </div><h2><b>Recognised Accreditation</b></h2> <div> <h3>CPD Certification Service</h3> <p>This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.</p> <h3>Quality Licence Scheme Endorsed</h3> <p>The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.</p> </div> <p> </p> <p> </p><h2><b>Certificate of Achievement</b></h2> <h3>Endorsed Certificate from Quality Licence Scheme</h3> <p>After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is Â£65.</p> <h3>Certificate of Achievement from Lead Academy</h3> <p>After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of Â£12, and there is an additional fee to obtain a printed copy certificate which is Â£35.</p> <p> </p><h2><b>FAQs</b></h2> <div id="accordionPanelsStayOpenExample"> <div> <h3 id="panelsStayOpen-heading21">  Is Cpd a Recognised Qualification in the UK?  </h3> <div id="panelsStayOpen-collapse21"> <div> <p>CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading23">  Are Qls Courses Recognised?  </h3> <div id="panelsStayOpen-collapse23"> <div> <p>Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading25">  When Will I Receive My Certificate?  </h3> <div id="panelsStayOpen-collapse25"> <div> <p>For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading27">  Can I Pay by Invoice?  </h3> <div id="panelsStayOpen-collapse27"> <div> <p>Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading29">  Can I Pay via Instalment?  </h3> <div id="panelsStayOpen-collapse29"> <div> <p>Yes, you can pay via instalments at checkout. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading31">  How to Take Online Classes From Home?  </h3> <div id="panelsStayOpen-collapse31"> <div> <p>Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading33">  Does Age Matter in Online Learning?  </h3> <div id="panelsStayOpen-collapse33"> <div> <p>No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons.</p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading35">  When I Will Get the Login Details for My Course?  </h3> <div id="panelsStayOpen-collapse35"> <div> <p>After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org</p> </div> </div> </div> </div>

Lead Academy

Industrial Automation Course Online

<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Overview</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn the Latest Skills | Accredited by CPD | Recognised Certificate | MCQ Based Exam &amp; Tutor Support | Interactive Video Training&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Office Administration Complete Course teaches core competencies in business writing, and professional communication and improves your customer service skills and computer literacy with programs like Microsoft Word, Excel, Outlook and PowerPoint.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Gain the confidence to excel in any professional office or commercial environment by gaining the necessary knowledge of administration, computer, and management techniques. This cutting-edge online course is taught by industry experts with continuing professional involvement, and it teaches you immediately applicable skills.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What Will You Learn?</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn the basic computer software you need to know to perform at your best on a daily basis</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn organisational, time management and meeting management skills</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn the basic principles of business writing</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enrich your expertise in MS Word, PowerPoint, and Excel</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn to keep the books in order and proper telephone etiquette</span></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What classes are included in this package?</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Earn a digital certificate upon successful completion accredited by UK and internationally recognised accredited qualification</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">There are no set schedules, so you can work at your own pace.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">On weekdays, you&rsquo;ll have access to a full-time tutor.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn in a user-friendly, cutting-edge online learning environment.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">High-quality e-learning study materials</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Benefit from instant feedback through mock exams and multiple-choice assessments</span></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Take This Course?</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course is ideal for those who want to work in administrative support roles in public or private sector organisations or those who wish to improve their managerial and supervisory skills.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Career Path</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Training offered by the Office Administration Complete Course could potentially benefit a range of roles, but would particularly enhance careers in:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Administrator Support Staff</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Personal Assistant</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Office Manager</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Receptionist</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Office Administrator</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Secretary</span></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Design</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">You are taught through a combination of</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Video lessons</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online study materials</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Mock exams</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Multiple-choice assessments</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Assignment</span></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certificate of Achievement</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for &pound;9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for &pound;15.99, which will reach your doorsteps by post.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Method of Assessment</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">On successful completion of the Office Administration Complete Course, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Retake fee</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">If you do not pass the exam first time, you can purchase the Retake Exam for &pound;1.99 and try again.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 01: Introduction to Office Administration&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 02: Skills of an Effective Administrator&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 03: Business Writing Skills&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 04: Communication Skills&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 05: Meeting Management&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 06: Organisational Skills&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 07: Telephone Etiquette&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 08: Negotiation Techniques&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 09: Conflict Management&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 10: Stress Management&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Module 11: Time Management</span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></li></ul></div></div></div></section><section fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></section><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></div>

Janets

Office Skills & Productivity

Office Skills

Office Management

Office Administration

Office Administration Complete Course

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p>The comprehensive Fundamentals of Number Theory has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Fundamentals of Number Theory today, and learn from the very best the industry has to offer!</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p>This best selling Fundamentals of Number Theory has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Fundamentals of Number Theory is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The Fundamentals of Number Theory is CPD-accredited, so you can be confident you're completing a quality training course  will boost your CV and enhance your career potential. The Fundamentals of Number Theory is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the Fundamentals of Number Theory, you will be awarded a certificate of completion  as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Fundamentals of Number Theory will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the Fundamentals of Number Theory to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

Programming Fundamentals

Networking Fundamentals

Business Fundamentals

Trainers Course

Finance Fundamentals

Fundamentals of Number Theory

<div data-section-id="1695385309833" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695385309833" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time.</p></div></div></section></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div data-section-id="1695042071629" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Course overview</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;1 day (6.5 hours)</strong></p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Our Excel Module 4 &ndash; Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending.</p><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div></section></div><div data-section-id="1695042071630" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"><br fr-original-style="" style="box-sizing: border-box;"></div></div><div data-section-id="1694266245578" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Objectives</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">By the end of the course you will be able to:</p><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Use a range of Text functions to manage text data</li><li fr-original-style="" style="box-sizing: border-box;">Create and use different types of date and time functions</li><li fr-original-style="" style="box-sizing: border-box;">Work with rounding functions</li><li fr-original-style="" style="box-sizing: border-box;">Use logical statements</li><li fr-original-style="" style="box-sizing: border-box;">Build nested formula</li><li fr-original-style="" style="box-sizing: border-box;">Use SUMIF, COUNTIF and AVERAGEIF</li><li fr-original-style="" style="box-sizing: border-box;">Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions</li><li fr-original-style="" style="box-sizing: border-box;">Use IS functions and IFERROR to test cell values</li></ul></div></div></section></div><div data-section-id="1694266514989" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></section></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></p></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Content</h3><div data-section-id="1695060919750" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with text&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Splitting text into multiple cells</li><li fr-original-style="" style="box-sizing: border-box;">Merging data into one cell</li><li fr-original-style="" style="box-sizing: border-box;">Extracting data using text functions</li><li fr-original-style="" style="box-sizing: border-box;">Tidying data</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with dates and times &nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Formatting dates and times</li><li fr-original-style="" style="box-sizing: border-box;">Date and time functions</li><li fr-original-style="" style="box-sizing: border-box;">Calculating date and time differences</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Using functions to round numbers up and down&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">ROUND</li><li fr-original-style="" style="box-sizing: border-box;">ROUNDUP</li><li fr-original-style="" style="box-sizing: border-box;">ROUNDDOWN</li><li fr-original-style="" style="box-sizing: border-box;">CEILING</li><li fr-original-style="" style="box-sizing: border-box;">FLOOR</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Use lookup functions&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Lookup functions</li><li fr-original-style="" style="box-sizing: border-box;">Creating a lookup table</li><li fr-original-style="" style="box-sizing: border-box;">Range naming</li><li fr-original-style="" style="box-sizing: border-box;">Using VLOOKUP</li><li fr-original-style="" style="box-sizing: border-box;">Using HLOOKUP</li><li fr-original-style="" style="box-sizing: border-box;">Using INDEX and MATCH</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with logical statements&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Creating an IF statement</li><li fr-original-style="" style="box-sizing: border-box;">Using the AND plus OR functions</li><li fr-original-style="" style="box-sizing: border-box;">Nesting functions</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Calculating values based on given criteria</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">SUMIF(S)</li><li fr-original-style="" style="box-sizing: border-box;">COUNTIF(S)</li><li fr-original-style="" style="box-sizing: border-box;">AVERAGEIF(S)</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Using IS and IFERROR and test cell values</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">ISBLANK</li><li fr-original-style="" style="box-sizing: border-box;">ISNUMBER</li><li fr-original-style="" style="box-sizing: border-box;">ISTEXT</li><li fr-original-style="" style="box-sizing: border-box;">ISERROR</li><li fr-original-style="" style="box-sizing: border-box;">IFERROR</li></ul></div></div></section></div><div data-section-id="1695060919751" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><br fr-original-style="" style="box-sizing: border-box;"></section></div></div></div></section></div></div></section></div></div></div></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695060919751" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></section></div></div></section></div>

Underscore Group

Excel Module 4 Advanced Formulas and Functions

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;</strong>This one day course is run over 2 half days virtually using Teams.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our Microsoft Excel Module 1 &ndash; Key Skills and Formula Creation course shows you all the key features to allow you to confidentially build Excel spreadsheets. &nbsp;It shows quick tips and tricks for working with spreadsheets and looks at different types of formula and how to use Excel more effectively.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;The course is aimed at new or existing users who want to build their skills and confidence in Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Objectives</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of the course you will be able to:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Create workbooks and worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Create different types of formula</li><li fr-original-style="" style="box-sizing: border-box;">Use basic Excel functions</li><li fr-original-style="" style="box-sizing: border-box;">Use absolute and relative references in formula</li><li fr-original-style="" style="box-sizing: border-box;">Edit and manipulate information</li><li fr-original-style="" style="box-sizing: border-box;">Format worksheets for professional presentation</li><li fr-original-style="" style="box-sizing: border-box;">Create and amend graphs</li><li fr-original-style="" style="box-sizing: border-box;">Preview, print and PDF information</li></ul><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Creating a worksheet</strong></div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Adding text, numbers, dates and times</li><li fr-original-style="" style="box-sizing: border-box;">Using automatic features</li><li fr-original-style="" style="box-sizing: border-box;">Renaming worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Saving a workbook</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Creating simple formulas</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Basic formulas</li><li fr-original-style="" style="box-sizing: border-box;">Formula syntax</li><li fr-original-style="" style="box-sizing: border-box;">Operators and brackets</li><li fr-original-style="" style="box-sizing: border-box;">Ordering calculations</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Using basic functions</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The function wizard</li><li fr-original-style="" style="box-sizing: border-box;">Using SUM, AVERAGE, MAX and MIN</li><li fr-original-style="" style="box-sizing: border-box;">Copying formula</li><li fr-original-style="" style="box-sizing: border-box;">Auto calculate</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Handling formulas</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Editing formulas</li><li fr-original-style="" style="box-sizing: border-box;">Using absolute references in formulas</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working with workbooks</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Navigating and editing worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Moving and copying</li><li fr-original-style="" style="box-sizing: border-box;">Adjusting column widths and row heights</li><li fr-original-style="" style="box-sizing: border-box;">Deleting data</li><li fr-original-style="" style="box-sizing: border-box;">Inserting and deleting columns and rows</li><li fr-original-style="" style="box-sizing: border-box;">Zoom</li><li fr-original-style="" style="box-sizing: border-box;">Freeze panes</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Text and number formatting</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Changing text attributes</li><li fr-original-style="" style="box-sizing: border-box;">Changing number formats</li><li fr-original-style="" style="box-sizing: border-box;">Using list autofill</li><li fr-original-style="" style="box-sizing: border-box;">Adding simple borders</li><li fr-original-style="" style="box-sizing: border-box;">Using the Mini Toolbar&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Applying cell styles&nbsp;</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Creating and amending graphs</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Creating simple charts</li><li fr-original-style="" style="box-sizing: border-box;">Changing the type of graph</li><li fr-original-style="" style="box-sizing: border-box;">Adding data labels</li><li fr-original-style="" style="box-sizing: border-box;">Customising the graph</li><li fr-original-style="" style="box-sizing: border-box;">Creating Sparklines</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Printing worksheets</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Using&nbsp;print preview</li><li fr-original-style="" style="box-sizing: border-box;">Amending page setup options</li><li fr-original-style="" style="box-sizing: border-box;">Printing a worksheet</li><li fr-original-style="" style="box-sizing: border-box;">Using Page Layout&nbsp;view and Page Break&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Preview&nbsp;</li></ul>Save as a PDF format

Microsoft

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Excel Module 1 - Key Skills and Formula Creation

<div>
									<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2><b>Receptionist Skills 2021- Overview</b></h2>		</div>
				</div>
				<div>
				<div>
							<p><span>Did you know? In the UK, 70% of first impressions of a company are formed at the reception desk. That's YOU holding the key to building trust and setting the tone for every interaction. But are you ready to unlock your full potential as a receptionist? Our Receptionist Skills 2021 course equips you with the skills and knowledge to become an excellent receptionist, the backbone of your company's success.</span></p><p><span>In this Receptionist Skills 2021 course, you will learn to craft a killer CV and cover letter and project unwavering professionalism, reflecting your company's brand values like a pro. In this course, you will learn the ins and outs of mail services, shipping, and travel arrangements, including business travel, hotel reservations, and international travel within the UK context. Our Receptionist Skills 2021 course will assist you in developing excellent telephone etiquette, telephone skills, and voice-mail courtesy, enabling you to communicate professionally and efficiently with clients, colleagues, and superiors.</span></p><p><span>Moreover, you will gain expertise in time management, enabling you to easily handle multiple tasks, appointments, and responsibilities, contributing to a more organized and productive workplace. Furthermore, you will develop the ability to confidently create various business documents and official reports, including their proper structure, editing, and proofreading, to maintain professionalism in written communication. As you move through the Receptionist Skills 2021 course, you will become proficient in organizing meetings and conferences, including scheduling, logistics, and communication, to facilitate successful events in the UK business environment. At the end part of the course, you will acquire the skills to manage invoices &amp; petty cash. </span></p><p><span>Enrol today and unlock your receptionist superpowers with our Receptionist Skills 2021 course. </span></p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3><b>Why Choose Teachers Training</b></h3>		</div>
				</div>
				<div>
				<div>
			<p>Some of our website features are:</p>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>This is a dedicated website for teaching</span>
									</li>
								<li>
											<span>
													</span>
										<span>24/7 tutor support</span>
									</li>
								<li>
											<span>
													</span>
										<span>Interactive Content</span>
									</li>
								<li>
											<span>
													</span>
										<span>Affordable price</span>
									</li>
								<li>
											<span>
													</span>
										<span>Courses accredited by the UK's top awarding bodies</span>
									</li>
								<li>
											<span>
													</span>
										<span>100% online </span>
									</li>
								<li>
											<span>
													</span>
										<span>Flexible deadline</span>
									</li>
						</ul>
				</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3><b> Entry Requirements
</b></h3>		</div>
				</div>
				<div>
				<div>
			<p>No formal entry requirements. You need to have:</p>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Passion for learning</span>
									</li>
								<li>
											<span>
													</span>
										<span>A good understanding of the English language</span>
									</li>
								<li>
											<span>
													</span>
										<span>Be motivated and hard-working</span>
									</li>
								<li>
											<span>
													</span>
										<span>Over the age of 16.</span>
									</li>
						</ul>
				</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3><b>Certification</b></h3>		</div>
				</div>
				<div>
				<div>
							<p><b>CPD Certification from The Teachers Training</b></p><p>Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.</p><ul><li>You can get your digital certificate (PDF) for £4.99 only</li><li>Hard copy certificates are also available, and you can get one for only £10.99</li><li>You can get both PDF and Hard copy certificates for just £12.99!</li></ul><p>The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.</p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
							</div><table width="100%">				<tbody><tr>
					<td colspan="4">Module 1: Introduction to Reception and Receptionist</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to Reception and Receptionist</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 2: Business Telephone Skills</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Business Telephone Skills</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 3: Representing Your Boss and Company</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Representing Your Boss and Company</td>
					<td> </td>
					<td><span><i></i> 00:36:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 4: Mail Services and Shipping</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mail Services and Shipping</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 5: Travel Arrangements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Travel Arrangements</td>
					<td> </td>
					<td><span><i></i> 00:26:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 6: Organising Meeting and Conferences</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Organising Meeting and Conferences</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 7: Time Management</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Time Management</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 8: Record Keeping and Filing Systems</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Record Keeping and Filing Systems</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 9: Business Writing Skills</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Business Writing Skills</td>
					<td> </td>
					<td><span><i></i> 00:42:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 10: Organisational Skills</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Organisational Skills</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 11: Communication Skills</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Communication Skills</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 12: Customer Service</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Customer Service</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 13: Effective Planning and Scheduling</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Effective Planning and Scheduling</td>
					<td> </td>
					<td><span><i></i> 00:48:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 14: Invoicing/Petty Cash</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Invoicing/Petty Cash</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
				</tbody></table>

The Teachers Training

Professional Skills

Receptionist

Professional Skills Course (PSC)

Resume & CV Writing

Receptionist Skills 2021

<div>
			<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><div><span><b>

Overview </b></span><span></span><br /></div></h2>		</div>
				</div>
				<div>
				<div>
			<h2><span></span></h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>From automation to complex data analysis, Python is used in a wide range of tasks. Thus, to become a high-demand professional in the IT industry, you must build a solid foundation in this programming language. Our Python for Beginners is the perfect place to start enhancing your knowledge and skills in this area.</span></p><p><span>Through the comprehensive course, you will get a primary understanding of Python. The informative modules will help you understand the data types and data structure. You will receive detailed lessons on control flow and operators. After that, the modules will equate you to the basics of Python arrays, iterators and generators. Finally, you will get a clear understanding of the functions and file manipulation.</span></p><p><span>After the completion of the course, you will receive a certificate of achievement. This certificate will help you elevate your resume. </span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><div><span><b>Course Preview</b></span><span></span><br /></div></h2>		</div>
				</div>
				<div>
				<div>
					<div>
			<div>
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        </div>		</div>
				</div>
				</div>
				<div>
				<div>
			<h2><div><span><b>Learning Outcomes</b></span><span></span></div></h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<ul><li><span>Introduce yourself to the basics of Python </span></li><li><span>Familiarise yourself with the data types and operators </span></li><li><span>Enhance your understanding of data structures and control flow</span></li><li><span>Explore the vital areas of Python arrays, iterators and generators </span></li><li><span>Develop a clear understanding of functions and file manipulation </span></li></ul>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2><div><span><b>Why Take This Course From John Academy?
</b></span><span></span></div></h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<ul><li><span>Affordable, well-structured and high-quality e-learning study materials</span></li><li><span>Engaging tutorial videos, materials from the industry-leading experts</span></li><li><span>Opportunity to study in a user-friendly, advanced online learning platform</span></li><li><span>Efficient exam systems for the assessment and instant result</span></li><li><span>Earn UK &amp; internationally recognised accredited qualification</span></li><li><span>Easily access the course content on mobile, tablet, or desktop from anywhere, anytime</span></li><li><span>Excellent career advancement opportunities</span></li><li><span>Get 24/7 student support via email.</span></li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><div><span><b>
What Skills Will You Learn from This Course?
</b></span><span></span></div></h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>Python</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2><div><span><b>
Who Should Take This Python for Beginners Course?
</b></span><span></span></div></h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2><div><span><b>Are There Any Entry Requirements?</b></span><span></span></div></h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>Thi</span><span>s Python for Beginners is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
								<div>
				<p></p><h3><b>Certificate of Achievement </b></h3>
    <p> After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates &amp; Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99.</p><p></p>					</div>
						</div>
				</div>
				<div>
				<div>
								<div>
				<p></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><div><span><b>Career Pathâ</b></span><span></span></div></h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>This exclusive Python for Beginners will equip you with effective skills and abilities and help you explore career paths such as </span></p><ul><li><span>Web Developer</span></li><li><span>Data Analyst </span></li><li><span>Software Developer </span></li><li><span>Game Developer</span></li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div>
				</div><table width="100%">				<tbody><tr>
					<td colspan="4">Course Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Python for Beginners Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 01: Getting Started with Python</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Why Learn Coding</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Why Learn Python</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Gearing Up Linux Machine For Python Programming</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Gearing Up Windows For Python</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Integrate Python And Git Bash With Vscode</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Gearing Up The Macos For Python Programming</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing Jupyter Notebook In Windows</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Hello World In Jupyter Notebook</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 02: Data Types and Operators</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Arithmetic Operators</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Of Evaluation</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Variable And Assignment Operators</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Correct Variable Names</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Integer Float And Complex Numbers In Python</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Boolean Comparison Operator And Logical Operator</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Strings In Python</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Type And Type Casting</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>String Methods In Python</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Taking Input From User</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exercise 1</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 03: Data Structures</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lists In Python</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Necessitites In List</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>List Methods</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tuples In Python</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sets In Python</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dictionary, Mutable, Accessing Items</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dublicates, Constructor And Data Types In Dictionary</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Access And Add Items In Dictionaries</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Nested Dictionaries And Dictionary Methods</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exercise 2</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 04: Control Flow</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conditional Statements</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Short Hand If Else</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Nested If</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>For Loops</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>While Loops In Python</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>While Vs For Loop</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Break Continue Statment</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Try And Except</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exercise 3</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 05: Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Intro To Functions</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Arguments, Parameters And Multiple Arguments</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Arbitrary Arguments, Keyword Arguments, Arbitrary Keyword Arguments</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Default Parameter Value And Passing A List As Parameters</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Return Values And Pass Statements</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exercise 4</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 06: Python Arrays, Iterators and Generators</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Array, Length Of Array, Accessing Elements Of Array</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adding, Removing Elements In Array, Array Methods</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Iterator In Python</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Generators In Python</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exercise 5</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 07: File Manipulation</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>File Hancdling And Syntax</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reading The File, Line Extraction And Parsing</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Appending And Writing The Files In Python</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create And Delete A File</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Computer Programming

Python for Beginners

<div>
	<h3><b>Course Overview</b></h3>
<p>A survey in the Uk shows that the total number of skills required for a single job has increased by 10% year-over-year since 2017. Furthermore, one in three skills in an average 2017 job posting are already obsolete. Due to ongoing business disruption and rapidly evolving needs, emerging skills gaps have accelerated due to the COVID-19 pandemic.</p>
<p>And to help you bridge that gap, Jhon Academy has prepared this comprehensive Admin, Secretarial &amp; PA - Level 7 online course. Admin, Secretarial &amp; PA - Level 7 covers a collection of necessary skills required to help you achieve your goals. In addition, our industry professionals will guide you through the process of establishing a solid foundation in Admin, Secretarial &amp; PA - Level 7.<br />
The Admin, Secretarial &amp; PA - Level 7 course is broken down into manageable sections, each of which will provide you with a new level of expertise. Our exclusive training in Admin, Secretarial &amp; PA - Level 7 will equip you with the skills required to set yourself up for career success.<br />
The Admin, Secretarial &amp; PA - Level 7 provides internationally accepted certification upon successful completion. This certificate will add value to your resume and let you stand out among your peers. So enrol now and work your way towards becoming a highly sought-after professional at Admin, Secretarial &amp; PA - Level 7.</p>
<h3><b>Certification</b></h3>
<p>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.<br />
Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</p>
<h3>Who is this Course for?</h3>
Admin, Secretarial &amp; PA - Level 7 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.<p></p>
<p>As there is no experience and qualification required for this course, it is available for all students from any academic background.</p>
<h3>Requirements</h3>
<p>Our Admin, Secretarial &amp; PA - Level 7 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</p>
<h3><b>Career Path</b></h3>
<p>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</p>
<div id="mouseposition-extension-element-full-container">
<div id="mouseposition-extension-element-rect-display">
<pre></pre>
</div>
<pre id="mouseposition-extension-element-coordinate-display"></pre>
</div>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Module 01 - Introduction to Personal Assistant &amp; Admin Support Assistant</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to Personal Assistant</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 02 - Introduction to Office Administration</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to Office Administration</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 03 - Skills of an Effective Administrator</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Skills of an Effective Administrator</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 04 - Introduction to Reception and Receptionist</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to Reception and Receptionist</td>
					<td> </td>
					<td><span><i></i> 00:26:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 05 - Business Telephone Skills</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Business Telephone Skills</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 06 - Representing Your Boss and Company</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Representing Your Boss and Company</td>
					<td> </td>
					<td><span><i></i> 00:36:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 07 - Business Etiquette</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Business Etiquette</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 08 - Mail Services and Shipping</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mail Services and Shipping</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 09 - Travel Arrangements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Travel Arrangements</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 10 - Organising Meeting and Conferences</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Organising Meeting and Conferences</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 11 - Diary Management and Note taking</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Diary Management and Note taking</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 12 - Time Management</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Time Management</td>
					<td> </td>
					<td><span><i></i> 00:35:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 13 - Record Keeping and Filing Systems</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Record Keeping and Filing Systems</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 14 - Business Writing Skills</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Business Writing Skills</td>
					<td> </td>
					<td><span><i></i> 00:41:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 15 - Organisational Skills</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Organisational Skills</td>
					<td> </td>
					<td><span><i></i> 00:26:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 16 - Communication Skills</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Communication Skills</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 17- Customer Service</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Customer Service</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 18- Effective Planning and Scheduling</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Effective Planning and Scheduling</td>
					<td> </td>
					<td><span><i></i> 00:52:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 19 - Invoicing/Petty Cash</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Invoicing/Petty Cash</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Secretarial & PA

Business Admin

Admin, Secretarial & PA - Level 7

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is for Azure Security Engineers who are planning to take the associated certification exam, or who are performing security tasks in their day-to-day job. This course would also be helpful to an engineer that wants to specialize in providing security for Azure-based digital platforms and play an integral role in protecting an organization's data.</p><p></p><p></p><p>This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization?s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.</p><p></p>Prerequisites<p></p><li>AZ-104T00 - Microsoft Azure Administrator</li>  <li>Security best practices and industry security requirements such as defense in depth, least privileged access, role-based access control, multi-factor authentication, shared responsibility, and zero trust model.</li>  <li>Be familiar with security protocols such as Virtual Private Networks (VPN), Internet Security Protocol (IPSec), Secure Socket Layer (SSL), disk and data encryption methods.</li>  <li>Have some experience deploying Azure workloads. This course does not cover the basics of Azure administration, instead the course content builds on that knowledge by adding security specific information.</li>  <li>Have experience with Windows and Linux operating systems and scripting languages. Course labs may use PowerShell and the CLI.</li><p></p></div><div id="course-pills-2"><h3>1 - Manage identities in Microsoft Entra ID</h3> <ul> <li>Secure users in Microsoft Entra ID</li> <li>Secure groups in Microsoft Entra ID</li> <li>Recommend when to use external identities</li> <li>Secure external identities</li> <li>Implement Microsoft Entra Identity protection</li> </ul> <h3>2 - Manage authentication by using Microsoft Entra ID</h3> <ul> <li>Configure Microsoft Entra Verified ID</li> <li>Implement multifactor authentication (MFA)</li> <li>Implement passwordless authentication</li> <li>Implement password protection</li> <li>Implement single sign-on (SSO)</li> <li>Integrate single sign-on (SSO) and identity providers</li> <li>Recommend and enforce modern authentication protocols </li> </ul> <h3>3 - Manage authorization by using Microsoft Entra ID</h3> <ul> <li>Configure Azure role permissions for management groups, subscriptions, resource groups, and resources</li> <li>Assign built-in roles in Microsoft Entra ID</li> <li>Assign built-in roles in Azure</li> <li>Create and assign a custom role in Microsoft Entra ID</li> <li>Implement and manage Microsoft Entra Permissions Management</li> <li>Configure Microsoft Entra Privileged Identity Management </li> <li>Configure role management and access reviews by using Microsoft Entra Identity Governance</li> <li>Implement Conditional Access policies</li> </ul> <h3>4 - Manage application access in Microsoft Entra ID</h3> <ul> <li>Manage access to enterprise applications in Microsoft Entra ID, including OAuth permission grants</li> <li>Manage app registrations in Microsoft Entra ID</li> <li>Configure app registration permission scopes</li> <li>Manage app registration permission consent</li> <li>Manage and use service principals</li> <li>Manage managed identities for Azure resources</li> <li>Recommend when to use and configure a Microsoft Entra Application Proxy, including authentication</li> </ul> <h3>5 - Plan and implement security for virtual networks</h3> <ul> <li>Plan and implement Network Security Groups (NSGs) and Application Security Groups (ASGs)</li> <li>Plan and implement User-Defined Routes (UDRs)</li> <li>Plan and implement Virtual Network peering or gateway</li> <li>Plan and implement Virtual Wide Area Network, including secured virtual hub</li> <li>Secure VPN connectivity, including point-to-site and site-to-site</li> <li>Implement encryption over ExpressRoute</li> <li>Configure firewall settings on PaaS resources</li> <li>Monitor network security by using Network Watcher, including NSG flow logging</li> </ul> <h3>6 - Plan and implement security for private access to Azure resources</h3> <ul> <li>Plan and implement virtual network Service Endpoints</li> <li>Plan and implement Private Endpoints</li> <li>Plan and implement Private Link services</li> <li>Plan and implement network integration for Azure App Service and Azure Functions</li> <li>Plan and implement network security configurations for an App Service Environment (ASE)</li> <li>Plan and implement network security configurations for an Azure SQL Managed Instance</li> </ul> <h3>7 - Plan and implement security for public access to Azure resources</h3> <ul> <li>Plan and implement Transport Layer Security (TLS) to applications, including Azure App Service and API Management</li> <li>Plan, implement, and manage an Azure Firewall, Azure Firewall Manager and firewall policies</li> <li>Plan and implement an Azure Application Gateway</li> <li>Plan and implement an Azure Front Door, including Content Delivery Network (CDN)</li> <li>Plan and implement a Web Application Firewall (WAF)</li> <li>Recommend when to use Azure DDoS Protection Standard</li> </ul> <h3>8 - Plan and implement advanced security for compute</h3> <ul> <li>Plan and implement remote access to public endpoints, Azure Bastion and just-in-time (JIT) virtual machine (VM) access</li> <li>Configure network isolation for Azure Kubernetes Service (AKS)</li> <li>Secure and monitor AKS</li> <li>Configure authentication for AKS</li> <li>Configure security for Azure Container Instances (ACIs)</li> <li>Configure security for Azure Container Apps (ACAs)</li> <li>Manage access to Azure Container Registry (ACR)</li> <li>Configure disk encryption, Azure Disk Encryption (ADE), encryption as host, and confidential disk encryption</li> <li>Recommend security configurations for Azure API Management</li> </ul> <h3>9 - Plan and implement security for storage</h3> <ul> <li>Configure access control for storage accounts</li> <li>Manage life cycle for storage account access keys</li> <li>Select and configure an appropriate method for access to Azure Files</li> <li>Select and configure an appropriate method for access to Azure Blob Storage</li> <li>Select and configure an appropriate method for access to Azure Tables</li> <li>Select and configure an appropriate method for access to Azure Queues</li> <li>Select and configure appropriate methods for protecting against data security threats, including soft delete, backups, versioning, and immutable storage</li> <li>Configure Bring your own key (BYOK)</li> <li>Enable double encryption at the Azure Storage infrastructure level</li> </ul> <h3>10 - Plan and implement security for Azure SQL Database and Azure SQL Managed Instance</h3> <ul> <li>Enable database authentication by using Microsoft Entra ID</li> <li>Enable and monitor database audit</li> <li>Identify use cases for the Microsoft Purview governance portal</li> <li>Implement data classification of sensitive information by using the Microsoft Purview governance portal</li> <li>Plan and implement dynamic mask</li> <li>Implement transparent data encryption?</li> <li>Recommend when to use Azure SQL Database Always Encrypted</li> </ul> <h3>11 - Plan, implement, and manage governance for security</h3> <ul> <li>Create, assign, and interpret security policies and initiatives in Azure Policy</li> <li>Configure security settings by using Azure Blueprint</li> <li>Deploy secure infrastructures by using a landing zone</li> <li>Create and configure an Azure Key Vault</li> <li>Recommend when to use a dedicated Hardware Security Module (HSM)</li> <li>Configure access to Key Vault, including vault access policies and Azure Role Based Access Control</li> <li>Manage certificates, secrets, and keys</li> <li>Configure key rotation</li> <li>Configure backup and recovery of certificates, secrets, and keys</li> </ul> <h3>12 - Manage security posture by using Microsoft Defender for Cloud</h3> <ul> <li>Implement Microsoft Defender for Cloud</li> <li>Identify and remediate security risks by using the Microsoft Defender for Cloud Secure Score and Inventory</li> <li>Assess compliance against security frameworks and Microsoft Defender for Cloud</li> <li>Add industry and regulatory standards to Microsoft Defender for Cloud</li> <li>Add custom initiatives to Microsoft Defender for Cloud</li> <li>Connect hybrid cloud and multicloud environments to Microsoft Defender for Cloud</li> <li>Identify and monitor external assets by using Microsoft Defender External Attack Surface Management</li> </ul> <h3>13 - Configure and manage threat protection by using Microsoft Defender for Cloud</h3> <ul> <li>Enable workload protection services in Microsoft Defender for Cloud, including Microsoft Defender for Storage, Databases, Containers, App Service, Key Vault, Resource Manager, and DNS</li> <li>Configure Microsoft Defender for Servers</li> <li>Configure Microsoft Defender for Azure SQL Database</li> <li>Manage and respond to security alerts in Microsoft Defender for Cloud</li> <li>Configure workflow automation by using Microsoft Defender for Cloud</li> <li>Evaluate vulnerability scans from Microsoft Defender for Server</li> </ul> <h3>14 - Configure and manage security monitoring and automation solutions</h3> <ul> <li>Monitor security events by using Azure Monitor</li> <li>Configure data connectors in Microsoft Sentinel</li> <li>Create and customize analytics rules in Microsoft Sentinel</li> <li>Configure automation in Microsoft Sentinel</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-500T00 Microsoft Azure Security Technologies training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the AZ-500T00 Microsoft Azure Security Technologies course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

CompTIA Security+

AZ-500T00 Microsoft Azure Security Technologies

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Learning & Development

Design & Technology Courses (DT)

Data Skills

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.</p><p></p>Overview<p>Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure</p><p></p><p>In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.</p><p></p></div><div id="course-pills-2"><h3>1 - Explore core data concepts</h3> <ul> <li>Identify data formats</li> <li>Explore file storage</li> <li>Explore databases</li> <li>Explore transactional data processing</li> <li>Explore analytical data processing</li> </ul> <h3>2 - Explore data roles and services</h3> <ul> <li>Explore job roles in the world of data</li> <li>Identify data services</li> </ul> <h3>3 - Explore fundamental relational data concepts</h3> <ul> <li>Understand relational data</li> <li>Understand normalization</li> <li>Explore SQL</li> <li>Describe database objects</li> </ul> <h3>4 - Explore relational database services in Azure</h3> <ul> <li>Describe Azure SQL services and capabilities</li> <li>Describe Azure services for open-source databases</li> </ul> <h3>5 - Explore Azure Storage for non-relational data</h3> <ul> <li>Explore Azure blob storage</li> <li>Explore Azure DataLake Storage Gen2</li> <li>Explore Azure Files</li> <li>Explore Azure Tables</li> </ul> <h3>6 - Explore fundamentals of Azure Cosmos DB</h3> <ul> <li>Describe Azure Cosmos DB</li> <li>Identify Azure Cosmos DB APIs</li> </ul> <h3>7 - Explore fundamentals of large-scale data warehousing</h3> <ul> <li>Describe data warehousing architecture</li> <li>Explore data ingestion pipelines</li> <li>Explore analytical data stores</li> </ul> <h3>8 - Explore fundamentals of real-time analytics</h3> <ul> <li>Understand batch and stream processing</li> <li>Explore common elements of stream processing architecture</li> <li>Explore Azure Stream Analytics</li> <li>Explore Apache Spark on Microsoft Azure</li> </ul> <h3>9 - Explore fundamentals of data visualization</h3> <ul> <li>Describe Power BI tools and workflow</li> <li>Describe core concepts of data modeling</li> <li>Describe considerations for data visualization</li> </ul></div>

Azure SQL Database

DP-900T00 Microsoft Azure Data Fundamentals

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.</p>Overview<p>Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365</p><p>This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. <br /><br /> Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.</p></div><div id="course-pills-2"><h3>1 - Planning and Provisioning Office 365</h3> <ul> <li>Overview of Office 365</li> <li>Core Services of Office 365</li> <li>Requirements for an Office 365 Tenant</li> <li>Planning a Pilot and Deployment</li> <li>Creating an Office 365 Tenant</li> <li>Adding Custom Domains and Managing DNS Settings</li> <li>Lab: Provisioning Office 365</li> </ul> <h3>2 - Managing Users and Groups in Office 365</h3> <ul> <li>Managing User Accounts and Licences</li> <li>Managing Passwords and Authentication</li> <li>Create and Managing the Different Types of Groups in Office 365</li> <li>Managing Users and Groups with PowerShell</li> <li>Managing Users and Groups in the Azure AD Admin Center</li> <li>Role Based Access and Administrative Roles</li> <li>Planning and Configuring Directory Synchronization</li> <li>Lab: Managing Users and Groups in Office 365</li> <li>Lab: Planning and Configuring Directory Synchronisation</li> </ul> <h3>3 - Deploying and Configuring Tools and Applications for Office 365</h3> <ul> <li>Planning Network Configuration for Office 365 Tools and Applications</li> <li>Using the Office Configuration Tool</li> <li>Click to Run Installation Use and Control</li> <li>Managing Centralized Deployment of Tools, Applications and Add-ins</li> <li>Reporting</li> <li>Lab: Deploying and Configuring Tools and Applications for Office 365</li> </ul> <h3>4 - Planning and Managing Exchange Online</h3> <ul> <li>What is Exchange Online</li> <li>Managing Exchange Online Mailboxes</li> <li>Managing Office 365 Groups in Exchange Online</li> <li>Configuring Exchange Online Permissions</li> <li>Managing Exchange Online using PowerShell</li> <li>Plan and Configure Mail Flow</li> <li>Plan and Configure Email Protection</li> <li>Lab: Planning and Managing Exchange Online</li> </ul> <h3>5 - Planning and Managing SharePoint Online</h3> <ul> <li>What is SharePoint Online</li> <li>Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups</li> <li>SharePoint Online Architecture</li> <li>Configure SharePoint Online</li> <li>Configure and Control External Sharing</li> <li>Managing SharePoint Online Site Collections</li> <li>Managing SharePoint Online using PowerShell</li> <li>Lab: Planning and Managing SharePoint Online</li> </ul> <h3>6 - Planning and Managing Microsoft Teams</h3> <ul> <li>What is Microsoft Teams</li> <li>How Microsoft Teams integrates with other Office 365 Services</li> <li>Create and Manage Organization Wide Settings</li> <li>Create, Manage and Assign Microsoft Teams Policies</li> <li>Plan and Configure External and Guest Access</li> <li>Managing Microsoft Teams using PowerShell</li> <li>Lab: Planning and Managing Microsoft Teams</li> </ul> <h3>7 - Planning and Managing Other Office 365 Services</h3> <ul> <li>Yammer</li> <li>Planner</li> <li>Visio</li> <li>Bookings</li> <li>Delve</li> <li>Forms</li> <li>Power Platform</li> <li>Stream</li> <li>Sway</li> <li>Viva</li> <li>Scheduler</li> <li>Add-ins, including Find Time and Junk Reporter</li> <li>Lab: Planning and Managing Office 365 Services</li> </ul> <h3>8 - Security and Compliance in Office 365</h3> <ul> <li>Overview of Security and Compliance Features in Office 365</li> <li>Extending Security and compliance Features with Additional Licences</li> <li>Using the Microsoft Defender Portal and Secure Score</li> <li>Using the Office 365 Compliance Portal and Compliance Score</li> <li>Plan and Configure Retention Labels and Policies</li> <li>Plan and Configure Data Loss Prevention Policies</li> <li>Create and Assign Sensitivity Labels</li> <li>Configure Safe Attachments and Safe Links Policies</li> <li>Plan and Configure Multi Factor Authentication</li> <li>Lab: Configure Security and Compliance in Office 365</li> </ul> <h3>9 - Reporting, Monitoring and Troubleshooting Office 365</h3> <ul> <li>Monitoring Office 365 Service Health</li> <li>Troubleshooting Administrative Access in Office 365</li> <li>Troubleshoot Directory Synchronization</li> <li>Troubleshooting Exchange Online</li> <li>Troubleshooting SharePoint Online</li> <li>Troubleshooting Microsoft Teams</li> <li>Troubleshooting Office 365 Security and Compliance</li> <li>Lab: Reporting, Monitoring and Troubleshooting in Office 365</li> </ul></div>

Microsoft Certification

Microsoft 365

55354 Administering Office 365

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for Enterprise network staff responsible for help desk support, system administration, and network design.</p>Overview<p>At Course Completion: - Features and functions of Group Policy - Use Group Policy management tools to manage security policies - Design a Group Policy infrastructure - Group Policy processing architecture - Back up, restore, import, and copy Group Policy Objects through the Group Policy - Management Console - Use Windows PowerShell to manage Group Policy - Implement security using Group Policy - Configure the desktop environment with Group Policy - Configure roaming profiles and Folder Redirection - Assign and publish software packages - Implement AppLocker and software restriction policies - Create and deploy Administrative Templates - Configure Group Policy preferences</p><p>In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with Group Policy, and you will learn to control and manage computer systems and domain users running Windows Server 2016 and Windows clients. Create Group Policies, implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience and tools needed to optimize your enterprise systems and networks, implement administrative and security templates, and determine best practices when deploying software packages.</p></div><div id="course-pills-2"><h3>1 - Introduction to Configuration Management</h3> <ul> <li>Configuration Management Overview</li> <li>Configuration Management Using Group Policy</li> <li>Group Policy Features Introduced with Later Versions of Windows</li> <li>Using Windows PowerShell in the Configuration Management Process</li> </ul> <h3>2 - Using Group Policy Management Tools</h3> <ul> <li>Local and Domain Policies</li> <li>Using Group Policy Management Console</li> <li>Understanding Group Policy Refresh</li> </ul> <h3>3 - Designing a Group Policy Infrastructure</h3> <ul> <li>Design Stages for a Group Policy Infrastructure</li> <li>Planning your Group Policy Design</li> <li>Designing Your Group Policy Solution</li> <li>Deploying Your Group Policy Solution</li> <li>Managing Your Group Policy Solution</li> </ul> <h3>4 - Understanding the Architecture of Group Policy Processing</h3> <ul> <li>Group Policy Components in AD DS</li> <li>Understanding the Group Policy Deployment Order</li> <li>Modifying Group Policy Processing</li> </ul> <h3>5 - Troubleshooting and Backing Up GPOs</h3> <ul> <li>Using Group Policy Troubleshooting Tools</li> <li>Integration of RSoP Functionality</li> <li>Group Policy Logging Options</li> <li>Backing Up, Restoring, Importing, and Copying GPOs</li> <li>Building Migration Tables</li> </ul> <h3>6 - Securing Windows Using Group Policy</h3> <ul> <li>Exploring the Windows Security Architecture</li> <li>Securing User Accounts</li> <li>Exploring Security Policies</li> <li>Windows Firewall with Advanced Security</li> <li>Implementing Domain Security</li> <li>Security Policy Options for Window Client and Windows Server</li> </ul> <h3>7 - Implementing Application Security Using Group Policy</h3> <ul> <li>Managing UAC Settings</li> <li>Defending Against Malware</li> <li>Using AppLocker to Restrict Software</li> <li>Implementing Windows App Security Settings</li> </ul> <h3>8 - Configuring the Desktop Environment with Group Policy</h3> <ul> <li>Exploring Script Types and Controlling Script Execution</li> <li>Defining the Desktop, Start Menu, and Taskbar Settings</li> <li>Defining the Control Panel Settings</li> <li>Defining the Windows Components Settings</li> <li>Configuring the Printer Management and Pruning Settings</li> <li>Defining the Network Settings</li> <li>Discovering the new Group Policy Settings</li> </ul> <h3>9 - Implementing User State Virtualization</h3> <ul> <li>Configuring Folder Redirection</li> <li>Managing Offline Files</li> <li>Implementing User Experience Virtualization</li> <li>OneDrive for Business</li> </ul> <h3>10 - Assigning and Publishing Software Packages</h3> <ul> <li>Using MSI Packages to Distribute Software</li> <li>Using Group Policy as a Software Deployment Method</li> <li>Deploying Software</li> <li>Setting Up Distribution Points</li> <li>Using the Systems Center Configuration Manager to Distribute Software</li> </ul> <h3>11 - Configuration Management with Windows PowerShell</h3> <ul> <li>Introducing Windows PowerShell</li> <li>Using Windows PowerShell</li> <li>Writing PowerShell Scripts</li> <li>Windows PowerShell Library for Group Policy</li> <li>Windows PowerShell-Based Logon Scripts</li> </ul> <h3>12 - Implementing PowerShell Desired State Configuration</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configure Preference Settings</li> </ul> <h3>13 - Configuring Group Policy Preferences</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configuring Preferences Settings</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 50255 Managing Windows Environments with Group Policy training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 50255 Managing Windows Environments with Group Policy course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

50255 Managing Windows Environments with Group Policy

MS-102T00 Microsoft 365 Administrator Essentials

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-400T00 Microsoft Power Platform Developer course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft PL-900

Microsoft Power Apps

Power Apps

Microsoft Power Platform

Microsoft Power Automate

PL-400T00 Microsoft Power Platform Developer

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.</p><p></p><p></p><p>This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.</p><p></p>Prerequisites<p>To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.</p></div><div id="course-pills-2"><h3>1 - Explore Azure App Service</h3> <ul> <li>Examine Azure App Service</li> <li>Examine Azure App Service plans</li> <li>Deploy to App Service</li> <li>Explore authentication and authorization in App Service</li> <li>Discover App Service networking features</li> </ul> <h3>2 - Configure web app settings</h3> <ul> <li>Configure application settings</li> <li>Configure general settings</li> <li>Configure path mappings</li> <li>Enable diagnostic logging</li> <li>Configure security certificates</li> </ul> <h3>3 - Scale apps in Azure App Service</h3> <ul> <li>Examine autoscale factors</li> <li>Identify autoscale factors</li> <li>Enable autoscale in App Service</li> <li>Explore autoscale best practices</li> </ul> <h3>4 - Explore Azure App Service deployment slots</h3> <ul> <li>Explore staging environments</li> <li>Examine slot swapping</li> <li>Swap deployment slots</li> <li>Route traffic in App Service</li> </ul> <h3>5 - Explore Azure Functions</h3> <ul> <li>Discover Azure Functions</li> <li>Compare Azure Functions hosting options</li> <li>Scale Azure Functions</li> </ul> <h3>6 - Develop Azure Functions</h3> <ul> <li>Explore Azure Functions development</li> <li>Create triggers and bindings</li> <li>Connect functions to Azure services</li> </ul> <h3>7 - Explore Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage</li> <li>Discover Azure Blob storage resource types</li> <li>Explore Azure Storage security features</li> <li>Discover static website hosting in Azure Storage</li> </ul> <h3>8 - Manage the Azure Blob storage lifecycle</h3> <ul> <li>Explore the Azure Blob storage lifecycle</li> <li>Discover Blob storage lifecycle policies</li> <li>Implement Blob storage lifecycle policies</li> <li>Rehydrate blob data from the archive tier</li> </ul> <h3>9 - Work with Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage client library</li> <li>Create a client object</li> <li>Manage container properties and metadata by using .NET</li> <li>Set and retrieve properties and metadata for blob resources by using REST</li> </ul> <h3>10 - Explore Azure Cosmos DB</h3> <ul> <li>Identify key benefits of Azure Cosmos DB</li> <li>Explore the resource hierarchy</li> <li>Explore consistency levels</li> <li>Choose the right consistency level</li> <li>Explore supported APIs</li> <li>Discover request units</li> </ul> <h3>11 - Work with Azure Cosmos DB</h3> <ul> <li>Explore Microsoft .NET SDK v3 for Azure Cosmos DB</li> <li>Create stored procedures</li> <li>Create triggers and user-defined functions</li> <li>Explore change feed in Azure Cosmos DB</li> </ul> <h3>12 - Manage container images in Azure Container Registry</h3> <ul> <li>Discover the Azure Container Registry</li> <li>Explore storage capabilities</li> <li>Build and manage containers with tasks</li> <li>Explore elements of a Dockerfile</li> </ul> <h3>13 - Run container images in Azure Container Instances</h3> <ul> <li>Explore Azure Container Instances</li> <li>Run containerized tasks with restart policies</li> <li>Set environment variables in container instances</li> <li>Mount an Azure file share in Azure Container Instances</li> </ul> <h3>14 - Implement Azure Container Apps</h3> <ul> <li>Explore Azure Container Apps</li> <li>Explore containers in Azure Container Apps</li> <li>Implement authentication and authorization in Azure Container Apps</li> <li>Manage revisions and secrets in Azure Container Apps</li> <li>Explore Dapr integration with Azure Container Apps</li> </ul> <h3>15 - Explore the Microsoft identity platform</h3> <ul> <li>Explore the Microsoft identity platform</li> <li>Explore service principals</li> <li>Discover permissions and consent</li> <li>Discover conditional access</li> </ul> <h3>16 - Implement authentication by using the Microsoft Authentication Library</h3> <ul> <li>Explore the Microsoft Authentication Library</li> <li>Initialize client applications</li> </ul> <h3>17 - Implement shared access signatures</h3> <ul> <li>Discover shared access signatures</li> <li>Choose when to use shared access signatures</li> <li>Explore stored access policies</li> </ul> <h3>18 - Explore Microsoft Graph</h3> <ul> <li>Discover Microsoft Graph</li> <li>Query Microsoft Graph by using REST</li> <li>Query Microsoft Graph by using SDKs</li> <li>Apply best practices to Microsoft Graph</li> </ul> <h3>19 - Implement Azure Key Vault</h3> <ul> <li>Explore Azure Key Vault</li> <li>Discover Azure Key Vault best practices</li> <li>Authenticate to Azure Key Vault</li> </ul> <h3>20 - Implement managed identities</h3> <ul> <li>Explore managed identities</li> <li>Discover the managed identities authentication flow</li> <li>Configure managed identities</li> <li>Acquire an access token</li> </ul> <h3>21 - Implement Azure App Configuration</h3> <ul> <li>Explore the Azure App Configuration service</li> <li>Create paired keys and values</li> <li>Manage application features</li> <li>Secure app configuration data</li> </ul> <h3>22 - Explore API Management</h3> <ul> <li>Discover the API Management service</li> <li>Explore API gateways</li> <li>Explore API Management policies</li> <li>Create advanced policies</li> <li>Secure APIs by using subscriptions</li> <li>Secure APIs by using certificates</li> </ul> <h3>23 - Explore Azure Event Grid</h3> <ul> <li>Explore Azure Event Grid</li> <li>Discover event schemas</li> <li>Explore event delivery durability</li> <li>Control access to events</li> <li>Receive events by using webhooks</li> <li>Filter events</li> </ul> <h3>24 - Explore Azure Event Hubs</h3> <ul> <li>Discover Azure Event Hubs</li> <li>Explore Event Hubs Capture</li> <li>Scale your processing application</li> <li>Control access to events</li> <li>Perform common operations with the Event Hubs client library</li> </ul> <h3>25 - Discover Azure message queues</h3> <ul> <li>Choose a message queue solution</li> <li>Explore Azure Service Bus</li> <li>Discover Service Bus queues, topics, and subscriptions</li> <li>Explore Service Bus message payloads and serialization</li> <li>Explore Azure Queue Storage</li> <li>Create and manage Azure Queue Storage and messages by using .NET</li> </ul> <h3>26 - Monitor app performance</h3> <ul> <li>Explore Application Insights</li> <li>Discover log-based metrics</li> <li>Instrument an app for monitoring</li> <li>Select an availability test</li> <li>Troubleshoot app performance by using Application Map</li> </ul> <h3>27 - Develop for Azure Cache for Redis</h3> <ul> <li>Explore Azure Cache for Redis</li> <li>Configure Azure Cache for Redis</li> <li>Interact with Azure Cache for Redis by using .NET</li> </ul> <h3>28 - Develop for storage on CDNs</h3> <ul> <li>Explore Azure Content Delivery Networks</li> <li>Control cache behavior on Azure Content Delivery Networks</li> <li>Interact with Azure Content Delivery Networks by using .NET</li> </ul></div>

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p><p>This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security.</p></div><div id="course-pills-2"><h3>1: Introduction to Microsoft Intune</h3> <ul> <li> Mobile Device Management</li> <li>Microsoft Intune</li> <li> Azure Active Directory</li> <li>AAD Identity Protection</li> <li> AAD Conditional Access</li></ul>  <h3>2: Microsoft Intune Device Management</h3><ul> <li>Enrolling Devices</li> <li> Device Compliance</li> <li> Device Profiles</li> <li>Device Updates</li></ul>  <h3>3: Microsoft Intune Application Management</h3><ul> <li> Application Management</li> <li> Deploying Applications</li> <li> Application Configuration</li> <li> Managing Applications</li> <li> Policy Sets and Guided Scenarios</li></ul>  <h3>4: Microsoft Intune Endpoint Security</h3><ul> <li> Security Baselines and tasks</li> <li> Antivirus</li> <li>Disk Encryption</li> <li>Firewall</li> <li>Atack Surface reduction</li> <li> Endpoint detection and response</li> <li> Account Protection</li></ul>  <h3>5: Deploying Windows with Windows Autopilot</h3><ul> <li> Windows Autopilot overview</li> <li> Preparing for Windows Autopilot deployment</li> <li>Deploying Windows 11 using Windows Autopilot</li></ul>  <h3>6: Microsoft Intune Additional and Premium Features</h3><ul> <li> Remote Help</li> <li> Tunnel for Mobile Application Management</li> <li>Endpoint Privilege Management</li> <li> Advanced Endpoint Analytics</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55399 Implementing and Managing Microsoft Intune training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55399 Implementing and Managing Microsoft Intune course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

3375 Courses delivered Online

Mastering Excel

By Sterling Training

Fundamentals of Excel

By Sterling Training

Industrial Automation Course Online

By Lead Academy

Office Administration Complete Course

By Janets

Fundamentals of Number Theory

By Course Cloud