3723 Office Skills courses in Polegate delivered Online

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 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 Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified AutoCAD for Structural Engineering and Construction bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The AutoCAD for Structural Engineering and Construction related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive AutoCAD for Structural Engineering and Construction bundle will help you build a solid foundation to become a proficient worker in the sector. This AutoCAD for Structural Engineering and Construction Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 : Read Construction & Structural Drawing Like Expert Course 02 : Diploma in Construction Management Course 03 : Quantity Surveyor Diploma Course 04 : Building Surveyor Course 05 : Land Surveying Course 06 : Bricklaying Course 07 : Construction Cost Estimation Diploma Course 08 : Construction Estimation using RSMeans Course 09 : Ladder Safety Training CPD Approved Course Course 10 : Mastering Colour-Architectural Design & Interior Decoration Course 11 : Property Law and Legislation Course 12 : Construction Industry Scheme (CIS) Course 13 : WELL Building Standard Course 14 : LEED V4: Building Design and Construction Course 15 : Introduction to Urban Planning Course Course 16 : Architectural Studies Course 17 : AutoCAD Programming using C# with Windows Forms Course 18 : CAD Design Course: Assemblies, Modelling And Civil Drawings Course 19 : Autocad Electrical Design Course 20 : Learning Drawing and Illustration Complete Training Course 21 : Solidworks Foundation Training Course 22 : Interior Design Professional Diploma Course 23 : Professional Interior Design & Construction Course 24 : Construction Safety Course 25: Fire Safety | Online Course Course 26: Emergency First Aid and Incident Management at Work Course 27: RIDDOR Training Course 28: LOLER Training Course 29: COSHH Training and Safety - Level 2 Course 30: DSEAR Training 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Creative Thinking: Techniques and Tools for Problem Solving Learning Outcome This tailor-made AutoCAD for Structural Engineering and Construction bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This AutoCAD for Structural Engineering and Construction Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Course 01: Read Construction & Structural Drawing Like an Expert Mastering the interpretation of construction and structural drawings. Understanding architectural symbols and notations. Becoming proficient in reading blueprints and plans. Course 02: Diploma in Construction Management Gaining comprehensive knowledge of construction management. Developing project planning and execution skills. Understanding legal and regulatory aspects of construction. Course 03: Quantity Surveyor Diploma Learning the principles of quantity surveying. Mastering cost estimation and budgeting in construction. Enhancing skills in procurement and contract management. Course 04: Building Surveyor Becoming proficient in building surveying techniques. Conducting property inspections and assessments. Providing expert advice on property maintenance and renovation. Course 05: Land Surveying Gaining expertise in land surveying methods and equipment. Conducting precise land measurements and boundary assessments. Creating accurate land survey reports and maps. Course 06: Bricklaying Developing practical bricklaying skills. Understanding masonry techniques and construction. Creating various brick structures and finishes. Course 07: Construction Cost Estimation Diploma Mastering construction cost estimation techniques. Learning to create accurate project budgets. Evaluating construction costs for different types of projects. Course 08: Construction Estimation using RSMeans Utilizing RSMeans data for construction estimation. Creating detailed estimates for construction projects. Enhancing accuracy in budgeting and cost control. Course 09: Construction Cost Estimation Using Xactimate Understanding Xactimate software for construction estimation. Creating precise estimates for insurance-related construction work. Navigating Xactimate's features for cost calculations. Course 10: Cost Estimation for Multiplex Building Using Xactimate Specialized training in estimating costs for multiplex buildings. Using Xactimate to create detailed estimates for complex projects. Ensuring accurate pricing for multiplex construction. Course 11: Property Law and Legislation Exploring property laws and regulations. Understanding property rights and ownership. Navigating legal aspects of real estate transactions. Course 12: Construction Industry Scheme (CIS) Learning about the Construction Industry Scheme in the UK. Understanding CIS tax deductions and compliance. Managing CIS registration and reporting. Course 13: WELL Building Standard Exploring the principles of the WELL Building Standard. Designing and implementing health-focused building strategies. Promoting occupant well-being through architectural design. Course 14: LEED V4: Building Design and Construction Mastering LEED v4 requirements for green building design. Achieving LEED certification for environmentally sustainable projects. Implementing sustainable design practices in construction. Course 15: LEED Green Associate Preparing for the LEED Green Associate exam. Understanding core concepts of green building and sustainability. Demonstrating knowledge of LEED rating systems. Course 16: Architectural Studies Exploring architectural history and theory. Studying architectural design principles and concepts. Analyzing iconic architectural works and styles. Course 17: AutoCAD Programming using C# with Windows Forms Learning to program AutoCAD using C# and Windows Forms. Creating custom AutoCAD applications and tools. Enhancing AutoCAD functionality through programming. Course 18: CAD Design Course: Assemblies, Modelling, And Civil Drawings Mastering CAD design for assemblies and modeling. Creating detailed civil engineering drawings. Enhancing skills in computer-aided design. Course 19: Autocad Electrical Design Developing expertise in electrical design using AutoCAD. Creating electrical schematics and diagrams. Understanding industry standards for electrical drawings. Course 20: Rendering AutoCAD Drawings in Photoshop Learning to render AutoCAD drawings using Photoshop. Enhancing the visual presentation of CAD designs. Creating professional-quality architectural renderings. Course 21: Solidworks Foundation Training Gaining a strong foundation in Solidworks 3D modeling. Creating 3D designs and assemblies. Developing proficiency in Solidworks for engineering applications. Course 22: Interior Design Professional Diploma Becoming a professional interior designer. Mastering interior design principles and techniques. Creating functional and aesthetically pleasing interior spaces. Course 23: Professional Interior Design & Construction Understanding the integration of design and construction in interior projects. Managing interior design projects from concept to completion. Ensuring quality and functionality in interior spaces. Course 24: Construction Safety Promoting safety in construction work environments. Identifying and mitigating construction-related hazards. Complying with health and safety regulations in construction. Course 25: Fire Safety | Online Course Learning essential fire safety measures and procedures. Understanding fire prevention and emergency response. Promoting fire safety in various settings. Course 26: Emergency First Aid and Incident Management at Work Acquiring emergency first aid skills for the workplace. Responding effectively to workplace incidents and injuries. Managing emergency situations to ensure safety. Course 27: RIDDOR Training Understanding the Reporting of Injuries, Diseases and Dangerous Occurrences Regulations (RIDDOR). Complying with RIDDOR reporting requirements. Promoting workplace safety and incident reporting. Course 28: LOLER Training Learning about the Lifting Operations and Lifting Equipment Regulations (LOLER). Understanding safe lifting practices and equipment inspections. Ensuring compliance with LOLER regulations. Course 29: COSHH Training and Safety - Level 2 Understanding Control of Substances Hazardous to Health (COSHH) regulations. Identifying hazardous substances and assessing risks. Implementing safety measures to protect against hazardous materials. Course 30: DSEAR Training Gaining knowledge of the Dangerous Substances and Explosive Atmospheres Regulations (DSEAR). Identifying and managing risks related to dangerous substances. Ensuring safety in environments with explosive atmospheres. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the AutoCAD for Structural Engineering and Construction bundle! This bundle is also ideal for professionals looking for career advancement. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in AutoCAD for Structural Engineering and Construction Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields. Certificates Quality Licence Scheme Endorsed Certificate of Achievement Hard copy certificate - Included

FREE Certification:QLS Endorsed + CPD Accredited | Instant Access | Round-the-Clock Tutor Support | All-Inclusive Cost

Level 7 Diploma(FREE QLS Endorsed Certificate)| 11 CPD Courses+11 PDF Certificates| 150 CPD Points|CPD & CiQ Accredited

Level 4 Diploma (FREE QLS Endorsed Certificate) | 11 CPD Courses & PDF Certificates | 225 CPD Points | CPD Accredited

Give a compliment to your career and take it to the next level. This Sage 50 Payroll: Essential Software for Payroll Management will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Sage 50 Payroll: Essential Software for Payroll Management will help you keep ahead of the pack. The Sage 50 Payroll: Essential Software for Payroll Management incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this Sage 50 Payroll: Essential Software for Payroll Management will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Sage 50 Payroll: Essential Software for Payroll Management, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Sage 50 Payroll: Essential Software for Payroll Management course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This Bundle Consists of the following Premium courses: Course 1: Sage 50 Training Course 2: Level 3 Tax Accounting Course 3: Level 3 Xero Training Course 4: Accounting and Bookkeeping Level 2 Course 5: UK Employment Law and Employee Rights Diploma Course 6: Team Management Course 7: Applied Business Analysis Diploma Course 8: Data Analysis in Excel Level 3 Course Course 9: Office Skills Course 10: Level 2 Financial Planning and Management Course Course 11: New Functions in Microsoft Excel 2021 As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Sage 50 Payroll: Essential Software for Payroll Management to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Sage 50 Payroll: Essential Software for Payroll Management: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum: Course 1: Sage 50 Training Module 1: Payroll Basics Module 2: Company Settings Module 3: Legislation Settings Module 4: Pension Scheme Basics Module 5: Pay Elements Module 6: The Processing Date Module 7: Adding Existing Employees Module 8: Adding New Employees Module 9: Payroll Processing Basics Module 10: Entering Payments Module 11: Pre-Update Reports Module 12: Updating Records Module 13: e-Submissions Basics Module 14: Process Payroll (November) Module 15: Employee Records and Reports Module 16: Editing Employee Records And Much More..... Sage 50 Payroll Advanced Diploma Module 1: The Outline View and Criteria Module 2: Global Changes Module 3: Timesheets Module 4: Departments and Analysis Module 5: Holiday Schemes Module 6: Recording Holidays Module 7: Absence Reasons Module 8: Statutory Sick Pay Module 9: Statutory Maternity Pay Module 10: Student Loans Module 11: Company Cars Module 12: Workplace Pensions Module 13: Holiday Funds Module 14: Roll Back Module 15: Passwords and Access Rights Module 16: Options and Links And More..... CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Sage 50 Payroll: Essential Software for Payroll Management bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Sage 50 Payroll: Essential Software for Payroll Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 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 in company 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. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Requirements Requirements 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 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

***24 Hour Limited Time Flash Sale*** Executive PA, Legal Secretary & Communication- 3 QLS Course Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Navigate through the corporate world with finesse and precision with our 'Executive PA, Legal Secretary & Communication' course bundle. This comprehensive suite of 8 courses unravels the many facets of corporate operations and communication. Take advantage of the 3 QLS-endorsed courses that masterfully delve into the roles of an Executive PA, a Legal Secretary, and the art of Effective Communication Skills - each one equipped with a hardcopy certificate. The journey doesn't stop there! Amplify your theoretical understanding with our 5 CPD QS accredited courses in Office Administration, Document Control, Legal Office Administration, Online Meeting Management, and Business Writing. Each course has been curated to enhance your corporate skillset and set you on the path to success. Equip yourself with our 'Executive PA, Legal Secretary & Communication' course bundle and rise above the competition! Key Features of the Executive PA, Legal Secretary & Communication- 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Executive PA, Legal Secretary & Communication- 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Executive PA QLS Course 02: Legal Secretary QLS Course 03: Effective Communication Skills 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Office Administration Course 02: Document Control Course 03: Legal Office Administration Course 04: Online Meeting Management Course 05: Business Writing In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Executive PA, Legal Secretary & Communication- 3 QLS Course courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the roles and responsibilities of an Executive PA and a Legal Secretary. Enhance your effective communication skills. Gain an understanding of office administration and document control procedures. Learn about legal office administration tasks. Develop skills in online meeting management and business writing. Understand the principles of professional document control. Develop strategies for efficient online meeting management. The 'Executive PA, Legal Secretary & Communication' course bundle offers a comprehensive theoretical foundation on crucial corporate roles and communication techniques. This bundle is designed to provide a deep understanding of the responsibilities of an Executive PA and a Legal Secretary. Moreover, it offers insight into effective communication skills that can enhance your workplace interactions. The course bundle also comprises CPD QS accredited courses on Office Administration, Document Control, Legal Office Administration, Online Meeting Management, and Business Writing. These courses will equip you with a deeper understanding of office procedures, document management, online meetings, and professional writing. By completing this bundle, you'll be well-prepared to excel in your professional life. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals looking to work as an Executive PA or Legal Secretary. Those keen on improving their communication skills. Office Administrators aiming to enhance their skills. Professionals looking to better manage online meetings and business writing. Career path Executive PA: (£25,000 - £35,000) Legal Secretary: (£20,000 - £30,000) Office Administrator: (£18,000 - £24,000) Document Controller: (£20,000 - £30,000) Legal Office Administrator: (£22,000 - £32,000) Business Writer: (£20,000 - £35,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Duration 1 Days 6 CPD hours This course is intended for The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones. Overview #NAME? This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates. 1 - An Introduction to Power Automate What is Microsoft Power Automate? The benefits of automation How to get to Power Automate Lab 1: Setup your tenant Setup Office 365 Download Course Files Customise your App Launcher Create accounts for colleagues After completing this module, students will be able to: Know what Microsoft Power Automate is The Benefits of using Power Automate to automate processes How to access a Power Automate 2 - Getting Started with Power Automate Using Power Automate templates Navigating in Power Automate Editing a Power Automate Publish and trigger a Power Automate Turn off or delete a Power Automate Lab 1: Building processes in Office 365 Create a Team with a channel Build an absence business process Testing the absence process Optional: Create Feedback Form Optional: Power Automate to Notify of Bad Ratings Optional: Test your Form and Power Automate After completing this module, students will be able to: How to use Power Automate tempaltes How to navigate around Power Automate How to edit Power Automates How to publish and trigger Power Automates How to turn off or delete Power Automates 3 - Power Automate Logic Adding conditions Designing switches Using apply to each Configuring do until logic Adding a scope Lab 1: Scheduling documentation reviews Setup a policy library in SharePoint Design a policy review schedule Testing the policy review process Optional: Notify if a file nears review After completing this module, students will be able to: How to add condtions in a Power Automate How to design switches for a Power Automate How to use apply to each How to configure do until logic How to add a scope 4 - Integration Standard and premium connectors Connecting to web services Using Power Automate with on-premises data Lab 1: Using Power Automate and SQL to Review Sales Create a new orders list Designing the price check process Testing the price check process Optional: Update with managers After completing this module, students will be able to: How to use Standard and Premium connectors How to connect to web services How to using Power Automate with on-premises data 5 - The Mobile App Downloading the mobile app Signing in and account management Building and managing Power Automates Creating buttons Feeds and approvals Lab 1: Optional: Using the Power Automate mobile app Setting up the Power Automate mobile app Create a new Power Automate in the mobile app Using Power Automate buttons in the app Uninstall the Power Automate mobile app After completing this module, students will be able to: How to download the mobile app How to sign into the mobile app How to build and manage Power Automates in the mobile app How to create buttons in the mobile app How to feed and use approvals in the mobile app 6 - Administration and Maintenance Maintaining a Power Automate View history and analytics Sharing a Power Automate Export and import Power Automates Office 365 administration for Power Automate Environments Data policies Data integration Lab 1: Maintaining your Power Automates Share a Power Automate with a colleague Disabling an active Power Automate Deleting a Power Automate After completing this module, students will be able to: How to maintain a Power Automate How to view history and analytics for a Power Automate How to share a Power Automate How to export and import Power Automates How to administrate a Power Automate in Office 365 How to use data policies in a Power Automate How to use data integration in a Power Automate