3736 Office Skills courses in Pontypool delivered Online

Take control of your personal finances with our Personal Finance With Excel course. Learn essential financial concepts and practical Excel skills to manage your money effectively. From setting smart goals to understanding investments and credit facilities, this hands-on class will empower you to make informed financial decisions using Excel.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft Office and want to incorporate digital note-taking and note collaboration by using OneNote for Windows 10. In addition to creating and modifying OneNote notebooks, this course will introduce you to inserting images and files into notebooks, managing notebooks, and sharing content. Overview In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks. You will: Navigate and customize the OneNote for Windows 10 environment. Add and format text, images, tables, and drawing objects in a notebook. Use tags, organize notebooks, and search notebook content. Send and share notebook content. Configure password protection and restore deleted notebook content. In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft© OneNote© for Windows© 10 provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Getting Started with OneNote Topic A: Navigate the OneNote for Windows 10 Environment Topic B: Customize the OneNote User Interface Adding and Formatting Notebook Content Topic A: Apply Formatting to Notebook Content Topic B: Insert Files Topic C: Insert Tables Topic D: Use Drawing Tools Organizing and Searching Notebooks Topic A: Use Tags Topic B: Organize and Search Notebooks Sending and Sharing OneNote Content Topic A: Share OneNote Content Topic B: Share OneNote Content Using OneDrive Managing Notebook Content Topic A: Configure Password Protection Topic B: Restore Notebook Content

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Teams Collaborate using Teams. Configure Teams. This course introduces several productivity apps including SharePoint, OneDrive and Teams that can be used in combination by teams for communication and collaboration. Outline for Teams About What is Microsoft Teams? Overview How to Access Microsoft Teams Etiquette for using teams Integration Capabilities SharePoint OneDrive Interface Storage ? OneDrive & SharePoint Permissions & Access Owner, Member & Guest Communication and Collaboration Team Conversations Private conversations Mentions Inviting people Search Settings and Customization Use the search tool to find specific messages, files or people Working with Files Create new files Upload files Attaching or sharing Files Edit and Collaborate on files Open files in SharePoint OneDrive for personal files Administration (Champions) Add members to a Team Access administrator settings Meetings and calls Initiate a meeting on demand Schedule a meeting and invite attendees Meetings and Outlook Introduction to SharePoint What is SharePoint Understanding your permissions Logging into SharePoint Working with SharePoint sites Working with SharePoint sites Navigate, browse and search in a site Follow a site Working with documents Navigate a library Open and edit a document Upload or create a document in a library Share a file Set alerts for files Use checkout and check-in Team collaboration Versioning Getting Started (OneDrive Outline) Sign in, access and navigate Working with files and folders Upload files Organize files and folders Rename. Copy and download files Delete and recover files Search Use OneDrive with Office Save an office file online to OneDrive Use OneDrive with desktop office Versioning Share files Co-authoring

Description: This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. 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? Microsoft Office 2013 Excel Advanced - Complete Video 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 Microsoft Office 2013 Excel Advanced - Complete Video 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. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for This course is designed for people who need to use Microsoft Teams to communicate, share files, and conduct online meetings with colleagues. No experience with Teams is required; however, a basic understanding of Office apps will be useful. Overview In this course, you will use Microsoft Teams to communicate and collaborate with your colleagues. You will: Send messages to colleagues using Teams. Call and meet with people in Teams. Lead a meeting. Configure your Teams environment. Share files and app content. Create and configure Teams. This course is designed to help you master Microsoft© Teams©, the key communications tool in the suite of Microsoft© 365© productivity apps. Microsoft Teams enables individuals and organizations to chat, share ideas, collaborate on files, and essentially, work together. You can use Teams to have a quick chat with a colleague, participate in a virtual meeting, make an online call, and share files and resources. The Microsoft Teams app is available in three versions: a desktop app, a web app, and a mobile app. Once you are familiar with the Teams desktop app, you can easily transfer that knowledge and work in the web and mobile apps to take advantage of connecting through Teams wherever your work takes you. Messaging Colleagues Using Teams Topic A: Navigate in Teams Topic B: Chat with Contacts Topic C: Post in Team Channels Calling and Meeting in Teams Topic A: Call People in Teams Topic B: Meet in Teams Leading Meetings in Teams Topic A: Conduct Presentations Topic B: Manage Meetings Configuring Your Teams Environment Topic A: Configure General Application Settings Topic B: Configure Notifications and Privacy Settings Topic C: Configure Call and Device Settings Sharing Files and App Content in Teams Topic A: Share Files Topic B: Add Apps and Connectors Creating and Configuring Teams Topic A: Create and Manage a Team Topic B: Create and Configure Channels Topic C: Add and Configure Channel Tabs

Duration 1 Days 6 CPD hours This course is intended for his course is designed to provide a preview of Red Hat Enterprise Linux 8 to experienced IT professionals, including: Linux system administrators, DevOps engineers, and Cloud administrators. Overview In this course, you will use the Microsoft 365 productivity apps to work collaboratively with others. You will: Identify the Microsoft 365 apps. Create a team and conduct online meetings with Microsoft Teams. Create a plan and manage team activities with Planner. Use Forms to create a form and collect responses. Post, organize, and view videos in Stream. Use Sway to create digital stories and content. Automate your workflow by connecting apps with Power Automate. This course builds on your foundational knowledge of the Microsoft© 365 core apps and takes a deeper look at some of the productivity apps beyond Microsoft Word, Excel©, and PowerPoint©. Knowing that productivity often begins with assembling the right people, this course starts with the Teams© app that is used to collaborate on shared files and conduct online meetings. The connection between Planner and Teams is established to keep the group's work on schedule. The Forms app is introduced as a tool for collecting information that can be used to help determine your next course of action. The apps designed to handle media assets are introduced: Stream to manage video resources and Sway© to create digital stories. Finally, the power of automating your work processes is introduced in Power Automate, with students using the built-in templates as a starting point. For those interested in the Power BI© and Power Apps© features, a brief overview of these apps is included in an appendix. Overview of the Office 365 Apps Navigate in Office 365 Identify How the Office 365 Apps Work Together Collaborating with Microsoft Teams Navigate the Teams Interface Create a Team Meet in Microsoft Teams Managing Activities with Planner Navigate the Planner Interface Create a Plan Gathering Information with Forms Create a Form Share Forms and Collect Responses Managing Video Resources with Stream Navigate the Stream Interface Post and Organize Videos in Stream Using Sway to Create Digital Stories Navigate the Sway Interface Create a Sway Automating Your Work with Flow Navigate the Flow Interface Create and Share a Flow

Managing Successful Machine Learning Projects Machine learning projects are a different beast. You have to secure access to the required data, often from multiple siloed sources. You have to switch back and forth between research mode and execution mode. You have to delicately guide data exploration towards a well-defined machine learning objective. You have to align this machine learning objective with your business objectives. You have to ensure that any sensitive data is adequately protected. How do you tame this beast and lead your project to successful completion? In this presentation, Dr. Neeraj Kashyap will share some practical tips for succeeding at machine learning, gained from his years at Google and in healthcare. We will discuss the life cycles of healthy machine learning projects and unhealthy ones so that you can identify impending disasters and avert them before they get out of hand. Throughout the session, we will emphasize data privacy, because no amount of intelligence is worth compromising your users for.

Become an accomplished Microsoft Excel professional with this engaging, innovative online distance learning course. Through exercises that put knowledge gained from video and handout lessons into practice, you will master higher Excel functions such as performing statistical analyses, creating and editing macros, and utilising advanced formulas, as well as broader business administration and IT skills. 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. Who is this course for? Level 3 Diploma in Microsoft Excel 2016 is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

Learn Microsoft Excel to create and format spreadsheets, analyse and share information to make knowledgeable resolutions. This Microsoft Office 2016 Excel Beginners is intended to teach you creating high-level workbooks and worksheets. Upon completion, you will have the ability to explain massive amounts of data and present that information to increase your understanding of the organisational account. 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.

Description: Call center agent is a person that represents the company through handling incoming and outgoing calls. Depending on the business they are in, it is possible for them to handle account inquiries, customer complaints or support issues. As call center agents are considered as representatives of a company, they must be trained to make sure they are representing the company well. Learn the necessary skills through this advanced call center course we are providing and become a professional call center agent. Who is the course for? Call center agents or customer service representatives who need to acquire skills for their profession. People who are interested in call center customer service training. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Call Center Training course is a useful qualification to possess, and would be beneficial for the following careers: Administration Assistant Call Center Agents Customer Service Representative Online Assistant Telephone Assistant. Call Centre and Customer Service Basics Module One - Getting Started 00:15:00 Module Two - The Basics (I) 00:30:00 Module Three - The Basics (II) 00:30:00 Module Four - Phone Etiquette 01:00:00 Module Five - Tools 01:00:00 Module Six - Speaking Like a Star 00:30:00 Module Seven - Types of Questions 01:00:00 Module Eight - Bench marking 00:30:00 Module Nine - Goal Setting 00:30:00 Module Ten - Key Steps 01:00:00 Module Eleven - Closing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Call Centre & Customer Service Training Course- Activities 00:00:00 Telephone Etiquette Module One - Getting Started 00:30:00 Module Two - Aspects of Phone Etiquette 01:00:00 Module Three - Using Proper Phone Language 01:00:00 Module Four - Eliminate Phone Distractions 01:00:00 Module Five - Inbound Calls 01:00:00 Module Six - Outbound Calls 01:00:00 Module Seven - Handling Rude or Angry Callers 01:00:00 Module Eight - Handling Interoffice Calls 01:00:00 Module Nine - Handling Voicemail Messages 01:00:00 Module Ten - Methods of Training Employees 01:00:00 Module Eleven - Correcting Poor Telephone Etiquette 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Advanced Call Centre Skills Training 00:30:00 Final Exam Final Exam- Advanced Call Centre Skills Training 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00