104 Courses in Manchester

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Watercolour for Beginners – Saturday 8th June – 10:30-13:30- Friends Meeting House Manchester During this course, you will discover how a deeper understanding of painting techniques can equip you with the practical methods and skills to help you with any future paintings you want to attempt. Suitable for people of all levels of experience; from those who are new to watercolour painting, to more experienced artist, this foundational course in watercolour painting, unites primary techniques so that you can expand your creativity in one coherent approach. This fully guided course covers topics such as: · Seeing shape: Translating three-dimensional objects into simple shapes before painting. · Mark Making: Exploring different types of marks and developing good brush control. · Understanding Basic Techniques: Learning fundamental techniques such as creating washes, wet-on-wet, wet -on-dry, glazing, lifting, and blending. · Colour Mixing: Learning how to mix colours to create a wide range of hues and values. · Composition: Exploring the principals of composition and design to create visually interesting drawings. · Subject Matter Exploration: Experimenting with different subjects such as still life and flowers. General Info: ⏳ Duration: 3 Hours 📍 Location : Friends Meeting House, Mount Street, Manchester , M2 5NS 👤 Age required: 16+ with a valid ID ♿ Accessibility: This venue is wheelchair accessible What We Will Provide: · Watercolour Paper & Drawing board · Drawing pencils, eraser, and sharpener · A range of watercolour paints . Tuition from our resident watercolour artist .Instructional handbook

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.

A mindful embroidery workshop by Manchester embroidery artist Hoop & Fred! The perfect wholesome activity for a hen do, work event, or community get together!

The ABT Level 3 Diploma in Nail Services is a substantial vocational qualification that will confirm your competence as a nail technician.

During this fully tutored life drawing course, you will discover how returning to the essential principles of drawing can help even the more experienced artist to express their ideas and observations more eloquently. Guided by our tutor, you will be encouraged to explore line, movement, and proportion, using simple techniques and exercises that are designed to enhance your the skills, knowledge, and confidence in creating responsive figure drawings. Suitable for even more experienced artists who would like to develop their skills and explore drawing further. This improvers course in life drawing is for those of an intermediate level, and will unite the skills of observation, expression and understanding in one coherent approach. Beginning with the key principles of observation, this course will give you a strong understanding of proportion and tonal value so that you can make well-observed, proportionally accurate drawings. This fully guided course will teach you to observe and understand the influence of anatomical masses such as the skeletal-muscular systems by drawing your attention to key themes and ideas such as: Exploring the Proportions of the Human Body Understanding Movement and Weight DistributionSeeing shape Seeing Variations in Tone Knowledge required: Improvers/beginners level: This course is suitable for beginners or those with experience in drawing who would like to develop their skills and explore life drawing further What we will provide: Table easels Paper & Drawing board A range of drawing pencils, charcoal sharpener and eraser Instructional Handbook By the end of this course, you will be able to confidently produce personal, focused and responsive figure drawings.

The perfect festive embroidery workshop! Organise something a little different for your Christmas party this year!

Reiki level 1, is the beginners level. Even at this level, you have access to Reiki energy and the ability to use Reiki energy to heal yourself and others. Level 1 is open to anyone. The focus during Level 1 is on opening the energy channels on a physical level, allowing the practitioner to connect to the universal life force energy; you will receive full ongoing support to ensure you feel fully confident and consistent in your practice. I believe this means more practitioners will continue to use reiki daily, rather than be attuned and then never use it again.

Phoenix Pottery and Art Studio offer a calendar of events including pottery courses and classes, glass fusing, art classes, watercolour painting classes and a variety of one off creative workshops. Situated in Golborne, with easy motorway access for the Northwest UK. Approx 20 miles from Liverpool and Manchester.

Join me on this landscape photography workshop in the iconic mountains, quarries and landscape of SnowdoniaLandscape PhotographyA new addition to the tours and workshops, this area has some of the highest mountain ranges in England and Wales. The landscape is rugged but beautiful with high mountains, flowing rivers and large lakes. Based around Capel Curig in the National Park we will visit some hidden treasures, lakes, mountains, quarries and iconic vistas.A Snowdonia photography workshop and photo walk in Cwm Idwal amidst the Glyderau and Carneddau mountain ranges, the glacial lakes of Llyn Idwal and Llyn Ogwen and the impressive Ogwen Falls. A workshop for beginners or anyone looking to further develop their landscape photography.Course content includes camera controls, use of filters, gear choice, advice on composition. The workshop involves walking to different viewpoints within Cwm Idwal on rocky, uneven paths and an ascent of 300ft to a viewpoint above the lake so a good level of fitness and mobility is required. Due to the terrain unfortunately the workshop is unsuitable for those with limited mobility.What do you need to bring with you?Camera/lenses/Spare memory card/batteries/tripod - A digital camera with "semi-automatic/manual" controls (Aperture and Shutter priority) is recommended to get the most from the course. Filters (if you have them) A packed lunch/snacks The relevant user manual for your camera Warm/waterproof clothing and suitable footwear - weather can be unpredictable all year round in Snowdonia. A notepad and pen What happens in bad weather?I monitor weather forecasts and if conditions are predicted to be completely unsuitable, to ensure both your safety and enjoyment of the day, it may be necessary to cancel a workshop. I will endeavour to provide at least 24hrs notice, although this cannot always be guaranteed; you will be offered either a full refund or a place on a future course.