3803 Office Skills courses in Reigate delivered Online

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who already have experience creating Modern SharePoint sites and populating them with content, who want to learn advanced features to extend SharePoint's capabilities, make information easier to find and manage, use SharePoint features to improve governance and compliance, and improve the security of information and services within the SharePoint environment. Overview Create a custom site template to reduce the time spent creating similarly configured SharePoint sites. Configure managed metadata, including custom term sets, content types, and metadata-based navigation. Control access through permissions. Improve overall security of sites, lists, libraries, folders, list items, and documents. Microsoft© SharePoint©, in conjunction with the Microsoft 365? productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance. Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration. This course focuses on these advanced site-building and administration tasks. Prerequisites To ensure your success in this course, you should have SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site. You should also have intermediate site builder skills such as the ability to create a SharePoint site, apply a site template, populate sites with pages, create lists and libraries, and connect a site to a hub site. NOTE: This course was developed using Microsoft 365 Business Standard edition. If you opt to use one of the Enterprise editions, be sure to key the course activities before you deliver the class so you will be able to anticipate any differences that students might see with the edition you use. Lesson 1: Creating Custom Site Templates Topic A: Prepare a Site Script Topic B: Generate and Use a Custom Site Template Lesson 2: Managing Content Services Topic A: Plan and Configure Managed Metadata Topic B: Create and Manage Content Types Topic C: Use Managed Metadata for Navigation and Filtering Lesson 3: Controlling Access Through Permissions Topic A: Assign Permissions Topic B: Manage Permissions Inheritance Lesson 4: Improving Security Topic A: Manage Access at the Site Level Topic B: Manage Access at the Tenant Level

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

Ready to stop sending your resume into the void? It’s time to master a fundamental life skill for every ambitious administrative professional: crafting a resume that doesn’t just list your entire work history, but actually it gets you interviews. Join us for an intensive workshop where we reveal the industry secrets behind the art and science of standout resumes.

Get Hard Copy + PDF Certificate + Transcript + Student ID Card as a Gift - Enrol SAP Training Now Give a compliment to your career and take it to the next level. This SAP Training bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this SAP Training bundle will help you stay ahead of the pack. Throughout the SAP Training programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. This SAP Bundle Consists of the following Premium courses: Course 01: Complete SAP UI5 Development Course 02: SAP S4HANA Controlling Level 2 Course 03: SAP Controlling (CO) - Product Costing S4HANA Course 04: Agile Practitioner Level 2 Course 05: Document Control and EDMS Implementation Step Course 06: Fundamentals of Business Analysis Course 07: Business Strategy Planning Course 08: Customer Relationship Management Course 09: Essential IT Skills Level 3 Course 10: Introduction to Data Analysis Course 11: Information Management Course 12: Microsoft Teams Course 13: Boost Your Business Productivity - Advanced Course 14: Effective Communication Skills So, enrol in the SAP Training bundle course now to advance your career! The curriculum of SAP Training Bundle: Course 01: Complete SAP UI5 Development Pre-course Web Development Introduction JavaScript UI5 Development Introduction Develop UI5 Applications with SAP Web IDE Use Real Data Deployment =========>>>>> And 13 More Courses <<<<<========= How will I get my SAP Training Certificate? After successfully completing the SAP Training course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this SAP Training bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this SAP Training course. Students can take this course to gather professional knowledge besides their study or for the future. Note: This is not a professional course. This course only covers theoretical knowledge about the topic. Requirements Our SAP Training bundle is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This SAP Training course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this SAP Training course; it can be studied in your own time at your own pace. Career path Having this various SAP Training expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Complete SAP UI5 Development) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Complete SAP UI5 Development) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

2 QLS Endorsed Courses | CPD Certified | Free PDF & Hard Copy QLS Certificates | 180 CPD Points | Lifetime Access

Duration 1 Days 6 CPD hours This course is intended for Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences. Overview After completing this course, you will be able to: Describe Microsoft Power Platform components Describe Microsoft Dataverse and connectors Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services Identify benefits and capabilities of Microsoft Power Platform Identify the basic functionality and business value Microsoft Power Platform components Implement simple solutions with Power Apps, Power Automate, and Power BI Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate. Module 1: Introduction to Microsoft Power Platform Identify when to use each Microsoft Power Platform component application to create business solution Learn the value of using Microsoft Power Platform to create business solutions Learn the components and features of Microsoft Power Platform Module 2: Introduction to Microsoft Dataverse Microsoft Dataverse Overview Module 3: Get Started with Power Apps Introduction to Power Apps How to build a canvas app How to build a model-driven app Module 4: Get Started with Power Automate Power Automate Overview How to Build an Automated Solution Module 5: Get Started with Power BI Power BI Overview How to Build a Simple Dashboard Module 6: Introduction to Power Virtual Agents Power Virtual Agents overview Additional course details: Nexus Humans PL-900T00 Microsoft Power Platform Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the PL-900T00 Microsoft Power Platform Fundamentals 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. 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.

Duration 3 Days 18 CPD hours This course is intended for Senior Consultants (both functional and technical) that aspire to be Solution Architects, or current Solution Architects that are new to the role. The Solution Architect is responsible for the successful design, implementation, deployment and adoption of an overall solution. The Solution Architect ensures that the solution meets the customer?s needs now and in the future. In this course, students will learn about decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more. This course is designed to give you an introduction to the Solution Architect role. Becoming a Solution Architect/Getting to know your customer Define a Solution Architect Role of a Solution Architect on projects Project Methodology Getting to know your customer Group exercise - Getting to know your customer Conceptualizing the design from requirements How to lead the requirement collection effort Using fit gap analysis Pillars of good architecture Blueprinting the solution architecture Group exercise - Design from requirements Project governance and working as a team Solution Architect's role in project governance Techniques for keeping a project on track Scenarios that could cause a project to fail Group exercise - Project governance and working as a team Power Platform Architecture Key Power Platform architecture components Understand how platform design and limits influence solution architectures Updates and feature releases Understand how to communicate how the platform meets customer needs Data Modeling Data model influences Data model strategy Data types Data relationships Group exercise - Data modeling Analytics and artificial intelligence Planning and evaluating requirements Operational reporting Power BI Enterprise BI Pre-built insights and custom AI Power Apps Architecture Discuss options for apps and how to choose where to start Discuss app composition options Using components as part of your app architecture Considerations for including Portals as an app in your architecture Group exercise - Power Apps Architecture topics Application Lifecycle Management (ALM) Microsoft vision and Solution Architect's role in ALM Environment strategies Defning a solution structure for your deliverable Power Automate Architecture Discuss options for automation and custom logic Review considerations for using triggers and common actions Explore using Business Process Flows (BPF) to guide users through business processes Group Exercise - Evaluate scenarios for Power Automate usage Security Modeling Solution Architect's role in security modeling Discovery and learning your client's environment Controlling access to environments and resources Controlling access to CDS Data Group Exercise - Security Modeling Integration Solution Architects role in Integrations What is an integration and why do we need it Platform features that enable integration CDS Event Publishing Scenarios for group discussion Dynamics 365 Applications Architecture Solution Architect's role when deploying Dynamics 365 apps Architecture Considerations for primary apps Group Exercise - App specific working groups evaluate requirements Power Virtual Agents architecture Introduction Chatbot options Chatbot concepts Best practices Integrate chatbots Power Virtual Agents in Microsoft Teams Robotic Process Automation Introduction Power Automate Desktop Recording and editing tasks Running desktop flows Process advisor Testing and Go Live Solution Architect's role with testing and go live Planning for testing Planning for go live

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions

Are you looking forward to Project Management training, the most demanding skills, for the ongoing year and beyond? Then you are in the perfect place. Let's explore! A project management training course is an intensive training program that teaches managers how to effectively manage projects and people. Managers must understand the various elements of a project, as well as the different skills and qualities required to effectively lead projects. Most training programs are taught by project managers who have completed their own training courses and earned certifications. You will get 4 FREE CPD Accredited Course to make your career more magnificence! FREE Courses includes: Course 01: Agile Scrum Master Course 02: Team Management Course 03: Time Management Course 04: Office Skills Project Management course Basic Learning Outcomes: Upon successful completion of this highly appreciated Project Manager Course, you'll be a skilled professional, besides- Recognise what project management entails. Examine the advantages of learning project management techniques. Determine the life-cycle phases of a project. To divide a project into clearly manageable segments, use a simple lifecycle. List the different project planning instruments. Talk about the significance of finishing projects on schedule. You have the peace of mind that Project Manager course provides the top of the range content in the market. So, stand out in the job market by completing the course. Get CPD accredited certificate and add it to your resume to impress your employers. Key Highlights for Project Manager Course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced course modules Course Curriculum: Unit 01: Introduction Unit 02: Project Management Framework Unit 03: Integration Management Unit 04: Stakeholder Management Unit 05: Project Scope Management Unit 06: Schedule Management Unit 07: How Much/Many of the Project Unit 08: Where in the Project Unit 09: How Things are Done on a Project? Certification CPD Accredited (CPD QS) Certificate Digital (PDF) & Hardcopy certificates are available CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Project Manager course. Besides, this course is ideal for- Office Manager Office Administrator Management Leader Requirements To enrol in this Project Manager course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Project Manager, such as- Project Management Office Manager Project Management Lead Project Management Administrator Certificates CPD Accredited PDF Certificate Digital certificate - Included 4 CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Very clearly explained Good pace. Lucy Tailor - ACER ' 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. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. 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