40595 Courses delivered Online

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Learn and master Excel 2019 by learning advanced functions and formulas

Description: The Internet and Computing - Key Applications Training explains what basic applications are. In the course, you will learn the different application options. Throughout the course, you will learn the usage of work processing and spreadsheets. The course will also focus the advanced skills such as the procedures for creating an excellent presentation, how to use database and collaboration. All type of applications has options like comments, screen consistency, formatting options such as making text bold, italicised, underlined etc., navigating system, and presentation features, etc. Basically, the course is conducted at five different levels: Word Processing where you will learn how to process and edit a text using options like indent, edit, page break, bulleted, deleting, etc. Spreadsheet application where you will know the use of spreadsheets and basic options such as navigation, saving a new workbook, editing formula and applying the formula, making different types of the chart like a pie chart, bar chart, graphs, etc. Presentation section teaches you the procedures for creating a stunning presentation using chart, images, and table. In the database part, you will be introduced to management procedures and the ways of working with queries and reports. Collaboration helps to know the sharing systems. In short, the purpose of the course is to provide you with an overall idea and key features of the application. 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? Internet and Computing - Key Applications Training 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 Internet and Computing - Key Applications Training 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. Application Features Application Features FREE 01:21:00 Working with Word Processing Working with Word Processing 00:44:00 Working with Spreadsheets Working with Spreadsheets 00:49:00 Making a Presentation Making a Presentation 01:08:00 Databases Databases 00:34:00 Collaboration Collaboration 00:18:00 Mock Exam Final Exam- Internet and Computing - Key Applications Training 00:20:00 Final Exam Mock Exam- Internet and Computing - Key Applications Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course will take you through the basics as well as advanced concepts in TestNG and automation framework building. The course focuses on important concepts such as TestNG, Java, Maven, Selenium WebDriver, page object model, and page factory design. You need to know the basics of core Java and Selenium to get started.

Overview This comprehensive course on CompTIA Network+ Certification will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CompTIA Network+ Certification comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this CompTIA Network+ Certification. It is available to all students, of all academic backgrounds. Requirements Our CompTIA Network+ Certification 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 43 lectures • 16:18:00 total length •Networking Fundamentals: 00:45:00 •Network Models and Topologies: 00:23:00 •Network Components and Services: 00:04:00 •Becoming a Network Professional: 00:14:00 •Introducing Networking Standards: 00:08:00 •Open Interconnection Systems Reference Model: 00:12:00 •IEEE Network Standards: 00:19:00 •Fundamentals of Network Transmission: 00:19:00 •Copper Media: 00:16:00 •Optical Media: 00:08:00 •Specialty Cables and Connectors: 00:03:00 •LAN Infrastructure Wiring: 00:06:00 •Wireless Networking: 00:50:00 •Understanding TCP IP: 00:39:00 •Working with IPv4 Addresses: 01:26:00 •Working With IPv6 Addresses: 00:26:00 •Assigning Addresses with DHCP: 00:14:00 •Resolving Names Using DNS: 00:19:00 •Introduction to Network Devices: 00:08:00 •Physical Layer Devices: 00:10:00 •Data Link Layer Devices: 00:38:00 •Network Layer Devices: 00:42:00 •Additional Network Devices: 00:06:00 •WAN Fundamentals: 00:07:00 •Wired WAN Connections: 00:20:00 •Wireless WAN Connections: 00:08:00 •Fiber WAN Connections: 00:13:00 •Introduction to Remote Networking: 00:22:00 •Authenticating Remote Connections: 00:16:00 •Understanding Virtual Private Networks: 00:26:00 •Network Security Fundamentals: 00:34:00 •Planning for Network Security: 00:44:00 •Identifying Threats and Vulnerabilities: 00:39:00 •Protecting the Network: 00:50:00 •Maintaining Business Continuity: 00:24:00 •Virtualization and Cloud Computing: 01:00:00 •Unified Communications: 00:07:00 •Network Safety Fundamentals: 00:10:00 •Network Operations: 00:04:00 •Maintaining and Monitoring Networks: 00:27:00 •Troubleshooting Methodology: 00:17:00 •Troubleshooting Tools: 00:19:00 •Troubleshooting Network Issues: 00:16:00

Thinking about a career in Business Analysis? The BCS Practitioner Certificate in Business Analysis has been designed to provide valuable learning for those in roles such as business analyst, business architect, business systems analyst, data analyst, enterprise analyst, management consultant, process analyst, product manager, product owner, project manager, and systems analyst.

Acrobat DC, the updated version of Acrobat software that allows you to make an instant edit of scanned documents, create PDF, edit image or text, convert document file to word, and many more features at an instant. To learn the vivid use of these aforesaid features, take a look at our well-segmented Adobe Acrobat DC Pro Foundation course. The course teaches you how to navigate interface, bars, use tools, menus, and changes preferences. Following that, it teaches you how to work with PDF marking the texts, adding comments, and highlighting the contexts. Furthermore, it teaches you how to reduce the size, convert PDF to RTF, EXCEL, and Word files. In the end, it also enhances your skill to protect your file by adding a signature, creating security, and understanding accessibility. Who is this course for? Ubuntu Linux for Beginners is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Ubuntu Linux for Beginners is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Ubuntu Linux for Beginners THE COMPANY BEHIND UBUNTU 00:15:00 DOMAIN NAME SYSTEM ON UBUNTU 00:15:00 DDNS Changes 00:30:00 UFW ON UBUNTU 00:30:00 UFW FEATURES 00:15:00 MAIL SERVER ON UBUNTU Part 1 00:30:00 MAIL SERVER ON UBUNTU Part 2 00:15:00 KERBEROS AND FEDERATION SERVICES ON UBUNTU 00:30:00 WORKING WITH WEB SERVERS ON UBUNTU 00:15:00 WORKING WITH DATABASE SERVERS ON UBUNTU 00:15:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This Level 3 Technical Certificate in Occupational Health and Safety (Accredited by Ofqual, UK and IOSH) has been designed to help learners gain a better understanding of health and safety practises in the workplace. This Level 3 Technical Certificate in Occupational Health and Safety course teaches you how to manage workplace issues and covers the topics you'd encounter in a health and safety role. The objectives of this Level 3 Technical Certificate in Occupational Health and Safety qualification are to enable learners to: Understand the different roles and responsibilities for health and safety in the working environment Be aware of safety and welfare rules in the working environment Understand the elements of a health and social policy Understand the benefits of safety management systems in organisations Be able to review health and safety procedures across an organisation Be able to communicate effectively when contributing to the maintenance of a healthy and safe work environment Understand the importance of working with others to maintain a healthy and safe workplace. Understand the principles of risk assessment Understand about risks and control methods for workplace hazards Know how to manage the effects of accidents and incidents Be able to monitor risks and incident management The Level 3 Technical Certificate in Occupational Health and Safety qualification is appropriate for those seeking employment in health and safety positions across a range of sectors and will equip candidates with the practical knowledge and skills that organisations and employers require.Individuals successfully completing this Level 3 Technical Certificate in Occupational Health and Safety qualification will be eligible to apply for Associate (AIOSH) / Technical (Tech IOSH) membership. Key Highlights of this Level 3 Technical Certificate in Occupational Health and Safety qualification are: Program Duration: 9 Months (Fast Track 6 months duration course also available) Program Credits: 34 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Requirements Level 3 Technical Certificate in Occupational Health and Safety Level 3 Technical Certificate in Occupational Health and Safety qualifications can be offered to learners from age 16. Although there are no formal entry requirements for this qualification, it is critical that learners are able to comprehend and articulate the concepts contained in the syllabus in the language in which the course will be delivered and assessed. Career path Progress to Year 1 of a 3 Year UK Undergraduate Degree qualification after completion of your Course. Completion of your Level 3 Technical Certificate in Occupational Health and Safety qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry. Certificates Certificate of Achievement Digital certificate - Included Othm courses: Once you complete the course, you would be receiving a digital copy of your Diploma along with its Transcript which can be downloaded from the awarding body website without any additional charge. You can also order Hard copy certificate by paying a nominal cost directly to the awarding body.

Learn the basic principles of good programme management using the MSP® approach and prepare for the Foundation and Practitioner examinations on this accredited programme. Duration: 5 days (32.5 hours) Our MSP® Foundation and Practitioner course is designed to teach the basic principles of good programme management in line with the Principles, Themes and Processes described in the MSP® approach. It also prepares delegates for the Foundation and Practitioner examinations. This course is designed for anyone who needs to understand programme management and the practical application of MSP® and to gain the MSP® Foundation and Practitioner qualifications. Delegates should have an understanding of and preferably experience in the issues surrounding business change The MSP® Foundation and Practitioner Course is based upon the “Managing Successful Programmes – 5th Edition” which describes “best practice” guidance for handling all types of transformational change programmes. These are intensive modules and require delegates to undertake some evening work in their own time. Objectives  By the end of the course you will be able to: Describe the differences between programmes and projects Describe the Principles, Themes and Processes as described in the MSP® - 5th Edition Practice the application of MSP® Prepare for both the MSP® Foundation and Practitioner Exam Please note that examinations are the responsibility of the examination board, PEOPLECERT and must be organised separately by each person attending. Content Introduction Introduction – what is, and why use, Programme Management The Three Lenses of the MSP® FrameworkMSP PrinciplesMSP ThemesMSP Processes The Themes Overview – introduction to the seven Themes Organization – roles, accountabilities, responsibilities Design – Vision, Benefits, Risk, Target Operating Model Justification – Business case and financial planning Structure – Delivery approaches, Planning and control Knowledge – Knowledge and Information management Assurance – Assurance at multiple levels approach and planning Decisions – Decision-making, Issue and Risk resolution approaches, Data-gathering and options analysis The Processes Overview – the seven processes Identify the Programme – initial justification Design the Outcomes - establishing solid foundations Plan Progressive Delivery – build on the programme design Deliver the Capabilities– oversee programme delivery Embed the Outcomes – adopting new ways of working and realize the benefits Evaluate new information – collecting, evaluating, analysing and presenting new information Close the Programme – final assessment and release resources Practitioner Workshop and Examination MSP® Practitioner Examination Objectives and Guidance MSP® Review MSP® Practitioner Examination Workshops MSP® Practitioner Examination MSP® Foundation and Practitioner Examinations The MSP® Foundation Exam is of 1 hour duration and consists of 60 multiple choice questions. A Pass is 36 correct answers, 60%.   The MSP® Practitioner Exam is a written paper of 2.5 hours duration. There are 70 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. The candidate must score 42/70, 60%, to be successful. Presented in association with aims4change, a PEOPLECERT Accredited Training Organisation. MPS® is a Registered Trade Mark of AXELOS Limited.