206 Mac courses in Street

NPORS Forward Tipping Mini Dumper (N139)

NPORS Plant Loader and Securer (N120)

In this course, students will learn general strategies for planning, designing, developing, implementing, and maintaining an IoT system through various case studies and by assembling and configuring an IoT device to work in a sensor network.

See how plastic bottle tops are remelted into beautiful objects!

Transform the inner metal from a car wheel, washing machine, tumble drier or even an old gas canister into a completely unique fire pit or barbecue. Your experience host will first show you how to safely work with a variety of hand and power tools, including angle grinders, which you’ll use to make your garden creation. Scott will guide you through the process of creating your upcycled piece, sharing his many years of experience upcycling from all sorts of recycled materials. At the end of the day you'll leave with your own custom fire pit or barbecue, along with the skills to make more upcycled metal creations at home. Facilities Toilets WiFi Refreshments available Parking COVID-19 guidelines Everyone will need to confirm fitness each day. Everyone will have their temperature taken at the beginning of each day. Hand washing will be compulsory at set times during the courses. Face masks will be compulsory during the specific parts of the course where you will be breathing heavily due to exertion. The remainder of the course we will have face shields available as an option to facemasks. Face shields will be provided. But please bring your own face mask. On the day You don't need any previous woodwork experience, just some enthusiasm! Please wear old clothes (or something that you don’t mind getting damaged or torn) and sensible, closed toe footwear. Work boots are recommended. Tea and coffee will be available throughout the day, but please bring along your own packed lunch. Course Location courses can be either in Glastonbury or at Scott's own workshop near the Bath and West show grounds (BA46QN) and will be confirmed.

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

In the past, popular thought treated artificial intelligence (AI) as if it were the domain of science fiction or some far-flung future. In the last few years, however, AI has been given new life. The business world has especially given it renewed interest. However, AI is not just another technology or process for the business to consider - it is a truly disruptive force.

Data Ethics for Business Professionals is designed for individuals who are seeking to demonstrate an understanding of the ethical uses of data in business settings.

English courses for all levels are available through Mac International

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar