• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

9790 Office courses

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored training courses: In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Intermediate - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Agile Project Management Office Course Online

By Lead Academy

From this course, you will gain knowledge about the project life cycles, agile project approaches and agile team methods. You will also gain knowledge about the entire agile transformation process, which will aid you in leading the transformation process of your office. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the fundamentals of agile project management Recognise the various agile approaches and practices Understand the project life cycles approaches Learn about various agile approaches and team methods Know how to lead the transformation process of your office Discover how to run an organization with the help of agile leadership and mindset Learn how to enhance the efficiency of your project management office Agile Project Management Office Course Overview This Agile Project Management Office Course Online is ideal for project managers, agile project leaders and project management office members who want to gain skills and knowledge about agile project management, as well as for those who want to develop an effective agile project management plan for their organisation. This course will assist you in comprehending how the project management office provides guidance and assistance for projects and programs that are carried out utilising agile methods. Finally, you will learn how to operate an organisation with the help of an agile mindset and agile leadership. Upon successful completion of this Agile Project Management Office Course Online, you will be equipped with essential skills and knowledge to improve the efficiency of your project management office using agile concepts and procedures. Who should take this course? This Agile Project Management Office Course Online is primarily aimed at: Accredited by CPD UK Endorsed by Quality Licence Scheme Project managers Team leaders Project team members Aspiring project managers Agile project leaders Project management office members Anyone looking to enhance their project management skills Anyone who wants to learn about agile project management New project managers who want to gain agile project management skills However, this course is not restricted to any single profession or field of work. This course can also benefit anyone who wants to learn more about agile project management in order to handle their own projects. Entry Requirements There are no academic entry requirements for this Agile Project Management Office Course Online, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Agile Project Management Office Course Online assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Course Curriculum Introduction Module 1:Course Overview Module 2:An Introduction to Agile Section 2: Life Cycles Approaches & Methods Module 3: Project Life Cycles - Part 1 Module 3: Project Life Cycles - Part 2 Module 4: Agile Project Approaches Module 5: Agile Team Methods Section 3 : Agile Transformation & Delivery Module 6: Agile Transformation Part 1-Agile Mindset Module 6: Agile Transformation Part 2: Agile Leadership Module 7: Agile Delivery Mock Assessment Mock Assessment Final Assessment Assessment - Agile Project Management Office Course Online Recognised Accreditation CPD Certification Service 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. Quality Licence Scheme Endorsed 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.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme 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. Certificate of Achievement from Lead Academy 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.   FAQs Is CPD a recognised qualification in the UK? 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. Are QLS courses recognised? 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. When will I receive my certificate? 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. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? 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. Does age matter in online learning? 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. When I will get the login details for my course? 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

Agile Project Management Office Course Online
Delivered Online On Demand
£25

Administrative Assistant

By Compete High

📚 Unlock Your Potential: Administrative Assistant Course! 🖇️ Are you ready to embark on a career as an efficient and indispensable administrative assistant? Enroll in our Administrative Assistant Course, a comprehensive program meticulously crafted to equip you with the essential skills and knowledge needed to thrive in administrative roles. Join us on a transformative journey where organization, communication, and efficiency are the keys to success. 🌟 Module 1: Introduction to Administrative Assistance Begin your journey with Module 1, where you'll gain a comprehensive understanding of the role and responsibilities of administrative assistants. Learn the foundational principles that underpin effective administrative support, setting the stage for your success. 💻 Module 2: Office Technology and Equipment Master the tools of the trade in Module 2. Explore a range of office technologies and equipment, from software applications to hardware devices, empowering you to leverage technology to streamline administrative tasks and enhance productivity. 🗂️ Module 3: Organizational Skills and Task Prioritization Optimize your organizational skills in Module 3. Discover techniques for managing workflows, prioritizing tasks, and maintaining efficient systems, ensuring that you can juggle multiple responsibilities with ease and effectiveness. 📝 Module 4: Business Correspondence and Documentation Refine your communication skills in Module 4. Learn the art of crafting professional business correspondence, including emails, memos, and reports, and hone your documentation skills to ensure accuracy and clarity in all written communications. 🤝 Module 5: Meeting and Event Coordination Become a master of coordination in Module 5. Explore the ins and outs of meeting and event planning, from scheduling and logistics to execution and follow-up, ensuring that every gathering runs smoothly and efficiently. 💬 Module 6: Office Communication and Interpersonal Skills Cultivate your interpersonal skills in Module 6. Learn to navigate office dynamics, communicate effectively with colleagues and stakeholders, and build positive working relationships that contribute to a harmonious and productive workplace environment. 🧳 Module 7: Travel Arrangements and Expense Management Become a logistical wizard in Module 7. Explore the intricacies of travel arrangements and expense management, mastering the art of coordinating travel itineraries, accommodations, and expenses with precision and efficiency. 🗄️ Module 8: Records Management and Data Security Ensure compliance and confidentiality in Module 8. Learn best practices for records management and data security, including file organization, document retention policies, and measures to safeguard sensitive information. 🚀 Why Choose Our Administrative Assistant Course? Comprehensive Curriculum: Covering all essential aspects of administrative support, ensuring that you are well-prepared for the demands of the role. Practical Applications: Engage in hands-on exercises, case studies, and simulations to reinforce learning and build practical skills. Expert Instruction: Learn from experienced administrative professionals who bring real-world insights and expertise to the course. Career Advancement: Gain a valuable credential that can open doors to a wide range of administrative opportunities and career advancement prospects. 🎓 Who Should Enroll? Aspiring Administrative Assistants Office Administrators Executive Assistants Office Managers Anyone Seeking to Enhance Administrative Skills 🌐 Empower Your Career Today! Elevate your administrative skills and unlock new opportunities in the dynamic world of office support. Enroll now in the Administrative Assistant Course and take the first step toward a rewarding and fulfilling career as a trusted administrative professional. Your journey to success starts here! 🚪🔑📊 Course Curriculum Module 1 Introduction to Administrative Assistance. Introduction to Administrative Assistance. 00:00 Module 2 Office Technology and Equipment. Office Technology and Equipment. 00:00 Module 3 Organizational Skills and Task Prioritization. Organizational Skills and Task Prioritization. 00:00 Module 4 Business Correspondence and Documentation. Business Correspondence and Documentation. 00:00 Module 5 Meeting and Event Coordination. Meeting and Event Coordination. 00:00 Module 6 Office Communication and Interpersonal Skills. Office Communication and Interpersonal Skills. 00:00 Module 7 Travel Arrangements and Expense Management. Travel Arrangements and Expense Management. 00:00 Module 8 Records Management and Data Security. Records Management and Data Security. 00:00

Administrative Assistant
Delivered Online On Demand8 hours
£25

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Programming and Data Wrangling with VBA and Excel
Delivered OnlineFlexible Dates
£885

Legal Office Administration Diploma - Video Training Course

4.3(43)

By John Academy

Description: The purpose of Legal Office Administration Diploma - Video Training Course is to help you with the most up-to-date legal skills and legal office management procedures to manage a legal office efficiently. The Legal Office Administration Diploma - Video Training Course provides all the necessary information regarding Legal Office Administration. The course contents include certification for paralegals, the law office, preparing legal documents, billing, litigation, and contracts. Throughout the course, you will also learn the family law, business law, bankruptcy, and criminal law and procedure. The course is divided into several sections that specify separate topics. For example, certification for paralegals teaches you how to prepare yourself for Certified Paralegal examination while the course The Law Office deals with ethical considerations, the basics, client relations, dealing with mail, file management, use of technology, and skills that every legal secretary need to run a legal office. In the Billing course, you will learn how attorneys charges. Similarly, preparing Legal Documents course will help you to prepare a legal document using Legal citations and the Legal library. Apart from these sections, you will also learn Litigations, torts, contracts, Criminal Law and Procedure, Family Law, Business Law, Real State Law, Bankruptcy, and Estate Planning and Guardianship. In short, the course will help you to meet the demands of the current and emerging legal office environment. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Legal Office Administration Diploma - Video Training Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Legal Office Administration Diploma - Video Training Course 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. Career Path 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. Certification for Paralegals Certifications FREE 00:07:00 The Law Office Ethical Considerations 00:10:00 The Basics 00:04:00 Client Relations 00:05:00 Dealing With Mail 00:05:00 File Management 00:03:00 Use Of Technology 00:06:00 Skills that Every Legal Secretary Should Have 00:06:00 Billing How Attorneys Charge 00:09:00 Time and Cost Entries 00:05:00 Trust Accounts 00:04:00 Docket Administration 00:05:00 Preparing Legal Documents Basic Preparation 00:13:00 Legal Citations 00:05:00 The Law Library 00:05:00 Litigation What is Litigation 00:04:00 Delivery of Documents 00:04:00 Motions Prior to and During Trial 00:07:00 Contracts The Basics 00:04:00 The Essential Elements 00:03:00 Remedies for Breach of Contract 00:04:00 Torts The Goal of Tort Law 00:10:00 Negligence 00:11:00 Strict Liability 00:07:00 Criminal Law and Procedure Criminal Law Basics 00:20:00 Criminal Procedure 00:15:00 Family Law Marriage 00:08:00 Annulment and Divorce 00:05:00 Child Custody 00:09:00 Business Law Types of Organizations 00:07:00 Corporations 00:09:00 Real Estate The Basics 00:10:00 Documenting Transactions 00:12:00 Estate Planning and Guardianship The Basics 00:07:00 Characteristics of a Will 00:08:00 Types of Trusts and Funding 00:04:00 Elder Law 00:06:00 Bankruptcy The Basics 00:14:00 Mock Exam Mock Exam- Legal Office Administration Diploma - Video Training Course 00:20:00 Final Exam Final Exam- Legal Office Administration Diploma - Video Training Course 00:20:00

Legal Office Administration Diploma - Video Training Course
Delivered Online On Demand5 hours 20 minutes
£21

Professionalism in the Office Level 2

4.7(160)

By Janets

Professionalism in the Office Level 2 course is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in the office environment and looks at skills needed to improve professionalism. By taking this course you will gain the necessary skills to perform effectively in this field. The Professionalism in the Office Level 2 is organised into 15 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 2 hours 51 minutes! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design 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. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Positioning Yourself as a Professional Attitude in the Workplace 00:10:00 Professionalism 00:03:00 Making Changes through Personal Accountability 00:07:00 Enhancing Your Professional Image Your Image as a Whole 00:05:00 Becoming More Marketable 00:03:00 Communicating and Image 00:08:00 Expanding Your Skills Time Management 00:14:00 Project Management Techniques 00:03:00 Making Decisions 00:06:00 Communicating for Results Keys to Effective Communication 00:26:00 Presentations 00:09:00 Meetings 00:07:00 Building Relationships and Networks Work and Your Personality 00:05:00 Networking 00:07:00 Roles in the Office 00:18:00 Mock Exam Mock Exam- Professionalism in the Office Level 2 00:20:00 Final Exam Final Exam- Professionalism in the Office Level 2 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Professionalism in the Office Level 2
Delivered Online On Demand2 hours 51 minutes
£25

Office Politics For Managers

By Course Cloud

Workplaces are intricate tapestries woven from countless threads of interpersonal dynamics, unique personalities, and shared objectives. Leading effectively in such environments requires technical insight and an innate understanding of these subtle currents. 'Office Politics for Managers' takes you on an enlightening journey, uncovering how individuals interact and influence one another in professional settings.  With each module, you'll be better equipped to embrace and navigate these complexities, turning potential pitfalls into opportunities for collaboration and growth. Learn to harness the latent power of office dynamics and create an atmosphere where projects thrive, conflicts dissolve, and the collective team vision comes to fruition. It's time to elevate your managerial prowess to its fullest potential.

Office Politics For Managers
Delivered Online On Demand
£25

SC-300T00 Microsoft Identity and Access Administrator

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This course is for the Identity and Access Administrators who are planning to take the associated certification exam, or who are performing identity and access administration tasks in their day-to-day job. This course would also be helpful to an administrator or engineer that wants to specialize in providing identity solutions and access management systems for Azure-based solutions; playing an integral role in protecting an organization. The Microsoft Identity and Access Administrator course explores how to design, implement, and operate an organization?s identity and access management systems by using Microsoft Entra ID. Learn to manage tasks such as providing secure authentication and authorization access to enterprise applications. You will also learn to provide seamless experiences and self-service management capabilities for all users. Finally, learn to create adaptive access and governance of your identity and access management solutions ensuring you can troubleshoot, monitor, and report on your environment. The Identity and Access Administrator may be a single individual or a member of a larger team. Learn how this role collaborates with many other roles in the organization to drive strategic identity projects. The end goal is to provide you knowledge to modernize identity solutions, to implement hybrid identity solutions, and to implement identity governance. Prerequisites SC-900T00: Microsoft Security, Compliance, and Identity Fundamentals AZ-104T00 - Microsoft Azure Administrator 1 - Explore identity in Microsoft Entra ID Explain the identity landscape Explore zero trust with identity Discuss identity as a control plane Explore why we have identity Define identity administration Contrast decentralized identity with central identity systems Discuss identity management solutions Explain Microsoft Entra Business to Business Compare Microsoft identity providers Define identity licensing Explore authentication Discuss authorization Explain auditing in identity 2 - Implement initial configuration of Microsoft Entra ID Configure company brand Configure and manage Microsoft Entra roles Configure delegation by using administrative units Analyze Microsoft Entra role permissions Configure and manage custom domains Configure tenant-wide setting 3 - Create, configure, and manage identities Create, configure, and manage users Create, configure, and manage groups Configure and manage device registration Manage licenses Create custom security attributes Explore automatic user creation 4 - Implement and manage external identities Describe guest access and Business to Business accounts Manage external collaboration Invite external users - individually and in bulk Demo - manage guest users in Microsoft Entra ID Manage external user accounts in Microsoft Entra ID Manage external users in Microsoft 365 workloads Implement and manage Microsoft Entra Verified ID Configure identity providers Implement cross-tenant access controls 5 - Implement and manage hybrid identity Plan, design, and implement Microsoft Entra Connect Implement manage password hash synchronization (PHS) Implement manage pass-through authentication (PTA) Demo - Manage pass-through authentication and seamless single sign-on (SSO) Implement and manage federation Trouble-shoot synchronization errors Implement Microsoft Entra Connect Health Manage Microsoft Entra Health 6 - Secure Microsoft Entra users with multifactor authentication What is Microsoft Entra multifactor authentication? Plan your multifactor authentication deployment Configure multi-factor authentication methods 7 - Manage user authentication Administer FIDO2 and passwordless authentication methods Explore Authenticator app and OATH tokens Implement an authentication solution based on Windows Hello for Business Deploy and manage password protection Configure smart lockout thresholds Implement Kerberos and certificate-based authentication in Microsoft Entra ID Configure Microsoft Entra user authentication for virtual machines 8 - Plan, implement, and administer Conditional Access Plan security defaults Plan Conditional Access policies Implement Conditional Access policy controls and assignments Test and troubleshoot Conditional Access policies Implement application controls Implement session management Implement continuous access evaluation 9 - Manage Microsoft Entra Identity Protection Review identity protection basics Implement and manage user risk policy Monitor, investigate, and remediate elevated risky users Implement security for workload identities Explore Microsoft Defender for Identity 10 - Implement access management for Azure resources Assign Azure roles Configure custom Azure roles Create and configure managed identities Access Azure resources with managed identities Analyze Azure role permissions Configure Azure Key Vault RBAC policies Retrieve objects from Azure Key Vault Explore Microsoft Entra Permissions Management 11 - Plan and design the integration of enterprise apps for SSO Discover apps by using Microsoft Defender for Cloud Apps and Active Directory Federation Services app report Configure connectors to apps Design and implement app management roles Configure preintegrated gallery SaaS apps Implement and manage policies for OAuth apps 12 - Implement and monitor the integration of enterprise apps for SSO Implement token customizations Implement and configure consent settings Integrate on-premises apps with Microsoft Entra application proxy Integrate custom SaaS apps for single sign-on Implement application-based user provisioning Monitor and audit access to Microsoft Entra integrated enterprise applications Create and manage application collections 13 - Implement app registration Plan your line of business application registration strategy Implement application registration Register an application Configure permission for an application Grant tenant-wide admin consent to applications Implement application authorization Manage and monitor application by using app governance 14 - Plan and implement entitlement management Define access packages Configure entitlement management Configure and manage connected organizations Review per-user entitlements 15 - Plan, implement, and manage access review Plan for access reviews Create access reviews for groups and apps Create and configure access review programs Monitor access review findings Automate access review management tasks Configure recurring access reviews 16 - Plan and implement privileged access Define a privileged access strategy for administrative users Configure Privileged Identity Management for Azure resources Plan and configure Privileged Access Groups Analyze Privileged Identity Management audit history and reports Create and manage emergency access accounts 17 - Monitor and maintain Microsoft Entra ID Analyze and investigate sign-in logs to troubleshoot access issues Review and monitor Microsoft Entra audit logs Export logs to third-party security information and event management system Analyze Microsoft Entra workbooks and reporting Monitor security posture with Identity Secure Score

SC-300T00 Microsoft Identity and Access Administrator
Delivered Online
£2,380

Legal Secretary and Office Skills

4.7(160)

By Janets

Our popular Legal Secretary and Office Skills Diploma Course will supply you with the skills and confidence required to start a lucrative career in the UK's legal system. You will become an excellent asset to the administration and operation of any high-performing law firm. The training will cover not only essential knowledge regarding UK legalities but also crucial office-based skills. You will be expertly trained in commonly used legal terminology, alongside tuition on vital practises that you can expect to encounter every day, such as wills, contracting, insurance, and property. Additionally, you will also be coached in the performing exemplary data management, customer service, and mastery of Microsoft office tools. By completing the course, you can be sure that you will have grasped the fundamental requirements to be a sought-after Legal Secretary. By signing up for the Legal Secretary and Office Skills Diploma Course, you will attain the capabilities expected for a law firm , both in terms of knowledge and administration competencies. The tutorial contains an extensive range of useful study tools, along with interactive exercises. All modules can be taken at your own pace, and you will rapidly move through all the lessons. Enrol now for an exciting future in the legal progression. Why choose this Legal Secretary and Office Skills Diploma Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design 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. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and 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. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? This course is designed for those who work in the UK's legal system, typically in a supportive or secretarial role. Career path The training delivered by the Legal Secretary and Office Skills Diploma Course will be beneficial to those working in a law firm office or individuals supporting a barrister or solicitor. As such, it will directly assist roles or positions such as: Legal Secretary Paralegal Legal Assistant Law Graduate Legal Advice Consultant Course Content Module 01: Introduction to Legal Secretary Introduction to Legal Secretary 00:25:00 Module 02: English Law & Legal Systems English Law and Legal Systems 00:22:00 Module 03: The Legal Workplace & Professionals The Legal Workplace and Professionals 00:20:00 Module 04: Law of Contract & Law of Tort Law of Contract & Law of Tort 00:31:00 Module 05: Wills, Probate and Estate Law Practice Wills, Probate, Estate Law 00:23:00 Module 06: Property Law & Conveyancing Practice Property Law & Conveyancing Practice 00:22:00 Module 07: Family Law and Insurance Practice Family Law and Insurance Practice 00:26:00 Module 08: Professional Writings and Documents Professional Writing and Documents 00:30:00 Module 09: Document Proofreading and Editing Document Proofreading and Editing 00:24:00 Module 10: Meeting Management & Minute Taking Meeting Management & Minute Taking 01:09:00 Module 11: Customer Service and Telephone Handling Skills Customer Service and Telephone Handling Skills 00:23:00 Module 12: Data Management and Record-Keeping Data Management and Record-Keeping 00:16:00 Module 13: Other Essential Skills for Secretarial Role Other Essential Skills for Secretarial Role 00:22:00 Module 14: Professional Conduct and Ethics Professional Conduct and Ethics 00:25:00 Microsoft Word Essentials New Document and Templates 00:02:00 Tabs, Ribbons and Groups 00:03:00 Zoom and Rulers in Word 00:02:00 Editing the Word Document 00:03:00 Insert Pictures with Word 00:05:00 Insert Shape and Text Box in Word 00:02:00 Review Tab in Word 00:03:00 Layout in Word 00:02:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft Powerpoint Essentials New PowerPoint Presentation and Templates 00:02:00 Tabs Ribbons and Groups PowerPoint 00:03:00 First Slide and Designing the Slide 00:02:00 Home Tab and Updates in PowerPoint 00:02:00 Buttons in PowerPoint 00:01:00 Inserting Pictures in PowerPoint 00:04:00 Presentation Mode 00:01:00 Animations Tab 00:05:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft Outlook Essentials Setting Up Outlook with Accounts 00:03:00 Tabs, Ribbons and Groups in Outlook 00:03:00 Navigation Bar in Outlook 00:01:00 Organizing Outlook with Favorites and Folders 00:03:00 Additional Options inside Outlook Tabs 00:01:00 Reading, Writing and Receiving Emails 00:08:00 Attaching Items in Outlook Mails 00:03:00 The View Tab in Outlook 00:02:00 Create a Rule to move emails to a folder 00:04:00 Insert a screen shot from Excel 00:02:00 Microsoft Excel - Top 50 Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Mock Exam Mock Exam - Legal Secretary and Office Skills 00:20:00 Final Exam Final Exam - Legal Secretary and Office Skills 00:20:00 Recommended Readings Recommended Readings: Legal Secretary and Office Skills 00:00:00 Assignment Assignment - Legal Secretary and Office Skills Unlimited Order Your Certificate Order your Certificate QLS 00:00:00

Legal Secretary and Office Skills
Delivered Online On Demand3 weeks
£25

Microsoft Project Introduction - In-company

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Project Introduction - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750