3100 Code courses

Discover your special powers, receive insights and deep healing together with an abundance of light codes taking your life to the next level!

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Overview Face painting is an art that originates back to ancient times, when it was first used for religious, military and hunting reasons. Nowadays, we use it for celebrating special occasions and livening up kid's birthday parties. And when it comes to creativity, there really are no limits! In this Face Painting Course online, you will explore this fascinating art form in detail, learning how to produce a range of popular face painting designs for festivals, Halloween, birthday parties, and much more. It will also take you through pricing and costs for setting up your own business, as well as the equipment and materials you'll need to get started. Whether you want to learn face painting as a hobby or make it a full-time profession, this course is packed with expert instructions for drawing on faces that beginners can easily follow. It also covers health and safety best practice, skincare tips, and general face painting code of practice. No previous experience is required to take this course, which is open to all learners. Hone your creative talents online and master the art of face painting for kids' parties, festivals and special celebrations!   What You Will Learn Through this Online Face Painting Course, you will learn how to get started in setting up a face painting business and will be trained on how to paint a range of popular face paint designs for kids. No experience is required for this beginner's course. The History & Origins of Face Painting How to Run a Face Painting Business Face Painting Code of Practice Popular Face Paint Designs for Kids Face Painting Equipment & Materials Face & Body Art Techniques for Beginners How to Take Protect and Take Care of the Skin Healthy & Safety Best Practice Setting Prices & Costs for Your Service Face Painting Dos and Don'ts Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

Step into the ever-evolving digital tech world, where programming and cyber safety intermingle, guiding you towards mastery of information technology principles.

In this course, you'll learn the Ruby programming language from absolute beginner to advanced - in no time at all!

The course will introduce you to some of the most enduring photographic portraits and provide discussion on why they remain so seminal. The course includes an introduction to lighting and composition techniques for portraiture, as well as providing guidance on shutter speed, aperture, lenses, and other visual controls. You will use studio flash lighting to explore basic techniques in formal and informal portrait photography – though all of the techniques taught are transferrable to natural and other lighting media. There will be time for participants to photograph under three standard lighting set-ups. Some digital SLR photography experience is recommended. Morning The morning session centres on discussion of the work of some classic portrait photographers and standard techniques employed. The discussions will include elements of composition, pose, gesture, format and technique. Afternoon The afternoon session will cover practical studio lighting, standard lighting set-ups, direction of sitters, and time permitting also a brief introduction to some of the editing capabilities of Adobe Photoshop. Project Days are designed for those who are already familiar with digital photography processes but who want to pursue a particular aspect or develop more specific skills in one or more areas. This course is the perfect follow-on from our Digital SLR training courses and will support you in building upon your existing knowledge of DSLR camera skills and becoming a better photographer in general. It will help you to work confidently on your own creative projects and develop the artist in you.   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

Covering ARM systems design and architecture and practical assembly programming, this is a comprehensive ARM assembly video course to get you up and running. You'll develop the skills necessary for starting your career as an ARM embedded developer, such as developing algorithms and creating state machines in assembly.

Unlock the world of web development with our comprehensive course! Whether you are a beginner or looking to enhance your coding skills, our masterclass will take you on an exciting journey. A project-based course that will help you learn and implement HTML, CSS, and JavaScript. With hands-on experience, you will design web pages, add interactive elements, and create a polished final project. Gain practical skills, optimize your coding workflow, and create professional web applications.

The Portable Appliance Testing course or PAT testing course as it is more commonly known is one of our most popular courses as it does not require you to have any formal previous qualifications and once completed, will enable you to offer your services. In the commercial setting, the law places a responsibility on all employers to ensure that the electrical equipment to be used by their staff and the public, should be fit for purpose and safe for use. Hence, all portable appliances have to be regularly checked and maintained by a competent person.

The 'JavaScript Foundations for Everyone' course is a comprehensive introduction to JavaScript programming designed for learners of all levels. Covering fundamental concepts and practical examples, this course equips participants with a solid foundation in JavaScript, including variables, data types, functions, scope, asynchronous programming, and error handling. With step-by-step demos and interactive modules, learners will gain the skills needed to confidently write, debug, and implement JavaScript code. Learning Outcomes: Understand the author's background and expertise in JavaScript. Explore the fundamentals of JavaScript and its role in web development. Analyze the strengths and weaknesses of JavaScript as a programming language. Write and execute JavaScript code using the Chrome browser console. Master JavaScript variables, data types, and their practical applications. Gain proficiency in JavaScript functions, scope, and hoisting. Implement asynchronous programming using timeouts, callbacks, and promises. Develop flow control and error handling mechanisms for robust code. Why buy this JavaScript Foundations for Everyone? 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 JavaScript Foundations for Everyone 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 JavaScript Foundations for Everyone does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Beginners with no prior programming experience looking to learn JavaScript. Web developers seeking to enhance their JavaScript skills and understanding. Students and learners interested in web development and programming. Professionals aiming to add JavaScript proficiency to their skill set. Prerequisites This JavaScript Foundations for Everyone 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 Front-End Web Developer - Median earning of £25,000 - £45,000 per year. JavaScript Developer - Potential earning of £30,000 - £60,000 per year. Full-Stack Web Developer - Median earning of £35,000 - £65,000 per year. Software Engineer - Potential earning of £40,000 - £80,000+ per year. Web Development Instructor - Median earning of £25,000 - £45,000 per year. Course Curriculum JavaScript Foundations for Everyone Module 01: About the Author 00:04:00 Module 02: Introduction to JavaScript 00:11:00 Module 03: Strengths and Weaknesses of JavaScript 00:15:00 Module 04: Writing JavaScript in Chrome 00:06:00 Module 05: JavaScript Variables 00:07:00 Module 06: Demo of JavaScript Variables 00:10:00 Module 07: Basic Types of JavaScript 00:07:00 Module 08: JavaScript Boolean 00:08:00 Module 09: JavaScript Strings 00:18:00 Module 10: JavaScript Numbers 00:16:00 Module 11: JavaScript Objects 00:13:00 Module 12: Demo of JavaScript Objects 00:07:00 Module 13: JavaScript Arrays 00:09:00 Module 14: Demo of JavaScript Arrays 00:26:00 Module 15: JavaScript Functions 00:06:00 Module 16: Demo of JavaScript Functions 00:08:00 Module 17: JavaScript Scope and Hoisting 00:10:00 Module 18: Demo of JavaScript Scope and Hoisting 00:07:00 Module 19: Currying Functions 00:03:00 Module 20: Demo of Currying Functions 00:07:00 Module 21: Timeouts and Callbacks 00:04:00 Module 22: Demo of Timeouts and Callbacks 00:08:00 Module 23: JavaScript Promises 00:05:00 Module 24: Demo of JavaScript Promises 00:07:00 Module 25: Demo of Javascript Async 00:04:00 Module 26: Flow Control 00:06:00 Module 27: Demo of Flow Control 00:07:00 Module 28: JavaScript For Loop 00:07:00 Module 29: Demo of JavaScript For Loop 00:04:00 Module 30: Demo of Switch Statements 00:05:00 Module 31: Error Handling 00:09:00 Module 32: Demo Project 01:11:00