2021 Courses

This Electrical Safety Management Training provides job-ready skills, expert insights, and a certification that helps you establish a safe and compliant working environment. Enrol now and take control of electrical safety in your workplace! 🚀

🐶✨ Ready to master the art of Dog Grooming? Whether you're a pet owner or an aspiring professional, our Dog Grooming Training Course will teach you essential grooming techniques, health and safety tips, and breed-specific styles—all at your own pace! 🛁✂️🐾

Follow your dreams by enrolling on the Microsoft Excel Masterclass course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel Masterclass will help you arm yourself with the qualities you need to work towards your dream job. Study the Microsoft Excel Masterclass training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Excel Masterclass course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Microsoft Excel Masterclass course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Excel Masterclass course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Microsoft Excel Masterclass course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Microsoft Excel Masterclass course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Excel Masterclass course. The Microsoft Excel Masterclass course is designed by industry experts and is tailored to help you learn new skills with ease.  The Microsoft Excel Masterclass is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Microsoft Excel Masterclass when it suits you. Access the Microsoft Excel Masterclass course modules from any internet-enabled device, including computers, tablets, and smartphones. The Microsoft Excel Masterclass course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Excel Masterclass now and start learning instantly! What You Get Out Of Studying Microsoft Excel Masterclass With Janets: Receive a digital Certificate upon successful completion of the Microsoft Excel Masterclass course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Microsoft Excel Masterclass training course is delivered through Janets' online learning platform. Access the Microsoft Excel Masterclass content from any internet-enabled device whenever or wherever you want to. The Microsoft Excel Masterclass course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Microsoft Excel Masterclass course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel Masterclass course. After successfully passing the Microsoft Excel Masterclass course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel Masterclass qualification. Certification All students who successfully complete the Microsoft Excel Masterclass course can instantly download their digital certificate. You can also purchase a hard copy of the Microsoft Excel Masterclass course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Microsoft Excel Masterclass is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Excel Masterclass course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Microsoft Excel Masterclass is open to all students and has no formal entry requirements. To study the Microsoft Excel Masterclass course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Microsoft Excel Masterclass is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Excel Masterclass and gain an industry-recognised qualification that will help you excel in finding your ideal job.

Description Do you want to master the world's best photo editing software? Or are you new to Adobe Photoshop CC? Then enrol the Adobe Photoshop CC Foundation course and begin your acquaintance with the course. The course is for the learners who have little or no knowledge about the photo editor. You will start your journey from the beginning. You will be familiar with the user interface and know how to open and create an image in Adobe Photoshop. The course introduces you to the essential tools, brushes and other features so that you can able to decide which tools to select while editing. Additionally, the course illustrates the concepts of colour schemes and guides you on how to use the colors efficiently. The procedures of adding text and text styles, working with Layers, adjusting Layers, customizing the workspace, moving and transforming Pixels, cropping images, etc. will be covered in the course. Finally, the course shows you how to print, convert and export files from Photoshop. Shortly, the course gives you a general understanding of the application so that you can proceed with the advanced skills. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? Photoshop CC Masterclass - Beginner to Advanced 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 Photoshop CC Masterclass - Beginner to Advanced 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. Adobe Photoshop CC Beginner Introduction Introduction FREE 00:03:00 Introduction to Photoshop Introduction to Photoshop 00:05:00 Understanding Types of Documents 00:04:00 Understanding Resolution 00:04:00 Creating New Documents 00:06:00 Using Artboards 00:05:00 Using CC Templates 00:03:00 Utilizing the Search Feature 00:02:00 Customizing the Workspace Using Workspace Presets 00:02:00 Moving, Closing, and Opening Panels 00:06:00 Understanding Document Views 00:06:00 Using the History Panel 00:06:00 Working with Layers Why Layers 00:02:00 Using Layers 00:07:00 Creating Fill Layers 00:05:00 Applying Blending Modes 00:04:00 Using Layer Styles 00:09:00 Discovering the Properties Panel 00:08:00 Understanding Selections Creating Basic Selections 00:09:00 Using the Lasso Tools 00:08:00 Understanding the Quick Select Tools 00:07:00 Editing the Quick Mask 00:04:00 Saving Selectionsv 00:04:00 Moving Selections to Layers.mp 00:03:00 Understanding and Using Color Understanding Color Modes 00:10:00 Creating Swatches 00:06:00 Using Masks and Advanced Layers Applying Layer Masks 00:00:00 Deleting Layer Masks 00:01:00 Organizing Layers 00:03:00 Merging Layers 00:02:00 Flattening Layers 00:02:00 Working with Layer Comps 00:06:00 Using Adjustment Layers Using Image Adjustments 00:07:00 Understanding Adjustment Layers 00:10:00 Using Layer Masks with Adjustment Layers 00:03:00 Cropping Images Using the Crop Tool 00:05:00 Using the Crop Tool to Add Canvas 00:02:00 Moving and Transforming Pixels Using Free Transform 00:04:00 Working with Other Transform Options 00:03:00 Flipping Pixels 00:01:00 Adding Text and Text Styles Using the Type Tool 00:10:00 Discovering Typesetting 00:08:00 Formatting Text 00:09:00 Creating Type on a Path 00:03:00 Warping Type 00:03:00 Using Styles on Type 00:08:00 Applying Special Effects Using Layer Styles 00:05:00 Working with Patterns 00:03:00 Applying Filters 00:04:00 Creating Pixels with Filters 00:06:00 Exporting from Photoshop Printing in Photoshop 00:03:00 Converting to CMYK 00:04:00 Converting to Other File Types 00:13:00 Using File Info 00:09:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Intermediate Start Here Introduction FREE 00:03:00 Painting and Using Brushes Painting with Brushes 00:09:00 Using the Brushes Panel 00:06:00 Defining Custom Brushes 00:04:00 Saving Tool Presets 00:02:00 Using the History Brush 00:03:00 Using Vector Tools Working with Vector Shapes 00:10:00 Creating Custom Shapes 00:02:00 Using the Pen Tool 00:07:00 Discovering Paths 00:04:00 Understanding Vector Masks 00:03:00 Using Vector Objects and Spot Colors 00:06:00 Using Libraries What is the CC Library 00:02:00 Adding and Deleting Assets in the Library 00:03:00 Sharing Assets 00:02:00 Creating New Libraries 00:03:00 Sharing a Library 00:02:00 Advanced Special Effects Using the Blur Filters 00:06:00 Applying the Distort Filters 00:03:00 Creating a Pixelated Look 00:02:00 Stylizing Effects 00:02:00 Using Liquify 00:05:00 Using Smart Filters 00:04:00 Working with Smart Objects 00:03:00 Loading a Texture into Type 00:04:00 Working with RAW Images What is a Raw Image 00:05:00 Processing Raw Images 00:12:00 Opening a JPEG File in Raw 00:06:00 Retouching Basics Developing a Strategy for Retouching 00:04:00 Using Retouching Tools 00:10:00 Using the Dust and Scratches Filter 00:04:00 Applying Sharpening 00:08:00 Working with Face Aware Liquify 00:06:00 Automating Tasks Using Actions 00:03:00 Creating Actions 00:07:00 Using Droplets 00:05:00 Using the Image Processor 00:05:00 Creating an HDR Image 00:07:00 Creating a Panoramic Image 00:07:00 Integration with other Adobe Software Using PSD Files in InDesign 00:04:00 Using PSD Files in Illustrator 00:03:00 Using PSD Files in Dreamweaver 00:04:00 Understanding Color Management Why Color Management 00:03:00 Calibrating a Monitor 00:04:00 Calibrating a Printer 00:03:00 Loading Profiles into PSDs 00:02:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Advanced Introduction Introduction FREE 00:03:00 Processing Raw Images What is the RAW Format 00:04:00 Understanding White Balance 00:05:00 Setting Exposure 00:07:00 Working with Color and Clarity 00:03:00 Working with Adobe Camera Raw Updating Adobe Camera Raw 00:01:00 Using the Before and After Views 00:05:00 Resetting the Sliders 00:01:00 Understanding the Workflow Options 00:04:00 Setting the Camera Raw Preferences 00:03:00 Working with the Tools Understanding the White Board Tool 00:03:00 Using the Color Sampler 00:01:00 Working with the Targeted Adjustment Tool 00:02:00 Cropping Images 00:03:00 Applying Straightening 00:01:00 Using the Spot Removal Tool 00:05:00 Applying the Red Eye Tool 00:03:00 Understanding the Adjustment Brush 00:04:00 Using the Graduated Filter 00:02:00 Applying the Radial Filter 00:02:00 Rotating Images 00:01:00 Using Advanced Exposure Settings and Sharpening Using Curves 00:03:00 Understanding Sharpening and Noise 00:03:00 Creating Grayscale Images 00:03:00 Using Split Toning 00:03:00 Managing Corrections and Effects Enabling Lens Profiles 00:03:00 Using Effects 00:02:00 Adding Grain 00:02:00 Applying Post Crop Vignette 00:02:00 Using Camera Calibration 00:03:00 Saving Presets 00:02:00 Applying Snapshots 00:02:00 Creating Image Adjustments Using Adjustment Layers 00:02:00 Painting Layer Masks 00:05:00 Discovering Plugins for Photoshop What are Plugins 00:04:00 Using the Nik Collection 00:08:00 Using HDR Pro Effex 00:06:00 Using On1 Effects 00:04:00 Exploring Workflows Introudcing the Workshop Videos 00:04:00 Processing a Landscape Image 00:13:00 Processing a Macro Image 00:09:00 Processing a City 00:11:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Do you want to create outstanding apps with SwiftUI? Moreover, are you eager to build up your professional portfolio and show up in your next job interview with confidence? This complete iOS application development course is designed to teach you how to become an advanced multiplatform app developer using Apple's native user interface framework: SwiftUI.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for intermediate business and requirements analysts who are looking to improve their business case development and presentation skills. This course is also a great fit for project managers and product owners who work closely with business analysts or who perform some form of business case work themselves. Overview Understand the role of the business analyst within the business case process Understand the main professional associations and standards that support business analysts in the industry Discuss the benefits of business case creation Explore how to define the business need Describe the role of the business analyst in supporting the enterprise to determine how to optimally invest in the right project initiatives Explain how to identify stakeholders and the significance to the pre-project activities Discuss the importance of analyzing the enterprise Describe and explore the activities performed to assess the current business environment Explain how a business analyst describes a ?future? state environment including how to identify gaps in enterprise capabilities Present and explore how to define the scope of a solution Describe the activities performed and techniques used to determine viable solution options Explore various techniques for evaluating solution options including feasibility and risk analysis Thoroughly understand the purpose of conducting a feasibility assessment Discuss and practice a number of business analysis techniques that support the business case process Explore the components of a business case Describe how the business case supports decision makers in making go/no-go decisions Demonstrate how to assemble the output from pre-project activities into a well-structured business case Present techniques for presenting business cases to top level managers and obtaining buy-in Discuss methods for preparing for challenges during business case delivery Students learn the steps to effective business case development and support your strategic business recommendations with sound budgeting and financial back-up. The one course you need to make high-impact recommendations and receive full management support for your ideas. Introduction Module Learning Objectives What is Business Analysis Polling Question International Institute of Business Analysis BABOK© Guide Components Project Management Institute Business Analysis for Practitioners: A Practice Guide BABOK© Guide Knowledge Areas Benefits of Business Analysis Polling Question A Business Analyst can Influence Project Success Factors Challenges of Business Analysis Polling Question Purpose of a Business Case Exercise 1a: What Should a Business Case Include Define the Business Case Elements What to Look Out For Who is Involved Exercise 1b: Review Business Case Outline Module Learning Objectives Pre-Project Activities & the Business Analyst Module Learning Objectives The Definition of a Business Analyst The Role of a Business Analyst Responsibilities of a BA BA Role vs. PM Role Business Analysis vs. Systems Analysis Business Analysis Competencies Polling Question Business Analyst Role and Stakeholders Exercise 2a: Review the Case Study What is a Stakeholder? The Importance of Stakeholders Stakeholder Identification Tips for Identifying Stakeholders Other Stakeholder Tips Stakeholder Identification/Analysis Exercise 2b: Identify Roles and Responsibilities Stakeholder Map Stakeholder Matrix & Onion Diagrams A Stakeholder Map Onion Diagram Exercise 2c: Why do we Need to Understand the Enterprise? Why Study the Enterprise? What is Enterprise Architecture? What is Strategy Analysis? About Strategy Analysis Purpose of Strategy Analysis When to Perform Strategy Analysis Strategic Planning Module Summary The Needs Assessment Process Module Learning Objectives Business Need Defined Define Business Need The Needs Assessment Process Problem or Opportunity Exercise 3a: Problem/Opportunity Identification Understanding Why Situation Statements Business Need and Current State Determine the Stakeholders Polling Question Goals and Objectives Polling Question Exercise 3b: Give 3 Examples of Business Goals Define Business Need Techniques Exercise 3c: Identify the Business Need Definition of Strategy Analysis When Business Strategy is not Driving Project Definition Typical Project Profile The Executive Paradox Solution to the Paradox Exercise 3d: Describe 3 Outcomes You Would Expect from the Case Study The Four ?Ares? Understand How to Create a Business Model Business Model Example Exercise 3e: Create a Business Model The Business Case Approach Financial and Strategic Measurement Tools Module Summary Determining the Required Capabilities & Defining Solution Scope Module Learning Objectives Business Need and Current State Purpose of Analyzing the Current State Analyzing Current Capabilities and Process Capabilities Defined Techniques for Analyzing the Current State Define the Future State Techniques for Defining the Future State Assess Capability Gaps Stakeholders Involved when Reviewing Capability Gaps Discussion: Assessing New Capabilities Defining Solution Scope Determining Scope Boundary How to Define Solution Scope Defining Solution Scope Project Scope and Product Scope Scope Modeling Techniques Used to Define Scope Define Scope Boundaries Modeling Scope: Context Diagram Exercise 4a: Create a Context Diagram from the Case Study Communicating Solution Scope to Stakeholders Stakeholders Participating in Scope Activities Exercise 4b: Discuss Managing Expectations Module Summary Assessing Feasibility & Proposing Solution Options Module Learning Objectives Financial Analysis Purpose of Financial Analysis Costs versus Benefits Financial Models Timing for Assessing Financial Benefits Risk Assessing Risks Risk Process Exercise 5a: Identifying Risks Risk Analysis Capturing and Categorizing Risks Risk Strategies Tolerance for Risk Determining Solution Options Solution Option Process Determining and Analyzing Solution Options Brainstorming Conducting an Outcomes Focused Brainstorming Session Stakeholders Involved in Determining Solution Options Exercise 5b: Determining Solution Options Feasibility Analysis Discussion: Ranking Solution Options Discussion: Recommending the Most Viable Option Exercise 5c: Assess the Most Viable Options Solution Approach Definition Exercise 5d: Review the Business Case Templates Module Summary Packaging & Presenting the Business Case Module Learning Objectives Circumventing a Business Case Documenting the Business Case Value of the Business Case Process Business Case Components Business Case Techniques Build a Convincing Business Case Discussion: Identifying Decision Criteria Exercise 6a: Supporting a Go/No Go Decision Packaging the Business Case Planning Business Case Delivery Discussion: Planning Stakeholder Buy-in Information and Communication Needs in the Business Case Process Presenting your Business Case Exercise 6b: Anticipating and Responding to Challenges Module Summary Course Wrap Up Course Summary Questions Additional Resources Thank You Additional course details: Nexus Humans BA03 - Writing Effective Business Cases 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 BA03 - Writing Effective Business Cases 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.

In this course, we will master the syntax and structure of RSpec then learn to utilize test-driven development principles to design and implement clean test specs and reduce dependencies in the test suite by mocking objects with class and instance doubles. We will also explore the wide collection of RSpec matches available to test the code.

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports 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? Level 3 Diploma in Microsoft Excel 2016 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 Level 3 Diploma in Microsoft Excel 2016 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. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course will help you get started with automation testing of web applications. You will cover the basic and advanced topics of Selenium and Python, along with unit tests, pytest, cross-browser testing, logging infrastructure, automation framework design, Jenkins, and a lot more.

Description: Corel WordPerfect 12 is a word processing application with a long history on multiple personal computer platforms. In the first section of the course, you will get basic knowledge on foundation training along with Workspace manager, customizing spelling and grammar. You will be able to create, edit, and save documents. Secondly, the intermediate level explains to you how to use the file dialogue box, toolbar, page set up, save and print files, etc. It will also teach you all the tools and techniques required to operate any work making it more valuable. Moving on to the advanced level, you will learn the stuff such as creating and modifying charts, making tables, working with rows and columns, sorting data, etc. Following that, you will learn about the basic introduction, applications and advantages of using email. Besides, you will get a clear idea of the anatomy, interface, shortcut keys, inbox, outbox, basic email etiquette, and so much more. Finally, application training section teaches you about email applications, opening and closing the WordPerfect email application. Corel WordPerfect Complete Training Course is created to help you stand out among other co-workers and to perform better at work. Learning Outcomes: Opening and closing the program; understanding the interface; using menus, quickmenus, toolbars and dialog boxes How to use the programs toolbar and property bar, showing or hiding toolbars, customizing and managing it Typing text basics, selecting text with mouse, keyboard and menu, general tips and tricks Working with text via cutting, copying, pasting, using drag and drop, understanding insert and typeover mode, and using undo and redo How to save files for the first and second times, opening and closing files and/or document Utilizing the help menu, help topics, Corel tutor, specialized help, contextual help amd 'What's This' option Navigation through your cursor, scroll bars, keyboard, and the toolbar Using the object browser, go to dialog box, find the dialog box, and find and replace words Managing fonts through font face, size, bold, underline, italics, colour, quickfonts button, highlighting, and text's case through the property bar More font options through the dialog box, and advanced font tasks like embedding fonts and more Managing text position using the alignment, justification, line and paragraph spacing, ruler, tabs, margins and more options Spelling and grammar checking, using prompt-as-you-go, Grammatik, thesaurus, and the dictionary Opening, using, creating a template and organising projects Using PerfectExpert, and creaing envelopes and labels from the menu option Inserting data, time, symbols, using QuickWords, QuickCorrect, and smart quotes Ways to insert, suppress, remove page numbers, force pages and further insert line numbers Inserting clipart and pictures, reshaping and resizing graphics, positioning through the QuickMenu, ordering and flipping pictures, and adding borders How to use page view, draft view, two page view and zoom Using the print preview option to make adjustments and printing through various settings and options Switching between various documents, arranging document windows, moving text between documents, saving text in a separate file, and inserting documents Emailing and faxing your documents, and publishing them as PDF Affects of HTML on your document, previewing file in your browser, and publishing to HTML Making WordPerfect look like MS Office, opening office documents, saving office files, and using outlook contacts in WordPerfect Utilizing the WordPerfect file dialog box and toolbar options Saving your files using file extensions, viewing file properties, backing up your documents, and saving different versions Using page setup through margins, layout options, page size and orientation Explore the various printing options in order to get printouts Creating, expanding and saving Master documents; also creating, editing and removing subdocuments Understanding reveal codes window and un-revealing codes Examining code - like modifying, deleting, hard vs. soft; working with specific codes - character, sentence and paragraphs, etc.; and finding and replacing codes Applying built-in style using the property bar, updating existing styles, and creating your own style using QuickStyles and dialog boxes Creating and using document styles; and managing styles through the adding, saving and settings options Inserting and creating different list styles, and managing these list styles Utilizing QuickFormat and other formatting tools like the Make-It-Fit command and more Creating headers and footers, using the property bar, placing, suppressing, and deleting headers and footers Formatting text into columns, commenting on documents and reviewing them as well How to create watermark or text boxes Moving, resizing, adding borders and fill, adding captions, and wrapping text in text boxes Understand the basics of custom graphics and how to edit them to meet your needs Creating hyperlink and speed link within your documents Working with bookmarks and quickmarks Create table of contents, setting it up, generating and re-generating it, and using the document map Discover how to use WordPerfect, Microsoft Word, WordPerfect Classic, and Legal mode Customize toolbars, property bars, menus, keyboards, display settings and application bar options Modify WordPerfect environment, file settings, setting summary and conversion options Keep your spelling and grammar on check, change language preferences, add words to dictionary, and customize word list Understand the table structure and use tables property bar, QuickCreate, table menu and perfect expert to manage tables Insert, delete, resize, join and split cells or columns and rows Format tables through cells rotation option, setting vertical alignment, adding borders and fill, using speedformat, and creating or deleting speedformat styles Carry out advanced table tasks by using QuickSum, creating formulas, changing numeric formula of a cell, converting table to tabbed text and vice versa Understand the structure of charts, insert charts, how interface differs when working with them, move, resize, and delete them Changing chart type, chart colours and fonts, legend box, and your perspective Sort out data using sort dialog, setting sort options, creating custom sort, and outputting sort results to a disk Importing and linking spreadsheets or databases, and inserting objects and other file types Merging mail, creating data file, entering your data, using meal merge toolbar in data file Finding records; navigating between records and fields; modifying field names; adding, deleting and editing records Create form documents, add merge fields and merge codes, performing the merge, and creating envelopes during the merge Get an overview of the XML interface, creating new documents, publishing to XML, and converting existing documents to XML Using macro toolbars and visual basic editor along with recording, playing, editing and deleting macros Downloading the OfficeReady browser, using it and templates from the browser How to searchfor files in WordPerfect, starting the WordPerfect when Windows starts, and the differences between Windows Clipboard vs. Corel Clipbook Email address structure, the benefits of email, email etiquette, understand spam and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Using the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Using the contact list, searching for messages, creating folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Flagging messages, marking messages as read or unread, opening and saving attachments, using reply & reply to all, and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Adding and removing attachments, changing priority, and copying text into a message Explore the differences between HTML and Plain text emails, set up default text fonts, add images, and spell checks Adding people to your contact list, how to create a distribution list, and adding and removing addresses from the distribution list Understanding the structure of email addresses, advantages of email, email etiquette, spams and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Utilizing the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Best ways to use the contact list, search for messages, create folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Discover more about message tools through flagging, marking messages as read or unread, opening and saving attachments, using reply and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Advanced message tools like adding and removing attachments, changing priority, copying text into a message Compare HTML vs. Plain text emails, set up default text fonts, add images, and check spellings Adding people to your contact list, how to create a distribution list, and changing the addresses from the distribution list 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? Corel WordPerfect Complete Training Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Corel WordPerfect Complete Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module - 1 OPENING COREL WORDPERFECT 12 00:30:00 MORE ABOUT TOOLBARS 00:30:00 CREATING AND SELECTING TEXT 00:30:00 WORKING WITH TEXT 00:30:00 WORKING WITH YOUR DOCUMENT 00:30:00 FINDING HELP 00:30:00 BASIC NAVIGATION 00:15:00 USING WORDPERFECT'S TOOLS TO NAVIGATE THROUGH YOUR DOCUMENT 00:30:00 USING FONTS ON THE PROPERTY BAR 00:30:00 USING THE FONTS DIALOG BOX 00:30:00 ADVANCED FONT TASKS 01:00:00 CHANGING TEXT'S POSITION 00:30:00 ADVANCED TEXT POSITIONING 00:30:00 LANGUAGE TOOLS 00:30:00 PROJECTS 01:00:00 OTHER PRE-FORMATTED DOCUMENTS 00:30:00 USING TIMESAVING TOOLS 01:00:00 USING PAGE NUMBERS 00:30:00 ADDING PICTURES 01:00:00 VIEWING YOUR DOCUMENT 00:30:00 USING PRINT PREVIEW 00:30:00 PRINTING YOUR DOCUMENT 00:30:00 WORKING WITH MULTIPLE DOCUMENTS 00:30:00 SENDING YOUR DOCUMENT ELSEWHERE 00:30:00 CREATING A WEB PAGE 00:15:00 WORDPERFECT AND MICROSOFT OFFICE 00:30:00 Module - 2 USING THE FILE DIALOG BOX 01:00:00 USING TOOLBARS 00:15:00 SAVING YOUR FILES 00:30:00 USING PAGE SETUP 00:30:00 PRINTING YOUR FILES 00:30:00 USING MASTER DOCUMENTS AND SUBDOCUMENTS 01:00:00 REVEALING CODES 00:30:00 EXAMINING CODE 00:30:00 SPECIFIC CODES 00:30:00 FINDING AND REPLACING CODES 00:30:00 APPLYING A BUILT-IN STYLE 00:30:00 CREATING A STYLE 00:30:00 USING DOCUMENT STYLES 00:30:00 MANAGING LIST STYLES 00:30:00 USING LIST STYLES 01:00:00 MANAGING LIST STYLES 00:30:00 USING QUICKFORMAT 01:00:00 OTHER FORMATTING TOOLS 01:00:00 CREATING HEADERS AND FOOTERS 00:30:00 FORMATTING TEXT INTO COLUMNS 01:00:00 COMMENTING ON A DOCUMENT 01:00:00 REVIEWING A DOCUMENT 01:00:00 CREATING A WATERMARK 00:30:00 CREATING TEXT BOXES 00:30:00 JAZZING UP TEXT BOXES 01:00:00 THE BASICS OF CUSTOM GRAPHICS 00:30:00 EDITING CUSTOM GRAPHICS 01:00:00 CREATING LINKS TO OUTSIDE YOUR DOCUMENT 00:30:00 WORKING WITH BOOKMARKS 00:30:00 WORKING WITH QUICKMARKS 00:30:00 CREATING A TABLE OF CONTENTS 01:00:00 Module - 3 Using the Workspace Manager 00:30:00 Customizing How You Interact With Word 00:15:00 Customizing How WordPerfect Interacts With Data 00:30:00 Customizing Spelling and Grammar 00:30:00 Creating a Basic Table 01:00:00 Working With Rows and Columns 00:30:00 Formatting a Table 00:30:00 Advanced Table Tasks 01:00:00 Creating Charts 00:30:00 Modifying Charts 00:30:00 Sorting Data 01:00:00 Using Data From Other Applications 00:30:00 Mail Merge Basics 00:30:00 Modifying Your Data 00:30:00 Finalizing the Merge 00:30:00 Creating an XML Document 01:00:00 Macros 01:00:00 Using the OfficeReady Browser 00:30:00 WordPerfect and Windows 01:00:00 Module - 4 All About E-mail 00:30:00 Getting Started 01:00:00 Components of the Mail Interface 00:30:00 Working with Messages 01:00:00 Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 01:00:00 Printing Messages 00:30:00 Creating Messages 01:00:00 Advanced Message Tools 01:00:00 Working With E-mail 01:00:00 Address Tools 01:00:00 Module - 5 All About E-mail 00:15:00 Getting Started 00:30:00 Components of the Mail Interface 00:30:00 Working with Messages 00:30:00 Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 00:30:00 Printing Messages 00:30:00 Creating Messages 00:30:00 Advanced Message Tools 00:30:00 Working With E-mail 00:30:00 Address Tools 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00