In this course, learn the C# programming fundamentals that are the building blocks of .NET programming, and build a solid foundation on the basics of C# programming language and coding constructs. No prior C# or .NET coding experience is required.
Microsoft Excel Advanced Course Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course. Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions. Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out. What's Covered in the Course? Any staff member choosing to study this course can expect to gain the following skills: How to set A Password to an Excel document; VLOOKUP Advanced formula options and manipulations; Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND; Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE; Colouring a column and row with a formula; Highlighting a cell with a formula; Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK; Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM; How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation; Calculating loan IPMT and EMI; Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX; Full explanation of the INDEX and MATCH functions; Looking up data; Selecting only cells containing comments; Hiding formulae; Automatically inserting serial numbers; The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions. The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts. What are the Benefits of the Course? Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities; The Level 3 Excel course is designed for 'power' users, but not only for programmers and those interested in financial modelling; Competent Excel users add huge value to an organisation, through advanced data analysis.
Master MongoDB, an open-source document database and leading NoSQL database that provides high performance, high availability, and automatic scaling. This course covers the MongoDB Community version for beginners and provides over 50 live-running queries, including creating new databases and tables.
Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.
This course introduces you to the paradigm and features of object-oriented programming using Java, an object-oriented language popular in the industry and IntelliJ. The course entails modeling objects and classes, object-oriented facilities like inheritance and polymorphism, native data structures, exception handling, file management, and streams.
The purpose of this course is to teach you how to use Python for machine learning to create real-world algorithms. You will gain an in-depth understanding of the fundamentals of deep learning. This course will help you explore different frameworks in Python to solve real-world problems using the core concepts of deep learning and artificial intelligence.
Learn to program with JavaScript from scratch. This hands-on practice-oriented course starts from the beginner's level and gradually moves to the intermediate level with a detailed understanding of object-oriented programming. We will also cover JSON objects and learn all versions of JavaScript from ES5, ES6, ES7, ES8, and the latest ES9 version.
This course aims to provide learners with a comprehensive understanding of the nature and process of Information Systems Development, Software Development Process, Programming Language, Globalization and the role of IT, Information Systems Ethics, Acceptable Use Policies, Intellectual Property, Privacy in Information Systems and future trends. After the successful completion of the course, you will be able to learn about the following, Understand the nature and process of Information Systems Development, its lifecycle, and Implementation Methodologies. Learn about Software Development Processes, models and technologies. Understand the nature, generations and types of Programming Language. Appreciate the concept of Globalization and the role of IT in Globalization. Learn about Information Systems Ethics and the Code of Ethics. Appreciate Acceptable Use Policies and Intellectual Property in IT. The concept of Privacy in Information Systems, its challenges and future trends. This course will provide learners with an understanding of the nature and process of Information Systems Development and Implementation Methodologies. The course will cover the Software Development Process, including models and technologies, and the nature, generations, and types of Programming Language. Learners will also learn about the role of IT in Globalization and the impact of Information Systems on the global economy. This course will provide learners with an understanding of the nature and process of Information Systems Development and Implementation Methodologies. The course will cover the Software Development Process, including models and technologies, and the nature, generations, and types of Programming Language. Learners will also learn about the role of IT in Globalization and the impact of Information Systems on the global economy. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Recognizing Information Systems Development and Globalisation Self-paced pre-recorded learning content on this topic. Recognizing Information Systems Development and Globalization Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. IT Professionals Software Developers Programmers Business Owners & Entrepreneurs Managers and Executives Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.
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.
State machines-the fundamental concept used today in many practical applications, starting from UI programming such as React, automated reply systems, lexical analysis in parsers, and formal language theory. In this course, we will study the automata theory on the practical example of implementing a regular expressions machine.