3187 Courses

A step-by-step guide that walks you through the fundamentals of Python programming followed using Python libraries to create random forest from scratch. A comprehensive course designed for both beginners with some programming experience or even those who know nothing about ML and random forest!

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management 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 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Lightroom is not an intuitive software and for this reason this course will show how it differs from Photoshop and how it works. The Lightroom course covers all of the main features in to enable you to use the software fully. By the end of the course you will be able to navigate all of the functions and customise settings to suit your workflow.

Learn how to build and test APIs and web services, which form the foundation of most software engineer work with the help of this carefully structured beginner's level course. You will be learning all of this in Python, one of the world's most popular and widely used programming languages.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using Tableau to perform numerical or general data analysis, visualization, and reporting. They need to provide data visualizations from multiple data sources, or combine data to show comparisons, manipulate data through calculations, create interactive visualizations, or create visualizations that showcase insights from statistical analysis. This course is also designed for students who plan to obtain Tableau Desktop Certified Associate certification, which requires candidates to pass the Tableau Desktop Certified Associate exam. Overview Blend data multiple sources. Join data. Access data in PDFs. Refine visualizations with sets and parameters. Analyze data with calculations. Visualize data with advanced calculations. Perform statistical analysis and forecasting. Create geographic visualizations. Get answers with Ask and Explain The advent of cloud computing and storage has ushered in the era of "big data." With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data driven insights with peers, executives, and clients. Prerequisites Tableau Desktop: Part 1 Lesson 1: Blending Data from Multiple Sources Topic A: Blend Data Topic B: Refine Blends to Visualize Key Information Lesson 2: Joining Data Topic A: Create Joins Topic B: Troubleshoot Joins Topic C: Merge Data with Unions Lesson 3: Accessing Data in PDFs Topic A: Connect to PDFs Topic B: Clean Up and Organize PDF Data Lesson 4: Refining Visualizations with Sets and Parameters Topic A: Create Sets Topic B: Analyze Data with Sets Topic C: Apply Parameters to Refine Visualizations Topic D: Create Advanced Visualizations Lesson 5: Analyzing Data with Calculations Topic A: Create Calculated Fields to Analyze Data Topic B: Manipulate Data with Functions Topic C: Analyze Data with Table Calculations Lesson 6: Visualizing Data with Advanced Calculations Topic A: Create Groups and Bins with Calculations Topic B: Analyze Data with LOD Expressions Lesson 7: Performing Statistical Analysis and Forecasting Topic A: Perform Statistical Analysis Topic B: Forecast Data Trends Lesson 8: Creating Geographic Visualizations Topic A: Create Maps Topic B: Customize Mapped Data Lesson 9: Getting Answers with Ask and Explain Topic A: Ask Data Topic B: Explain Data Additional course details: Nexus Humans Tableau Desktop - Part 2 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 Tableau Desktop - Part 2 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.

Parsing or syntactic analysis is one of the first stages in designing and implementing a compiler. Implementing a full manual parser from scratch allows understanding and seeing this process from the inside, demystifying internal structures, and turning building parsers into an interesting engineering task.

About this Training Course This 5 full-day course will focus on geological fundamentals: how different basin types differ in subsidence mechanisms, basin cycles, heat flow through time, depositional systems, structural styles and their type of petroleum systems. This will allow participants to make realistic interpretations in new areas; interpretations that are consistent with the specific basin type and to be expected depositional systems and structural styles. In addition, through simple paper-based exercises, the course will provide background and understanding of how some of the typical PBE products are made: creaming curves, Field-size plots and Yet-to-find. Finally, the essentials of commercial assessments will be covered. Training Objectives To provide participants with a sound understanding how, and under which conditions different basin types develop, and what the impact of their development is on the typical petroleum systems of these different basin types. To teach evaluation techniques that assist in the regional understanding and illustration of sedimentary basins and their development. While some of these techniques can be done using computers, in the course these will be done 'by hand' for maximum understanding. Target Audience This course is designed in the first place for geoscientists working in exploration and their direct supervisors. The course is also very instructive for specialist staff working closely with exploration staff such as (bio)stratigraphers, geochemists, basin modelers, structural geologists, geophysicists, reservoir engineers and petrophysicists. Course Level Intermediate Training Methods Each topic is introduced by a lecture, and leaning is re-enforced by practical exercises (on paper). There is ample time for discussions of general issues and any specific questions participants may have. For several exercises participants will be invited to do exercises on a basin of their choice, which will make the course more impactful for the participants. Participants will be provided with the following pre-read material: Concepts of Conventional Petroleum Systems. De Jager, J. (2020). Invited contribution for Regional Geology and Tectonics Volume 1: Global Concepts, Techniques and Methodology (eds: Adam, J., Chiarelly, D. & Scarselli, N. Play-Based Exploration of the petroleum potential of the Tremp-Graus, Ainsa and eastern Jaca Sub-basins in the southern De Jager, J & van Winden, M. (2020). invited contribution for Digital Learning - Multi-scale analysis of depositional systems and their subsurface workflows (eds: Grötsch, J. & Pöppelreiter, M.), EAGE. Trainer Your expert course leader has a PhD in Geology from the University of Utrecht. He worked for 31 years (1979 -2010) with Shell as an exploration geologist in a variety of functions across the globe. As Principle Technical Expert, he was responsible for ensuring that Risk & Volume assessments were carried out consistently and correctly in all of Shell's exploration units. In this capacity, he led and participated in countless prospect review sessions and developed and conducted a successful in-house course on Risks & Volume assessment. As manager of the Exploration Excellence Team, he performed in depth analysis of basins and plays and provided advice on exploration opportunities to senior management. Together with his team, he visited most of Shell's exploration offices, working hands-on with Shell's local exploration teams to generate new play and prospect ideas and to suggest evaluation techniques and technologies to apply. In 2010, he was appointed as extraordinary professor Regional and Petroleum Geology at the VU university of Amsterdam and in 2012 also at the University of Utrecht. He was visiting professor at the University of Malaya (Malaysia). Through his own consultancy, as of 2010, he provides advice on exploration activities to several companies and is regularly invited to carry out technical reviews. Activities cover all continents and include Portfolio Reviews, Prospect assessment, Play-based Exploration, and Geothermal activities. He conducts courses on several topics including Risk & Volume Assessment, Prospect Maturation, Basin Analysis, Play-based Exploration, Trap & Seal Analysis, Petroleum Geology for Non-geologists. Some of his recent publications include: De Jager, J. & van Winden, M. (2020): Play-Based Exploration of the petroleum potential of the Tremp-Graus, Aínsa and eastern Jaca Sub-basins in the southern Pyrenees. Invited contribution for Digital Geology, EAGE special publication (eds: Grötsch, J. & Pöppelreiter, M.) De Jager, J. (2020). Concepts of Conventional Petroleum Systems. Invited contribution for Regional Geology and Tectonics Volume 1: Global Concepts, Techniques and Methodology (eds: Adam, J., Chiarelly, D. & Scarselli, N.) De Jager, J. (2021): Handbook Risk & Volume Assessment. Self-published De Jager, J., Van Ojik, K & Smit, R. (2023 - in preparation): Geological Development of The Netherlands. In: Geology of The Netherlands (eds: Ten Veen, J., Vis, G-J., De Jager, J. @ Wong, T.) POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 Excel Basics Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Formats 00:08:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Essential Formulas Basic Formula Operations 00:13:00 Mathematical Functions 00:19:00 Textual Functions 00:17:00 Logical Functions 00:11:00 Date-Time Functions 00:07:00 Lookup Functions ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools Data Tools 00:19:00 Formatting data and tables Formatting data and tables 00:18:00 Pivot Tables Pivot Tables 00:08:00 Excel Charts Excel Charts - Categories of messages that can be conveyed 00:04:00 Elements of charts 00:05:00 The Easy way of creating charts 00:03:00 Bar and column charts 00:12:00 Formating charts 00:15:00 Line Charts 00:09:00 Area Charts 00:06:00 Pie and Doughnut Charts 00:13:00 Why we should avoid Pie charts 00:04:00 Scatter plot or XY chart 00:16:00 Frequency Distribution and Histograms 00:13:00 Waterfall Charts 00:12:00 Sparklines 00:05:00 Pivot Charts Pivot Charts 00:07:00 Named Ranges Named Ranges 00:10:00 Indirect Function 00:05:00 Excel Shortcuts Shortcuts 00:12:00 Macros Macros 00:10:00 Advanced Excel Advanced Excel: Analytics in Excel 00:15:00 Final Assessment Assessment - Microsoft Excel For Beginners 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

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.

In this course, we will understand the absolute basic concepts of programming. Learn essential C# scripting for game development by building 20+ mini projects. We will also build 2D games with Unity and C#, and master C# by building these games with Unity.