3817 Link courses

This is a 4-day course where students will be exploring sci-fi stories. 🚀 👽 The children will be analysing engaging sci-fi stories and discussing characters, settings and plots. 👽 Students will also create their own imaginative sci-fi settings, and design their own alien! It will be a fantastic opportunity for children to build their confidence and skills in writing, all while having fun! Please note: this course is for 4 days and will take place on the following days: Saturday 21st December at 10am UK / 2pm UAE/ 6pm HK Monday 23rd December at 12pm UK / 4pm UAE/ 8pm HK Tuesday 24th December at 11am UK / 3pm UAE/ 7pm HK Friday 27th December at 10am UK / 2pm UAE/6pm HK If you cannot attend a lesson for any reason, Mollie will record it and send you a link to watch the session via the Zoom cloud. 

This is a full day intensive workshop which will teach you the processes involved in photo etching, including preparing the metal for etching, transferring the designs onto the metal using press and peel (P&P) paper and how to use specific etching solutions to cut the designs into the metal. This course will allow you to broaden your design process so that you can add some intricate textures to your copper and silver jewellery designs. You will be provided with a set amount of materials including copper sheet to practice the process and a 4cm by 4cm piece of silver sheet to create a silver textured pendant during your session. WHEN: Sunday 13th October 10-5pm WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Krista Thomson WHAT DOES THE DAY INVOLVE? This is a full day intensive workshop which will teach you the processes involved in photo etching, including preparing the metal for etching, transferring the designs onto the metal using press and peel (P&P) paper and how to use specific etching solutions to cut the designs into the metal. This course will allow you to broaden your design process so that you can add some intricate textures to your copper and silver jewellery designs. You will be provided with a set amount of materials including copper sheet to practice the process and a 4cm by 4cm piece of silver sheet to create a silver textured pendant during your session. If you would like to create additional designs, you are welcome to bring along your own additional flat silver sheet, it must be no thinner than 0.6mm. This is a great opportunity to stock pile some great patterned silver for us with future projects. On the day you will be provided with some patterns to etch, if you have a set pattern in mind, please send us the artwork in good time for your class. Designs must be black and white only and please note smaller patterns work better than larger ones. Please email it to us at hello@workshop925.com. Alternatively instruction on where to purchase P&P paper and how to print your own designs onto it will be sent out prior to your course date to those of you who wish to etch your own designs. You will be etching the majority of the day, however if you would like to create a finished design, we can accommodate this, you can do some etching in the morning and create a design in the afternoon. EXPERIENCE REQUIRED: None, all abilities are welcomed. This course is a great introduction to etching for those who have a vast experience in jewellery making but have not yet tried this technique as well as beginners looking to create beautiful textural pieces of jewellery. Our small classes mean we are able to provide each student with the support they require. CLASS SIZE: 6 WHAT IS INCLUDED? All tools and consumables are supplied Please bring refreshments as we are no longer able to provide them The cost of this course includes copper sheet to practice the technique and a 4cm by 4cm section of silver sheet. The price also includes a selection of patterns printed on P&P paper to use during your course.  WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Please bring any PPE, snacks and drinks to each session. We regret we can’t offer tea and coffee at the moment due to Coronavirus. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.

This is a full day intensive workshop which will teach you the processes involved in photo etching, including preparing the metal for etching, transferring the designs onto the metal using press and peel (P&P) paper and how to use specific etching solutions to cut the designs into the metal. This course will allow you to broaden your design process so that you can add some intricate textures to your copper and silver jewellery designs. You will be provided with a set amount of materials including copper sheet to practice the process and a 4cm by 4cm piece of silver sheet to create a silver textured pendant during your session. WHEN: Sunday 3rd November 10-5pm WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Krista Thomson WHAT DOES THE DAY INVOLVE? This is a full day intensive workshop which will teach you the processes involved in photo etching, including preparing the metal for etching, transferring the designs onto the metal using press and peel (P&P) paper and how to use specific etching solutions to cut the designs into the metal. This course will allow you to broaden your design process so that you can add some intricate textures to your copper and silver jewellery designs. You will be provided with a set amount of materials including copper sheet to practice the process and a 4cm by 4cm piece of silver sheet to create a silver textured pendant during your session. If you would like to create additional designs, you are welcome to bring along your own additional flat silver sheet, it must be no thinner than 0.6mm. This is a great opportunity to stock pile some great patterned silver for us with future projects. On the day you will be provided with some patterns to etch, if you have a set pattern in mind, please send us the artwork in good time for your class. Designs must be black and white only and please note smaller patterns work better than larger ones. Please email it to us at hello@workshop925.com. Alternatively instruction on where to purchase P&P paper and how to print your own designs onto it will be sent out prior to your course date to those of you who wish to etch your own designs. You will be etching the majority of the day, however if you would like to create a finished design, we can accommodate this, you can do some etching in the morning and create a design in the afternoon. EXPERIENCE REQUIRED: None, all abilities are welcomed. This course is a great introduction to etching for those who have a vast experience in jewellery making but have not yet tried this technique as well as beginners looking to create beautiful textural pieces of jewellery. Our small classes mean we are able to provide each student with the support they require. CLASS SIZE: 6 WHAT IS INCLUDED? All tools and consumables are supplied Please bring refreshments as we are no longer able to provide them The cost of this course includes copper sheet to practice the technique and a 4cm by 4cm section of silver sheet. The price also includes a selection of patterns printed on P&P paper to use during your course.  WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Please bring any PPE, snacks and drinks to each session. We regret we can’t offer tea and coffee at the moment due to Coronavirus. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.

In this unique course with tutor Sarah Reece you will learn how to cut two shapes of stones: The first will be a free form shape with a flat edges as shown in the images. The second the focus will be how to create a traditional cabochon. This stone will be have a flat base with a rounded top. This will be cut from rough stone which you can each select from Sarahs beautiful collection. You can decide the shape and size and which part of the stone you wish to use. The class size is limited to just 1 student. So you do not breathe in harmful rock dust during the process, you will be cutting the stone while it is in water. With this in mind, please wear older clothes, and waterproof shoes – wellies are advised as it is not a clean or dry activity. Water sprays from the rotating wheels as you are working. We will provide you with a waterproof apron. This course is an excellent introduction to stone cutting. It allows you to step into the world of Lapidary where you can cut and create any shaped stone you desire, you won’t be beholden to the shop bought stone. This means your projects and settings can become completely unique as per your designs. You will be working with a Cab King 6″ and the Diamond Pacific Pixie Cabbing Machine. We have factored in a 30 minute break for lunch during our Saturday sessions. Full info below… When: Sarah is available at weekends and during the week. If you decide to book a stone cutting course, there is flexibility for your booking. We will contact you to find a suitable session. Length: The session will last 4 hours Where:  THIS WORKSHOP COURSE IS BASED IN FARNHAM NOT OUR WOKING WORKSHOP Weydon Farm House Weydon Farm Lane GU9 8QJ There is parking on site. Tutor: Sarah Reece What does the session involve? In this unique course with tutor Sarah Reece you will learn how to cut two shapes of stones: The first will be a free form shape with flat edges (as shown in the images). The second the focus will be how to create a traditional cabochon. This stone will have a flat base with a rounded top. This will be cut from rough stone which you can select from Sarah’s beautiful collection. You can decide the shape and size and which part of the stone you wish to use. You will be cutting the stone while it is in water so you do not inhale harmful dusts. With this in mind, please wear older clothes, and waterproof shoes – wellies are advised as it is not a clean or dry activity. Water sprays from the rotating wheels as you are working. We will provide you with a waterproof apron. This course is an excellent introduction to stone cutting. It allows you to step into the world of Lapidary where you can cut and create any shaped stone you desire, you won’t be beholden to the shop bought stone. This means your projects and settings can become completely unique as per your designs. You will be working with a Cab King 6″ and the Diamond Pacific Pixie Cabbing Machine. The class size is limited to just 1 student. This Instagram post gives you a preview of what to expect from your session Experience required: None, all abilities are welcomed. We support you throughout the session and provide demonstrations to show you the techniques and steps needed to create your project. With one to one sessions, you will gain a large amount of support in this intensive introduction to stone cutting Class size: 1 What is included? All tools and consumables are supplied The stones you will carve are NOT INCLUDED in the price of the course – This is something you can choose on the day so you can select something you would like to work with. Sarah has priced up different varies in generous sizes ranging from £3-£20. If you would rather not buy stone to work with, no problem, Sarah has plenty of beautiful flint that you can use instead. What to bring: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within the workshop. Wellies or older waterproof shoes advised. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. There are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Also pack your own snacks and drinks for the session if required.

Duration 2 Days 12 CPD hours This course is intended for Anyone who works with IBM SPSS Statistics and wants to learn advanced statistical procedures to be able to better answer research questions. Overview Introduction to advanced statistical analysis Group variables: Factor Analysis and Principal Components Analysis Group similar cases: Cluster Analysis Predict categorical targets with Nearest Neighbor Analysis Predict categorical targets with Discriminant Analysis Predict categorical targets with Logistic Regression Predict categorical targets with Decision Trees Introduction to Survival Analysis Introduction to Generalized Linear Models Introduction to Linear Mixed Models This course provides an application-oriented introduction to advanced statistical methods available in IBM SPSS Statistics. Students will review a variety of advanced statistical techniques and discuss situations in which each technique would be used, the assumptions made by each method, how to set up the analysis, and how to interpret the results. This includes a broad range of techniques for predicting variables, as well as methods to cluster variables and cases. Introduction to advanced statistical analysis Taxonomy of models Overview of supervised models Overview of models to create natural groupings Group variables: Factor Analysis and Principal Components Analysis Factor Analysis basics Principal Components basics Assumptions of Factor Analysis Key issues in Factor Analysis Improve the interpretability Use Factor and component scores Group similar cases: Cluster Analysis Cluster Analysis basics Key issues in Cluster Analysis K-Means Cluster Analysis Assumptions of K-Means Cluster Analysis TwoStep Cluster Analysis Assumptions of TwoStep Cluster Analysis Predict categorical targets with Nearest Neighbor Analysis Nearest Neighbor Analysis basics Key issues in Nearest Neighbor Analysis Assess model fit Predict categorical targets with Discriminant Analysis Discriminant Analysis basics The Discriminant Analysis model Core concepts of Discriminant Analysis Classification of cases Assumptions of Discriminant Analysis Validate the solution Predict categorical targets with Logistic Regression Binary Logistic Regression basics The Binary Logistic Regression model Multinomial Logistic Regression basics Assumptions of Logistic Regression procedures Testing hypotheses Predict categorical targets with Decision Trees Decision Trees basics Validate the solution Explore CHAID Explore CRT Comparing Decision Trees methods Introduction to Survival Analysis Survival Analysis basics Kaplan-Meier Analysis Assumptions of Kaplan-Meier Analysis Cox Regression Assumptions of Cox Regression Introduction to Generalized Linear Models Generalized Linear Models basics Available distributions Available link functions Introduction to Linear Mixed Models Linear Mixed Models basics Hierachical Linear Models Modeling strategy Assumptions of Linear Mixed Models Additional course details: Nexus Humans 0G09A IBM Advanced Statistical Analysis Using IBM SPSS Statistics (v25) 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 0G09A IBM Advanced Statistical Analysis Using IBM SPSS Statistics (v25) 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.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Learn How To Create a Web App for iPad Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Learn How To Create a Web App for iPad Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Learn How To Create a Web App for iPad Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Learn How To Create a Web App for iPad Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Learn How To Create a Web App for iPad? Unlimited access to the course for forever 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 Certification After studying the course materials of the Learn How To Create a Web App for iPad there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn How To Create a Web App for iPad course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Learn How To Create a Web App for iPad does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn How To Create a Web App for iPad 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Learn How To Create a Web App for iPad is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction About the Course 00:01:00 A Few Words before we Begin 00:02:00 Software You'll Need to Follow along 00:02:00 About the Project Files 00:02:00 Starting Your Project 00:01:00 Section 02: Creating the Graphics Creating the Web App-Specific Graphics for iPad 00:06:00 Creating the Content Graphics 00:05:00 Creating the Gallery Images 00:01:00 Section 03: Setting Up the HTML Examining the HTML and CSS Strategy for the Layout 00:03:00 Setting Up the Meta Tags and Icon Link 00:07:00 Setting Up the HTML Containers 00:04:00 Adding Container for iScroll and Google Map 00:03:00 Add Navigation Links and Copyright 00:03:00 Section 04: Add Style & Layout for Homepage and Navigation Add CSS Rules for Style and Layout 00:14:00 Add Homepage Positioning and Animation for Elements 00:06:00 Style the Navigation Links and Copyright 00:04:00 Section 05: Adding the Java Script and (jQuery) Detecting the Orientation of the iPad 00:10:00 Loading Page Contents with AJAX 00:15:00 Detecting the Home Page 00:04:00 Detecting the Contact us Page 00:06:00 Setting and Loading a Default Page on Load 00:05:00 Initializing Google Maps 00:04:00 Activating iScroll 00:05:00 Section 06: Adding Content for the Gallery and Video Pages Adding HTML for the Gallery 00:05:00 Adding CSS Rules for the Gallery 00:05:00 Activating the Gallery Thumbnails 00:10:00 Adding a Graphic and Video 00:05:00 Detecting and Replacing Graphics for Retina Displays 00:05:00 Section 07: Detecting iPads and Stand Alone Status Detecting an iPad 00:07:00 Detecting the Stand-alone Status 00:04:00 Replacing Click Events and Disabling Selections 00:05:00 Section 08: Where to Go from Here Where to Go from Here 00:02:00 Considering Web Apps for Android 00:01:00 Assignment Assignment - Learn How To Create a Web App for iPad 00:00:00

Thinking about learning more understanding the role of data within an organisation? As data becomes an important currency in the world and an enabler for the future, it is imperative that all organisations have a firm understanding of the data available to them and the power it can hold. The BCS Foundation Award in Understanding Data in your Organisation teaches the the terminology, principles, concepts and approaches used within data management, and the overall value of data to an organisation.

Overview This comprehensive course on 3D Humanoid Characters in Unity will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 3D Humanoid Characters in Unity comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this 3D Humanoid Characters in Unity. It is available to all students, of all academic backgrounds. Requirements Our 3D Humanoid Characters in Unity is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 74 lectures • 06:21:00 total length •Welcome: 00:01:00 •Using Autodesk's Character Generator: 00:09:00 •Creating characters with Adobe Fuse: 00:08:00 •Auto-rigging with Adobe Mixamo: 00:03:00 •Applying animation to rigged characters in Mixamo: 00:03:00 •Importing an Autodesk character into Adobe Mixamo: 00:02:00 •Selecting and animating a fantasy character within Mixamo: 00:04:00 •Exploring commercial rigged and animated characters: 00:03:00 •Using Unity Hub to install the Unity Editor: 00:06:00 •Configuring Unity's user interface: 00:04:00 •Importing and setting up an architectural model: 00:07:00 •Importing selected standard assets: 00:05:00 •Rendering lightmap data for static objects: 00:05:00 •Configuring packages: 00:03:00 •Creating Cinemachine virtual cameras: 00:08:00 •Importing a character into Unity: 00:06:00 •Combining texture maps in Photoshop: 00:09:00 •Shaders and render modes for eyes and eyelashes: 00:05:00 •Configuring hair material and texture maps: 00:05:00 •Combining textures with alpha channel using Gimp: 00:05:00 •Exploring an avatar's bones and muscles: 00:05:00 •Referencing a controller in the animator component: 00:07:00 •Controlling the character with scripts and components: 00:07:00 •Altering code to make the character walk by default: 00:06:00 •Altering the script to walk and not run diagonally: 00:05:00 •Set up Cinemachine FreeLook camera: 00:03:00 •Fine-tune free look rigs: 00:07:00 •Replacing animations in controller: 00:07:00 •Integrating a death animation into controller: 00:07:00 •Scripting death by falling: 00:05:00 •Walking upstairs using colliders from hidden ramps: 00:05:00 •Bringing in a new character: 00:04:00 •Designing a third person player game object: 00:06:00 •Connecting FreeLook camera to third person player: 00:03:00 •Swapping out characters within the third person player: 00:03:00 •Using legacy characters: 00:06:00 •Using high quality commercial characters: 00:07:00 •Making character prefabs and overrides: 00:06:00 •Using the Cinemachine collider extension: 00:06:00 •Setting up post-processing and anti-aliasing: 00:04:00 •Configuring post-processing effects: 00:06:00 •Commercial animated stationary characters: 00:08:00 •Custom animated stationary characters: 00:06:00 •Providing seating for an animated character: 00:04:00 •Cropping an animation on humanoid rig: 00:06:00 •Bring in a new character to be driven by Ai: 00:04:00 •Configuring components on Ai character: 00:04:00 •Building and refining the nav mesh: 00:05:00 •Getting agents to climb stairs: 00:03:00 •Creating off-mesh links: 00:03:00 •Making nav mesh obstacles: 00:06:00 •Implementing high-cost areas for the Ai: 00:06:00 •Abstracting NPC for use with other skins & avatars: 00:06:00 •Outlining the goal of the game: 00:03:00 •Getting the NPC to chase the Player: 00:03:00 •Getting a hold of the Player's Animator through code: 00:08:00 •Logging NPC's collision with Player to console: 00:06:00 •Stopping the NPC and killing the Player: 00:07:00 •Offsetting the death animation: 00:03:00 •Allowing NPC to take leap with off-mesh link: 00:07:00 •Adding user interface with canvases and buttons: 00:09:00 •Toggling defeat canvas on when NPC collides with Player: 00:04:00 •Differentiating between victory and defeat in code: 00:09:00 •Refining the NavMesh for fluid Ai movement: 00:03:00 •Building a GameManager class and game object: 00:08:00 •Connecting Restart buttons to setting bool Property true: 00:05:00 •Connecting controller and testing in game: 00:01:00 •Mapping the Fire2 axis to run: 00:07:00 •Mapping the Fire1 axis to crouch: 00:05:00 •Mapping analogue stick to Cinemachine FreeLook camera: 00:05:00 •Fine tuning how analog game stick controls camera: 00:05:00 •Building and playing standalone game: 00:05:00 •Bonus: 00:01:00 •Assignment - 3D Humanoid Characters in Unity: 00:00:00

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 two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment