9847 Courses

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

Microsoft Excel® in Depth: Virtual 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

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Thinking about a career in Business Analysis? The BCS Practitioner Certificate in Business Analysis has been designed to provide valuable learning for those in roles such as business analyst, business architect, business systems analyst, data analyst, enterprise analyst, management consultant, process analyst, product manager, product owner, project manager, and systems analyst.

Employee Assistance Programme Training

A practical programme for HR professionals who are keen to develop a coaching style of interaction either within their teams and/or with business stakeholders. Develop skills in taking a more engaging, non-directive approach to supporting your business and to encouraging a coaching style of communication in your organisation.

The aim of this module is to enable delegates to perform entry-type injured person rescue operations, in a Wind Turbine Generator, using industry standard rescue equipment, rescue methods and techniques, exceeding those of GWO Working at Heights. Valid GWO BST Module Working at Heights, GWO First aid and GWO Manual Handling certificates are prerequisites for participation.

A payment plan is available, please contact us for more details. WSET Level 3 in Wines Award is an advanced level qualification for professionals working in the wine industry and for wine enthusiasts. If you are looking to delve deeper into the world of wines, this qualification provides a detailed understanding of grape growing and wine making. Upon completion you will be able to assess wines accurately, and use your understanding to confidently explain wine style and quality.  What the course covers Wine Tasting: Taste, describe and analyse wines using the WSET Systematic Approach to Tasting Food and Wine Matching: A guide to the key considerations when matching food and wine successfully Labelling: Learn how to decode and understand labels Wine Production: Learn about the production factors influencing the style, quality and price of wine from vineyard to bottling Light Wines: Learn about the styles of wines produced in the key wine regions and districts of the world: France, Italy, Spain, Portugal, Austria, Germany, Greece, South Africa, Australia, New Zealand, North and South America, England and Wales Sparkling Wines: Learn about the methods of production and the main styles of sparkling wines from the key wine producing countries: France, Spain, Italy, Germany, New World - Australia, California, New Zealand, South Africa Fortified Wines: Learn about the methods of production/main styles of fortified wines from the key wine countries: Spain, Portugal, France, Australia Examination: The examination is in two parts and takes place in the afternoon session of the final day of the course. The WSET Exam fee is included in the course cost. Theory paper: a combined theory paper consisting of a 50 question multiple-choice section and a four question short answer written section. 2 hours. Tasting: a blind tasting of two wines. A mark of 55% required in all sections to pass. 1 hour. The qualification has full accreditation from the UK Government’s Qualifications & Curriculum Authority as a Level 3 Vocational Qualification. To view the full course specification, including examples of exam questions, please click HERE. Recommended Private Study: 56 hours additional private study is recommended for this course. It is strongly recommended the majority of the private study is done in preparation for each session. Private study is essential to ensure that you are ready and prepared for the exam. Entry requirements: Although not essential, we do recommend you have completed the WSET Level 2 Award in Wines before enrolling on the course. The syllabus assumes that candidates already possess a good basic understanding of simple wine making techniques, key grape varieties and viticultural patterns. The fee of £825 includes All WSET course materials including; 'Accounting For Style And Quality' course manual (comprehensive 250 page textbook), Study Guide and Full SAT Tasting Card All wine tasting samples (60 to 70 wines) The use of professional ISO tasting glasses 6 days of professional WSET tuition by a WSET Certified tutor Teaching of the WSET Level 3 Systematic Approach to Tasting Wine (SAT) ® which will enable you to analyse wines objectively and consistently in preparation for the tasting exam Two fully marked mock tasting exams and weekly written exam technique sessions to ensure you are fully prepared for the exam Comprehensive student support by WSET certified educator outside of class time should you have any questions before, during and after the course Registration with WSET and all examination fees Internationally-recognised certificate and pin badge upon successful completion VAT at 20% (VAT receipt can be provided on request) Special Educational Needs Please make us aware if you have a condition that may mean you qualify for additional help during the exam such as dyslexia. Funding Funding for this course is available:  DEVELOP is the educational programme of The Drinks Trust, the drinks and hospitality industry charity. DEVELOP offers fully funded training and skills courses, delivered by industry-leading providers for people already working, or with an ambition to work, in the drinks and hospitality industry. Manchester Wine SChool has partnered with The Drinks Trust to bring courses free of charge to eligible students. All of the WSET courses are available for funding with DEVELOP. To learn more please visit the Drinks Trust website HERE Criteria of eligibility for DEVELOP funding: must be 18 or over, eligible to work in the UK, have a National Insurance Number, and be earning less than £26k/pa

The one day glass fusing course is designed to give total beginners an introduction to a new skill, and allow more time to create a larger piece of work. At the end of the day, you will have created a glass bowl, wall hanging or large wave (approx 30cm x 30cm). You should also have had some fun! I keep the glass fusing classes small, to make sure it's easy to give everyone as much input as is required. There is a 2m gap between all work-stations, to help maintain social distancing. We also provide visors (or you can wear your own mask), and there is lots & lots of hand sanitiser. All equipment & materials are disinfected before the start of each day. You don't need to bring any materials, as everything required to create your piece of work is provided. The only thing you need to wear are closed shoes (e.g. no sandals), and to bring some lunch. We can also arrange lunch at a small cost, if required. You'll start the day by creating a design - you can bring your own, or we can provide one. You'll learn how to cut the glass & then build up your design which is then fired overnight. You will be able to collect your design the next day, or we can arrange to post it to you (you just need to cover the cost of the postage). Timings: 10am - 4pm Buying as a gift? Just select the most appropriate date and, if that turns out not to be suitable, the recipient can simply reschedule over the phone or by email (we just need 2 weeks' notice).