3402 Courses

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.

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.

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

Fundamentals of Teaching Grammar and Sentence Structure (30 Hours)

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.

Dive into the intricate world of numbers and data with our comprehensive 'Microsoft Excel & Accounting Training' course. Begin your journey by mastering the foundational elements of Microsoft Office Excel 2016, from the basics of worksheet modifications to the art of data visualisation using charts. As you progress, pivot your attention towards the meticulous realm of accounting. Here, you'll unravel the secrets of the accounting equation, immerse yourself in transaction analyses, and culminate your learning by understanding the complete accounting cycle. Whether you're looking to enhance your data management skills or embark on a career in accounting, this course is your stepping stone to success. Learning Outcomes: Acquire proficiency in utilising Microsoft Excel 2016 for data analysis, visualisation, and workbook management. Understand the core principles of accounting, including the accounting equation and transaction analysis. Demonstrate the ability to prepare financial statements and complete the accounting cycle. Implement advanced Excel features such as PivotTables, PivotCharts, and Lookup Functions. Apply knowledge in real-world scenarios, including fiscal year evaluations and spreadsheet exercises. Why buy this Microsoft Excel & Accounting Training? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Microsoft Excel & Accounting Training Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Microsoft Excel & Accounting Training course for? Individuals aiming to bolster their data analysis and management capabilities. Aspiring accountants keen on understanding the fundamentals of the profession. Business owners desiring a deeper grasp of financial statements and accounting cycles. Students pursuing a career in finance or data management. Professionals looking to integrate Excel functionalities into their daily tasks. Career path Data Analyst: Average salary range: £25,000 - £40,000 Annually Accountant: Average salary range: £28,000 - £52,000 Annually Financial Controller: Average salary range: £40,000 - £70,000 Annually Management Accountant: Average salary range: £30,000 - £55,000 Annually Excel Specialist: Average salary range: £22,000 - £35,000 Annually Bookkeeper: Average salary range: £18,000 - £30,000 Annually Prerequisites This Microsoft Excel & Accounting Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel & Accounting Training 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. 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. Course Curriculum **Microsoft Excel** Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interfact 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:07: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 Create and Modify Tables 00:16:00 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 **Accounting Training** Professional Bookkeeper Introduction Professional Bookkeeper 00:09:00 Introduction to Accounting and Business Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 Analyzing Transactions The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Journal Entries 00:38:00 Entering Information - Posting Entries Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Horizontal Trend : Balance Sheet 00:21:00 Horizontal Trend: Income Statement 00:36:00 Adjusting Process The Purpose of the Adjusting Process 00:15:00 Adjusting Entries Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet Preparing a Worksheet 00:06:00 Financial Statements The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Completing the Accounting Cycle Temporary vs. Permanent Account 00:19:00 The Accounting Cycle Illustrated Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year Fiscal Year 00:09:00 Spreadsheet Exercise Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00

Description: Microsoft Excel 2016 and VBA continues Velsoft's in-depth training material for Excel 2016. This course covers the duration of five lessons, by taking it you will get the skills you need to harness Visual Basic for Applications, or VBA, to automate many tasks you will encounter while using Excel 2016. This course will help you to get all the knowledge you need to gain about Microsoft Excel 2016 and VBA. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: 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 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? Microsoft Excel 2016 and VBA 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 Microsoft Excel 2016 and VBA 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. Developing Macros 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 Formatting Worksheets Using Macros 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 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets 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 Performing Calculations 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 Mock Exam Mock Exam- Microsoft Excel 2016 and VBA 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 and VBA 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The NASM Certified Nutrition Coach (CNC) is your education solution for guiding clients toward optimal nutrition choices for health- and wellness-related outcomes. The course arms you with evidence-backed nutrition science that has been peer-reviewed by multiple experts in the industry. It also teaches you how to use behavior change and coaching strategies with your clients to develop long-lasting weight loss and healthful nutrition habits.

Course Overview Discover how to enhance and develop your existing skills with Microsoft's primary information handling tool with this Access 2019 Intermediate course. Access 2019 remains one of the most accessible and effective ways to integrate data and link with other Office programmes. However, you may not be using its functions enough to get the full benefit from this dependable platform. Make sure that you are proficient and comfortable with some of Access's more progressive functions and abilities by taking this intuitive and helpful training. This Microsoft Access 2019 tutorial provides further tips and hints for those who want to extend and improve their abilities with their use of it and work towards becoming an expert. It has been written to help those with basic awareness of data management reach the next level of understanding and create more complex tables, reports, and results with its help. This valuable training is guaranteed to increase your awareness of the functions available in Access 2019 and make you the go-to person to facilitate its best use in all fields. This best selling Access 2019 Intermediate has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Access 2019 Intermediate is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Access 2019 Intermediate is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Access 2019 Intermediate is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Access 2019 Intermediate, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Access 2019 Intermediate will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Access 2019 Intermediate to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Make your critical data easier to follow with dashboards displaying the main insights when you train to use Data Analytics with Google Data Studio. Sometimes analysts find that their collated information on Google Sheets is not viewed subjectively by clients or that they take unexpected conclusions from it. You can learn to eliminate this possibility by utilising the functions of Google Data Studio (GDS), the premier online tool for converting data into customisable informative reports and dashboards for easy perusal. This Data Analytics training provides a total learning curve for GDS and how to get the very best results from it. You will be taught the basic functions of Google Sheets, including queries and calculations. Following this, you will be given a masterclass on GDS itself, from its field calculation abilities to its layout design and accommodating a client's page requirements. With this expert tuition, you will be able to effortlessly format data and underline all of the key findings with a simple click or touch of the screen. Make your data speak volumes with this valuable course. This best selling Data Analytics with Google Data Studio has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Data Analytics with Google Data Studio is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Data Analytics with Google Data Studio is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Data Analytics with Google Data Studio is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Data Analytics with Google Data Studio, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Data Analytics with Google Data Studio will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Data Analytics with Google Data Studio to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.