• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5826 Computing courses in Kilwinning delivered Online

WNAW41 SAP Web Intelligence Delta 4.1

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for Experienced Web Intelligence report creators and analysts upgrading from a previous version of SAP BusinessObjects Web Intelligence to SAP BusinessObjects Web Intelligence 4.1. In this course, participants will gain an understanding of the Deltas between Web Intelligence 3.1 and 4.1. Content Preview Data Ribbon Options Context Menus Drag-and-Drop functionality Application Modes -Data Mode -Reading Mode -Design Mode Freeze Columns New options in the formula editor Grouping Data New Predefined Cells Element Linking New Charting Engine Direct Connectivity to SAP BW BEx Queries

WNAW41 SAP Web Intelligence Delta 4.1
Delivered OnlineFlexible Dates
Price on Enquiry

Introduction to Test Automation Essentials (TT3511)

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for The content is appropriate for test automation engineering roles, test manager roles, test lead roles, test architect roles, as well as developer roles. This course assumes you have a foundational understanding of testing and the purpose of automation. This course will be beneficial to anyone who is accountable for assessing, planning, designing, and implementing an integrated set of technology (testing infrastructure) that supports development, testing, and deployment. Overview Working in an interactive learning environment, led by our expert facilitator, attendees will learn to: Document the current state of test automation in your organization Define a custom test automation plan and architecture to fit their situation Create an initial implementation plan Identify initial key measures Develop a metrics dashboard for tracking the value of test automation Lay out a future strategy and roadmap to get there Introduction to Test Automation is a one-day, hands-on event designed to provide participants with the skills required to develop a custom test automation plan and architecture for their organization. Throughout the course, students will examine and work through various practical examples, learning how to create an integrated test automation plan and develop a test automation architecture. Participants will also learn about the possible real-world challenges they may face while trying to accomplish their goals, exploring the practical positive aspects of engaging their technical team, along with the possible frustrations of experiencing too much isolation between test automators and test designers. Getting Started Automation beginnings Software as a series of imperfect translations The Compelling Business Needs for Automation Automation the next opportunity Islands of Automation Getting products to market more quickly, at the right costs and quality Automation Challenges and Requirements Automation Challenges Test Automation Key Requirements Foundational material for your automation plan Templates Questions Examples Virtual Consulting included with this course Automation plan vision and strategy Vision, Strategy, Approach Example Defining your end in mind Deciding where to start Engaging Others Conducting a current state tools inventory Assessing your current state - tools and processes Tools inventory example and template Radar Chart as a means of presenting current state information Consider the best automation approach Waterfall vs. agile cycles of work Aligning tools with your methodologies Strategies for Automating The Test Automation Pyramid Developing your test automation architecture Blocks of automation capabilities Islands of Automation Integrated Tools Architecture Template Integrated Tools Architecture Examples Test automation architecture examples Examples of different test automation architectures and frameworks Selenium Key Test Automation Architecture Characteristics Acceptance test-driven and behavior-driven testing overview Test automation approaches FitNesse Cucumber Gherkin script overview Tool workflow Considerations for what to automate and when Categories of tests that might be automated We have many tool choices Key points in Test Tool Architecture Planning Piloting and Implementing automation Selecting and evaluating tools and rolling them out Selling Automation - qualitative questions Selling Automation - quantitative questions Measuring automation benefits Measures in technical terms Measures in business terms Measures of testing vs. measures of test automation Next Steps A few keys to success

Introduction to Test Automation Essentials (TT3511)
Delivered OnlineFlexible Dates
Price on Enquiry

S4F20 SAP Business Processes in Management Accounting

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Application Consultant Business Analyst Business Process Owner / Team Lead / Power User Help Desk / COE Support Program / Project Manager Overview This course will prepare you to: Describe the motivation for SAP S/4HANA Enterprise Management Provide an overview of basic business processes in the main components of Financial Accounting with SAP S/4HANA Participants of this course will gain an overview of the Financial Accounting capabilities of SAP S/4HANA. You will learn how SAP S/4HANA covers the Financial Accounting related business requirements and how the fundamental business processes and tasks are executed in the system. General Ledger Accounting, Accounts Payable, Accounts Receivable, Asset Accounting and Bank Accounting and their integration are all discussed in this course. Especially if you are new to Financial Accounting in SAP S/4HANA, this course is the right starting point for you. If you plan to take the academy and certification for Financial Accounting, this course will help you to better understand the certification courses. For the actual certification, it is recommended, but not mandatory. Overview of SAP S/4HANA Providing an Overview of the SAP S/4HANA Using the SAP Fiori Front-En Overview of Financial Accounting (FI) in SAP S/4HANA Outlining Financial Accounting (FI) Components in SAP S/4HANA General Ledger (G/L) Accounting Outlining Organizational Elements in Financial Accounting (FI) Maintaining G/L Master Records Posting Transactions in the G/L Accounts Payable Maintaining Vendor Master Records Maintaining Accounts Payable Transactions Managing the Integration between Accounts Payable and Materials Management Performing Accounts Payable Closing Operations Accounts Receivable Maintaining Customer Master Records Managing Accounts Receivable Transactions Managing Customer Correspondence Creating Accounts Receivable Dispute Cases Managing the Integration between Accounts Receivable and Sales Order Management Performing Accounts Receivable Closing Operations Asset Accounting Maintaining Asset Master Records Executing Asset Transactions Executing Asset Accounting Period-End Closing Activitie Bank Accounting Maintaining Bank Accounting Master Records Managing Bank Accounting Transactions Closing Operations in General Ledger Accounting Performing General Ledger (G/L) Closing Operations Additional course details: Nexus Humans S4F20 SAP Business Processes in Management Accounting 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 S4F20 SAP Business Processes in Management Accounting 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.

S4F20 SAP Business Processes in Management Accounting
Delivered OnlineFlexible Dates
Price on Enquiry

BA29 - User Acceptance Testing for Business Analysts

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is designed for the Business Analyst professional who is involved with testing the functionality of technology projects. Overview Develop an understanding about basic concepts associated with User Acceptance TestingSee how UAT applies to the Software Development Lifecycle (SDLC)Recognize benefits of improved quality of deployed software using User Acceptance TestingIdentify the key roles, activities and deliverables which make up User Acceptance Testing Use a Business Use Case to define scenarios for testingCreate a UAT test plan and write UAT test cases with associated test dataUnderstand the process for testing functional and non-functional requirementsIdentify the challenges of testing vendor-supplied applications This course looks at the issues which drive the need for a UAT process & describes the components of the process. It is designed to help Business Analysts to develop an understanding of their role, the process, and the deliverables associated with UAT. Day 1 Software Testing - the Basics Understanding the Tester?s Terminology The UAT Planning Process Day 2 UAT Test Coverage Creating & Executing the UAT Test Cases Verifying the Test Results Testing Vendor-Supplied Applications Additional course details: Nexus Humans BA29 - User Acceptance Testing for Business Analysts 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 BA29 - User Acceptance Testing for Business Analysts 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.

BA29 - User Acceptance Testing for Business Analysts
Delivered OnlineFlexible Dates
Price on Enquiry

BC401 SAP ABAP Objects

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Developers, Developer Consultants, Help Desk/COE Support, and Program/Project Managers. Overview Understand the concepts of object-oriented programmingDevelop business applications with ABAP Objects In this course, students will gain an understanding of the concepts of object-oriented programming and develop business applications with ABAP Objects. Introduction to Object-Oriented Programming Explaining the Object-Oriented Programming Model Analyzing and Designing with Unified Modeling Language (UML) Fundamental Object-Oriented Syntax Creating Local Classes Creating Objects Accessing Methods and Attributes Implementing Constructors in Local Classes Implementing Class Constructors in Local Classes Inheritance and Casting Implementing Inheritance Implementing Upcasts Using Inheritance Implementing Polymorphism Using Inheritance Implementing Downcasts Using Inheritance Interfaces and Casting Defining and Implementing Local Interfaces Implementing Polymorphism Using Interfaces Integrating Class Models Using Interfaces Object-Oriented Events Implementing Events in Local Classes Implementing Events in Local Interfaces Object-Oriented Repository Objects Creating Global Classes Defining and Implementing Global Interfaces Implementing Inheritance in Global Classes ABAP Object-Oriented Examples Using the ABAP List Viewer (ALV) Describing Business Add-Ins (BAdIs) Global Classes in ABAP Development Tools Developing Eclipse-Based ABAP Programs Class-Based Exceptions Explaining Class-Based Exceptions Defining and Raising Exceptions Implementing Advanced Exception Handling Techniques Unit Testing Unit Testing with ABAP Unit Object-Oriented Design Patterns Implementing Advanced Object-Oriented Techniques Implementing the Singleton Pattern Implementing Factory Classes Using Friendship Implementing Persistent Objects Runtime Type Services Using Runtime Type Identification (RTTI) Creation of a Comprehensive Object-Oriented Application Developing a Comprehensive Object-Oriented Application Additional course details: Nexus Humans BC401 SAP ABAP Objects 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 BC401 SAP ABAP Objects 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.

BC401 SAP ABAP Objects
Delivered OnlineFlexible Dates
Price on Enquiry

Cisco Optical Technology Intermediate v3.0 (OPT200)

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This course is intended for: System engineers Technical support personnel Channel partners and resellers Overview After taking this course, you should be able to: Describe Cisco DWDM platform basics Describe DWDM network topologies Describe the management software used for managing Cisco DWDM networks List the different hardware components of the Cisco ONS and Cisco NCS DWDM systems Provision nodes and circuits in a Cisco DWDM network Perform node and multishelf configurations Implement SMR-based rings Provision optical circuit protection mechanisms Configure Any Rate cards Describe the function of Raman amplifiers Perform basic maintenance and troubleshooting of a Cisco DWDM network The Cisco Optical Technology Intermediate (OPT200) v3.0 course is designed to teach you the skills necessary to deploy the Cisco© Optical Networking System (ONS), 15454 Multiservice Transport Platform (MSTP), and Cisco Network Convergence System (NCS) 2000 Series Dense Wavelength-Division Multiplexing (DWDM) networks from installation to protection. Through a combination of lecture and hands-on experience, you will learn installation, configuration, circuit protection, maintenance, and basic troubleshooting using the Cisco Transport Controller for the Cisco ONS 15454 M6 and M12 shelves, and for the Cisco NCS 2016 shelf.Additionally, in this course you will review DWDM terminology and components, explore available chassis and cards, and discuss hardware installation. You will learn to use the Cisco Transport Controller server software to connect to the nodes, perform network turn-up and circuit creation, and deploy linear and single-module ROADM (SMR) DWDM multishelf topologies. Using this software, you will also configure Raman amplifiers and Any Rate cards, and configure protected and unprotected circuits. The course covers a variety of card options: controllers, transponders, multiplexer-demultiplexer, add/drop, Raman amplifiers, and Cisco Any Rate muxponder cards. You will use the various cards to configure terminal, amplifier, mesh, split, Optical Service Channel (OSC) regenerator, and Reconfigurable Optical Add/Drop Multiplexing (ROADM) nodes. Finally, you will learn how to use many of the tools and features available with the Cisco Transport Controller to perform maintenance, testing, and basic troubleshooting of your optical network. Course Outline DWDM Optical Platform Foundation Chassis and Cards Hardware Installation Node Turn-Up and Circuit Creation Node and Multishelf Configurations SMR-Based Rings 10Gb Circuit Protection Any Rate Card Configuration Raman Amplifiers Maintenance and Basic Troubleshooting Additional course details: Nexus Humans Cisco Optical Technology Intermediate v3.0 (OPT200) 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 Cisco Optical Technology Intermediate v3.0 (OPT200) 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.

Cisco Optical Technology Intermediate v3.0 (OPT200)
Delivered OnlineFlexible Dates
Price on Enquiry

Cisco Protecting Against Malware Threats with Cisco AMP for Endpoints v6.0 (SSFAMP)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Security administrators Security consultants Network administrators Systems engineers Technical support personnel Cisco integrators, resellers, and partners Overview Identify the key components and methodologies of Cisco Advanced Malware Protection (AMP) Recognize the key features and concepts of the AMP for Endpoints product Navigate the AMP for Endpoints console interface and perform first-use setup tasks Identify and use the primary analysis features of AMP for Endpoints Use the AMP for Endpoints tools to analyze a compromised host Analyze files and events by using the AMP for Endpoints console and be able to produce threat reports Configure and customize AMP for Endpoints to perform malware detection· Create and configure a policy for AMP-protected endpoints Plan, deploy, and troubleshoot an AMP for Endpoints installation Use Cisco Orbital to pull query data from installed AMP for Endpoints connectors Describe the AMP Representational State Transfer (REST) API and the fundamentals of its use Describe all the features of the Accounts menu for both public and private cloud installations This course shows you how to deploy and use Cisco AMP for Endpoints, a next-generation endpoint security solution that prevents, detects, and responds to advanced threats. Through expert instruction and hands-on lab exercises, you will learn how to implement and use this powerful solution through a number of step-by-step attack scenarios. You?ll learn how to build and manage a Cisco AMP for Endpoints deployment, create policies for endpoint groups, and deploy connectors. You will also analyze malware detections using the tools available in the AMP for Endpoints console, Cisco Threat Grid, and the Cisco Orbital Advanced Search Tool. Course Outline Introducing Cisco AMP Technologies Introducing AMP for Endpoints Overview and Architecture Navigating the Console Interface Using Cisco AMP for Endpoints Identifying Attacks Analyzing Malware Managing Outbreak Control Creating Endpoint Policies Working with AMP for Endpoint Groups Using Orbital for Endpoint Visibility Introducing AMP REST API Navigating Accounts

Cisco Protecting Against Malware Threats with Cisco AMP for Endpoints v6.0 (SSFAMP)
Delivered OnlineFlexible Dates
Price on Enquiry

Certified Scrum Product Owner: Virtual In-House Training

By IIL Europe Ltd

Certified ScrumMaster®: Virtual In-House Training This course is an introduction to Scrum and the principles and tools required to be an effective Scrum Product Owner. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of the Scrum framework to different situations. Participants successfully completing this course earn a Certified Scrum Product Owner® (CSPO®) designation. The Scrum Alliance certification includes a one-year membership with Scrum Alliance. What You Will Learn You'll learn how to: Use the principles, practices, and tools required to be an effective Scrum Product Owner Make effective decisions regarding the application of the Scrum framework to different situations, including: Setting product vision and goals Chartering the project Writing user stories and structuring your product backlog Scaling the Product Owner Estimating for forward planning Applying prioritization techniques Planning and tracking release progress Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Process control models Incremental and iterative development Shifting the focus on product management Overview of the Scrum process Agile principles Lean principles Scrum Roles and Responsibilities Scrum roles Cross-functional teams Product Owner Responsibilities The Scrum Project Community What happens to my traditional role in Scrum? Chartering the Project Establishing a shared vision Elevator Statement Data sheets Product Vision Box Magazine Review / Press Release Product Backlog and User Stories Product uncertainty and progressive refinement User role modeling User Stories Product backlog characteristics Getting backlog items ready Slicing User Stories Using the product backlog to manage expectations Sprints Done and Scaling Done The Scrum process in detail Sustainable pace The Product Owner's role in each of the Scrum meetings Scaling the Product Owner Scaling Scrum Approaches to scaling the Product Owner Estimation for Forward Planning Why comparative estimation works Planning Poker Affinity Estimation Prioritization Techniques Additional Product Backlog Prioritization Techniques Kano Analysis Theme Screening Release Planning and Tracking Progress Velocity Release Planning Tracking release progress

Certified Scrum Product Owner: Virtual In-House Training
Delivered OnlineFlexible Dates
Price on Enquiry

Fundamental Concepts of Java

4.3(43)

By John Academy

Course Overview Learn Java programming from the Fundamental Concepts of Java course and be able to create object-oriented programs using your skill. This course will help you to create interactive object-oriented programS for your desktop, phone or website. In this Fundamental Concepts of Java course, you will learn about the modern Java programming tools, Java 9 and 11, inheritance, abstraction, interference, different Java features and many other functions that will help you to program using Java language. You will be able to understand how Java programming works for websites, desktops and Android mobiles. You will also be able to understand why the functions work instead of only understanding how to use them. This course will help you to understand how to create Java programming from scratch. This is an ideal course for anyone who wants to learn Java programming understand the use of it and start their career as a programmer. Learning Outcomes Learn the fundamentals of the Java programming language Understand object-oriented programming Know about exception handling enums and type wrapper Be able to understand the concept of inserting animation into programming Learn how Java works and convert code to the understandable computer language Who is this course for? This course is ideal for anyone who wants to learn the Java programming language and build their career as a programmer. This course will help you understand the function of Java programming from scratch. 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. Certification After you have successfully completed the course, 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 hardcopy 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 Fundamental Concepts of Java is a useful qualification to possess and would be beneficial for any related profession or industry such as: Programmer Web Developer Android App Developer Web Designer Data Security Officer Fundamental Concepts of Java Module 01: Hello World _ IDE 00:07:00 Module 02: What is Java? 00:13:00 Module 03: Working With Variables 00:12:00 Module 04: Variable Types 00:14:00 Module 05: Non-Numeric Data Types 00:10:00 Module 06: Strings 00:16:00 Module 07: Arithmetic Operators 00:14:00 Module 08: Relational Operators 00:10:00 Module 09: Logical Operators 00:10:00 Module 10: Assignment Operators 00:10:00 Module 11: Solving Problems with Google 00:09:00 Module 12: If in Java 00:11:00 Module 13: Else If Else 00:16:00 Module 14: Switch 00:12:00 Module 15: While Loop 00:14:00 Module 16: For Loop 00:13:00 Module 17: Arrays 00:14:00 Module 18: Sorting Array 00:15:00 Module 19: Methods 00:15:00 Module 20: Recursion 00:07:00 Module 21: OOP #1 - Classes _Object 00:12:00 Module 22: OOP #2 - Constructors 00:08:00 Module 23: OOP #3 - Inheritance 00:14:00 Module 24: OOP #4 - Modifier Types 00:17:00 Module 25: OOP #5 - Encapsulation 00:12:00 Module 26: OOP #6 - Abstraction 00:16:00 Module 27: OOP #7 - Polymorphism 00:09:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Fundamental Concepts of Java
Delivered Online On Demand5 hours 30 minutes
£18

Need to Know Advanced Excel Formulas and Functions

4.3(43)

By John Academy

Course Overview Take your Excel skills to the next level with the help of the Need to Know Advanced Excel Formulas and Functions course. In this course, the expert instructor will show you how to optimize the use of excel. You will learn a handful of useful functions and formulas that will increase your proficiency in excel. The Need to Know Advanced Excel Formulas and Functions course aims to increase your competence in excel. The course will teach you the fundamental math functions. You will understand the concept of relative reference and absolute reference. The course will educate you on Autosum. You will receive lectures on how to link sheets and workbooks. The course will enrich your understanding of vlookup and hlookup functions. You will become skilled in training functions. From this course, you will achieve the essential training to upgrade your MS excel skills in no time. This Need to Know Advanced Excel Formulas, and Functions course will help you build excellent expertise in excel. Enroll in the course to boost your abilities and your employability in the relevant job market. Learning Outcomes Understand how to build basic math formulas Enrich your understanding of Autosum and relative references Learn how to link sheets and workbooks Gain the skills for tracking functions Deepen your knowledge of Vlookup and Hlookup functions Build your skills to work with text functions Who is this course for? Those who want to upgrade their excel skills 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. Certification After you have successfully completed the course, 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 hardcopy 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 Need to Know Advanced Excel Formulas and Functions course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Administrative Officer Need to Know Advanced Excel Formulas and Functions Building basic math formulas 00:08:00 Autosum and Relative references 00:09:00 Absolute references 00:06:00 Named Ranges 00:06:00 Linking sheets and workbooks 00:06:00 If, And, Or, and the nested If functions 00:16:00 Countif, Sumif, Averageif, Sumifs, and Countifs functions 00:09:00 Vlookup and Hlookup functions 00:15:00 Match and Index functions 00:07:00 Date and time formulas and functions 00:12:00 Text functions 00:11:00 Tracing formulas 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Need to Know Advanced Excel Formulas and Functions
Delivered Online On Demand1 hour 53 minutes
£18